Business Analytics

Syllabus

Course Code: MS 211

BUSINESS ANALYTICS

UNIT I

Introduction to Business Analytics: Concept and Scope, Importance of data in Business, Decision Models-Concept and Types, Analyst’s role in the Business Analytics Model.                                                                     (4 Hours)

UNIT II

Exploring Data and Data Visualization: Exploring data using Pivot Tables, Pivot Charts, Look-up functions, Data Validation and whatif analysis functions in spreadsheets for data visualization. Introduction to Google Dashboards and Power BI.        (7 Hours)

UNIT III

Data Preparation: Treatment of Missing Values, Identification and management of Outliers & erroneous data.

Data Warehousing: Need for a data warehouse. ETL processes, Data Quality: Cause and Effect of Poor Data Quality, Alternative Ways of Storing Data, Master data management.                                                             (7 hours)

UNIT IV

Predictive Modelling and Analysis: Logic driven modelling, strategies for building predictive models, data-driven modelling, Supervised learning, regression-simple, multiple and logistic regression.

Data Reduction Techniques: Principal Component Analysis, Clustering Analysis: k-Nearest Neighbors.

                                                                                                                                                   (10 Hours)