BUSINESS ANALYTICS | MBA 2nd Sem | JNTUK

Syllabus

Course Code: C-206

Business Analytics

UNIT-I

Introduction to Data Analytics: Introduction to Data Analytics - Role of Data in Organization, Data Lifecycle. (Data Source, Data Changes, Processes, Usage) -Various Data Types - Significance of Analytics- Role of Data Analyst - Difference between Data Analytics and Business Analytics – Real-World Data Analytics Examples.

UNIT-II

Tools & Techniques: Typical Data Analysis Process - Data Analytics Techniques: Regression Analysis, Factor Analysis, Cohort Analysis, Cluster Analysis-Time-Series Analysis. Data Analytics Tools -Microsoft Excel, Tableau, SAS, RapidMiner, Power BI.

UNIT-III

Concepts of Data Cleaning - Data Visualization: Over View of Data Visualization – Data Visualization Tools, Statistical Methods for Summarizing Data – How to Create Pivotal Tables Using Excel - Exploring Data Using Pivot Table –Cross Tabulation _ Creating Charts: -1. Scatter Charts, 2. Line Charts, 3. Bar Charts and Column, 4. Pie Charts and 3-D Charts, 4. Bubble Charts, - Effective use of Dashboards, Power BI and Tableau.

UNIT-IV

Descriptive Analytics: Concept of Descriptive Analytics –Measures of Central Tendency –Measuring and Calculation of Arithmetic Mean, Mode, Median - Calculation of Application of Weighted Arithmetic Mean, Geometric and Harmonic Mean using MS Excel-Measures of Variability-Range, Variance, Standard Deviation, Coefficient of Variation using MS Excel

UNIT-V

Predictive Analytics: Karl Pearson Correlation Techniques - Spearman’s Rank correlation -Simple and Multiple Regression -Regression by the Method of Least Squares – Building Good Regression Models – Regression with Categorical Independent Variables.