The Super Store Dashboard project is a comprehensive data analytics and visualization endeavor that involved creating a data warehouse and performing in-depth analyses on the data. The objective was to gain valuable insights into the Super Store's sales and profit and product trends. The project encompassed datawerehouse, transformation, loading, and the development of a dynamic dashboard for intuitive data exploration.
Dimension Creation:
Dim Geography: This dimension focuses on geographical attributes relevant to the Super Store. It includes information such as country, region, city and other location-related data. The purpose is to enable geographic-based analysis and segmentation of sales, customer behavior, and performance.
Dim DateTime: The Dim DateTime dimension plays a critical role in time-based analysis. It encompasses various temporal attributes, including date, month, year and day of the week.
Dim Product: This dimension is dedicated to product-related attributes. It consolidates information about the products sold at the Super Store, such as product category and product sub-category brand
Dim Customer: The Dim Customer dimension is essential for customer-centric analysis. It contains customer-specific attributes like customer ID, name, family and segment.
In this picture, you can see a few pages of our Dashboard
The team consists of the following members:
This team has completed the project under the mentoring of Amirali Rastegari.