Welcome to my portfolio! Here you can find all my projects in the data universe.
| Project Link | Completion Date | Tools | Project Description |
|---|---|---|---|
| 📲 Google Play Store | May 2023 | Python (pandas; matplotlib), Jupyter Notebook | Analysis of a Google Play Store dataset containing data about several applications. |
| 🛍️ Super Store | Apr 2023 | Python (pandas; matplotlib), Jupyter Notebook | Analysis of a Super Store dataset where each row represents an order for an item and its quantity, sales, discount and profit. |
| 🛌 New York City Airbnb Data | Apr 2023 | Python (pandas; matplotlib), Jupyter Notebook | In this project, a thorough analysis of the “New York City Airbnb Open Data” dataset was conducted using Python. The objective was to understand the fundamental characteristics of the data and extract meaningful insights. |
| ⚽️ Premier League | Mar 2023 | Python, PostgreSQL, Jupyter Notebook | Designed, created, and deployed a custom data model for a dog adoption data set using Python and PostgreSQL on Jupyter Notebook. |
| 🏍️ MotoGP World Championships | Mar 2023 | Python, PostgreSQL, Jupyter Notebook | Designed, created, and deployed a custom data model for a dog adoption data set using Python and PostgreSQL on Jupyter Notebook. |
| Project Link | Completion Date | Tools | Project Description |
|---|---|---|---|
| 👁️ Iris Dataset Classification | May 2023 | Python, Jupyter Notebook | Developed and implemented an end-to-end ETL pipeline for processinsg NYC Trip Record data. The pipeline encompassed extracting raw data, performing data transformation using Python, applying fact and dimensional data modelling techniques, orchestrating the pipeline on Mage, and ultimately creating a dashboard using Looker Studio. |
| ⚽️ Project 2 | Mar 2023 | Python (scikit-learn), Jupyter Notebook | A simple description |
| Project Link | Completion Date | Tools | Project Description |
|---|---|---|---|
| 🔪 SQL Murder Mystery | Fev 2024 | Python, GCP (Storage, Compute Engine, BigQuery), Mage, Looker Studio | Developed and implemented an end-to-end ETL pipeline for processinsg NYC Trip Record data. The pipeline encompassed extracting raw data, performing data transformation using Python, applying fact and dimensional data modelling techniques, orchestrating the pipeline on Mage, and ultimately creating a dashboard using Looker Studio. |
| Project Link | Completion Date | Tools | Project Description |
|---|---|---|---|
| 👩💼 Streamlit Sales Dashboard | May 2023 | Python, GCP (Storage, Compute Engine, BigQuery), Mage, Looker Studio | Developed and implemented an end-to-end ETL pipeline for processinsg NYC Trip Record data. The pipeline encompassed extracting raw data, performing data transformation using Python, applying fact and dimensional data modelling techniques, orchestrating the pipeline on Mage, and ultimately creating a dashboard using Looker Studio. |
Made with 💪 & 💙 by Diogo Silva