Looking for a quick data analytics exercise for financial statement analysis in an introductory accounting class? You can give your students the link for this financial statement analysis dashboard and then ask a series of questions. There is no software for students to install; the dashboard is hosted on Tableau Public and can be accessed […]
Continue reading
Tag Archives: Data analytics
A job cost mini-dashboard for a quick data analytics exercise
April 13, 2022 
5 Comments
Looking for a quick data analytics exercise for introductory managerial accounting? You can give your students the link for this job cost analysis dashboard and then ask a series of questions. There is no software for students to install; the dashboard is hosted on Tableau Public and can be accessed by anyone with the link […]
Continue readingNew! Constructing an Interactive Excel Dashboard project for introductory financial accounting available
January 13, 2021 0 Comments
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 readingNew! Google Sheets data analytics case for introductory accounting available – City of Magicville
January 11, 2021 2 Comments
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 readingAICPA webinar on how to introduce data analytics in your course when your students have Chromebooks
October 21, 2020 3 Comments
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 readingAnnouncing a new blog for data analytics cases, Accounting is Analytics!
January 14, 2020 6 Comments
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 readingSummary of seven data analytics projects for introductory accounting
April 7, 2019 0 Comments
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 readingNew data analytics case for introductory financial accounting available – KAT Insurance!
February 25, 2019 3 Comments
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 readingNEW! Data analytics project: Contribution margin analysis and segment margins for introductory managerial accounting
January 5, 2019 2 Comments
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 readingRecap of all data analytics projects available
January 4, 2019 0 Comments
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
Accounting in the Headlines 