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.