Scribd
Upload
6 views8 pages

Data Analysis

The document outlines a 12-week course on data analysis, covering foundational topics such as data types, Excel, Python, SQL, and data visualization tools like Power BI and Tableau. It includes practical exercises, mini projects, and assignments to reinforce learning, culminating in a final portfolio project where students apply their skills to real-world datasets. By the end of the course, students will be equipped to perform data analysis, write SQL queries, and create visualizations and dashboards.

Uploaded by

bilalrehmat676
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
6 views8 pages

Data Analysis

The document outlines a 12-week course on data analysis, covering foundational topics such as data types, Excel, Python, SQL, and data visualization tools like Power BI and Tableau. It includes practical exercises, mini projects, and assignments to reinforce learning, culminating in a final portfolio project where students apply their skills to real-world datasets. By the end of the course, students will be equipped to perform data analysis, write SQL queries, and create visualizations and dashboards.

Uploaded by

bilalrehmat676
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Month 1 — Foundations of Data Analysis

Week 1 — Introduction to Data & Analytics


●​ What is Data Analysis​

●​ Types of Data (Structured / Unstructured)​

●​ Data Analysis Workflow​

●​ Data Analyst vs Data Scientist​

●​ Installing tools:​

○​ Microsoft Excel​

○​ Python​

○​ Jupyter Notebook​

●​ Dataset exploration​

Practice

●​ Analyze a simple dataset (sales or student dataset)​

Week 2 — Excel for Data Analysis (Basics)


●​ Excel interface​

●​ Sorting and Filtering​

●​ Data Cleaning Basics​

●​ Important Functions​
○​ IF​

○​ SUM​

○​ AVERAGE​

○​ COUNT​

○​ VLOOKUP / XLOOKUP​

Mini Project

●​ Simple Sales Report​

Week 3 — Excel Advanced + Data Cleaning


●​ Pivot Tables​

●​ Conditional Formatting​

●​ Removing Duplicates​

●​ Data Formatting​

●​ Creating Charts​

Assignment

●​ Clean and organize a messy dataset​

Week 4 — Statistics for Data Analysis


●​ Mean, Median, Mode​

●​ Standard Deviation​
●​ Data Distribution​

●​ Correlation​

●​ Outliers​

Practice

●​ Perform statistical analysis using Excel​

Month 2 — Python & SQL for Analysis


Week 5 — Python Basics
●​ Python Introduction​

●​ Variables​

●​ Data Types​

●​ Lists and Dictionaries​

●​ Loops​

●​ Functions​

Practice

●​ Write simple Python scripts​

Week 6 — Python for Data Analysis


Libraries:
●​ NumPy​

●​ Pandas​

Topics:

●​ DataFrames​

●​ Loading CSV files​

●​ Filtering data​

●​ Data aggregation​

Assignment

●​ Analyze a dataset using Pandas​

Week 7 — Data Visualization with Python


Libraries:

●​ Matplotlib​

●​ Seaborn​

Charts:

●​ Line charts​

●​ Bar charts​

●​ Histograms​

●​ Heatmaps​

Mini Project
●​ Create a visual report from a dataset​

Week 8 — SQL for Data Analysis


Using MySQL or PostgreSQL

Topics:

●​ SELECT statements​

●​ WHERE conditions​

●​ GROUP BY​

●​ ORDER BY​

●​ JOINs​

●​ Aggregations​

Assignment

●​ Query and analyze a business dataset​

Month 3 — Visualization & Portfolio


Week 9 — Business Data Analysis
●​ KPIs (Key Performance Indicators)​

●​ Business Questions​

●​ Exploratory Data Analysis (EDA)​


Practice

●​ Analyze a real business dataset​

Week 10 — Dashboard Creation


Tools:

●​ Power BI or Tableau​

Topics:

●​ Data Modeling​

●​ Dashboard Design​

●​ Interactive Visualizations​

Project

●​ Sales Dashboard​

Week 11 — Real-World Data Project


Students choose dataset such as:

●​ E-commerce Data​

●​ Marketing Data​

●​ Finance Data​

●​ Public Datasets​

Tasks:
●​ Data Cleaning​

●​ Data Analysis​

●​ Visualization​

●​ Extract Insights​

Week 12 — Final Portfolio Project


Students build a complete case study

Steps:

1.​ Define problem statement​

2.​ Clean the data​

3.​ Perform analysis​

4.​ Create visualizations​

5.​ Present insights​

Tools Used

●​ Excel​

●​ Python​

●​ SQL​

●​ Power BI / Tableau​

Final Outcome
By the end of the course students will:

●​ Perform data analysis using Excel​

●​ Analyze datasets using Python​

●​ Write SQL queries​

●​ Create visualizations and dashboards​

●​ Build a professional portfolio project

You might also like