Architecture of Power BI
Architecture of Power BIData Integration:
An organization needs to work with data which comes from different sources which can be in various file formats. The data should be extracted from a different source which can be from different servers or databases. This data is integrated into one standard format in a common staging area.
Data Processing:
In this stage, the integrated data is still not prepared for visualization as the data needs processing. This data is pre-processed. For example, redundant values, missing values will be removed from the data set.
The business rule should be applied to the data when the data is cleaned. You can load that data back to Data Warehouse.
Data Presentation
Once the data is loaded and processed, it can be visualized much better with use of various visualization that Power Bi has to offer. Use of dashboard and report helps one represent data more intuitively. This visual report helps business end users to take business decision based on the insights.
