Data Analysis

Purpose:

The following serves as a directory of projects and Datasets analysed using SQL.

Repository Link	Description
PROJECT- Analyzing Food claim process in Vivendo (a fast food chain in Brazil with over 200 outlets)	DATASET: Vivendo-claim process data..This is a case study I performed as part of my the DataCamp Data Analyst Associate certification. After data validation and analysis answer questions like: How does the number of claims differ across locations? What is the distribution of time to close claims? How does the average time to close claims differ by location?
PROJECT- Analyze International Debt Statistics	DATASET: The World Bank data It contains both national and regional debt statistics for several countries across the globe as recorded from 1970 to 2015. SQL queries to answer questions like: What is the total amount of debt that is owed by the countries listed in the dataset? Which country owns the maximum amount of debt and what does that amount look like? What is the average amount of debt owed by countries across different debt indicators?
PROJECT- Optimizing Online Sports Retail Revenue	DATASET: Click here Analyzing product data for an online sports retail company to optimize revenue. Worked with numeric, string, and timestamp data on pricing and revenue, ratings, reviews, descriptions, and website traffic SKILLS used: aggregation, cleaning, labeling, Common Table Expressions, and correlation to produce recommendations on how the company can maximize revenue!
PROJECT- Analyzing NYC Public School Test Result Scores	Dataset: NYC's public school data. Skills used: Summary statistics and filters to analyze test scores across New York City's public schools!
PROJECT- Covid_data_Analysis(2020-2021)	Dataset: Kaggle covid data Skills used: Joins, CTE's, Temp Tables, Windows Functions, Aggregate Functions
PROJECT- Identifying Golden Age of Video Games	Dataset: Kaggle videogame data In this project, I am analyzing video game critic and user scores as well as sales data for the top 400 video games released since 1977. Finding golden age of video games by identifying release years that users and critics liked best, and also explore the business side of gaming by looking at game sales data. SKILL USED: This involves joining datasets and comparing results with set theory. Also filter, group, and order data.
PROJECT- Analysis of Nashville Housing Data	Skills used: Converting Data Types, Joins, CTE's, Creating Views
PROJECT - What and Where are the World's Oldest Businesses	In this project, exploring data from BusinessFinancing.co.uk on the world's oldest businesses: when were they founded, and which industries do they belong to? SKILLS USED: Used join techniques to discover the oldest businesses in the world.