A job cost mini-dashboard for a quick data analytics exercise

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 to the mini-dashboard. I also created a quick video about using mini-dashboards in Tableau Public – that mini-dashboard intro video is available at this link.

To get you started on the kinds of questions you can ask with this job cost mini-dashboard, here are some ideas:

  1. What is the gross profit generated by the <insert product type here> product group in all plants?
  2. What is the total sales revenue generated by <insert product ID here> in the <insert plant location here> plant?
  3. How many <insert product ID here> models were sold by the <insert plant location here> location?
  4. What is the gross profit of the <insert product type here> product group in the <insert plant location here> plant?

Anyways, I have made several of these mini-dashboards and have found that they are a quick and easy way to insert some data analysis into an introductory accounting course. I will be sharing some of these mini-dashboards from time to time. Enjoy!

Wendy

About Dr. Wendy Tietz, CPA, CMA, CSCA, CGMA

Dr. Wendy Tietz is a professor of accounting at Kent State University in Kent, Ohio, USA. She is also a textbook author with Pearson Education.

5 Responses to “A job cost mini-dashboard for a quick data analytics exercise”

  1. Hi Wendy–My Accounting II class tried playing around with this today, but we didn’t see any changes…are we supposed to? Thanks!

    Nancy

    On Wed, Apr 13, 2022 at 8:58 AM Accounting in the Headlines wrote:

    > Dr. Wendy Tietz, CPA, CMA, CSCA, CGMA posted: ” 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 > dashboa” >

  2. Carolyn Christesen Reply April 13, 2022 at 11:40 am

    Hi Wendy – I had the same experience as Nancy and did not see changes when clicking on different plants, etc. Thank you! Carolyn

    • Dr. Wendy Tietz, CPA, CMA, CSCA, CGMA Reply April 13, 2022 at 11:43 am

      I fixed it about ten minutes ago; did you refresh and try again? (I just doublechecked and it is working since I fixed it.)

    • Dr. Wendy Tietz, CPA, CMA, CSCA, CGMA Reply April 13, 2022 at 11:43 am

      Be sure to refresh the page so that you get the change that I made.

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.