Data Analyst Portfolio: 5 SQL Case Studies
Free Intermediate course · 10 lessons · 3 weeks · Certificate on completion
Complete five realistic SQL business case studies you can show employers. Across 10 lessons you'll move from fundamentals to a portfolio-ready outcome — at your own pace, with quizzes after each lesson and a final exam to certify your mastery.
What you'll learn
- How to present an analysis
- Case 1: sales performance
- Case 2: marketing funnel
- Case 3: subscription retention
- Case 4: operations efficiency
- Case 5: pricing analysis
Skills you'll pick up
- How to present an analysis
- Case 1: sales performance
- Case 2: marketing funnel
- Case 3: subscription retention
- Case 4: operations efficiency
- Case 5: pricing analysis
Tools covered
- Data Analyst Portfolio
- Real-world projects
- Quizzes
- Final exam
Course modules
Module 1: How to present an analysis
Module 1 of Data Analyst Portfolio: 5 SQL Case Studies. 3 lessons · 3h
Module 2: Case 3: subscription retention
Module 2 of Data Analyst Portfolio: 5 SQL Case Studies. 3 lessons · 3h
Module 3: Visualising results
Module 3 of Data Analyst Portfolio: 5 SQL Case Studies. 2 lessons · 2h
Module 4: Publishing the portfolio
Module 4 of Data Analyst Portfolio: 5 SQL Case Studies. 2 lessons · 2h
Lessons in this course
- How to present an analysis
- Case 1: sales performance
- Case 2: marketing funnel
- Case 3: subscription retention
- Case 4: operations efficiency
- Case 5: pricing analysis
- Visualising results
- Writing executive summaries
- Publishing the portfolio
- Walking through it in interviews
Instructor
Sofia Lindqvist — Analytics Engineering Lead
Sofia Lindqvist is a Analytics Engineering Lead with years of hands-on experience teaching Data Analyst Portfolio to thousands of learners worldwide.
Certificate
Finish every lesson and pass the final exam to earn a free, verifiable Learnera certificate for Data Analyst Portfolio: 5 SQL Case Studies. It can be downloaded as a PDF and shared on LinkedIn.
Career outcomes
Median global salary $95,000 per year · median India salary ₹13,30,000 per year · 79,211 open roles worldwide
- Data Analyst Portfolio Specialist
- Senior Data Analyst Portfolio Lead
- Data Analyst Portfolio Consultant
Frequently asked questions
Is the Data Analyst Portfolio: 5 SQL Case Studies course free?
Yes. Every Learnera course, including Data Analyst Portfolio: 5 SQL Case Studies, is completely free — lessons, quizzes, the final exam, and the certificate.
How long does Data Analyst Portfolio: 5 SQL Case Studies take?
10 lessons, typically completed in 3 weeks at a comfortable pace.
Do I get a certificate?
Yes — pass the final exam and you receive a free, verifiable certificate you can share on LinkedIn.