Case studies are used for longer processes that can be accomplished using multiple possible methods.

The Quarterly Report

In the Quarterly report case, an analyst generates a report of quarterly car sales from Statistics Canada data.

The data is available here at: Car Sales Data.
Three different approaches were taken to aggregate and report information. All three approaches used Get Data in order to get the data from the .CSV file.

Use a SUMIFS() formula. – This approach imported the data into a table, then analyzed using Excel formulas.

Use a pivot table. – This approach used a pivot table to aggregate the data, then used GETPIVOTDATA() to extract the values in a user friendly way.

Use the data model. – This approach imported the data directly into the data model, then extracted using CUBEVALUE() functions.