Data Analytics

Power BI

Build interactive reports your managers can answer their own questions with

Phone: +237 672 149 730

ImageImageImageImageImage

Course Description

The monthly report is usually a scramble: figures copied between spreadsheets for two days, emailed as a file that is out of date before it is opened, and the manager still asks for the one breakdown that was left out.
Power BI teaches you to build the report once and let it update itself. You will shape data in Power Query, model your tables, write the measures a report runs on in DAX, lay out visuals with slicers and drill-through, then publish it on a scheduled refresh for the people who need it.

Course Outline

Avatar
Week 1

Loading And Shaping Data With Power Query

Connect to files and databases, then clean and reshape the data on the way in, so every refresh arrives in the right form without anyone repeating the work by hand.
Avatar
Week 2

Data Models And Relationships

Join your tables into a model that answers questions correctly: fact and dimension tables, one-to-many relationships, and the date table every time-based report needs.
Avatar
Week 3

Measures With DAX

Write the calculations a report runs on: totals, averages, month-on-month change and share of total, as measures that respond to whatever the reader filters.
Avatar
Week 4

Building Interactive Reports

Lay out a report that answers the question at a glance and lets the reader dig in: slicers for period and branch, drill-through to detail, and visuals that stay readable.
Avatar
Week 5

Publishing, Refresh And Sharing

Publish to the service, set a scheduled refresh, share with the people who need it and control who sees what, so the report keeps working after you hand it over.
Message Us