15-Day Data Analysis & Visualization Course
Day 1: Introduction to Data Analysis
Understand what data analysis is, the importance of data-driven decisions, types of data, and basic concepts
in data analysis.
Assignment:
- Summarize the day's topic in your own words.
- Complete a mini project or task using the tool covered today.
- Reflect on what was challenging and how you overcame it.
15-Day Data Analysis & Visualization Course
Day 2: Excel Basics for Data Analysis
Learn Excel interface, data entry, formatting, formulas, and functions such as SUM, AVERAGE, IF, and
VLOOKUP.
Assignment:
- Summarize the day's topic in your own words.
- Complete a mini project or task using the tool covered today.
- Reflect on what was challenging and how you overcame it.
15-Day Data Analysis & Visualization Course
Day 3: Excel Charts & Visualization
Create charts like bar, pie, line, and scatter plots. Understand when to use each and how to format charts for
clarity.
Assignment:
- Summarize the day's topic in your own words.
- Complete a mini project or task using the tool covered today.
- Reflect on what was challenging and how you overcame it.
15-Day Data Analysis & Visualization Course
Day 4: Data Cleaning in Excel
Identify and clean missing or duplicate data. Use tools like Text to Columns, Remove Duplicates, and Data
Validation.
Assignment:
- Summarize the day's topic in your own words.
- Complete a mini project or task using the tool covered today.
- Reflect on what was challenging and how you overcame it.
15-Day Data Analysis & Visualization Course
Day 5: Introduction to Power BI
Get familiar with Power BI interface. Learn how to load, transform, and model data using Power Query.
Assignment:
- Summarize the day's topic in your own words.
- Complete a mini project or task using the tool covered today.
- Reflect on what was challenging and how you overcame it.
15-Day Data Analysis & Visualization Course
Day 6: Creating Dashboards in Power BI
Build interactive dashboards using visuals like cards, charts, and slicers. Use DAX for calculated fields.
Assignment:
- Summarize the day's topic in your own words.
- Complete a mini project or task using the tool covered today.
- Reflect on what was challenging and how you overcame it.
15-Day Data Analysis & Visualization Course
Day 7: Data Cleaning with Power BI
Use Power Query for advanced data transformation, including merging, appending, filtering, and replacing
values.
Assignment:
- Summarize the day's topic in your own words.
- Complete a mini project or task using the tool covered today.
- Reflect on what was challenging and how you overcame it.
15-Day Data Analysis & Visualization Course
Day 8: SQL Basics for Data Analysis
Learn SQL syntax, SELECT, FROM, WHERE, GROUP BY, and ORDER BY clauses. Practice with sample
databases.
Assignment:
- Summarize the day's topic in your own words.
- Complete a mini project or task using the tool covered today.
- Reflect on what was challenging and how you overcame it.
15-Day Data Analysis & Visualization Course
Day 9: Intermediate SQL Queries
Use JOINs, subqueries, CASE statements, and window functions to manipulate and analyze complex data.
Assignment:
- Summarize the day's topic in your own words.
- Complete a mini project or task using the tool covered today.
- Reflect on what was challenging and how you overcame it.
15-Day Data Analysis & Visualization Course
Day 10: Connecting Excel/Power BI to SQL
Establish live or import connections to SQL databases. Use queries to pull and analyze external data.
Assignment:
- Summarize the day's topic in your own words.
- Complete a mini project or task using the tool covered today.
- Reflect on what was challenging and how you overcame it.
15-Day Data Analysis & Visualization Course
Day 11: Introduction to Data Visualization Principles
Learn about storytelling with data, color theory, chart design, and avoiding common visualization pitfalls.
Assignment:
- Summarize the day's topic in your own words.
- Complete a mini project or task using the tool covered today.
- Reflect on what was challenging and how you overcame it.
15-Day Data Analysis & Visualization Course
Day 12: Advanced Excel Techniques
Use PivotTables, PivotCharts, advanced formulas, and macros to automate analysis.
Assignment:
- Summarize the day's topic in your own words.
- Complete a mini project or task using the tool covered today.
- Reflect on what was challenging and how you overcame it.
15-Day Data Analysis & Visualization Course
Day 13: Advanced Power BI & DAX
Use advanced DAX for time intelligence, custom metrics, and optimization techniques.
Assignment:
- Summarize the day's topic in your own words.
- Complete a mini project or task using the tool covered today.
- Reflect on what was challenging and how you overcame it.
15-Day Data Analysis & Visualization Course
Day 14: Project: Real-World Data Analysis
Analyze a real dataset (e.g., sales, health, or education) from start to finish using Excel and Power BI.
Assignment:
- Summarize the day's topic in your own words.
- Complete a mini project or task using the tool covered today.
- Reflect on what was challenging and how you overcame it.
15-Day Data Analysis & Visualization Course
Day 15: Presentation & Reporting
Create an engaging report or presentation from your analysis. Use storytelling and visuals to explain findings.
Assignment:
- Summarize the day's topic in your own words.
- Complete a mini project or task using the tool covered today.
- Reflect on what was challenging and how you overcame it.