This page has 0 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

Software ==>	PowerPivot (72 exercises)
Topic ==>	KPIs (5 exercises)
Level ==>	Relatively easy
Subject ==>	Power BI training

Use a KPI to show how well you are performing against the previous quarter

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Before you can do this exercise, you'll need to download and unzip this file .

The aim of this exercise is to create the following pivot table:

We'll aim for each quarter's total quantity sold to be at least 99% - and ideally 100% - of the previous quarter's total quantity sold. Lots of help follows!

If you haven't already done so, first run the SQL script in the above folder (copying and commercial use prohibited) to generate a database called MAM. Also if you haven't already done so, run the spCreateCalendarTable stored procedure to create a calendar table.

Create a new workbook, and within this create a data model incorporating the tblCalendar, tblPos and tblTransaction tables.

Create the following two calculated fields:

Field	Notes
This quarter	The total of the Quantity column for any query context.
Previous quarter	The total of the Quantity for the previous quarter (use CALCULATE and DATEADD to sum the figure for 1 quarter back in time).