Power BI Architecture

Power BI Architecture

The architecture of Power BI is shown as below:

Power BI architecture has three phases. The first two phases use ETL (extract, transform, and load) process to handle the data.

  1. Data Integration: An organization needs to deal with the data that comes from different sources.
    First, extract the data from different sources which can be your separate database, servers, etc.
    Then the data is integrated into a standard format and stored at a common area that’s called staging area.
  2. Data Processing: Still, the integrated data is not ready for visualization because the data needs processing before it can be presented. This data is pre-processed.
    For example, the missing values or redundant values will be removed from the data sets.
    After that, the business rules will be applied to the data, and it transforms into presentable data.
    Then this data will be loaded into the data warehouse.
  3. Data presentation: Once the data is loaded and processed, then it can be visualized much better with the use of various visualization that Power BI offers.
    By using of dashboard and reports, we represent the data more intuitively.
    These visual reports help business end-users to take business decision based on the insights.

To get more tutorial videos go through OnlineITguru’s Power BI Online Course Blog




Big Data,ios,android,Spark

Love podcasts or audiobooks? Learn on the go with our new app.

Backup and Recovery for Salesforce

Cross-Organizational Teams Can Benefit Your Software Development Process

POJ : Crane

Meet Vicci — Very Intelligent Covid Chat Interface — 2

How to Build A Message Routing Bot for Slack with Python and Host it on Docker

We REALLY need to discuss goals of care with all patients admitted with COVID-19.

How To Protect Your WSL Distro More Firmly

Why you shouldn’t use Python

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store


Big Data,ios,android,Spark

More from Medium

Tableau Dashboard Version Management with Git

Microsoft Power BI in nine hours


6 Reasons Why You Need Power Bi