Course materials

Course resources

Midterm 1 Practice Problems
Open Midterm 1 Practice Problems
Midterm 2 Practice Materials Coming Soon

Class 1: Introduction to the Analytics Mindset and Skillset

Materials

Slides

Class 01 Slides
View slides: Class 01 Slides

Class 2: Data Quality

Materials

Case

Analytics mindset case studies ETL Overview
This is an overview reading about data quality. It can be used as a reference.
View Online: Analytics mindset case studies ETL Overview PDF: Analytics mindset case studies ETL Overview Word: Analytics mindset case studies ETL Overview
Case

Analytics mindset case studies ETL Case1 Alteryx
This case discusses issues relating to data quality and the ETL process.
View Online: Analytics mindset case studies ETL Case1 Alteryx PDF: Analytics mindset case studies ETL Case1 Alteryx Word: Analytics mindset case studies ETL Case1 Alteryx
Slides

Class 02 Slides
View slides: Class 02 Slides

Class 3: ETL: Combining and Summarizing Data

Materials

Case

EYARC Joins Case
The reference case for the activities we will cover in class.
View Online: EYARC Joins Case PDF: EYARC Joins Case Word: EYARC Joins Case

Class 4: Extract, Transform, and Load (ETL) Changing Fields

Materials

Case

EYARC Transform Fields Case
An introductory ETL case on focusing on extracting and changing information in data fields.
View Online: EYARC Transform Fields Case PDF: EYARC Transform Fields Case Word: EYARC Transform Fields Case
Slides

Class 03 Slides
View slides: Class 03 Slides
Slides

Class 04 Slides
View slides: Class 04 Slides

Class 5: ETL: Cleaning and Transforming Data

Materials

Slides

Class 05 Slides
View slides: Class 05 Slides

Class 6: Transaction Analytics: Understanding Transactions

Materials

Case

Analytics mindset case studies FairviewInc Reimbursement calculation method
Case 1
View Online: Analytics mindset case studies FairviewInc Reimbursement calculation method PDF: Analytics mindset case studies FairviewInc Reimbursement calculation method Word: Analytics mindset case studies FairviewInc Reimbursement calculation method
Case

Analytics mindset case studies FairfieldInc Travel expense audit
Case 2
View Online: Analytics mindset case studies FairfieldInc Travel expense audit PDF: Analytics mindset case studies FairfieldInc Travel expense audit Word: Analytics mindset case studies FairfieldInc Travel expense audit
Slides

Class 06 Slides
View slides: Class 06 Slides

Class 7: Transaction Analytics: Identifying Unusual Activity

Materials

Case

Analytics mindset case studies FairviewInc Reimbursement calculation method
View Online: Analytics mindset case studies FairviewInc Reimbursement calculation method PDF: Analytics mindset case studies FairviewInc Reimbursement calculation method Word: Analytics mindset case studies FairviewInc Reimbursement calculation method
Case

Analytics mindset case studies FairviewInc Employee assignment method
View Online: Analytics mindset case studies FairviewInc Employee assignment method PDF: Analytics mindset case studies FairviewInc Employee assignment method Word: Analytics mindset case studies FairviewInc Employee assignment method
Slides

Class 07 Slides
View slides: Class 07 Slides

Class 9: Integrating Analytical Skills 1

Materials

Slides

Slides Class 09
View slides: Slides Class 09

Class 10: Integrating Analytical Skills 2

Materials

Case

General Ledger Clean Up
View Online: General Ledger Clean Up Word: General Ledger Clean Up
Case

International Group Taxes Overview
View Online: International Group Taxes Overview Word: International Group Taxes Overview
Case

Suspect Vendors Overview
View Online: Suspect Vendors Overview Word: Suspect Vendors Overview
Case

Sales and Use Tax Allocation Overview
View Online: Sales and Use Tax Allocation Overview Word: Sales and Use Tax Allocation Overview
Case

Organizing Financial Report Data Overview
View Online: Organizing Financial Report Data Overview Word: Organizing Financial Report Data Overview
Case

PO Splitting Overview
View Online: PO Splitting Overview Word: PO Splitting Overview
Slides

Class 10 Slides
View slides: Class 10 Slides

Class 11: Integrating Analytical Skills: Conclusion

Materials

Slides

Class 11 Slides
View slides: Class 11 Slides

Class 12: Analyzing Accounting Disclosures and Financial Statement Analysis

Materials

Case

FAANG case20170112
View Online: FAANG case20170112 Word: FAANG case20170112
Slides

Class 12 Slides
View slides: Class 12 Slides

Course resources

Midterm 1 Practice Problems

Midterm 2 Practice Materials Coming Soon

Materials

Class 01 Slides

Materials

Analytics mindset case studies ETL Overview

Analytics mindset case studies ETL Case1 Alteryx

Class 02 Slides

Materials

EYARC Joins Case

Materials

EYARC Transform Fields Case

Class 03 Slides

Class 04 Slides

Materials

Class 05 Slides

Materials

Analytics mindset case studies FairviewInc Reimbursement calculation method

Analytics mindset case studies FairfieldInc Travel expense audit

Class 06 Slides

Materials

Analytics mindset case studies FairviewInc Reimbursement calculation method

Analytics mindset case studies FairviewInc Employee assignment method

Class 07 Slides

Materials

Slides Class 09

Materials

General Ledger Clean Up

International Group Taxes Overview

Suspect Vendors Overview

Sales and Use Tax Allocation Overview

Organizing Financial Report Data Overview

PO Splitting Overview

Class 10 Slides

Materials

Class 11 Slides

Materials

FAANG case20170112

Class 12 Slides