Month 6 of 7 · 24 hours
Guided Data Analysis Project
This course is a guided capstone. Over four weeks you will complete one end-to-end data analysis project using every tool from the earlier courses: choose a dataset, define a business problem, collect and clean the data, analyze it with SQL and Python, explore it, build a dashboard, turn findings into business insights and document the whole thing. Each week ends with a checkpoint deliverable so you get feedback before moving on.
Weeks
- Week 1Dataset Selection, Problem Definition and Data CollectionPick a dataset, define the problem you will solve, and gather the data.5 hours · 3 videosDone
- Week 2Data Cleaning and SQL AnalysisMake the data trustworthy, then answer your first questions with SQL.6 hours · 3 videosDone
- Week 3Python Analysis and Exploratory AnalysisGo deeper with Python and explore the data for patterns you did not expect.6 hours · 3 videosDone
- Week 4Dashboard Creation, Business Insights and Project DocumentationPresent the results, recommend actions and document the project.7 hours · 3 videosDone
- FinalCapstone rubricGraded project with a rubric.
What you will be able to do
- Choose a suitable public dataset and judge its quality and licensing.
- Turn a vague topic into specific, measurable business questions.
- Clean the data and record every change.
- Answer questions with SQL queries and Python analysis.
- Explore the data, build a dashboard and write evidence-based recommendations.
- Document the project so another person can understand and repeat it.
Before you start
Prerequisites: Courses 1 to 5, or comfort with Excel, SQL, Python and a dashboard tool.
Tools: Excel, a SQL editor, Python (Google Colab or Jupyter) and Power BI from Courses 1 to 5. A free GitHub account is introduced in Week 4.
Schedule
| Week | Topics | Time |
|---|---|---|
| Week 1 | Dataset Selection, Problem Definition and Data Collection | 5 hrs |
| Week 2 | Data Cleaning and SQL Analysis | 6 hrs |
| Week 3 | Python Analysis and Exploratory Analysis | 6 hrs |
| Week 4 | Dashboard Creation, Business Insights and Project Documentation | 7 hrs |
Each week includes learning objectives, plain-language lessons with examples, beginner videos, a practice activity, a self-check quiz with answers and a graded assignment.