Business Analytics Using Excel Workshop

Importing Text File into Excel: Exercise

• Importing (PDF)

Descriptive Business Analytics

Descriptive Business Analytics or Reporting Business Analytics: reports on insights from processing historical data (e.g. totals, means, medians, standard deviations, skewnesses).

• Descriptive Business Analytics Using Excel: Exercise 1 (PDF)

Predictive Business Analytics

Predictive Business Analytics: uses historical data to forecast the future (e.g. regression analysis).

• Predictive Business Analytics Using Excel: Exercise 1 (PDF)
• Predictive Business Analytics Using Excel: Exercise 2 (PDF)

Controlling Business Analytics:

Controlling Business Analytics: compares the existing against planned performance and, if necessary, recommends corrective actions. This type of Business Analytics relies on “fresh” data.

• Controlling Business Analytics Using Excel: Exercise 1 (PDF)