FESTMART-Dashboard Analysis

Project Overview

This dashboard provides a comprehensive analysis of the Festmart retail business. The key insights include:

• Total sales of $2.30M and total profit of $286.41K
• Sales breakdown by product category, with Technology, Furniture, and Office Supplies being the top sellers
• Profit margins by business segment, with Consumer-focused products being the most profitable
• Regional sales performance, showing the West as the top-performing region
• Detailed monthly sales trends, with steady growth throughout the year
• Customer metrics like total customers and customer growth by category

This data-driven dashboard gives Festmart's leadership team clear visibility into their business performance across multiple dimensions. It enables data-informed decision making to drive continued growth and profitability.

Tools

• excel - Data cleaning
• Power BI - Creating reports

Data cleaning/preparation

in the initial data preparation phase we performed the following task;

1. Data loading and inspection
2. Handling missing values
3. Data cleaning and formatting
4. Load data into Power BI Desktop, dataset is a csv file.
5. Open power query editor & in view tab under Data preview section, check "column distribution", "column quality" & "column profile" options.
6. Also since by default, profile will be opened only for 1000 rows so you need to select "column profiling based on entire dataset".

Based on the FESTMART dashboard image, here are some key insights and recommendations:

Insights:

1. Sales Performance:

• Total sales: $2.30M
• Total profit: $286.41K
• Total quantity sold: 38K units
• Total discounts given: $1.56K
• Number of customers: 793

Product Categories:

• Technology is the highest selling category, followed by Furniture and Office Supplies.
• Phones and Chairs are the top-selling sub-categories.

2. Seasonal Trends:

• Sales show a general upward trend throughout the year, with peaks in October and December.
• February appears to have the lowest sales.

3. Regional Performance:

• The West region leads in sales (31.58%), followed by Central (29.55%), East (21.8%), and South (17.05%).

4. Customer Segments:

• Consumer segment generates the highest profit (46.83%), followed by Corporate (32.12%) and Home Office (21.05%).

5. Returns:

• Office Supplies category has the highest number of returns, followed by Furniture and Technology.

Recommendations:

1. Product Focus:

• Invest more in marketing and inventory for top-selling categories like Technology and Furniture, especially phones and chairs.
• Analyze underperforming sub-categories to determine if they should be discontinued or need marketing support.

2. Seasonal Strategy:

• Develop targeted marketing campaigns for low-sales months, especially February.
• Prepare inventory and promotions for high-sales periods in October and December.

3. Regional Expansion:

• Investigate reasons for success in the West region and apply those strategies to boost sales in underperforming regions, particularly the South.

4. Customer Segment Targeting:

• Create tailored marketing and product offerings for the Consumer segment to capitalize on its high profitability.
• Develop strategies to increase sales to the Home Office segment, which has the lowest profit contribution.

5. Reduce Returns:

• Analyze reasons for high returns in Office Supplies and implement quality control measures or improve product descriptions to reduce returns.

6. Discount Strategy:

• Review the current discount strategy ($1.56K total) to ensure it's effectively driving sales without unnecessarily cutting into profits.

7. Customer Retention:

• Implement a customer loyalty program to increase repeat purchases among the 793 customers and attract new ones

These insights and recommendations should help FESTMART optimize its operations, increase sales, and improve profitability