This Power BI project presents an interactive Sales Performance Dashboard designed to analyze and visualize key business metrics such as total revenue, gross profit, and sales units.
The dashboard allows users to explore data dynamically using filters for Country and Year, enabling in-depth performance tracking across different regions and time periods.
- Interactive filters for Country and Year.
- KPI cards display overall performance indicators such as:
- Total Revenue
- Gross Profit
- Total Units Sold
- A dynamic product ticker that shows revenue by product name.
- A list of Top Sales Representatives to highlight best performers.
- A pie chart displaying revenue distribution among subcategories (e.g., Extra, Super, Micro, Regular).
- A stacked column chart comparing revenue for each product across subcategories.
- A donut chart illustrating the contribution of different product categories to overall revenue.
- A waterfall chart showing year-over-year revenue changes for various products.
- A line chart depicting total revenue and quarter-over-quarter growth trends.
- A line chart showing gross profit along with month-over-month growth visualization.
- Tool: Microsoft Power BI Desktop
- Data Preparation: Power Query for data cleaning and transformation
- Data Modeling: DAX (Data Analysis Expressions) for measures and calculated fields
- Visuals Used:
- Card KPIs
- Pie Chart
- Donut Chart
- Waterfall Chart
- Line Chart
- Stacked Column Chart
- Table Visual
- Clone or download this repository.
- Place all dataset files inside the
/Datafolder as shown above. - Open the
Sales_Report.pbixfile in Power BI Desktop. - Reconnect datasets if required using the Data Source Settings menu.
- Use the filters (Country, Year) to interact with the dashboard.
This dashboard helps stakeholders and analysts:
- Monitor overall sales and profitability trends.
- Identify best-performing products, categories, and subcategories.
- Understand regional and time-based variations in performance.
- Support decision-making through data-driven visual insights.
Through this project, the following Power BI concepts were applied:
- Data cleaning and transformation using Power Query
- Creating data models and relationships
- Building interactive visuals and slicers
- Designing a professional and user-friendly dashboard layout
- Applying DAX for business logic and key metrics
The Sales Report Dashboard provides a consolidated and interactive view of business performance, allowing users to filter data, identify trends, and make informed strategic decisions.
It demonstrates effective use of Power BI for professional data visualization and analysis.