6.
Session Plan
Module/ Topic/ Sub Topic Reading Reference Pedagogy Session Learning CO
Session Outcomes
Module 1: Leveraging Analytics for Business Decision-making
1 Laying the foundation of Text, Chpt:1 Discussion Expectation 1
Business Analytics & Handouts/ TB-1 Settings and Course
Decision-making: Scope and Overview
Future of BA and its
applications.
2 Formulating business Text, Chpt:1 Discussion Understanding 1
problems as analytics Handouts/ TB-1 Business Analytics:
problems: Analytics Value The Science of
Chain Model (Data cleaning Data-driven
to model building), Decision-making
Business Context + BA
Techniques = Business
Insights
3 Branches of Analytics – Text, Chpt:1 Discussion Understanding of 1
Descriptive, Predictive, and Handouts/ TB-1 different branches
Prescriptive Analytics (Use of Analytics and
cases on techniques of importance of ETL
analytics) and ETL (Extract, Transform
and Load) process
and its integration
with types of
analytics.
Module 2: Data Modelling for Business Decision-making: The case of salary hike
4 Modeling Data – towards Module Case 1: Discussion Understanding data 1
analytical model building Handout/ and its type.
(using MS-Excel): TB-1(chpt-10) Understanding data
Understanding Data types modeling:
understanding
what-if/goal
seek/data table
analysis
5 Useful Functions for Case 1 Discussion Learn useful 1,2,3
Modelling: Handout/ and hands- functions for
SUM, IF, SUMIFS, TB-1(chpt-10) on modeling
COUNTIFS, AVERAGEIFS
6 Building Scenarios: Data Case 1 Discussion Learn what-if 1,2,3
Modelling Handout/ and hands- analysis
(What-if analysis) TB-1(chpt-10) on
7 Building Scenarios: Data Case 1 Discussion Learn what-if 1,2,3
Modelling Handout/ and hands- analysis
(goal seek, data tables) TB-1(chpt-10) on
8 Useful Functions for Case 1 Discussion Learn useful 1,2,3
Modelling: VLOOKUP Handout/ and hands- functions for
Auditing Spreadsheet TB-1(chpt-10) on modeling
models
9 Analysis using pivot tables Case 1 Discussion, Moving towards 1,2,3
Handout/ demonstratio building a level
TB-1(chpt-3) n, and dashboard
hands-on
activity
10 Using advanced features of Case 1 Discussion, Students learn to 1,2,3
PT: Grouping on continuous Handout/ demonstratio analyze data with
Module/ Topic/ Sub Topic Reading Reference Pedagogy Session Learning CO
Session Outcomes
and categorical data, pivot TB-1(chpt-3) n, and advanced features
charts hands-on of PT for analyzing
activity data in various
forms.
11 Mini dashboard using pivot Case 1 Discussion, Students build their 1,2,3
table features like slicers and Handout/ demonstratio first base-level
timeline TB-1(chpt-3) n and hands- dashboard.
on activity
Module 3: Power BI as Analytical Solution: Analyzing Sales
12 Moving towards Power BI: Module Case 2: Discussion Sensitizing students 1,2,3
Limitations of MS-Excel Handouts with the rationale of
and the rationale to upgrade moving towards
to Power BI adoption of Power
BI as a
visualization tool
by show casing
limitations of Excel
in terms of (a)
Structural
limitations (b) data
visualization (c)
data modeling and
relationships
13 Visualization Best Practices: Case 2. Discussion Familiarizing 1,2,3
Gestalt Principles & Pre- Handouts students with
attentive attributes visualization best
practices
14 Visualization of Categorical Case 2. Case Learn different 1,2,3
Data Handouts Discussion charts to visualize
Using Lab categorical data
Session
15 Visualization of Continuous Case 2. Case Learn different 1,2,3
Data Handouts Discussion charts to visualize
Using Lab continuous data
Session
16 Building Reports in Power Case 2. Case Familiarizing 1,2,3
BI Handouts Discussion students with KPI’s
Using Lab and how to analyze
Session and create a
dashboard of KPI’s
17 Moving towards Case 2. Case Learn to create a 1,2,3
dashboarding and Handouts Discussion dashboard using
storytelling Using Lab Power BI
Session
18 Adding interactivity and Case 2. Case Learn to create 1,2,3
dynamism in reports and Handouts Discussion charts using Power
dashboards Using Lab BI
Session
19 Narrating the story Case 2 Case Learn to 1,2,3
Discussion communicate the
Using Lab story
Session
20 Winding up, of course --- Discussion Summarizing the 1,2,3
& Review learning of the
course
Case Bank: The case of salary hike/The case of Nawloin Plastics/Superstore/any other as suitable.