Analysis and visualisation of public data sets using SQL, R and PowerBI.
-
LPJ Original Sales Data - Clean up & Analysis
-
Step 1: Data organisation & cleaning, with overall sales analysis --> SQL Code: '1. LPJ Data Cleaning and General Analysis.sql'
-
Step 2: Specific sales analysis - Yearly breakdowns, Sales breakdown by country and product --> SQL Code: '2. LPJ Specific Sales Data Analysis.sql'
-
-
COVID-19 Data analysis:
-
Worldwide data downloaded on 22/01/2023 from: https://ourworldindata.org/explorers/coronavirus-data-explorer?zoomToSelection=true&time=2020-03-01..latest&facet=none&pickerSort=asc&pickerMetric=location&Interval=7-day+rolling+average&Relative+to+Population=true&Color+by+test+positivity=false&country=USA~GBR~CAN~DEU~ITA~IND&Metric=Confirmed+cases
-
Step 1: Data clean up, manipulation and organisation --> SQL code: 'ScottsAnalysis\Data-Analysis\COVID Data Analysis_GitHub_Final.sql'
-
Step 2: Data visualisation using R and PowerBI --> R visualisation code: 'ScottsAnalysis\Data-Analysis\COVID Data Visualisation_MortalityRatePercentChange_GitHub.R' --> PowerBI dashboard: https://app.powerbi.com/view?r=eyJrIjoiNWY4NmJkZWYtMWYwOC00YTliLWEwZjItNDhkZTRkYzY0MWMyIiwidCI6ImE3YTczN2VmLTA5YjgtNGFjZi1hNjI5LThmNjhhNWQzM2MwMiJ9
-
-
Nashville Housing Data clean-up and organisation:
- Data downloaded from: https://github.com/AlexTheAnalyst/PortfolioProjects/blob/main/Nashville%20Housing%20Data%20for%20Data%20Cleaning.xlsx
- SQL code: 'ScottsAnalysis\Data-Analysis\Nashville Housing Data Clean Up_GitHub.sql'
-
Tesla Car Accidents since 2013, Including Involvement of Autopilot feature:
- Data downloaded from: https://www.kaggle.com/datasets/ibriiee/tesla-autonomous-deaths-data-updated-2023?resource=download
- SQL code: 'ScottsAnalysis\Data-Analysis\Tesla Deaths Analysis_06.02.2023.sql'
- Visualisation in Tableau:
-
Worldwide average temperature changes (per country) compared to baseline (i.e.: average temperatures between 50's-80's)
- Data downloaded from: https://www.kaggle.com/datasets/mdazizulkabirlovlu/all-countries-temperature-statistics-1970-2021?resource=download
- SQL code: 'WorldWide Temperatures_Data cleaning and Calculations_Github.sql'
- R Visualisation code: 'Worldwide Temperature Increase Data Visualisation and Statistics.R'