Build a Complete Data Analyst Portfolio Project
Go from messy raw data to an interactive Power BI
dashboard using Python, PostgreSQL, and SQL. Get the Files, code, instructions and career resources you need to complete the project at your own pace.
Designed for beginner and aspiring data analysts who want practical experience—not another tutorial they only watch.
One-Time Payment
$26.95
Instant download • One-time payment • Lifetime access
What's Included
Raw & Cleaned Dataset
Messy raw data & fully cleaned dataset for practice.
Python Code
Data cleaning, exploration & upload to PostgreSQL scripts.
PostgreSQL Setup
Database setup script & instructions to get started quickly
SQL Queries
Business analysis queries to answer real-world questions.
Power BI Dashboard
Interactive Power BI dashboard with KPI cards, charts & slicers.
DAX Measures
All DAX measures used in the dashboard included.
Dashboard Assets
Icons, images & visuals used in the dashboard.
Interview Q&A
Common interview questions with model answers.
Portfolio Guide
How to use this project in your portfolio & resume.
Cheat Sheets
SQL cheat sheet & Power BI DAX cheat sheet.
Common Errors & Fixes
Step-by-step solutions to common issues beginners face.
What You'll Learn
Clean messy data using Python & pandas
Upload data into PostgreSQL
Write SQL queries to analyze data
Create KPI's and Measures in Power BI
Build interactive Dashboard
Follow a complete data analysis workflow
Frequently Asked Questions
Is this Project Kit beginner-friendly?
Yes. It was created for beginner and aspiring data analysts. Step-by-step instructions and a Common Errors & Fixes guide are included. You do not need professional data-analyst experience, but you should be comfortable downloading software, opening files, and following written instructions.
What software will I need?
You will use Python and Jupyter Notebook, PostgreSQL and pgAdmin, and Power BI Desktop. These programs can be downloaded at no additional cost. The software itself is not included in the kit.
Can I complete this project on a Mac?
Python and PostgreSQL can run on a Mac. However, Power BI Desktop requires Windows. Mac users will need access to a supported Windows computer or Windows environment to open and work with the included Power BI .pbix file.
What will I receive?
You will receive the raw and cleaned datasets, Python code, PostgreSQL setup scripts, SQL queries, a Power BI dashboard, DAX measures, dashboard assets, interview questions and answers, portfolio and resume guidance, cheat sheets, and a Common Errors & Fixes guide.
Is this a video course?
This is a downloadable Project Kit rather than a complete video course. It includes the files, code, scripts, dashboard, and written guidance needed to complete the project. You can also follow the free project playlist on the @DataGeekIsMyName YouTube channel. Link is listed to the YouTube video is provided after purchase.
How will I receive the Project Kit?
You will receive access to the download page immediately after completing your payment. Please also enter a valid email address during checkout so you receive all purchase and access information.
Can I use this project in my portfolio?
Yes. The kit was designed to help you build a complete data-analysis project for your portfolio. You should complete the work yourself, personalize your final presentation, and be prepared to explain your process and findings during an interview.
Do I need previous Python, SQL, or Power BI experience?
No professional experience is required. The kit provides guided practice for beginners. Some familiarity with basic computer tasks will make the installation and setup process easier.
Does the kit include personal tutoring or technical support?
Private tutoring and personalized project completion are not included. The kit contains step-by-step instructions and a Common Errors & Fixes guide to help with common beginner issues. While the kit does not include private tutoring, we will help with access issues and reasonable questions related to the included materials.
What is the refund policy?
Because this is a downloadable digital product with immediate access, please review the Refund Policy before purchasing. The Refund Policy is linked at the bottom of this page.
Data Geek Is My Name | Learn Python, SQL & Power BI with real projects. Empowering future data analysts through hands-on tutorials, templates, datasets, and YouTube lessons.
📘 Created by Veronica — Educator | YouTuber | Data Enthusiast
Privacy policy | Terms and conditions | Refund Policy
© Data Geek is my name