This Power BI project analyzes customer shopping trends to help businesses make informed decisions about product performance, customer segmentation, and regional sales contributions. The dashboard enables dynamic filtering and offers interactive visuals to track KPIs, regional trends, and manager performance.
- Age Range Selector: Adjustable slider to analyze sales by age group.
- Region, Location, Store Name, Gender: Dropdown filters to refine insights by demographic and geographic attributes.
- Total Sales: 513K
- Customer Count: 4
- Average Sales per Customer: 128.19K
- Top Category Sold: Electronics
- Average Sales per Customer by Product: Compares performance across products like Machine, Lead, High, Claim, etc.
- Total Sales by Sale Date: Time-series visual showing trends across multiple years.
- Total Sales by Region and Category: Bar chart showing sales contribution across South region segmented by category.
- Total Sales by Location and Category: Geospatial map powered by Microsoft Bing showing global distribution.
- Total Sales by Gender: Equal distribution (50% male, 50% female).
- Top Performing Cities: Every city listed (e.g., Baileybury, Basserport, etc.) shows ~0.51M in total sales.
- Impact by Manager: Barbara Riggs leads with 63K in total sales, followed by Eric Byrd and others.
- Yearly Growth by Category: Line graph tracking annual growth for all product categories.
- Power BI Desktop
- DAX for Measures & Calculations
- Power Query for Data Transformation
- Microsoft Bing & OpenStreetMap Integration for Geospatial Analysis
- Clone or download this repository.
- Open the
.pbixfile in Power BI Desktop. - Use the slicers (age, gender, region, etc.) to explore specific customer segments.
- Review KPIs and charts to identify sales drivers and optimization opportunities.