Course Title: Course Code: CSIT660 Credit Units: 3 Level: PG

Annexure ‘AAB-CD-01’
Course Title: Business Analytics and Modelling L T P SW/FW PSDA TOTAL

Course Code: CSIT660 CREDIT UNITS
Credit Units: 3 2
Level: PG
2 0 0 3 3
Course Objectives:
 The objective of this course is to introduce the concepts and importance of business analytics.
 To understand the significance and alignment of business & analytics, leading to growth.
 To emphasize further the role and aspects of implementation of business analytics in organizations.
Prerequisites: The student should have a preliminary understanding of statistics.
Course Learning Outcomes:

Upon successful completion of this course, the students will be able to
 Identify business situations requiring use of analytical techniques
 Apply business analytics skills in their organizations
 Determine and apply forecasting techniques for business decision making
 Develop managerial and leadership capabilities
Module Course Contents Weightage

No.
1 Module I: To introduction Business Analytics and Exploratory Data Analysis 20%
 Defining Business Analytics

 Role of Business Analytics
 Life cycle of BA and Application of BA in Business Environment
 Skills required for Business Analyst profile
 Summarizing Data
 Normality Test, Homogeneity Test
 Graphical Charts: Histogram, Box plots, Bar plots, Scatterplot
2 Module II Analytics on Spreadsheets 20%
 Excel Formulae
 Advance Excel (Sum, Sumif, Round) Functions
 Row function (Vlookup, hlookup )
 Column function (Vlookup, hlookup)
 Index & Match Function
3 Module III Descriptive Analytics 20%
 Measures of central tendency and dispersion

 Application of Pivot Tables
 Using a PivotChart to Summarize Research Surveys
 Ensuring Charts Update Automatically
 Using Sparklines to Summarize Multiple Data Series
 Slicers and Crosstabulation
 Decision Analysis and Decision Tree
4 Module IV Predictive Analytics and Monte Carlo Simulation 20%
 Multiple Regression Analysis

 Multidimensional Scaling (MDS)
 Linear Optimization
 Time Series analysis
 Monte Carlo Simulation and Risk Analysis
 New Product Development Model
 Sensitivity Analysis
 New Vendor Model
5 Module V Visualization and its role in analytics 20%
 What is visualization
 Contribution of visualization in analytics
 Principles of communicating data, Beautiful data & how do we achieve beauty
 Importance of storytelling, Effective visualization
 Data Visualization & MS Excel
Pedagogy for Course Delivery:

This course pedagogy will involve a blended learning approach, having formal lectures, case studies, group project work; and student presentations
of the work in progress, as well as online lectures and tutorials.
List of Professional Skill Development Activities (PSDA):
1. Explore case studies on business analytics and Use of various formulas for mathematical and statistical calculations through Excel.
2. Application of techniques learnt during class on given datasets
3. In a group , work on a real-life Data Analytics Project from any domain such as HR, Finance, Supply Chain etc. and prepare a report
Theory L/T (%) Lab/Practical/Studio (%) End Term Examination
50% NA 50%
Continuous Assessment/Internal Assessment End Term

Examination
Components (Drop down) Home Assignment Project Quiz Midterm Attendance
Linkage of PSDA with PSDA1 & PSDA 2 PSDA 3

Internal Assessment
Component, if any
Weightage (%) 10% 10% 5% 20% 5% 50%

Mapping Continuous Evaluationcomponents/PSDA with CLOs
Bloom’s Level > Remembering Understanding Applying Analysing Evaluating Creating
Course Learning 1.Identify business situations requiring 2.Apply business 3.Determine and apply 4. Develop managerial and
Outcomes use of analytical techniques analytics skills in their forecasting techniques for leadership capabilities
organizations business decision making
Assessment type
/PSDA
Home Assignment √ √
– PSDA 1
Home √ √ √
Assignment –
PSDA 2
Project- PSDA √ √ √ √ √ √
3
Midterm √ √ √ √ √ √
Text & References:
Text: Evans, James (2016), Business Analytics, Pearson’s Publication

References:
 Jeffrey D Camm(2015), Essentials of Business Analytics Cengage Learning
 Wayne L. Winston (2014), Marketing Analytics: Data-Driven Techniques with Microsoft Excel, John Wiley & Sons, Inc.
 Conrad Carlberg(2016), Business Analysis with Microsoft Excel (5th Edition), Pearson Education India
 Prasad, R. N., Acharya, Seema(2015), Fundamentals of Business Analytics, 2ed, Wiley.

Course Title: Course Code: CSIT660 Credit Units: 3 Level: PG

Uploaded by

Copyright:

Available Formats

Course Title: Course Code: CSIT660 Credit Units: 3 Level: PG

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Course Title: Course Code: CSIT660 Credit Units: 3 Level: PG

Uploaded by

Copyright:

Available Formats

Annexure ‘AAB-CD-01’

Course Title: Business Analytics and Modelling L T P SW/FW PSDA TOTAL

Prerequisites: The student should have a preliminary understanding of statistics.

Course Learning Outcomes:

Module Course Contents Weightage

 Defining Business Analytics

3 Module III Descriptive Analytics 20%

 Measures of central tendency and dispersion

 Multiple Regression Analysis

Pedagogy for Course Delivery:

List of Professional Skill Development Activities (PSDA):

2. Application of techniques learnt during class on given datasets

Theory L/T (%) Lab/Practical/Studio (%) End Term Examination

Continuous Assessment/Internal Assessment End Term

Linkage of PSDA with PSDA1 & PSDA 2 PSDA 3

Weightage (%) 10% 10% 5% 20% 5% 50%

Bloom’s Level > Remembering Understanding Applying Analysing Evaluating Creating

Text: Evans, James (2016), Business Analytics, Pearson’s Publication

You might also like