Overview:

This 2022 Beverage Sales Review Dashboard, created in Power BI, comprehensively analyzes beverage sales performance across different brands, regions, and time periods. Designed to help businesses track sales trends, operating profit, and geographic distribution, this dashboard enables data-driven decision-making by offering interactive filtering and visual insights into key performance metrics.

Key Features:

• Total Sales Performance:

• Visualizes daily sales trends over the year, helping identify peak sales periods and seasonality.

• Operating Profit Analysis:

• Compares operating profit against total sales across major beverage brands.

• Highlights profitability by brand, supporting strategic pricing and inventory decisions.

• Beverage Brand Breakdown:

• Displays key sales metrics, including units sold, total revenue, average price per unit, and operating margin for each brand.

• Provides a data-driven ranking of beverage performance.

• Sales by State (Geographic Analysis):

• Interactive map visualization highlights state-level sales distribution, revealing top-performing locations and market opportunities.

• Dynamic Filtering & Date Range Selection:

• Users can filter by region, state, and time period to customize the analysis and drill down into specific trends.

Overview:

This Sales Performance Dashboard, built in Power BI, provides a comprehensive overview of yearly sales trends, profit margins, customer activity, and product category performance. Designed for sales teams, analysts, and executives, this dashboard delivers real-time insights into revenue generation, sales segmentation, and profitability.

Key Features:

• Overall Sales & Profit Overview:

• Tracks total sales ($2.30M), profit ($286.4K), orders (5009), and customers (793) for a holistic business performance view.

• Sales Breakdown by Category & Segment:

• Identifies top-performing product categories, including Technology ($836K), Furniture ($742K), and Office Supplies ($719K).

• Segments sales performance by Consumer, Corporate, and Home Office customers to analyze buying behaviors.

• Sales vs. Profit Over Time:

• Displays an interactive time-series analysis to highlight seasonal trends, revenue fluctuations, and profitability patterns.

• Detailed Product Profitability Table:

• Analyzes individual product profitability, revealing both high-revenue and loss-leading items.

• Helps businesses refine pricing strategies and optimize product offerings.

• Dynamic Filtering & Date Selection:

• Allows users to filter data by region, state, and date range, making it easy to customize insights based on business needs.