Portfolio
Toy Kingdom Sales & Inventory Dashboard
Training project built in Power BI using the Maven Analytics Toy Store dataset. Tracks store-level sales against monthly targets and flags inventory risk across product categories and locations.
About Me
I'm a Microsoft Certified Power BI Data Analyst Associate, and I come from a background in systems engineering and SQL Server administration and development. That means I don't just build dashboards — I understand where data lives, how it moves, and what can go wrong before it ever hits a report.At my last company, I built the tools my teams actually needed — scheduling systems in Excel, Salesforce dashboards for operations and leadership, visual mapping tools for resource planning. Nobody asked me to do most of that. I saw gaps and filled them.Taking raw data and building something clear, useful, and honestly kind of beautiful — that's what I like to do.Resume · Certification
Toy Kingdom Sales & Inventory Dashboard
This dashboard monitors store-level sales performance against monthly targets and flags inventory risk across product categories and locations. Built in Power BI using the Maven Analytics Toy Store dataset.
What I Built
Two-page report with page navigation. The main page tracks current month orders, revenue, and profit against targets using KPI cards with variance indicators. A store location slicer filters all visuals by location type. Orders by category uses a bar chart as a click-to-filter selector. Custom color theme pulled from the Toy Kingdom logo to match the brand's playful tone.The second page surfaces stores with critical inventory levels. It includes DAX calculated columns for average monthly orders, months of stock remaining, and a risk level classification (No Supply, Critical, Low, Moderate, Healthy, No Demand). Conditional formatting on the risk level column provides visual urgency at a glance.
Techniques Used
| Star schema data model | DAX calculated columns | KPI cards with target variance |
| Conditional formatting | Data bars | Slicer filtering |
| Click-to-filter visuals | Page navigation | Custom color theme |
Data Model
Star schema with two fact tables (Sales and Inventory) connected to four dimension tables: Calendar, Products, Stores, and Risk Level. A dedicated Measures Table keeps DAX measures organized and separate from source data tables. The Inventory table includes calculated columns for Average Orders Per Month, Months of Stock Remaining, and Stock Risk Level — the logic behind the inventory risk page.