MAN6905: Sales & Marketing Database and BI Project

This project presents a comprehensive solution for a database and business intelligence assignment. It begins with the design of an Entity-Relationship Diagram and proceeds to database creation using SQL, including the creation of tables for customers, products, payments, sales, stores, and employees, along with data population. The solution then demonstrates SQL queries for data retrieval and analysis. Furthermore, the project includes the creation of an MS Access form for data input and display. Finally, it delves into business intelligence by analyzing two datasets (financial budget report and house price data) using pivot tables and charts in Excel, providing insights and analysis of the data. The project demonstrates the application of critical thinking and technical skills to solve authentic business problems.