Semester-VI
( [Link] )
Discipline Specific Core Course- 6.1 (DSC-6.1): Business Analytics
Course Credi Credit distribution of the Eligibili Pre-
title ts course ty requisite
& criteria of the
Lectur Tutori Practical/
Code course
e al Practice (if any)
Business 4 2 0 Pass in Studied Business
Analytics 2 Class XII Statistics
DSC- 6.1
(DSC-3.1)
Learning Objectives
This course aims to introduce the learners to business intelligence and analytics which includes
describing business data, analysing the data using various statistical tools for creating predictive
models and making inferences for solving business problems and for providing assistance in
business decision making.
Learning Outcomes:
After completion of the course, the learners will be able to:
1. Describe skills for computation and aggregation of data using spreadsheets.
2. Analyse data with the help of pivot tables and pivot charts.
3. Analyse data using R packages and interpret the results.
4. Identify linear regression models using spreadsheet & R and interpret the results.
5. Examine textual data analysis using R.
SYLLABUS OF DSC-6.1
Unit 1: Introduction (3 hours)
Data and Data Science; Data analytics and data analysis, Classification of Analytics, Application of
analytics in business, Types of data: nominal, ordinal, scale; Big Data and its characteristics,
Applications of Big data. Challenges in data analytics.
Unit 2: Data Preparation, Summarisation and Visualisation Using spreadsheet (6 hours)
Data Preparation and Cleaning, Sort and filter, Conditional formatting, Text to Column, Removing
Duplicates, Data Validation, identifying outliers in the data, covariance and correlation matrix,
Moving Averages, Finding the missing value from data; Summarisation; Visualisation: scatter plots,
line charts, histogram, etc., Pivot Tables, pivot charts and interactive dashboards.
Unit 3: Getting started with R (6 hours)
Introduction to R, Advantages of R, Installation of R Packages, Importing data from spreadsheet files,
167
Commands and Syntax, Packages and Libraries, Data Structures in R - Vectors, Matrices, Arrays,
Lists, Factors, Data Frames, Conditionals and Control Flows, Loops, Functions, and Apply family.
Unit 4: Descriptive Statistics Using R (6 hours)
Importing Data file; Data visualisation using charts: histograms, bar charts, box plots, line graphs,
scatter plots. etc; Data description: Measure of Central Tendency, Measure of Dispersion,
Relationship between variables: Covariance, Correlation and coefficient of determination.
Unit 5: Predictive and Textual Analytics (9 hours)
Simple Linear Regression models; Confidence & Prediction intervals; Multiple Linear Regression;
Interpretation of Regression Coefficients; heteroscedasticity; multi-collinearity.
Basics of textual data analysis, significance, application, and challenges. Introduction to Textual
Analysis using R. Methods and Techniques of textual analysis: Text Mining, Categorization and
Sentiment Analysis.
Note:
The General Purpose Software referred in this course will be notified by the University
Departments every three years. If the specific features, referred to in the detailed course
above, are not available in that software, to that extent it will be deemed to have been
modified.
Practical Exercises (60 hours):
The learners are required to
1. Showcase their understanding of the basics of Spreadsheet: Organizing data with
Spreadsheet – Performing simple computations and aggregations using Spreadsheet - Working
with Summing and other Reporting functions in Spreadsheet - Working with pivot tables and
charts - Using Spreadsheet for Data Analytics: Power Query - Power Pivot - Power view -
Power Map - Building tips – Display tips - Keyboard shortcuts – Mouse shortcuts -
Standardized layouts - Understanding table-based and spreadsheet-based layouts.
2. Showcase their understanding of data cleansing techniques using External Data – Searching
and Combining Data with Power Query: Getting started with Power Query - Know the
Environment tabs and toolbars - Access new or existing reports - Importing and combining data
from databases, web, files - Splitting and aggregating data - Discovering and Analyzing Data
with Power Pivot: Database concepts - Loading Data into Power Pivot - Using Power Query
and Power map add-ins - Designing Pivot Table reports - Filtering data – Creating Custom
functions and formulas - Formatting Pivot Tables - Managing Power Pivot Data - Setting
Connection properties - Managing Data sources - Configuring Pivot Table Options, Preparation
of Histograms - Pareto charts – Boxplots - Treemap and Sunburst charts.
3. Create Linear Regression Models using Spreadsheet; Interpretation of results. Applying tests
for heteroscedasticity and multi-collinearity.
4. Read datasets into R - Export data from R - Manipulate and Process Data in R - Use functions
and packages in R - Demonstrate with a Case Study to perform basic analytics using R.
5. Use R for analysing textual data; Data loading into Python; Pre-processing and Text Clean
up; Generating a TF-IDF (Term Frequency Inverse Document Frequency) Matrix; Data
Clustering; Visualization & Reporting.
168
Suggested Readings:
● Alexander, M., Decker, J., & Wehbe, B. (2014). Microsoft business intelligence tools
for spreadsheet analysis. New Jersey, United States: Wiley.
● Giri, A., & Paul, P. (2021). Applied marketing analytics: using spss (modeler, statistics
and amos graphics). Delhi, India: PHI Learning Pvt. Ltd.
● Kumar, D. U. (2017). Business analytics: the science of data driven decision making.
New Jersey, United States: Wiley.
● McKee, A. (2003). Textual analysis: a beginner's guide. London, United Kingdom:
Sage Publication.
● Motwani, B. (2019). Data analytics with r. New Jersey, United States: Wiley.
● North, M. (2012). Data mining for the masses. Athens, Greece: Global Text Project.
● Ohri, A (2012). R for business analytics. Springer.
● Paul, T. (2011). R cookbook. New York, United States: O Reilly Media.
● Provost, F., & Fawcett, T. (2013). Data science for business. New York, United States:
O'Reilly Media.
● Rao, P. H. (2013). Business analytics—an application focus. Delhi, India: PHI Learning
Private Limited.
Note: Suggested readings will be updated by the Department of Commerce and
uploaded on the Department's website.
169