Power BI for BI Analysts
Power BI is Microsoft's business analytics platform for loading data, modelling it, writing DAX measures and publishing interactive reports. Power BI Desktop is used to author reports, and the Power BI Service hosts them for sharing, scheduled refresh and governance, with workspaces and roles controlling who sees what.
Stage: Dashboard Tools · Part of the BI Analyst roadmap · Last reviewed 19 November 2026
What to learn in Power BI
- Create relationships between tables in the model view
- Write a DAX measure using CALCULATE with a filter condition
- Build a year-over-year comparison with time intelligence functions
- Publish a report and schedule a dataset refresh in the Service
- Apply row-level security so each manager sees only their region
Power BI interview questions
What is the difference between a calculated column and a measure in DAX?
A calculated column is evaluated row by row when data refreshes and stored in the model. A measure is calculated at query time in the current filter context, such as a chart's slicers. Use measures for aggregations and columns for row-level attributes.
What does CALCULATE do in DAX?
CALCULATE evaluates an expression after modifying the filter context. For example, CALCULATE(SUM(Sales[Amount]), Region[Name] = "West") sums sales for the West region regardless of the slicer on region. It is the most important function for custom measures.
Where Power BI fits in the BI Analyst roadmap
Power BI belongs to the Dashboard Tools stage (beginner level), which takes about 7 hours. Pick and master a platform.
Other units in this stage
Back to the full BI Analyst roadmap