Database and Data Warehouse Design

Milestone 1

Developed a Conceptual Model and a MYSQL diagram that have 10 entities, and a number of relationships, attributes, PK's, FK's, captions that help describe the ER Model, with the goal of identifying business insights for a small coffee shop.

Milestone 2

• Generated the physical database from the model.
• Populated some tables with Sample Data.
• Generated relevant SQL Queries.
• Created Stored Procedure.

Milestone 3

• Deployed database to AWS cloud.
• Utilized Tableau to visualize and present the key findings that helped answer the business problems including supplies, merchandising, and marketing campaigns.

Sample Screenshot