Welcome to my Data Analytics Portfolio! This repository highlights my projects in Python, SQL, and Tableau, showcasing my expertise in data analytics, visualization, and storytelling. Explore detailed descriptions, code repositories, and live dashboards below.
- Description: This project analyzes data from the Euros 2024 tournament, incorporating web scraping, data transformation, and database integration. Inspired by McKay Johns' tutorial, I extended the project with a Streamlit app for visualizing player shots and goals dynamically.
- Key Features:
- Integrated Supabase APIs and SQL queries for dynamic data retrieval.
- Designed a shot map using Matplotlib.
- Links:
- Description: This project explores and analyzes the complete history of the Summer Olympics, culminating in a Streamlit dashboard for interactive data visualization and insights.
- Key Features:
- Developed user-friendly visualizations to uncover Olympic trends.
- Leveraged Streamlit for an interactive and seamless user experience.
- Links:
- Description: Conducted an in-depth analysis of Pokémon data using a Kaggle dataset, focusing on relationships among Pokémon attributes, types, and evolutions.
- Key Features:
- Cleaned and visualized data using Python.
- Explored trends and insights among Pokémon characteristics.
- Links:
- Description: A hands-on learning project focusing on SQL mastery using the PGExercises platform. Includes foundational and advanced query practice, covering topics such as data retrieval, aggregations, and nested subqueries.
- Learning Approach:
- PostgreSQL Setup:
- Installed PostgreSQL using
brew install postgresql@15. - Created practice tables using PG Exercises.
- Installed PostgreSQL using
- Query Practice:
- Began with Basic SQL Questions to solidify core concepts.
- Progressed to complex problems, including joins, aggregations, and subqueries.
- PostgreSQL Setup:
- Links:
- Description: Solved SQL challenges on LeetCode, applying concepts from foundational practice to real-world scenarios. Focused on query optimization, pattern recognition, and problem-solving.
- Future Plans:
- Expand this repository with solutions for advanced LeetCode SQL problems.
- Explore integration of SQL queries into visualization tools like Tableau.
This portfolio demonstrates my skills in transforming raw data into actionable insights and creating intuitive visualizations. Let's connect and discuss how I can contribute to your projects or collaborate on exciting ideas!