Department of Computer Science
Data Analysis with Excel & Python L T P SL C
(AI & DS)
60 0 0 60 4
Pre-requisite Nil SDG: 3, 9
Course Objectives:
1. To understand the fundamentals of data analysis and data-driven decision making.
2. To learn spreadsheet-based data analysis using Microsoft Excel.
3. To apply Python programming for data cleaning, processing, and visualization.
4. To develop practical skills in data handling and exploratory data analysis.
5. To build industry readiness through exposure to modern analytics tools and workflows..
Course Content
UNIT I INTRODUCTION TO DATA ANALYSIS AND EXCEL BASICS 12
Introduction to Data Analysis – Data Types – Data Collection Methods – Spreadsheet Fundamentals –
Excel Interface – Workbook and Worksheet Operations – Formulas and Functions – Data Formatting –
Sorting and Filtering – Charts and Graphs – Data Validation
Activity: Analyze a small dataset using Excel formulas and charts
UNIT II ENERGY SOURCES AND STORAGE DEVICES 12
Logical and Lookup Functions – Conditional Formatting – Pivot Tables and Pivot Charts – Dashboard
Basics – What-if Analysis – Data Cleaning in Excel – Importing and Exporting Data – Statistical Analysis
using Excel – Business Reporting Concepts
Activity: Create an interactive Excel dashboard using sample business data
UNIT III PYTHON PROGRAMMING FOR DATA ANALYSIS 12
Introduction to Python for Data Analysis – Python Basics – Variables and Data Types – Control Structures
– Functions – File Handling – Introduction to NumPy – Arrays and Mathematical Operations –
Introduction to Pandas – DataFrames and Series – Reading CSV and Excel Files
Activity: Load and analyze datasets using Pandas
UNIT IV DATA VISUALIZATION AND EXPLORATORY DATA ANALYSIS 12
Data Cleaning and Preprocessing – Handling Missing Values – Data Transformation – Exploratory Data
Analysis (EDA) – Data Visualization Concepts – Line Charts, Bar Charts, Histograms and Scatter Plots –
Correlation Analysis – Introduction to Matplotlib and Seaborn – Basic Statistical Analysis.
Activity: Perform EDA and create visual reports for real-world datasets
UNIT V INDUSTRIAL APPLICATIONS AND BUSINESS ANALYTICS 12
Business Analytics Basics – Data-driven Decision Making – KPI and Reporting Concepts – Data Analysis in
Finance, Healthcare and Marketing – Introduction to Predictive Analytics – Cloud-based Analytics
Overview – Data Ethics and Privacy – Career Opportunities in Data Analytics – Future Trends in Data
Science.
Activity: Analyze industrial case studies and prepare analytical reports
TOTAL LECTURE HOURS 60 Hours
TOTAL TERM WORK AND SELF LEARNING HOURS 60 Hours
TOTAL NO. OF HOURS PER SEMESTER 120 Hours
Expected Course Outcome: On completion of the course, the student is expected to
1. Understand the concepts and applications of data analysis. K3
2. Use Excel functions, charts, and pivot tables for business and data analysis tasks. K3
3. Apply Python libraries for data manipulation and visualization. K2
1
Department of Computer Science
4. Perform exploratory data analysis using real-world datasets. K3
5. Develop basic analytical dashboards and reports. K3
Text Books:
1. Python for Data Analysis — Wes McKinney, 3rd Edition, O’Reilly Media, 2022.
2. Data Analysis Using SQL and Excel — Gordon S. Linoff, 1st Edition, Wiley Publications, 2016.
3. Practical Statistics for Data Scientists — Peter Bruce and Andrew Bruce, 2nd Edition, O’Reilly Media,
2020.
Reference Books:
1. Hands-On Data Analysis with Pandas — Stefanie Molin, 2nd Edition, Packt Publishing, 2023.
2. Data Science for Business — Foster Provost and Tom Fawcett, 1st Edition, O’Reilly Media, 2013.
3. Excel Data Analysis For Dummies — Stephen L. Nelson, 5th Edition, Wiley Publications, 2018.
4. Think Stats — Allen B. Downey, 2nd Edition, O’Reilly Media, 2014.
5. Storytelling with Data — Cole Nussbaumer Knaflic, 1st Edition, Wiley Publications, 2015.
Web Links:
1. [Link]
2. [Link]
3. [Link]
4. [Link]
5. [Link]