Author : MD TAREQ HASSAN

Building blocks

five building blocks are:

Building blocks are sometimes referred to as Power BI content. Content exists in workspaces

Note: Workbooks are a special type of dataset (when excel file is connected to Power BI instead of imported)

ETL Process

Power BI ETL Process

Flow

Power BI Desktop

|--------------------------------------|         |--------------------------------|      |---------------------------------------| 
|            Create Report             | <====== |   Relationship | Data Modeling | <=== | Enhance data with DAX | Data Modeling | 
| (Export as PBIX, Upload to Power BI) | <====== | (Relationship as like EF EDMX) | <=== |   (DAX = Data Analysis Expression)    | 
|--------------------------------------|         |--------------------------------|      |---------------------------------------| 
                                                                                                    ^
                                                                                                    |
|-------------------------|                       |-----------------------|        |-----------------------------|
|      Data source        | == data import  ====> |    Power BI Desktop   | =====> |  Transform | Data Modeling  |
| (i.e. A file with data) | == data connect ====> |    (Data in Memory)   | =====> | (clean, add, remove, modify)|
|-------------------------|                       |-----------------------|        |-----------------------------|

Power BI Online / Power BI Services

|----------------------|       |-----------------------|      |---------------|
|        Dataset       | ====> |     Create Visuals    | ===> |     Share     |
|  (i.e. Import PBIX ) | ====> | (Reports, Dashboards) | ===> | (to consumer) |
|----------------------|       |-----------------------|      |---------------|

Power BI Workflow

Design Steps

Power BI Design Steps 2

Power BI Design Steps 1