Data Visualisation & Analytics
Course Outline
1.0 COURSE DETAILS
Course Title Data and Visual Analytics
Major
Credits 4 Domain with CSA224
Course Code
Mode Regular Period
Academic Year 2025-26 Sem 3 Category Core
and Semester (Core/Audit)
Instructor Aayushi Office Hours
Vashishth, Bipul
Kumar
LTP 2-1-2
(Lecture-Tutorial-Practical)
2.0 SUBJECT OVERVIEW
The course description should convey to students the intellectual goals of the course -- e.g., the
rationale for the course, the guiding questions for the course, the general content of the course.
The facilitator's vision for the Data and Visual Analytics course is to
Facilitator’s Vision: empower students with the essential skills to transform raw data into
actionable insights through powerful analytical tools and visualization
techniques. The course aims to provide a hands-on, practical approach to
understanding data, enabling students to effectively analyze and present
information in a visually compelling way, driving better decision-making
and business strategies.
Data-driven insights shape decisions in nearly every industry. This course
Relevance for Students: equips learners with essential techniques—data cleaning, manipulation,
and interactive reporting—that improve them for ongoing growth in the
field.
Uniqueness of Unlike single-tool programs, this course merges Excel & Python-based
the program analytics with Tableau visualization.
Students work with varied data types, develop efficient data schemas, and
learn to create compelling dashboards, fostering versatility for modern
workplaces.
● Basic familiarity with Python programming language & SQL
Pre-Requisites: ● Comfortable with fundamental mathematical concepts ( basic
statistics - Descriptive & Inferential )
[Link]: Develop a comprehensive understanding of data analytics
Intellectual Goals & workflows—from data collection to final visualization.
Rishihood University Page 1
Guiding Questions:
Guiding Question: How do I transform raw data into actionable insights?
[Link]: Build proficiency in advanced tools (NumPy, Pandas,Pivot
tables,Lookups) and best practices for data cleaning, manipulation, and
exploration.
Guiding Question: Which methods and libraries offer the most efficient
path to cleaning and preparing large datasets?
[Link]: Master visual communication techniques, both in Python and with
Tableau, to effectively present findings.
Guiding Question: How can I design dashboards and visualizations that
highlight key patterns and engage stakeholders?
3.0 EDUCATIONAL OBJECTIVES
Objectives 1. Understand:
a. Understand the data analytics lifecycle from identifying business problems,
data collection, and cleaning, to analysis, visualization, and communication
of findings.
b. Learn the fundamentals of data preparation, data wrangling, and
exploratory analysis using tools like Excel, Python, and Tableau .
2. Analyze:
a. Analyze datasets using descriptive statistics, correlation analysis, and data
transformations to uncover patterns and insights.
b. Conduct Exploratory Data Analysis (EDA) using Python (Pandas, NumPy,
Matplotlib, Seaborn) to summarize and understand data trends.
c. Use SQL to query and manipulate datasets for deeper analysis and
reporting.
3. Apply:
a. Apply data-cleaning techniques to prepare datasets for analysis, ensuring
data integrity and quality.
b. Develop interactive dashboards and visualizations using Excel/Tableau to
present data-driven insights to stakeholders.
4. Evaluate:
a. Evaluate the effectiveness of different data analysis techniques, comparing
and contrasting methods for identifying key business insights.
b. Assess the impact of data storytelling in communicating complex analysis
and presenting it in an accessible and actionable format.
c. Evaluate the quality and clarity of analytical models, dashboards, and
reports to ensure they meet business needs.
5. Create:
a. Create comprehensive data stories by transforming data into meaningful
Rishihood University Page 2
insights that influence business decisions.
b. Develop end-to-end analytics projects from data preparation to reporting
and visualization, showcasing it in a professional portfolio.
4.0 LEARNING OUTCOMES
Outcomes Identify the learning outcomes based on Skills, Knowledge, Attitudes and
Values that will be worked upon during the course.
Skills ● Proficient in data cleaning, transformation, and
exploratory data analysis using Python and
Excel.
● Ability to build interactive dashboards and
visualizations using Tableau .
● Strong problem-solving skills to apply
analytical methods to real-world business
problems.
Knowledge ● Understanding of the data analytics lifecycle,
from data collection to visualization and
communication of insights.
● Familiarity with business metrics, data
modeling, and visualization principles.
● Knowledge of using SQL and Python for
effective data analysis and reporting.
Attitudes/Val ● Analytical thinking and a critical approach to
ues solving business problems through data.
● Strong focus on collaboration and teamwork
for real-world projects.
● Commitment to continuous learning and
staying updated with industry tools and
techniques.
Rishihood University Page 3
5.0 PROGRAM OUTLINE
Map the learnings of each week of the course
WEE CONTENT ACTIVITY/OUTCLASS ASSIGNMENTS/ASSESSMENT
K S
Introduction to Data Analytics
- What is Data Analytics?
- Types – Descriptive, Diagnostic,
Predictive, Prescriptive Analytics
- Lifecycle: Ask → Prepare →
Process → Analyze → Share
- Industry use cases and roles of
data analysts
Excel Interface & Data Handling
- Excel interface overview
- Data types, referencing,
- Formatting
Cleaning text data • 1-2 Case study
• Activity: Clean and format a messy
Functions: `LEN`, `TRIM`, `UPPER`, sales dataset in Excel
`PROPER`, “Text to Columns”, Remove • In-class dry-run activity with flow Code based Quiz
Week 1 Duplicates diagrams Coding Assignments
Excel Analytics & Conditional Logic
- Conditional logic, calculations,
- aggregation with criteria,Converting
business problems to
metrics(Analytical Thinking and KPI
Design)
- Lookup and Reference Functions • Lab - Activity: Compute KPIs and
* Functions: `IF`, `IFS`, `AND`, `OR`, metrics using conditional functions Code based Quiz
Week 2 `NOT`, `COUNTIF`, `COUNTIFS`, `SUMIF`, • Workbook: “Find the Big-O” exercises Coding Assignments
Rishihood University Page 4
`SUMIFS`
`VLOOKUP`,`HLOOKUP`, `XLOOKUP`,
`INDEX`, `MATCH`
- Pivot Tables
- What-If Analysis
- Slicers, Goal Seek, Scenario
Manager, - Build a basic visual dashboard
- Data Visualization with Charts with multiple chart types
- Types of charts – Bar, Line, Pie, - Create Pivot table and perform
Combo, Scatter, Waterfall & their what-if analysis to derive some Workbook Integrated Assignment
Week 3 use cases in different scenarios insight based on given data & Codebased Quiz
Combine cleaning, formulas, charts, and
pivots to create a complete dashboard
and analysis using SQL queries
Excel & SQL Capstone Project – Business Excel & SQL Capstone Project – Build regional dashboard using all Excel
Week 4 Dashboard Business Dashboard concepts
Data Preparation & Transformation in
Python
- Python environment setup,Jupyter
Notebook,
- Llibraries overview (Pandas,
NumPy, Matplotlib,Seaborn)
- Data Inspection and Cleaning using
basic functions like -
[Link]()`,[Link](),`[Link]()`, • Activity - Import datasets in Jupyter
`[Link]()`, `[Link]`, Notebook using `pd.read_csv()`, and
`[Link]()`, [Link](), Inspect, clean, and handle missing data
`[Link](value)`, Code based Quiz
Week 5 - Understand how Python • Pair activity: identify possible answers Coding Assignments
Rishihood University Page 5
complements Excel analytics
Exploratory Data Analysis (EDA) and
Visualization
- Filtering data
- Grouping, merging,
- Pivoting
- Descriptive stats,
- Correlation, frequency analysis
Functions: `[Link]()`, `[Link]()`, • Activity: Merge sales and region
`df.pivot_table()`,`[Link]()`, `[Link]()`, datasets, compute regional KPIs
`df.value_counts()` ,`[Link]()`, Code based Quiz
Week 6 `[Link]()`, `df.value_counts()` Coding Assignments
Advanced Visualization with Matplotlib &
Seaborn
- Design Principles,
- Plotting basics,
- Univariate,Bivariate, Multivariate
analysis ,
- Data type and chart usage
accordingly: line/bar/pie/scatter
plots,
- Customizing visuals
- Correlation heatmaps, pairplots,
boxplots, histogram etc.) • Activity - Create static visualizations in
Python based on given data to derive
(Prerequisite - Percentiles and Quantiles; some insights
Data distribution (normal/Gaussian, right Code based Quiz
Week 7 and left skewness) and outliers) Coding Assignments
Analytical Thinking and SQL Integration • Activity: Run SQL queries inside
- Integrating SQL and Python Python notebook for insights Code based Quiz
Week 8 - Using SQLite with Pandas, Lab Activity: Clean and shape raw
Rishihood University Page 6
querying datasets directly dataset & create a basic Chart
-
What is Tableau ?
Tableau Desktop vs Tableau Public
vs Tableau Server
- Interface overview
- Data Loading
- Extract vs Live Connection
- Basic Data Cleaning
Dimension ,Measures + Chart Building
,Fields & Parameters
- Dimensions vs Measures,
- Discrete vs Continuous
- Blue pill vs Green Pill logic
- Marks Card(Color size,Label,Tool • Activity: Create some charts by
tip,Detail ) summarizing data and add color,labels
- Building essential Charts & know & tooltips fields
when to use which chart • Activity: Create Top 5/10 charts using
- Filters : Dimension,measure,Top parameter , Apply filters , and add a
N,Context filter action ( Click- filter other charts )
Week 9 - Parameters Code based Quiz
Calculated Fields,LODs,Table
Calculation,Dashboard design
- Basic Calculations : If-else ,
Case,Date functions,String func
- Table calculations : Running total
,Percent of total ,Rank,Moving
average
- LODs :FIXED,INCLUDE,
EXCLUDE
- Sheets vs Dashboard
- Containers • Activity: Build complete multi-page Code based Quiz
Week 10 - Filters,Legends dashboard for a business case
Rishihood University Page 7
- Parameter controls
- Layout design, storytelling
End-to-End Integration
- Connecting Excel → Python →
SQL- TableaI; exporting CSV
linking results • Activity: Integrate Excel-cleaned data Code based Quiz
Week 11 and Python analysis into dashboard Coding Assignments
Project Finalization
Objective: Ensure quality and clarity in
Capstone Project & Evaluation final project, Demonstrate full data
- Project Review analytics and visualization process
Week 12 Project Review & Evaluation
Rishihood University Page 8
6.0 EVALUATION CRITERIA
Map the percentage weightage to each category.
Function % Weightage Notes
Attendance/Class 5%
Participation
Test Assignments ( 10% Weekly contests
Contests )
In-Class and Lab 5% Time bound quizzes and
Assignments assignments
Project 1 + Interview 10 % Project based in Excel &
(Before Midsem ) SQL (Building dashboard
& performing analysis )
Project 2 (End sem) 10%
Mid Semester 20% Mid-term Exam
End Semester 40% End-term Exam
7.0 REQUIRED READINGS AND REFERENCES
List of required and suggested material. Can mention week-wise or topic-wise. Can also mention how
to access readings.
Readings Lindy Ryan: Visual Analytics Fundamental
Edward Tuft: Visualization book
Ajay Bansal (LPU): Advance data visualization
Videos
Others
8.0 PROGRAM AUTHORIZATION
(SIGNOFF)
The undersigned acknowledge they have reviewed the course outline. Changes to this course outline will be
coordinated with and approved by the undersigned or their designated representatives.
Program Head
Signature: Date:
Print Name:
Title:
Role:
Signature: Date:
Print Name:
Rishihood University Page 9
Title:
Role:
OAA Office
Signature: Date:
Print Name:
Title:
Role:
VC Office
Signature: Date:
Print Name:
Title:
Role:
Signature: Date:
Print Name:
Title:
Role:
Course Owner
Signature: Date:
Print Name:
Title:
Role:
Signature: Date:
Print Name:
Title:
Role:
Signature: Date:
Rishihood University Page 10
Print Name:
Title:
Role:
Rishihood University Page 11