This project presents a comprehensive redesign of a relational database schema tailored for managing restaurant operations, including table reservations, food ordering, customer records, menu structures, and staff assignments. The report highlights key improvements such as enhanced field naming, the use of constraints (ENUM, UNIQUE, DEFAULT), and the addition of status tracking and timestamps. The redesign aims to support improved data integrity, scalability, and reporting efficiency for real-world deployment.

This document contains the R scripts along with the generated outputs, including tables, summaries, and visualizations. It demonstrates the data transformation, date-time conversions, and analysis performed on the Bike Share dataset

MySQL Basics

Data Analyst & Database Engineer with expertise in SQL, R, Tableau, and Excel. Passionate about transforming complex data into actionable insights, optimizing data management, and driving data-driven decision-making. Skilled in statistical analysis, data visualization, and database design. Seeking opportunities to collaborate on innovative projects that enhance business intelligence and efficiency.

In this project, you will step into the shoes of an entry-level data analyst at the fictional Mint Classics Company, helping to analyze data in a relational database with the goal of supporting inventory-related business decisions that lead to the closure of a storage facility.

This README file provides step-by-step instructions for setting up and using MySQL Workbench to analyze warehouse and order data. It includes guidance on downloading and installing MySQL, configuring your SQL Server, and importing datasets for analysis. The instructions aim to help users leverage MySQL Workbench for efficient data querying, aggregation, and analysis, ultimately enabling improved inventory management and operational insights.

Objective: This project delves into the intricacies of warehouse and order data to enhance inventory management and provide actionable operational insights.