Archive | Data analytics RSS feed for this section

Upcoming Webinar: Bring Data Analytics to Your Classroom with Google Sheets

On Thursday, March 18, 2021, from 3 to 4 pm Eastern, I will be presenting at an Ohio Society of CPAs webinar on how you can use Google Sheets to bring data analytics into your classroom. You can register for free at this link. This webinar will feature a Google Sheets data analytics project I […]

Continue reading

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

Note from Wendy: This case is the fourth of the four interactive Excel dashboard cases I created around the Jubilee Superstores data set – so if you have been following this blog, you have already seen the prebuilt dashboard in financial accounting project, the constructing a dashboard project for financial accounting, and the prebuilt dashboard […]

Continue reading

New! Prebuilt Interactive Excel Dashboard project for introductory managerial accounting available

This new case has students use a prebuilt interactive Excel dashboard to analyze a company’s product contribution margins and segment margins. This dashboard is ready for students to use; students will view a tutorial video about the case, read the instructions, and use the Excel dashboard to answer the case questions. The case will take, […]

Continue reading

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! Prebuilt Interactive Excel Dashboard project for introductory financial accounting available

This new case has students use a prebuilt interactive Excel dashboard to analyze sales transactions. This dashboard is ready for students to use; students will view a tutorial video about the case, read the instructions, and use the Excel dashboard to answer the case questions. The case will take, on average, 15 – 20 minutes […]

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

New! Google Sheets data analytics case for introductory financial accounting available – Kent Cabinet Hardware

This new case is designed to be completed using Google Sheets. The case can be completed by students using Chromebooks. I am really excited to be able to share this case – it is the first one I have created that uses Google Sheets as the software. Read on for details…. Data set background 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