Capstone Project 2 - Chillout Takeout Meal Delivery Company

Presentation Slides: Chillout Takeout Meal Delivery Company

As the project file size is too big to be uploaded into Github, I have breakdown the project file into smaller segment for your reference below.

Project description:
This project’s objective is to analyse the outcome of the promotion and discontinue product with the least sale to minimise cost. This project was done in Microsoft’s excel interactive dashboard with the data clean and prepare by using Microsoft SQL Server Management Studio.

ERD

The Data collected needs to be clean, but before that we have to identify the relationship between the data. First, we have to establish the Primary and Foreign keys of the data, as shown below before we clean the data and remove any unnecessary data field.

Please click on the image for full size

SQL

Before starting the data analysis, I have used SQL studio to execute a few command. Command such as the following example of joining all tables to link all relationships of primary and foreign keys. Please download the presentation slides at the top of the page to view more of such SQL commands.

Please click on the image for full size

Outlook of the interactive dashboard

I have assign the slicers to a few different category, mainly in the outlet in different region, quarters of the year, promotion status, cuisine, and food category. This helps to narrow down the dashboard to specific outcome when clicked on different slicers.

Please click on the image for full size

Conclusion

Having SQL Server Studio to assist with data cleaning allowing me to understand more regarding the data. It allows me to understand the relationship of each data table and setting up primary and foreign keys, I am also able to normalise the data which eventually consolidate and import into excel. Pairing it up with the excel’s interactive dashboard format broaden my knowledge while maintain the integrity of the SQL database.

Please download the complete presentation slides at the top of the page to see the complete presentation slides.

< Back