Projects
Below are the list of projects, each with a brief description. For more detailed information, click on the blue button on right side of each corresponding project to view detailed SQL scripts and files used for the respective projects.
Skills Used :
-
Data Extract, Transform, Load (ETL).
-
Data Modelling
-
Data Visualization
-
Power BI - measures, Dynamic Slicers.
-
SQL - Aggregate, Window functions, JOINS.
Data Analysis - Warehouse
Data Analysis
The project showcases Data Analysis skills using MySQL, the ‘mintclassics’ database provided by Coursera. This project covers a wide range of KPIs being measured including Total Revenue, Average Order Value as a part of financial metrics, inventory management (inventory turnover ratio, days inventory outstanding), customer analysis and other operational matrices such as order fulfillment rate, sales per employee, and the order status. These matrices will help monitor, evaluate and improve business performance.
Skills Used :
-
Data Extract, Transform, Load (ETL).
-
Data Modelling
-
Data Visualization
-
Power BI - measures, Dynamic Slicers.
-
SQL - Aggregate, Window functions, JOINS.
-
MS Excel
Pizza Sales Data Analysis
Data Analysis
Pizza is a popular choice for meals, especially after a long week of work. This interest prompted me to explore the most in-demand or popular pizzas. This SQL project demonstrates my data analysis skills using Microsoft SQL Server to analyze pizza order data and identify trends in pizza preferences.
Skills Used :
-
Data Extract, Transform, Load (ETL).
-
Data Modelling
-
Data Visualization
-
Power BI - measures, Dynamic Slicers.
-
MS Excel
