<aside> 📌 This is a case study project or final assignment during my undergraduate studies given in the course 'Data Warehouse’
</aside>
Table of Contents
SpecialtyBrew is a coffee shop located in Jakarta, Indonesia. SpecialtyBrew sells coffees, coffee beans and tumblers. To improve the business, SpecialtyBrew’s CEO needs a database system that can analyze the operational data for decision making using Microsoft SQL Server 2019.
Establish an efficient data warehousing system that facilitates comprehensive analysis of sales transactions, customer preferences, employee performance, supplier details, and product metrics. The system will enable daily, monthly, quarterly, and annual reports, alongside ad-hoc analyses, for strategic decision-making and marketing initiatives.
The provided data includes information about:
Sales and purchase transaction data for coffee, coffee beans, and tumblers are also available in sufficient quantities for in-depth analysis. Each master table such as MsCoffeeBean, MsCoffee, MsEmployee, MsCustomer, MsSupplier, MsTumbler contains around of 1,000 entries, while the main transactions have around of 10,000 header entries and 25,000 detail entries. All of this data forms the foundation for the development and analysis conducted in this project.