Business Data Analytics & Advanced Excel · Intermediate level

Intermediate level · Module 6: Business Reporting Project · Lesson 2 of 3

Building the Solution

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

In this lesson you will

  • Implement the full solution
  • Check every KPI independently

Key concepts

queriesmodelmeasuresreport pages

The lesson

Build the queries and star-schema model, then the measures from the glossary, each checked against an independent calculation.

Build the report pages for each audience with interactivity and accessibility.

Keep a test log recording each KPI's check.

Step by step

  1. Build the queries and model.
  2. Write and check the measures.
  3. Build the pages.
  4. Complete the test log.

Practice activity

Build the reporting solution.

Expected result: A working solution with a complete test log.

Check your understanding

  1. How should each KPI be checked?

    Show answer

    Against an independent calculation, recorded in a test log.

  2. What comes first: measures or the model?

    Show answer

    The model.

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.