PowerBi¶
Visualization software used for Business Intelligence
Advantages¶
- Easy to maintain
- Drag & drop and Coding
- Embed everything in a single shareable “.pbix” file
- Does not support live queries very well. Need to use very high frequency refresh schedule. You can even use PowerAutomate to refresh
Disadvantages¶
- Not as flexible as hand-coding a dashboard in Python or so
- Might get too big for very large datasets
Coding languages¶
- PowerQuery
- DAX (Data Analysis Expressions)
IDK¶
PowerBi Desktop \(\ne\) PowerBi Cloud
PowerBi cloud every uploaded dashboard gets split into Report & Semantic Model