The "01 - Sales Dashboard.xlsx" spreadsheet is a sales dashboard that provides an overview of total sales and sales by location. It can be used to monitor sales performance, identify trends, and make informed business decisions.
**Dashboard Overview:**
* **Total Sales:** Shows the total sales for the selected period.
* **Total Sales Trend:** Shows the trend of total sales over time.
* **Sales by Location:** Shows the total sales for each location.
* **Brand A and Brand B:** Shows the sales for each brand by location.
**How to use the dashboard:**
1. **Select the desired period:** The spreadsheet allows you to select the desired period for analysis.
2. **Analyze Total Sales:** Observe the total sales and the trend of total sales. 3. **Identify Top Performing Locations:** Identify locations with the highest total sales.
4. **Analyze Sales by Brand:** View sales for each brand by location.
5. **Make Informed Decisions:** Use the dashboard insights to make informed business decisions such as resource allocation, marketing strategies, and sales planning.
**Additional Information:**
* The spreadsheet contains sales data for the year 2017.
* Sales data is grouped by location, brand, and product.
* The spreadsheet also includes shopper information such as name, gender, and purchase quantity.
* The dashboard insights can be used to improve sales performance and increase revenue.