INFOPARKDAILY

Career Tools · Free for job seekers

Beginner → Intermediate 7 lessons · free · no sign-up

Power BI tutorial Dashboards, DAX and data models.

Power BI — dashboards and reports for analyst roles. Every lesson has sample data with the steps or DAX formulas and the result you should see, key points, a practice task, a quiz and interview questions.

Start learning Power BI Not started
  • 7lessons
  • 7quick checks
  • 14interview Q&As
  • 7practice tasks

Syllabus

What you'll learn

Every lesson has a worked example, key points, a quick check, a practice task and interview questions.

  1. 01Power BI introductionWhat Power BI is, Desktop vs Service, and the get data → model → visualise → share workflow.
  2. 02Cleaning data with Power QueryRemoving duplicates, fixing types, splitting columns, merging and appending queries.
  3. 03Data modelling & relationshipsFact and dimension tables, the star schema, relationships, cardinality and a date table.
  4. 04DAX basics: measures & columnsMeasures vs calculated columns, SUM, COUNTROWS, DIVIDE and simple ratios.
  5. 05CALCULATE & time intelligenceChanging filter context with CALCULATE, year-to-date, last year and growth percentage.
  6. 06Building reports & dashboardsChoosing visuals, KPI cards, slicers, drill-down, tooltips and good report design.
  7. 07Publishing, refresh & securityPublishing to the Power BI Service, workspaces, scheduled refresh, gateways and row-level security.