An Interactive Power BI Dashboard designed to analyze and visualize comprehensive sales performance metrics across multiple dimensions including time periods, geographical regions, and product categories.
- KPI Cards with dynamic indicators showing:
- Total Sales: 1.18M with growth percentage (+370.93%)
- Average Order Value: 344.45 with trend analysis (+72.23%)
- Quantity metrics: 586,736 units with performance tracking (+551.93%)
- Profit analysis: 235.47K with variance indicators (+619550.29%)
- Year Slicer: Filter data by specific years (2009, 2010)
- Month Slicer: Analyze monthly performance (January through December)
- Country Slicer: Regional performance filtering with dropdown selection
- Clear All Slicers: Reset all filters instantly
- Total Sales by Quantity: Scatter plot analysis showing quantity vs sales relationship
- Total Sales by Day: Time-series line chart with monthly breakdown (January-July)
- Customers by Month: Horizontal bar chart showing customer distribution (22K-33K range)
- Total Sales by Description: Donut chart showing sales breakdown by product categories
- Total Sales by Month: Vertical bar chart displaying monthly revenue trends
- Geographic Mapping: Interactive world map showing sales distribution across regions
- Detailed Data Table: Comprehensive view with Month, Description, Quantity, Price, and Total Sales
- Microsoft Power BI Desktop (Latest version recommended)
- Power Query for data transformation and cleaning
- DAX (Data Analysis Expressions) for custom calculations and measures
- Power BI Visualizations including maps, charts, and custom visuals
- Interactive Slicers and Filters for dynamic data exploration
- Data Modeling with relationships and hierarchies
This dashboard enables analysis of:
- Revenue Growth: Significant growth tracking with 370.93% increase in total sales
- Customer Behavior: Monthly customer acquisition patterns ranging from 22K to 33K
- Product Performance: Category-wise sales distribution through interactive donut charts
- Regional Analysis: Geographic sales mapping across global markets
- Seasonal Trends: Monthly performance patterns and daily sales fluctuations
- Profitability: Substantial profit growth of over 600% with detailed margin analysis
- Microsoft Power BI Desktop (Free download from Microsoft)
- Basic understanding of Power BI interface
- Sales dataset in supported format (Excel, CSV, SQL, etc.)
- Download the Power BI (.pbix) file from this repository
- Open Power BI Desktop
- Open the downloaded .pbix file
- Refresh data connections if prompted
- Use slicers to filter by Year, Month, and Country
- Explore interactive charts and KPI metrics
- Analyze the detailed data table for specific insights
- Use the slicers on the left panel to filter your view
- KPI cards automatically update based on applied filters
- Charts respond dynamically to slicer selections
- Click "Clear all slicers" button to reset all applied filters
- Hover over chart elements for detailed tooltips
- Click on chart segments to cross-filter other visuals
Power-BI-Interactive-Sales-Dashboard
├── sales-dashboard.pbix # Main Power BI dashboard file
├── dashboard-preview.png # Dashboard screenshot
├── data.csv # CSV File sample
├── README.md # This file
└── LICENSE # MIT License
Your sales dataset should include the following columns:
- Date: Transaction date
- Product Description: Detailed product information
- Quantity: Units sold
- Price: Unit price
- Country: Geographic location
- Customer ID: Unique customer identifier (optional)
- Products include: DOORMAT UNION JACK GUNS AND ROSES, 3 STRIPE MICE FIELDS, ANIMAL STICKERS
- Geographic coverage: Global sales data
- Time range: Multi-year data (2009-2010 visible in current dataset)
- Transaction-level detail with pricing and quantity information
- Open the Power BI file
- Go to Home > Transform Data to open Power Query Editor
- Replace or update the data source with your sales dataset
- Ensure column names match the expected structure
- Apply transformations as needed
- Close & Apply to refresh the dashboard
- Charts: Select visual and modify in Visualizations pane
- KPIs: Update DAX measures in the Data view
- Slicers: Add new slicers by dragging fields to canvas
- Colors: Customize color themes in Format pane
- Layout: Resize and reposition visuals as needed
Example DAX calculations used in this dashboard:
Total Sales = SUM('Sales'[Quantity] * 'Sales'[Price])
Average Order Value = DIVIDE([Total Sales], DISTINCTCOUNT('Sales'[OrderID]))
Sales Growth % = DIVIDE([Total Sales] - [Previous Period Sales], [Previous Period Sales])
- Cross-Filtering: Interactive relationships between all visuals
- Drill-Down Capabilities: Navigate from yearly to monthly to daily views
- Dynamic Titles: Titles update based on applied filters
- Conditional Formatting: Visual indicators for performance metrics
- Export Options: Export filtered data to Excel or CSV
- Mobile Layout: Optimized view for mobile devices
- Bookmarks: Save specific filter states for quick access
- Data Model Optimization: Efficient relationships and hierarchies
- DAX Optimization: Optimized measures for better performance
- Visual Optimization: Reduced visual complexity for faster rendering
- Data Refresh: Scheduled refresh capabilities for live data
Contributions are welcome! Please feel free to submit a Pull Request. For major changes:
- Fork the repository
- Create a feature branch (
git checkout -b feature/NewVisualization) - Make your changes to the .pbix file
- Test thoroughly with sample data
- Commit your changes (
git commit -m 'Add new visualization feature') - Push to the branch (
git push origin feature/NewVisualization) - Open a Pull Request with detailed description
- Sales Teams: Track individual and team performance metrics
- Management: Executive dashboards for strategic decision making
- Marketing: Campaign effectiveness and customer behavior analysis
- Operations: Inventory planning and demand forecasting
- Finance: Revenue analysis and profitability assessment
- Regional Managers: Geographic performance monitoring
power-bi sales-dashboard data-visualization business-intelligence kpi-reporting interactive-dashboard dax power-query data-analytics sales-analysis
This project is licensed under the MIT License - see the LICENSE file for details.
If you found this project helpful, please star the repository!
For questions or support:
- Open an Issue for bug reports or feature requests
- Check existing Discussions for community help
- Fork and modify for your specific business needs
- Refer to Microsoft Power BI Documentation for additional help
- Operating System: Windows 10 or later
- Software: Microsoft Power BI Desktop (Free)
- Memory: Minimum 2 GB RAM (4 GB recommended)
- Storage: At least 2 GB available space
- Internet: Required for data refresh and Power BI Service integration
Built with Microsoft Power BI Desktop