Posts

Showing posts from November, 2024

COFFEE SHOP SALES POWERBI DASHBOARD

  Introduction This Power BI dashboard provides a detailed analysis of sales data from a coffee shop, covering metrics such as total sales, quantity sold, product popularity, and sales trends. By exploring these metrics, the dashboard uncovers important insights into customer preferences, high-demand products, and overall sales performance over time. 1. Overall Sales and Quantity Overview The dashboard highlights a total of 214K units sold and 108 billion in sales revenue. These metrics provide a high-level summary of the coffee shop's overall performance. A gauge showing the "Sum of Price and First Category" reflects a mid-range total price value, indicating a balanced distribution of product pricing across categories. 2. Sales Trends Over Time The "Sales by Year, Quarter, Month, and Day" line chart shows a clear upward trend in sales throughout the year, with occasional fluctuations. Peaks in sales volume can be observed during certain months, suggesting per...

Walmart Sales Power BI Dashboard

 Introduction BI DASHBOARD This Power BI dashboard provides an insightful analysis of Walmart's sales performance over multiple years (2010-2012). By examining key factors such as fuel prices, unemployment rates, seasonality, and holiday periods, the dashboard helps identify trends, uncover relationships, and highlight areas for potential improvement in sales strategies. 1. Total Sales Overview The dashboard shows a cumulative total of $6.74 billion in weekly sales over the analyzed period, indicating Walmart's significant market reach. Visuals such as the large gauge at the top center emphasize this cumulative sales figure, providing a quick snapshot of the overall performance. 2. Sales by Year and Seasonal Trends The "Weekly Sales by Year" line chart shows that sales peaked in 2011 but saw a decline in 2012. This trend might reflect changing economic conditions or competitive pressures that affected sales. Breaking down sales by quarter reveals that Q2 and Q3 consis...