MarketFlash Marketing Services

MarketFlash Marketing Services is a new startup marketing company founded by Markus in 2023. He had requested to build a Database and a Dashboard based on the requirements below.

Project Requirements

1. Design a Functional ER Diagram and build it in SQL
2. The Dashboard Initial Design - Mockup designs as a proposal.
3. Build the dashboard on Tableau.
4. Finalised Presentation with ERD and Tableau Dashboard Design.

Information Provided for Database Design and SQL

• MarketFlash Marketing Data 2023
• MarketFlash Employee Data 2023

Pointers from MarketFlash as a Guideline

• Entities
• Data Info 1
• Data Info 2
• Relationships for ERD

Solutions

• Entity Relationship Diagram
• SQL Syntaxes: Creating the Database
• SQL Syntaxes: Inserting the Database
• MarketFlash Performance Campaign Dashboard (Tableau)
• Video Presentation on Project Summary