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

In addition to the data analytics case we posted last week for introductory financial accounting, we have also developed a case, using the same KAT Insurance Company data set, for introductory managerial accounting. The three of us who teach introductory accounting (Wendy Tietz, Jennifer Cainas, and Tracie Miller-Nobles) developed a KAT Insurance case to introduce data analytics in the introductory managerial accounting course. This case uses real-life insurance company data that has been anonymized and simplified. The case itself is a one-page case and is designed to be able to be completed in 30 – 40 minutes with each software tool (Excel, Power BI, and Tableau.)

white ipad
Photo by rawpixel.com on Pexels.com

This case teaches students how to drill-down into a company’s sales data, gaining a deeper understanding of the company’s sales, variable costs, and contribution margin, and how this information can be used for decision-making. Students will use Excel, Power BI, and/or Tableau to analyze the sales transactions for an insurance company. Students will first have to find and correct errors in the data set. Students then will use various techniques to analyze the case. Step-by-step tutorial videos will guide students through the Excel, Power BI, and Tableau portions of the case analysis. This case will introduce the student to data analytics topics including data cleansing, data dictionaries, and data visualizations.

***You can obtain the Instructor Guide for the KAT Insurance Managerial Accounting case by requesting it at this link.***

Several resources have been developed for this case to make it easy to integrate into introductory managerial accounting courses. Read on for the resources that have been developed and for information on how to request the case and related resources.

What’s included

The following resources are available for this case and are included or linked in the Instructor Guide for the KAT Insurance Managerial Accounting case:

  1. Case (one-page Word handout)
  2. Student guide (Word)
  3. General learning objectives for the overall case
  4. Specific learning objectives (related to specifically to Excel, Power BI, and Tableau)
  5. Data sets containing 65,000+ records (4 versions: A, B, C, and D)
  6. 24-record tutorial data set
  7. Step-by-step tutorial video (close captioned)
  8. Scripted tutorial video slides (pdf)
  9. Editable grading rubric (Word document in Appendix A)
  10. Multiple-choice questions with solutions for each of the four data sets Excel solution files
  11. Optional video assignment instructions

How to obtain case materials

***You can obtain the Instructor Guide for the KAT Insurance Managerial Accounting case by requesting it at this link.***

You will need to fill out a brief form and then we will verify your instructor status prior to sending you the Instructor Guide. We generally send the Instructor Guide within a week after the request; we will contact you if we need additional information to verify your instructor status.

The Instructor Guide contains links to all the resources listed above. We do ask that you not share the Instructor Guide with students. Please do not post the solutions to the case on Blackboard, Canvas, or any other Learning Management System. Also, please do not post the Instructor Guide or the solutions on any web site. (Thank you in advance for helping to maintain the academic useful life of the materials.)

Again, you can obtain the Instructor Guide for the KAT Insurance Managerial Accounting case by requesting it at this link.

We hope you and your students find value in this data analytics case for introductory managerial accounting. Please share any feedback with us about your experiences in using the case. Enjoy! Also, remember that we also have KAT Insurance case for introductory financial accounting (see link.)

Sincerely,

Wendy M. Tietz, PhD, CPA, CMA, CSCA

 Jennifer M. Cainas, DBA, MAcc, CPA

Tracie L. Miller-Nobles, CPA

Blog: https://iteachaccounting.com/

Financial Accounting Data Analytics Case for Excel, PowerBI, and/or Tableau

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 accounting course. This case uses real-life insurance company data that has been anonymized and simplified. The name of the fictitious company analyzed in the case is “KAT Insurance Company.” The case itself is a one-page case and is designed to be able to be completed in 30 – 40 minutes with each software tool (Excel, Power BI, and Tableau.)

pngLOGO1

This case teaches students how to drill-down into a company’s sales data, gaining a deeper understanding of the company’s sales and how this information can be used for decision-making. Students will use Excel, Power BI, and/or Tableau to analyze the sales transactions for an insurance company. Students will first have to find and correct errors in the data set. Students then will use various techniques to analyze the case. Step-by-step tutorial videos will guide students through the Excel, Power BI, and Tableau portions of the case analysis. This case will introduce the student to data analytics topics including data cleansing, data dictionaries, and data visualizations.

***You can obtain the Instructor Guide for the KAT Insurance Financial Accounting case by requesting it at this link.***

Several resources have been developed for this case to make it easy to integrate into introductory financial accounting courses. Read on for the resources that have been developed and for information on how to request the case and related resources.

What’s included

The following resources are available for this case and are included or linked in the Instructor Guide for the KAT Insurance Financial Accounting case:

  1. Case (one-page Word handout)
  2. Student guide (Word)
  3. General learning objectives for the overall case
  4. Specific learning objectives (related to specifically to Excel, Power BI, and Tableau)
  5. Data sets containing 65,000+ records (4 versions: A, B, C, and D)
  6. 24-record tutorial data set
  7. Step-by-step tutorial video (close captioned)
  8. Scripted tutorial video slides (pdf)
  9. Editable grading rubric (Word document in Appendix A)
  10. Multiple-choice questions with solutions for each of the four data sets Excel solution files
  11. Optional video assignment instructions

How to obtain case materials

***You can obtain the Instructor Guide for the KAT Insurance Financial Accounting case by requesting it at this link.***

You will need to fill out a brief form and then we will verify your instructor status prior to sending you the Instructor Guide. We generally send the Instructor Guide within a week after the request; we will contact you if we need additional information to verify your instructor status.

The Instructor Guide contains links to all the resources listed above. We do ask that you not share the Instructor Guide with students. Please do not post the solutions to the case on Blackboard, Canvas, or any other Learning Management System. Also, please do not post the Instructor Guide or the solutions on any web site. (Thank you in advance for helping to maintain the academic useful life of the materials.)

We hope you find value in this data analytics case for introductory financial accounting. Please share any feedback with us about your experiences in using the case. Enjoy! Also, watch for our upcoming KAT Insurance Managerial Accounting case….

Again, you can obtain the Instructor Guide for the KAT Insurance Financial Accounting case by requesting it at this link.

Sincerely,

Wendy M. Tietz, PhD, CPA, CMA, CSCA

Jennifer M. Cainas, DBA, MAcc, CPA

Tracie L. Miller-Nobles, CPA

Overview of Data Analytics Projects

Wendy Tietz (accountingintheheadlines.com) and I are presenting a poster at the American Accounting Association Annual meeting in Washington DC this upcoming week. Our presentation centers around using data analytics in introductory accounting.

white ipad
Photo by rawpixel.com on Pexels.com

Data analytics is the process of inspecting, cleansing, transforming, and modeling data with the goal of discovering useful information, suggesting conclusions, and supporting decision-making.

In introductory accounting, we can begin to discuss with our students how data analytics is used to solve accounting questions. For example:

Walmart – In 2015, Walmart announce it was in the process of creating the world’s largest private data cloud which would be able to process 2.5 petabytes of information every hour. The company uses this data to analyze sales across different stores in different geographical areas in real time. 

Airbnb – Since 2008, Airbnb has collected around 1.5 petabytes on vacation habits and lodging preferences. The company developed an algorithm that helped landlords develop the right price of their rentals, identify areas where the company did not have enough listings to recruit potential rental property.

Dickey’s Barbecue Pit – Dickey’s has its own point-of sale (POS) system called “Smoke Stack” that provides real-time feedback on sales and key performance indicators (KPIs). Data is examined every 20 minutes to enable immediate decisions. If lower-than-expected sales occur, the company can send text invitations to their loyal customers with a coupon to increase sales. 

Source: Marr, B. (2016). Big data in practice. West Sussex, UK: John Wiley and Sons Ltd.

alphabet class conceptual cube
Photo by Pixabay on Pexels.com

We can also begin to teach more advanced excel and data analytics skills in our courses so students are more prepared for advanced data analytics in later business courses. The goal of our projects is to build students Excel skills using larger data sets while still learning accounting. Below you’ll find a summary of the projects we have developed so far:

Project 1: City of Somerville, MA: Transaction Analysis (Financial Accounting)

  • 55,000 records, real-world data
  • Pivot tables
  • Sum, count, and average columns in pivot table
  • Pivot charts

Project 2: Hula Hut Burger: Fixed Asset Schedule (Financial Accounting)

  • 1,500 records, anonymized data
  • Pivot tables
  • Calculated fields
  • Slicer, Timeline tool
  • Finding errors

Project 3: Cabinet Accessory Company: Sales, Cost, and Gross Profit Analysis (Financial Accounting)

  • 49,000 records
  • Pivot tables and pivot charts
  • Find and correct errors
  • Analyze sales data
  • Determine net impact on retained earnings
  • Interpret findings

Project 4: City of Somerville, MA: Budgeting and Performance Evaluation (Managerial Accounting)

  • 55,000 records, real-world data
  • Pivot tables
  • Format pivot tables
  • Apply filters
  • Prepare budget variances and analyze

Off to learn!

Do you remember what it is like to learn? I’m headed to Orlando, FL this week to an intensive data analytics conference hosted by the American Accounting Association. I’m going to be learning a lot of great data analytics tools including advanced Excel, Power BI, Tableau, and maybe, if I get brave, even Python or R.

abstract art blur bright
Photo by Pixabay on Pexels.com

I’m excited, nervous, and terrified. A jumble of feelings as I enter the learning experience. As a teacher, I’m reminded that this is how my students feel when they step into my class at the beginning of each semester. I can help them overcome their anxiety by doing a couple of things:

  • Create a warm and welcoming environment.
  • Be positive and happy!
  • Explain what the course covers and all of the requirements.
  • Share a little bit about me and have them share a little bit about them.
  • Make sure that the students know that I’m here to help them succeed.
  • Instill confidence by sharing stories of other students who have succeeded.
black and white blackboard business chalkboard
Photo by Pixabay on Pexels.com

I can’t wait to head to Orlando and be a student again. I know I’m going to learn a lot and I’ll have great instructors who will help me succeed. When’s the last time you’ve learned something new? What were your takeaways? How did being a student help you become a better professor?

Data analytics project: Fixed Asset Schedule, Hula Hut Burger

Overview of this project

This project uses fixed asset information from anonymized and modified data for a tax client from a public accounting firm. The data set includes 1,500 fixed asset records. In this project, the student will use Excel to create a variety of pivot tables, format the pivot tables, apply filters, create calculated fields, use the slicer and timeline tool. In addition, students will be asked to analyze the data for errors. The students will prepare several different fixed asset schedules and also a pivot chart (column type) that depicts book value by asset category and region.

Project resources

Learning Objectives

  1. Create a pivot table in Excel
  2. Format a pivot table
  3. Apply filters to a pivot table
  4. Create sum columns in a pivot table
  5. Create a calculated field
  6. Use the slicer tool in a pivot table
  7. Analyze data for errors
  8. Use the timeline tool in a pivot table
  9. Create a pivot chart in Excel

Office 365 or Excel 2016 (newest version)

Anyone doing this project will need to have either Office 365 or Excel 2016. It is important that students update their version of Office 365 and/or Excel 2016.

Solution

If you would like to have a copy of the Excel solution file, please fill out the request form. (There is a separate request form for each project.) Once I verify your status as an instructor, I will email the file to you within a week. Please do not post the solution file on the internet and please do not share the solutions files with your students. The Excel solutions file is for you own use only.

Other Projects

I am working on this project in conjunction with my colleague, Dr. Wendy Tietz. You can find additional data analytics projects for introductory financial and introductory managerial accounting on her website, accountingintheheadlines.com. I will be developing additional projects in the coming months. Stay posted to the blog!

Surrounding Yourself with Great Colleagues

pexels-photo-601170.jpeg

This journey into creating a blog with my teaching ideas and projects began because I have great colleagues! My colleague and friend, Wendy Tietz, suggested that I build a website to host my projects and teaching ideas on. She and I are working on a project to incorporate Big Data Analytics into the Intro Accounting courses. and I have just developed my first big data project (Hula Hut Burgers – watch for it to be published soon!).

I don’t know much about this blogging thing, though, and so I plan on relying on Wendy for lots of help. That’s the great thing about surrounding yourself with great colleagues – I am a better educator because of them! So, stay posted! I’ll be updating this site as I go along.