Alex Freberg Portfolio
Self-taught data analyst turned educator ("Alex The Analyst") whose "Data Analyst Portfolio Project" series (SQL exploration → Tableau dashboard) is one of the most widely replicated beginner portfolio templates in the field.
What makes it work
A breakdown of the choices that make this portfolio stand out.
A documented, repeatable end-to-end project structure
The explicit SQL → cleaning → Tableau dashboard sequence maps directly onto real analyst workflows rather than an unstructured mix of snippets.
Entry made without a traditional pedigree
Landing a data analyst role in 2017 without a mentor, then documenting exactly how, is unusually useful evidence for self-taught candidates.
Public queries paired with a live published dashboard
His public GitHub SQL repo and Tableau Public dashboards are both public and linked, letting a reviewer trace query to finished chart.
What Data Analysts can take from this
Specific, actionable tips to apply to your own portfolio — no generic advice.
Publish the SQL/cleaning step and the visualization step as two linked, visible artifacts.
If self-taught, document your actual timeline and the specific projects that got you hired.
Structure your portfolio as a numbered project series to show clear skill progression.
Reuse a well-known public dataset if you lack real company data — analysis quality matters more than originality for a beginner portfolio.
More Data Analyst portfolios
Ready to build your portfolio?
Follow the Data Analyst roadmap — skills, projects, and timeline to get hired.