Discussion Post: Spreadsheet for Business Analytics
Watch the YouTube video "Analytics Superpowers - KPI Analysis" about KPI analysis using process behavior/control charts and the YouTube video "Statistical Data Analysis with Excel Made Easy!" with an example business process behavior chart. Note that Langer uses a natural end to the time series (end of year) to allow him to create two process charts which can be compared, as well. Read the attached document showing how to create and analyze the process control chart. Using your own choice of dataset and what you have learned from the video use a KPI analysis to learn about your data set. Discuss, in 500 words or more, what the KPI analysis reveals about your business question. Share the business question you are attempting to answer.
The response should include a reference list. Double-space, using Times New Roman 12 pnt font, one-inch margins, and APA style of writing and citations.