Power BI

Power BI projects

Build a data model and a dashboard that answers a real business question. You will see the required KPIs and the model you need to reach — but never the finished dashboard.

About .pbix files

A .pbix file cannot be opened or run in a browser — it is a Power BI Desktop format. We store your file privately for your instructor to download and review, and you can additionally publish to the Power BI Service and submit that link so reviewers can interact with the report.
1

Download the dataset

You get the raw files, a data dictionary and the business requirements.

2

Model the data

Clean in Power Query, then build a star schema with the relationships the brief describes.

3

Build the report

Write the measures, hit the required KPIs, and design a dashboard someone can read at a glance.

4

Publish and submit

Upload the .pbix, add screenshots, and paste your Power BI Service link if you published it.

What you will practise

Preparation and modelling

  • Power Query
  • Data cleaning
  • Relationships
  • Star schema
  • Calculated columns
  • Row-level security

DAX

  • Measures
  • CALCULATE
  • Time intelligence
  • Filter context
  • Variables
  • Iterators

Report design

  • Dashboard layout
  • Drill-through
  • Tooltips
  • Slicers and filters
  • Bookmarks
  • Data storytelling
  • Accessibility

What you submit

  • The .pbix file
  • Screenshots of each report page
  • A Power BI Service link, if you published the report
  • A written explanation of your findings and recommendations

Power BI projects(1)

Current section: /power-bi