What are the components of PowerBI and what is architecture of PowerBI?

Power BI Components

The components of Power BI are shown as below:

Power BI Components

1. Power Query: It is used to access, search, and transform public and internal data sources.

2. Power Pivot: Power pivot is used in data modeling for in-memory analytics.

3. Power View: By using the power view, you can analyze, visualize, and display the data as an interactive data visualization.

4. Power Map: It brings the data to life with interactive geographical visualization.

5. Power BI Service: You can share workbooks and data views which are restored from on-premises and cloud-based data sources.

6. Power BI Q&A: You can ask any questions and get an immediate response with the natural language query.

7. Data Management Gateway: You get periodic data refreshers, expose tables, and view data feeds.

8. Data Catalog: By using the data catalog, you can quickly discover and reuse the queries.

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.