The California Sales Dashboard is a comprehensive Power BI report that offers deep insights into sales data across California. Built to support sales strategy and business intelligence, this report delivers a clear picture of regional performance, product trends, customer behavior, and financial outcomes.
-
📈 Sales Performance Analysis
- View trends over time (monthly, quarterly, yearly)
- Monitor key KPIs such as Total Sales, Revenue, and Profit
-
🗺️ Geographic Sales Distribution
- Breakdown of sales by region, city, or zip code in California
- Visual mapping with location-based insights
-
🛍️ Product Category Insights
- See which product categories contribute most to revenue
- Compare product performance over time
-
👤 Customer Demographics
- Analyze customer behavior, frequency of purchases, and segmentation
- Understand age, gender, or income-based patterns (if applicable)
-
💰 Profitability & Inventory Tracking
- Track profit margins and cost-related metrics
- Monitor inventory levels and turnover rates
- Tool: Microsoft Power BI Desktop
- File Format:
.pbix - Data Modeling:
- Relationships between tables using foreign keys
- Custom measures created using DAX
- Slicers for time, product category, and geography
- Download and install Power BI Desktop.
- Clone or download this repository.
- Open
california_sales.pbixin Power BI Desktop. - Interact with the dashboard using built-in slicers and filters.
- No confidential or sensitive data is included in this public version.
- If needed, connect your own dataset via the Power Query Editor.
Feel free to fork the repo, add your own features, and submit a pull request. Suggestions and issues are welcome.