Month 7 of 7 · 24–25 hours
Data Analyst Portfolio
Employers want proof that you can do the job. In this course you will plan a portfolio of three projects that together show Excel, SQL, Python, statistics and dashboard skills, complete and polish them using the same ten steps as the Project course, and publish them on GitHub with clear documentation and a simple portfolio page. You can reuse your Project course capstone as one of the three.
Weeks
- Week 1Portfolio Planning: Dataset Selection, Problem Definition and Data CollectionDesign a portfolio that shows a range of skills, and start the new projects.5 hours · 3 videosDone
- Week 2Data Cleaning, SQL Analysis and Python AnalysisComplete the analysis for the two new projects to a portfolio standard.7 hours · 3 videosDone
- Week 3Exploratory Analysis, Dashboard Creation and Business InsightsTurn each project's analysis into visuals and insights a hiring manager will remember.6 hours · 3 videosDone
- Week 4Project Documentation and Publishing Your PortfolioPublish all three projects on GitHub and present them professionally.6–7 hours · 3 videosDone
- FinalPortfolio rubricGraded project with a rubric.
What you will be able to do
- Plan a portfolio of three projects that covers different tools, industries and question types.
- Write a clear problem definition for each project.
- Show strong data cleaning, SQL, Python and exploratory skills in public work.
- Present each project with a dashboard and business insights.
- Publish projects on GitHub with professional READMEs.
- Build a simple portfolio page and describe your projects on a resume and LinkedIn.
Before you start
Prerequisites: Course 6 (Project), or one completed end-to-end analysis.
Tools: Everything from Courses 1 to 5, plus a free GitHub account. Optional: Tableau Public or the Power BI Service for sharing dashboards, and LinkedIn.
Schedule
| Week | Topics | Time |
|---|---|---|
| Week 1 | Portfolio Planning: Dataset Selection, Problem Definition and Data Collection | 5 hrs |
| Week 2 | Data Cleaning, SQL Analysis and Python Analysis | 7 hrs |
| Week 3 | Exploratory Analysis, Dashboard Creation and Business Insights | 6 hrs |
| Week 4 | Project Documentation and Publishing Your Portfolio | 6 to 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.