The Hackathon Problem Brief

The following is the problem statement for the Hackathon, it is advisable to bookmark this page or copy and paste its contents somewhere easy to access:

As a data engineering consultant for LotsOfStuff, an ecommerce company that sells kitchen equipment, gardening equipment, and books, you have been asked to design and build a data mart to support the sales tracking and reporting needs of the company. The data mart will need to store information about the various products that LotsOfStuff sells, as well as details about the company’s clients, including their loyalty points, segmentation level (standard, silver, or gold), and contact and address information. Gold clients also have birthday information that needs to be stored in the data mart.

The main purpose of the data mart is to track and report on sales volume and value, both on a daily basis. This data should be able to be trended over time to show day-of-week, week-on-week, month-on-month, and year-on-year comparisons. The data mart should also enable slicing of sales data by various dimensions, such as product type, client segmentation level, and other relevant factors. It is important that the data mart be able to support these various tracking and reporting needs in order to provide valuable insights to the sales team and managers at LotsOfStuff.

Your task is to design and build a data mart that meets these requirements and enables the sales tracking and reporting needs of LotsOfStuff. This will require careful planning and consideration of the data that needs to be collected and stored, as well as the various ways in which this data will be accessed and analyzed by the sales team. You will need to extract the key points from the problem statement in order to understand the specific needs of the company and develop a solution that meets these needs effectively.