Author : MD TAREQ HASSAN
Building blocks
five building blocks are:
- datasets
- visualizations
- reports
- dashboards
- apps
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
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) |
|----------------------| |-----------------------| |---------------|