Dream Craft 

About Dream Craft

Dream Craft is a company that specializes in producing and selling miniaturized classic car models and other collectibles. They operate globally, having multiple offices in different countries. Each office employs several staff members, including sales representatives responsible for managing customer relationships. The customers of Dream Craft are predominantly toy and gift stores worldwide. These stores purchase classic car models, collectibles, and related merchandise from Dream Craft. Each customer interacts with a designated sales representative from Dream Craft who serves as their primary point of contact. Customers typically place orders for different products available in Dream Craft’s catalogue. These orders consist of various items in different quantities. Upon placing these orders, customers may choose to pay for multiple orders at once, often using methods such as checks or other forms of payment. The company aims to increase its sales by implementing business intelligence through Power BI and centralizing its database using Snowflake for enhanced data management.

Project Objective:

This project seeks to addressed the challenges in accurately auditing and consolidating sales data due to the vast geographic distribution of its operations. 

Built a comprehensive database solution with Snowflake and an integrated dashboard using Power BI to address the key challenges and requirements.