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.  Functions: IF, COUNTIF, SUMIF
Module 3. Funciton: VLOOKUP, MATCH, INDEX
Module 4.  Data visualization
Module 5.  Pivot Tables
Module 6.  Dashboards
Module 7.  Forecasting & regressions
Module 8.  Financial forecasting 
Module 9.  Building a heat map
Module 10.  Working with real time data project
Module 11.  coming soon
Module 12. coming soon 

Extra resources