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 consistently perform better, with both quarters recording over $1.8 billion in sales. This suggests a seasonal pattern, possibly tied to summer and back-to-school shopping peaks.
3. Holiday Impact on Sales
  • The "Weekly Sales and Holiday Flag" bar chart by month highlights an increase in sales during holiday months like March, July, and November.
  • For example, March and July, representing spring and mid-year holiday sales, both recorded high weekly sales figures, showcasing how holiday promotions effectively boost revenue.
  • November, despite being a key holiday month, shows a slightly lower sales level compared to other holiday months. This might indicate room for improvement in holiday season marketing or inventory strategies.
4. Impact of Economic Indicators
  • Fuel Prices: The "Fuel Price by Year" line chart illustrates a peak in 2011 followed by a drop in 2012. Given that higher fuel prices generally increase transportation costs, this could have affected Walmart’s logistics and pricing strategies, potentially impacting sales.
  • Unemployment Rate: The "Unemployment and Weekly Sales by Year" donut chart shows unemployment data alongside sales. Despite varying unemployment levels across the years, sales remained robust, suggesting that Walmart's affordable product offerings may attract consumers even during economic downturns.
5. External Factors Affecting Sales
  • The "Temperature and Weekly Sales by Year" scatter plot suggests a possible relationship between temperature changes and weekly sales. Sales may increase during certain weather conditions, such as cooler months or holiday seasons, which can influence customer foot traffic and spending behavior.
6. Store and Holiday Flag Analysis by Year
  • The "Store and Holiday Flag by Year" chart shows the number of stores with sales marked by holiday flags. This metric allows Walmart to track sales effectiveness during holiday periods by year, highlighting 2011 as a peak year with the highest holiday-driven sales.
Conclusion


The Walmart Sales Power BI Dashboard provides valuable insights that help Walmart understand its sales patterns across different times of the year and under various economic conditions. By leveraging this information, Walmart can make informed decisions to optimize holiday promotions, adjust inventory management during peak periods, and align its pricing strategies with economic factors like fuel prices. This data-driven approach ensures Walmart remains responsive to both market trends and consumer demands.

Comments

Post a Comment

Popular posts from this blog

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...
Read more