Items Sold Overview

Description: Displays total items sold broken down by time periods.

• Details: Analyze sales by month and day of the week.
• Purpose: Identify peak sales periods.

Purpose: Understand buying trends and optimize operational efforts.

Transaction Analysis

Description: Insights into transactional behavior over time.

• Top Visualization: Average amount spent per transaction by month.
• Bottom Visualization: Transaction patterns by day of the week and time.

Purpose: Together, this dashboard highlights peak transaction times on weekends and midday activity during weekdays, offering valuable insights for resource allocation, marketing strategies, and operational planning.

Sales Performance Overview

Description: Visualizes key sales performance metrics for 2024.

• Metrics: Revenue trends and cost analysis.
• Insights: Identify patterns in revenue and cost efficiency.

Purpose: Understand overall sales performance and optimize profitability.

Revenue and Cost Trends

Description: Compares revenue and cost by month, highlighting trends and fluctuations.

• Details: Analysis covers August to December.
• Insights: The visualization emphasizes consistent profitability despite variations in revenue, helping to identify high-performing months, such as August, and areas where revenue trends declined.

Purpose: These insights can support financial planning and strategic decision-making for improved performance.

Customer Spending Patterns

Description: Provides insights insights into customer spending patterns by tier.

• Metrics: Total Orders, Total Spend, Number of Customers, and Average Spend.
• Filters: Filter data by customer tiers (1 to 5).
• Insights: Tier 5 represents registered customers with no purchases.

Purpose: Identify high-value segments and customer behavior trends.

Order Distribution Across Tiers

Description: Highlights order distribution across customer tiers, including missing customer IDs.

• Chart: Displays orders linked and unlinked to customer accounts.
• Insights: Significant number of orders lack customer IDs.
• Strategy: Encourage sign-ups to improve data accuracy.

Purpose: Enhance customer data for better business strategies and insights.

Product Performance Overview

Description: Explore and analyze product performance across different categories.

• Top Chart: 'Revenue by Product Category' highlights total revenue for each category.
• Filters: Use the Category Filter to analyze specific product categories.
• Middle Chart: 'Best Selling Products' identifies products generating the most revenue.
• Right Chart: 'Top 10 Ordered Products' displays the most frequently purchased items.

Purpose: Identify star performers, customer preferences, and opportunities to optimize product offerings.

Products with Most Significant Association

Description: This table lists the association rules derived from market basket analysis. Each row represents a rule showing relationships between products.

• Itemset Rule: The rule indicating associated items.
• Frequency: The proportion of transactions containing the rule.
• Lift: Measures how much more likely two products are to be purchased together compared to being purchased independently.
• Confidence: The likelihood of buying the consequent item.

Purpose: Highlights the strongest product associations using frequency, lift, and confidence metrics.

Low Co-Purchase Frequency

Description: A horizontal bar chart showing items that are rarely purchased with others.

Details: These items have a co-purchase frequency of less than 1% with any other product. "Unknown Product" represents null product IDs.

Purpose: Identify gaps or opportunities for cross-promotion.

Items Frequently Purchased Together

Description: A bar chart showing the most frequent combinations of items purchased together.

Details: Displays popular pairs/groups of items bought together.

Purpose: Highlight opportunities for bundling or related promotions.

Low Ticket Items with Low Co-Purchase Frequency

Description: Displays low-ticket items (priced at $25 or less) rarely purchased with other products.

Insights: Items like "Butterfly Hairclip" and "Basic Hairclip" are frequently standalone purchases, limiting cross-selling opportunities.

High Ticket Items with Low Co-Purchase Frequency

Description: Highlights high-ticket items (priced $75 or more) that are rarely purchased with other items.

Insights: Items like "Mini Woven Crossbody" and "Weave Tote" are often seen as standalone investments.