Bang Ti Lenydoor

Power BI for Business Reporting Professional Certificate

Wishlist Share
Power BI for Business Reporting course cover

About Course

Power BI for Business Reporting teaches you to turn spreadsheets and databases into clear, interactive reports that managers actually use. Power BI is one of the most widely used business intelligence tools in the world, and Power BI skills are in high demand across banks, telecoms, NGOs, government agencies and growing businesses in Africa.

You will follow the complete professional workflow: connecting to data; cleaning and reshaping it with Power Query; designing a star-schema data model with correct relationships and a date table; writing DAX measures, including CALCULATE and time intelligence such as year-to-date and year-over-year growth; designing reports with the right visuals, interactivity and layout; and publishing and sharing securely with row-level security.

Every module uses realistic business examples, and the capstone asks you to build a complete sales dashboard for an agro-dealer chain with stores in South Sudan, Uganda, Kenya and Rwanda, using a multi-table dataset with more than 23,000 transactions.

No previous Power BI or programming experience is required; basic spreadsheet skills are enough. Power BI Desktop is free and runs on Windows (Mac users can use a Windows virtual machine or a lab computer). How the course works: six modules, 23 lessons with more than 25 videos from respected Power BI educators including Kevin Stratvert, SQLBI, Guy in a Cube, Pragmatic Works and Leila Gharani, a hands-on activity in every lesson, a quiz after every module, a capstone project and a final certification examination. Most learners finish in 6 to 8 weeks at 4 to 5 hours per week.

Show More

What Will You Learn?

  • Explain what business intelligence is and how Power BI Desktop and the Power BI service fit together
  • Connect to Excel, CSV, folders, databases and web data
  • Clean, reshape, merge and append data with Power Query
  • Design star-schema data models with fact and dimension tables
  • Create correct relationships and a proper date table
  • Choose between calculated columns and measures
  • Write DAX measures with CALCULATE, filter context and iterators
  • Build time intelligence: year-to-date, same period last year and growth rates
  • Design clear, interactive reports with slicers, drill-through, tooltips and bookmarks
  • Publish, share and secure reports with row-level security

Course Content

Module 1: Getting Started with Power BI

  • Business Intelligence and Power BI
  • Power BI Desktop: Interface and First Report
  • Connecting to Data Sources
  • The Power BI Service, Workspaces and Apps
  • Module 1 Quiz: Getting Started with Power BI

Module 2: Cleaning and Shaping Data with Power Query

Module 3: Data Modelling

Module 4: DAX Measures and Time Intelligence

Module 5: Report Design, Interactivity and Publishing

Module 6: Capstone Project and Certification

Scroll to Top