JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

22BBA503: BUSINESS ANALYTICS

BBA (Data Analytics) V Semester (R22)

Course Objectives:

To understand the importance, difference and practices of analytics in business.
To learn the basic arithmetic functions used in MS Excel.
To understand the data visualization tools, application and statistical methods.
To learn the mean variance, coefficient variation using MS Excel.
To understand the predictive analysis using MS Excel.

Course Outcomes:

Able to analyze different analytical tools in business.
Adopt the arithmetic operation in MS Excel for the business decisions.
Able to represent the data using charts, pivotal tables and statistical methods in business.
To learn the measure of variability in decision making.
To apply different techniques and models of predictive analysis in business decisions.

UNIT - I: Introduction to Data Analytics

Introduction to Data analytics - Importance of Analytics- Difference between Data analytics and Business Analytics – Business Analytics in Practice: - 1. Financial analytics, 2. HR analytics, 3. Marketing analytics, 4. Health care analytics, 5. Supply chain analytics 6. Web analytics etc.

UNIT - II: Basic Arithmetic operation of MS Excel

Basic arithmetic operation in Excel such as Addition, Subtraction, Multiplication and Division- Calculations using – Auto sum Function- SUMIF functions – MAX and MIN functions – COUNT and COUNTIF Functions-Modifying data in excel- Sorting and filtering Data in Excel- Conditional Formatting of Data in Excel- Frequency Distribution for Categorical data and Qualitative data in MS Excel.

UNIT - III: 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

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.