Portfolio Details
Plieger Suitcase Day – Power BI Dashboard
This Power BI dashboard provides insights into the turnover and sales performance across different regions in the Netherlands during the "Plieger Suitcase Day" event. It includes key performance indicators (KPIs), regional sales comparisons, and stock tracking, enabling decision-makers to analyze business performance effectively.
Key Features
KPIs (Key Performance Indicators)
- Turnover: €1,811,873
- No. of Items Sold: 310,337
Turnover Per FTE Leaderboard
- Displays a ranking of regions based on revenue per full-time
equivalent (FTE).
- Top Performing Region: Oost-Nederland (€15,266.91 per FTE),
followed by Noord-Nederland and Noord-Brabant.
Regional Sales & Hourly Sales
- Users can switch between "Region Sales" and "Hourly Sales"
using bookmarks.
- The bar chart titled “Omzet per Regio” (Revenue per Region)
showcases turnover by region.
- Region 04 has the highest revenue (€458,007), while Region
00 has the lowest (€13,862).
Stock Tracking
- Visualizes remaining stock, with 152,729 units left out of a
maximum value of 463,066.
- Provides an easy-to-read representation of inventory levels
during the event.
Real-Time Data Update
- The dashboard includes a timestamp (Data Up To: 23:16:40),
indicating when the data was last updated.
Power BI Techniques Used
- Data Modeling: Ensured optimized relationships between sales, inventory, and regional data.
- DAX Measures: Created calculated fields for turnover per FTE, ranking, and KPI metrics.
- Bookmarks & Navigation: Implemented to switch between "Region Sales" and "Hourly Sales" views.
- Custom Visualizations: Used a cylindrical gauge chart for inventory tracking.
- Conditional Formatting: Applied in the ranking table for visual emphasis on top-performing regions.
Portfolio Value
This dashboard is a great showcase of data visualization, interactivity, and business intelligence techniques in Power BI. It highlights the ability to present complex sales and stock data in an intuitive and visually appealing manner, making it useful for business performance tracking and decision-making.