
A regional sales manager used to spend 4 hours every Monday manually merging five territory Excel spreadsheets and fixing broken VLOOKUPs. With a clean Star Schema and automated DAX measures, that entire weekly reporting routine finishes in 10 minutes.
Most people learning Power BI practice on clean, 10-row sample spreadsheets that never show up in real workplaces. Then they sit in a live technical interview or get handed messy company exports and struggle to connect tables, calculate year-over-year trends, or build executive-ready KPIs.
Created by Hasbal Global Solutions (hasbal.com.ng), the GlobalMart Power BI Executive Dashboard Toolkit gives you raw multi-table retail data, an interactive executive dashboard simulator, and a copy-paste DAX & Power Query formula cheat sheet so you can reverse-engineer and build a boardroom-ready portfolio project immediately.
GlobalMart_Sales_Data.csv: 2,500 transactional order records spanning 2023 and 2024 with quantities, unit prices, discounts, and order IDs.GlobalMart_Products.xlsx: Complete product master catalog across Electronics, Appliances, Apparel, and Home Goods with unit cost mappings.GlobalMart_Customers.csv: 200 multi-region customer demographic profiles (North, South, East, West) across Corporate, Consumer, and Home Office segments.GlobalMart_Returns.csv: 200 returned order logs with timestamps and return reasons (Not as Described, Defective, Changed Mind, Wrong Item) for return-rate modeling.2024 YTD, 2023, All Years), Region, and Product Category slicers.$669.1K YTD), Total Profit ($220.8K), Profit Margin (33.0%), YoY Growth, and Return Rate (8.9%), plus dynamic Smart Narrative inventory recommendations. CALCULATE, TOTALYTD, SAMEPERIODLASTYEAR, RANKX, custom DAX Date tables, and Power Query unpivot/merge steps.1:* single-direction relationships between your Sales fact table and dimension tables.Built by Azeez Ajibola Azeez, Founder and Lead Data Consultant at Hasbal Global Solutions (hasbal.com.ng). Holding credentials from Microsoft and DataCamp, Azeez builds automated reporting pipelines tracking over $20M in transactional spend and has trained more than 100 professionals across 15+ countries.
(Looking for the companion 56-page step-by-step study manual and PL-300 practice exam book? Search Power BI Masterclass: From Data Chaos to Executive Dashboards on Amazon Kindle or follow the direct link inside your toolkit's README file.)