Data Career Podcast: Helping You Land a Data Analyst Job FAST 175: 5 Unique Data Analyst Projects (beginner to intermediate)
17 snips
Sep 2, 2025 Discover five unique data analyst projects that can enhance your skills and impress potential employers. Dive into stock price analysis using Excel, SQL real estate data exploration, and building a personal finance dashboard with Tableau or Power BI. Unleash your creativity with a fun Pokémon analysis project in Python. Wrap it up with sports analytics, focusing on football metrics and predictions. Each project is designed to refine your data storytelling abilities and boost your career prospects!
AI Snips
Chapters
Transcript
Episode notes
Analyze One Stock In Depth
- Do a stock price analysis using daily (or finer) data to practice time-series skills and Excel formulas.
- Add moving averages or forecasting to level up and demonstrate advanced analysis.
Show Excel Fluency With Time-Series Tools
- Use Excel functions (charts, XLOOKUP/VLOOKUP, MAX/MIN/AVERAGE) to analyze stock returns and key events.
- Create user-friendly lookups so viewers can query prices or daily changes easily.
Use Real Estate Data To Practice SQL
- Use real estate datasets and analyze them in SQL to practice imports, SELECT, WHERE, GROUP BY, and window functions.
- Join complementary data (e.g., crime) to add depth and explore trends across locations and time.