Tag Archives: Data analytics

New! Constructing an Interactive Excel Dashboard project for introductory financial accounting available

In this new case, students build an interactive Excel dashboard to analyze sales transactions. Students will view tutorial videos for each of the five sections in the project and will use their dashboard to answer the case questions. The case will take students, on average, 60 – 90 minutes to complete. The Teaching Notes for […]

Continue reading

New! Google Sheets data analytics case for introductory accounting available – City of Magicville

This new case is designed to be completed using Google Sheets for an introductory financial accounting class. The case can be completed by students using Chromebooks. I am really excited to be able to share this case – it is the second one I have created that uses Google Sheets as the software (see this […]

Continue reading

AICPA webinar on how to introduce data analytics in your course when your students have Chromebooks

Join Kimberly Swanson Church, PhD, Missouri State University, and me as we walk through how to introduce data analytics in your introductory accounting courses using Google Sheets in an AICPA webinar on Wednesday, November 4, 2020, from 4 – 5 pm Eastern. The discussion will include what data analytics is, the impact of analytics on […]

Continue reading

Announcing a new blog for data analytics cases, Accounting is Analytics!

Exciting announcement! Three of us have created a blog site called “Accounting is Analytics.” This site houses data analytics teaching materials (cases and instructional material) for introductory accounting. We (Wendy Tietz, Jennifer Cainas, and Tracie Miller-Nobles) develop cases for Excel, Power BI, and/or Tableau that are suitable for introductory accounting classes. All materials are free […]

Continue reading

Summary of seven data analytics projects for introductory accounting

There has been a lot of interest in the data analytics cases for introductory accounting that have been posted on this blog. I am providing a summary of the seven data analytics cases and related links in the table below to make it more convenient to see, at a glance, what projects are available and […]

Continue reading

New data analytics case for introductory financial accounting available – KAT Insurance!

The demand for business graduates with data analytics skills has exploded, while the tools and techniques are continuing to evolve and change at a rapid pace. Three of us who teach introductory accounting (Wendy Tietz, Jennifer Cainas, and Tracie Miller-Nobles) have joined forces to develop a case to introduce data analytics in the introductory financial […]

Continue reading

NEW! Data analytics project: Contribution margin analysis and segment margins for introductory managerial accounting

This blog post contains a data analytics project that is suitable for introductory managerial accounting. The student uses Excel to analyze a data set that contains more than 48,000 records. The data analytics project can be assigned in the course once the concepts of contribution margin, contribution margin ratio, and segment margins reviewed. Overview of […]

Continue reading

Recap of all data analytics projects available

Hello! I have posted a few data analytics projects here on my blog and thought it might be useful as the semester starts to post the links in one post. (Heads up: I will be posting a new managerial accounting data analytics case within the next week too!) Here goes: Project 1: Transaction analysis for […]

Continue reading

A recap of the Excel data analytics project blog posts

Hello! I have posted a few data analytics projects here on my blog and thought it might be useful as the semester starts to post the links in one post. Here goes: Project 1: Transaction analysis for Introductory financial accounting using the City of Somerville, MA, online checkbook data set (link) Project 2: Budgeting and […]

Continue reading

Data analytics project: Gross profit analysis for introductory financial accounting

This blog post contains a data analytics project that is suitable for introductory financial accounting. The student uses Excel to analyze a data set that contains more than 48,000 records. The data analytics project can be assigned early in the course once the concept of gross profit is reviewed. Overview of project This project uses […]

Continue reading