Data Analyst | Data Engineer | SQL | Excel | Tableau | Python | Pyspark | HTML | CSS
In this I took raw data from Gov.uk and clean it in excel then use Tableau for Data preperation
Analyze it using Python and ML techniques finally Visualize in Power BI
Analysis of Road accident data of 2019 & 2020 in cities of UK provided by the Department of Transport(UK Government)
Data Analysis on Airline On-Time Statistics and Delay Causes Using Pyspark and Spark SQL
Analyse the given database design and the requirement for a data mart, and identify the dimensions and fact for data mart.Implement your data extraction, transformation and loading through SQL
Crime analysis is made for the reported crimes in Leicestershire and Essex for the year 2020 and 2021. The data is gathered from data.police.uk. . The report depicts useful insights which can be used for future analysis. Moreover, report highlight the crimes which are most often and its trends across the months.
In this Project I created food delivery database using SQL SERVER. Used DML and DDL queries. I also added a file Cellphone store data Model where I used DDL and DML
First I clean the raw data of NHS scotland and apply Forcasing techniques for intances time series forcasting using Excel and then visualize these on tableau