Your boss started putting together a data model but was soon confused as to how to handle multiple dates in his fact table. He needs you to create a chart showing sales counts by order date and by ship date.

The student is asked to create total sales for a specific product and year, and then calculating the maximum sales any single customer had, using both SUMMARIZE and SUMMARIZECOLUMNS. These are both very important functions, especially when you need to generate data to export to CSV or SQL Server.

We're continuing our theme of summarizing data. The student will be asked to expand on the work done in the prior exercise by adding additional aggregation columns to the output. However, it may not be quite as easy as you might think.

Your boss needs a CSV file created that contains all customers that purchased a certain combination of products in one year, and made the same purchase in the next year.

The student will be creating an aggregation table, which can greatly speed up query times for large databases. Once created, the aggregation table will be imported into SQL Server.

A co-worker comes to you with a query that is producing unexpected results. She needs your help in understanding what DAX is doing.

Your co-worker is back and is having trouble with another query that is generating an error. She needs help in understanding what the error means and how to fix it.

The student will be working with the AdventureWorks2016 database and creating two cards. The first will show the top three products and the second will show the bottom three products. However, the names of these products must be concatenated together.

We're building on the prior exercise by adding some new features to the report and a bit more complexity.

Your co-worker has been asked to generate a report showing repeat customers for all countries and years. She needs your help.

The report created in exercise 10 needs to be extended a bit and the co-worker you helped to create it isn't sure if and how to change the measure to accommodate the change.

The student is asked to create a table with the number of distinct customer counts for each day and the number of new customers each day.

We will be expanding on the prior exercise by adding a lost customer count. This is the number of customers that made a purchase say 90 days ago and have not made any purchases since. However, to make it a bit more fun, the number of days without purchases should be a value selected by the user in a slicer.

The student will be creating a calculated column in the Product table of AdventureWorks2016 that computes the percentage of sales of that product against all sales.

This is a potentially tricky little exercise to find all products sold in both the Internet Sales and Reseller Sales tables and then calculating the total sales of each product, from both tables.

In the Contoso database, we created four measures to calculate maximum daily sales for each month and year. Three are correct and one is not. You'll need to explain why one is not and why the other three work.

The student is asked to create a table, using a DAX expression, that populates the table with all even numbers between 0 and 500. Hint: Don't add the numbers one at a time, manually!

This lecture involves a brief discussion of percentiles and quartiles. As a Power BI / DAX developer you will eventually be asked to show a breakdown of data based on percentiles or quartiles.

This is the first of several exercises dealing with percentiles and quartiles

The student will be building on the report created in the prior exercise by determining which quartile each customer falls within.

The student will be building on the report created in the prior exercises by adding a slicer and removing customers which had no sales.

Your company Sales department has asked you to create a fairly complex report based on percentiles and customer percentage of sales. You'll use quite a variety of DAX functions in this exercise.

This is a brief introduction to the 4-4-5 (or 4-5-4, 5-4-4) calendars

We talk briefly about the Contoso database and the 4-4-5 calendar used for the next series of exercises

We'll be starting off pretty easy by building a report showing yearly and weekly sales along with the same sales amount from the previous year and week.

The student will develop a report that shows, for each day, month and year, the week to date sales.

The student will be creating a report that shows sales for each week and year, along with sales from the prior week. Perhaps not as straightforward as you might think.

The student is asked to figure out how to create a month-to-date report against a weekly calendar.

The student will be creating a report with two tables containing various quarterly data against the weekly calendar.

Your boss loves the 445 Calendar in the Contoso database and wants you to import that table into the company development SQL Server database. How can you accomplish this?

In this exercise you will be building a simple line chart showing current sales and 15, 30, 45, 60 and 90 day rolling averages. You will be laying the foundation for the next exercise which should test your abilities just a bit.

The student will expand the report created in the prior exercise to give the user the option of selecting just the rolling averages they wish to see. This exercise will test your ingenuity!

The student will be examining three different queries that attempt to do the same thing. One of the queries produces wildly different results. You'll need to explain why, and how the queries differ from each other.

Learn about all our course offerings