Business Data Analytics & Advanced Excel · Intermediate level

Intermediate level · Module 6 of 6 · 15 guided hours

Business Reporting Project

Deliver the organisation-wide Power BI reporting solution from requirements to governed, published reports.

Learning objectives

  • Gather reporting requirements and define KPIs
  • Build the data pipeline, model, measures and reports
  • Test, govern and present the solution

Topics

  • requirements and KPI glossary
  • data pipeline
  • model and measures
  • report design
  • governance
  • presentation

Lessons

  1. Lesson 1 Requirements and KPIs

    Agree what the organisation needs to see and define every KPI precisely.

    requirementsKPI definitiontargetsglossary

  2. Lesson 2 Building the Solution

    Build the queries, model, measures and report pages, checking every number.

    queriesmodelmeasuresreport pages

  3. Lesson 3 Governance and Presentation

    Finalise governance, publish and present the solution.

    governance noteRLSrefresh planpresentation

Practical activity

Deliver the level project in three reviewed stages: requirements and data, model and reports, governance and presentation.

Expected outcomes

  • A complete Power BI reporting solution
  • Experience delivering reporting to an organisation

Assessment

The level project assessed against its criteria with a live demonstration.

Taught live by an instructor — online or in person. Free course lessons are for self-study and do not lead to a certificate — see registration options.