Business Analytics

Business analytics is the use of data, information technology, statistical analysis, quantitative methods, and mathematical computer-based models to help managers gain improved insight about their business operations and make better, fact-based decisions.  This course will introduce students to concepts and tools of business analytics.

Course outline and assignments 

Module 1. Intro to analytics, Excel basics  
Module 2.  Data visualization
Module 3.  Functions: IF, COUNTIF, SUMIF
Module 4.  Pivot Tables – edit hw
Module 5. Funciton: VLOOKUP, MATCH, INDEX
Module 6.  Dashboards – to be modified- Macros, etc
Module 7.  Forecasting & regressions
Module 8.  Financial forecasting 
Module 9.  Building a heat map
Module 10. Power map
Module 11. Working with real time data 

Extra resources