Planned
S.No Topics to be covered Text/ref
hrs
UNIT 1 INTRODUCTION TO BUSINESS ANALYTICS Planned Hours - 6
1 1 Analytics and Data Science – Analytics Life Cycle 1. R. Evans James,
Business Analytics, 2nd
2 1 Types of Analytics – Business Problem Definition
Edition, Pearson, 2017
3 1 Data Collection – Data Preparation 2. R N Prasad,
4 1 Hypothesis Generation – Modeling Seema Acharya,
Fundamentals of
5 1 Validation and Evaluation
Business Analytics, 2nd
6 1 Interpretation – Deployment and Iteration Edition,Wiley, 2016
UNIT II BUSINESS INTELLIGENCE Planned Hours – 6
7 1 Data Warehouses and Data Mart 1. R. Evans James,
Business Analytics, 2nd
8 1 Knowledge Management
Edition, Pearson, 2017
9 1 Types of Decisions - Decision Making Process 2. R N Prasad,
10 1 Decision Support Systems – Business Intelligence Seema Acharya,
Fundamentals of
11 1 OLAP
Business Analytics, 2nd
12 1 Analytic functions Edition,Wiley, 2016
UNIT III BUSINESS FORECASTING Planned Hours -6
13 1 Introduction to Business Forecasting 1. R. Evans James,
Business Analytics, 2nd
14 1 Predictive analytics
Edition, Pearson, 2017
15 1 Logic and Data Driven Models 2. R N Prasad,
16 1 Data Mining Seema Acharya,
Fundamentals of
17 1 Predictive Analysis Modelling
Business Analytics, 2nd
Machine Learning for Predictive analytics. Edition,Wiley, 2016
18 1
UNIT IV HR & SUPPLY CHAIN ANALYTICS Planned Hours -6
19 1 Human Resources – Planning and Recruitment 1. R. Evans James,
20 1 Training and Development - Supply chain network Business Analytics, 2nd
Edition, Pearson, 2017
21 1 Planning Demand, Inventory and Supply
2. R N Prasad,
22 1 Logistics Seema Acharya,
23 1 Analytics applications in HR & Supply Chain Fundamentals of
Applying HR Analytics to make a prediction of the Business Analytics, 2nd
24 1 demand for hourly employees for a year. Edition,Wiley, 2016
UNIT V MARKETING & SALES ANALYTICS Planned Hours- 6
25 1 Marketing Strategy 1. R. Evans James,
26 1 Marketing Mix, Customer Behaviour Business Analytics, 2nd
Edition, Pearson, 2017
27 1 selling Process
2. R N Prasad,
28 1 Sales Planning Seema Acharya,
29 1 Analytics applications in Marketing and Sales Fundamentals of
predictive analytics for customers' behaviour in Business Analytics, 2nd
30 1 marketing and sales. Edition,Wiley, 2016
TOTAL NO OF THEORY: 30 PERIODS
LIST OF EXPERIMENTS:
EXP TITLE
NO
I Cycle – MS Excel
Explore the features of Ms-Excel.
1
(i) Get the input from user and perform numerical operations
(MAX, MIN, AVG, SUM, SQRT, ROUND)
2
(ii) Perform data import/export operations for different file formats.
Perform statistical operations - Mean, Median, Mode and Standard deviation,
3 Variance, Skewness, Kurtosis
Perform Z-test, T-test & ANOVA
4
Perform data pre-processing operations i) Handling Missing data ii)
5
Normalization
Perform dimensionality reduction operation using PCA, KPCA & SVD
6
Perform bivariate and multivariate analysis on the dataset.
7
Apply and explore various plotting functions on the data set.
8
II Cycle – Power BI Desktop
Explore the features of Power BI Desktop
9
10 Prepare & Load data
11 Develop the data model
12 Perform DAX calculations
Design a report
13
14 Create a dashboard and perform data analysis
Presentation of a case study
15
TOTAL NO OF PRACTICAL: 30 PERIODS
COURSE OBJECTIVES:
• To understand the Analytics Life Cycle.
• To comprehend the process of acquiring Business Intelligence
• To understand various types of analytics for Business Forecasting
• To model the supply chain management for Analytics.
• To apply analytics for different functions of a business
COURSE OUTCOMES:
CO1: Explain the real world business problems and model with analytical solutions.
CO2: Identify the business processes for extracting Business Intelligence
CO3 : Apply predictive analytics for business fore-casting
CO4: Apply analytics for supply chain and logistics management
CO5: Use analytics for marketing and sales.
TEXT BOOKS
1. R. Evans James, Business Analytics, 2nd Edition, Pearson, 2017
2. R N Prasad, Seema Acharya, Fundamentals of Business Analytics, 2nd Edition,Wiley,
2016
3. Philip Kotler and Kevin Keller, Marketing Management, 15th edition, PHI, 2016
4. VSP RAO, Human Resource Management, 3rd Edition, Excel Books, 2010.
5. Mahadevan B, “Operations Management -Theory and Practice”,3rd Edition, Pearson
Education,2018.
CO’s-PO’s & PSO’s MAPPING
PO’s PSO’s
CO’s
1 2 3 4 5 6 7 8 9 10 11 12 1 2 3
1 2 2 3 1 1 - - - 1 2 1 1 3 2 1
2 3 3 3 2 3 - - - 1 2 2 2 3 1 2
3 2 2 3 3 2 - - - 3 1 1 3 3 1 2
4 2 1 1 2 2 - - - 3 3 2 1 1 3 1
5 2 3 2 3 2 - - - 3 3 1 3 3 1 1
AVg. 2.2 2.2 2.4 2.2 2 - - - 2.2 2.2 1.4 2 2.6 1.6 1.4
1 - low, 2 - medium, 3 - high, ‘-' - no correlation
