Project information

  • Category: Database Development / Data Analysis
  • Skills Used: Database Modeling, MySQL, MySQL Workbench, Python, Tableau
  • Learn More at: Little Lemon Resturant

Summary:

In this project, we used MySQL Workbench for modeling a database for LittleLemon restaurant and deployed the model as MySQL database. We also created several stored procedures for enabling secure CRUD operations using transactions and generating sales reports. We used Tableau to perform data analytics using relevant charts and dashboards. MySQL Python Connector was also used to create python client for executing sql queries from jupyter notebook.