sara silva's portfolio:

sql_

For my first SQL project, I've decided to do some Data Cleaning.

I grabbed a dataset from Kaggle and, after studying the data, I realized that I needed to perform tasks, such as:

  • Standardizing the data;

  • Removing duplicates;

  • Populating blank values;

  • Removing unnecessary columns.

Skills: CTE's, Row Number, Partition By, Case Statement

Check the project here.

data cleaning_

exploratory data analysis_

With the same dataset, I then went for an Exploratory Data Analysis exercise.

Having some easy queries at the top and a few complex ones at the bottom, I've explored the following topics:

  • Top 5 Bikes with the most Total Profit;

  • Which Age Group bought more bikes;

  • Days with the biggest Total Revenue and Total Quantity;

  • Top 3 of the most sold Bikes per Country and their respective Total Quantity and Total Revenue.

Skills: CTE's, Dense Rank, Substrings, Partition By

Check the project here.

contact_