🙋♂️ Hello !
Welcome to my Portfolio Guide where I provide a walkthrough to all of my data analytics projects. Hope you like it ;)
Functions: Aggregations, Joins, CTEs, Window functions (aggregates, ranking, running total, partitioned averages), CASE WHEN statements, subqueries, nested subqueries, DATETIME functions, data type conversion, text and string manipulation
| Project Name | Description |
|---|---|
| 🏅 Olympic Games | Data exploration, solving 9 challenges and building a dashboard around a business task |
| 🧹 Data Cleaning Nashville Housing | This work is focused on cleaning the data about home value data for the hot Nashville market |
Skills: Data cleaning, wrangling, visualisation, analysis, web scraping.
| Project Name | Area | Description | Libraries |
|---|---|---|---|
| 💍 Amazon LOTR Book | Web Scraping | In this project we want to monitor the values of a book that we want to buy on amazon. To do this, we are going to make a Web Scraper using Python and create a table to store the value of each analyzed day | BeautifulSoup, requests, time, smtplib,datetime |
| 🎬 Movie Industry Analysis | Data Wrangling & EDA | In this work, we set out to analyze the dataset of films scraped from IMDB and answer some questions: Does a higher budget constitute to a higher profit, Which actor(s) is associated with higher revenue and profit, Which company has the most revenue and what is their most profitable film? | pandas, numpy, seaborn |
| Project Name | Description |
|---|---|
| 👩💻 Professional Survey | Clean and Analyze dataset about data professionals using Power BI, concluding with a visualization |
| 🌎 World Population | Analyze current US Census Bureau world population estimate data and create a visualization |
| 🏅 Summer Olympic Games | Data analysis of an olympics dataset using SQL and development of a summer olympics dashboard |