How to Teach Data Analytics

Tutorials and Sample Student Cases
(Click each to download)

General business and/or Accounting Cases

Data Analysis Using Pivot Tables: Slice and Dice MegaCorp Inc.'s Sales Data


Without data inconsistencies; the data in Excel has been cleaned and scrubbed.  Three Pivot tables must be created and based upon the results a series of unique analytic questions need to be answered. 

Video Tutorial Data File Sample Student Case
PDF
Data Analysis Using Pivot Tables: Cuddly Stuffed Animals


Without data inconsistencies; the data in Excel has been cleaned and scrubbed.  Three Pivot tables must be created and based upon the results a series of unique analytic questions need to be answered.

Video Tutorial Data File Sample Student Case
PDF
Data Analysis Using Pivot Tables Plus: Cuddly Stuffed Animals Plus


With data inconsistencies; the data in Excel contains errors that must first be corrected.  Three Pivot tables must then be created and based upon the results a series of unique analytic questions need to be answered.

Video Tutorial Data File Sample Student Case
PDF
Data Prep 1: Cuddly Stuffed Animals - Single Stream


ETL software is used to remove blank rows, remove extra columns, change data types, rearrange columns, check for data input errors, create new columns and change the position of columns. The transformed file is then loaded into Excel.
Alteryx Power BI Tableau Prep Builder Tutorial Data File Sample Student Case
Video
PDF
Data Prep 2: Cuddly Stuffed Animals - Append


In addition to the steps used to clean the first stream, ETL software is used to separate combined fields, create new fields, and match all the field names and field types.  The two streams are then combined
Alteryx Power BI Tableau Prep Builder Tutorial Data File Sample Student Case
Video
PDF
Data Prep 3: Cuddly Stuffed Animals - Join


This case is independent of the other two ETL cases and can be used prior to or after the other cases. While the case includes minor data cleansing, the essence of this case is in the joining of data streams by using primary and foreign keys.  One of the streams is a crosstab that, before it can be joined, must be transformed to a flat data stream with a unique primary key.
Alteryx Power BI Tableau Prep Builder Tutorial Data File Sample Student Case
Video
PDF
Data Visualization: Graphing Performance Indicators


The data in Excel has errors that must be corrected before the data file is connected to Tableau Desktop. Each case requires the creation, in a randomized order, of a Pie Graph, a Map Graph, a Multi-level Bar Graph and a Horizontal or Vertical Bar Graph. The graphs created are automatically graded using our proprietary technology.
Tableau Desktop Visualization Tutorial Data File Sample Student Case
Video
PDF






Accounting Cases

Data Analysis: But I Need a Trial Balance - Single Stream

Students use ETL software to transform a General Journal into both a General Ledger and an Adjusting Journal.
 
Alteryx Power BI Tableau Prep Builder Tutorial Data File Sample Student Case
Video
PDF
Data Analysis: They Changed Accounting Systems - Append

A new accounting system was activated during the accounting period.  The field names and field types must be identical before the two General Journals can be combined. Use ETL software to transform the data and combine the two General Journals into a General Ledger and an Adjusting Journal.
 
Alteryx Power BI Tableau Prep Builder Tutorial Data File Sample Student Case
Video
PDF
Data Prep 2B: Depreciation and Changes in Net Income

Students must analyze the results of their "They Changed Accounting Systems" case and as the method of depreciation is changed calculate the effect on net income.

 
Data Prep 3: Joining Data Tables

This case is independent of the other two accounting cases and can be used prior to or after the other cases. While the case includes minor data cleansing, the essence of this case is in the joining of data streams by using primary and foreign keys.  One of the streams is a crosstab that, before it can be joined, must be transformed to a flat data stream with a unique primary key.
Alteryx Power BI Tableau Prep Builder Tutorial Data File Sample Student Case
Video
PDF