Tag Archives: Data analytics

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

Data analytics project: Budgeting and performance evaluation for introductory managerial accounting using the City of Somerville, MA, online checkbook data set

As promised in my data analytics introductory financial accounting project blog post, here is the second data analytics project I have developed. This one covers budgeting and performance evaluation in introductory managerial accounting. Background After thinking about the best tool to use for data analytics in the introductory classes, I decided to use Excel as […]

Continue reading

Data analytics project: Transaction analysis for introductory financial accounting using the City of Somerville, MA, online checkbook data set

Data analytics is here! I have been working on some projects for the past few months to be able to incorporate data analytics into the introductory accounting classes. After thinking about the best tool to use for data analytics in the introductory classes, I decided to use Excel as the analytics tool since introductory accounting […]

Continue reading

How might Target use data analytics to help make decisions?

In a recent visit in early February to a Target (NYSE: TGT) store in northeast Ohio, snow shovels were on display next to swimming suits, offering an interesting juxtaposition. [The average temperature in northeast Ohio in February is about 31° Fahrenheit, accompanied by an average monthly snowfall of about 15.”] An article in the Wall […]

Continue reading