I build data and delivery systems that help organizations see themselves more clearly. My practice combines Power BI development, data architecture across sources like SharePoint and Excel, and project management discipline. I'm currently pursuing my PMP certification and building depth in Power BI, SQL, and Python.
The projects below are built using publicly available datasets, enriched and re-branded for portfolio purposes. They demonstrate the analytical and technical work I bring to client engagements: data modelling, executive-quality visualization, DAX authoring, and dashboard architecture. Real client work, where confidential data prevents public sharing, is discussed in private conversations with prospective clients.
If you'd like to discuss dashboard development, analytics consulting, or project management for your organization, please get in touch.
Portfolio 1:
Royal Taste Sales Intelligence Dashboard
An operational intelligence dashboard for the fictional restaurant Royal Taste, built to surface menu performance, service-time patterns, and payment trends from twelve months of transaction data.
Fast-food restaurants generate large volumes of transaction data through their point-of-sale systems, but that data often lives in exports that never get analyzed. Royal Taste, a fictional restaurant used for this portfolio project, represents a common operational reality: strong daily transaction volume with no consolidated view of performance patterns. Without visibility into which menu items drive revenue, when peak service periods hit, and how payment channels are shifting, management decisions rely on instinct rather than evidence.
How I built it
- Consolidated twelve months of POS transaction data (1,350 transactions) into a single Power BI model
- Designed a minimal star schema with one fact table and a date dimension for query performance
- Built executive-level KPI cards paired with drill-through detail views for management use
- Applied a branded color system (pistachio, bottle green, warm gold) matched to the restaurant's identity
- Surfaced data quality issues (missing payment type on 7% of transactions) directly on the dashboard so management can act on them
What the dashboard revealed
Growth trajectory: Royal Taste grew from $6,530 in launch quarter (Q2 2022) to $8,466 peak quarter (Q4 2022), a 30% increase, before showing a typical post-holiday cooldown in Q1 2023.
Weekend concentration: Friday, Saturday, and Sunday generate 62% of weekly revenue. Weekday sales run 38% below weekend peaks, suggesting an opportunity for mid-week promotions to smooth demand.
Evening rush dominance: The 5-9pm dinner window accounts for 40% of daily revenue. Staffing and inventory decisions should center on this window.
Digital payment transition: Online payments grew from 41% adoption in Q2 2022 to 64% in Q1 2023, a 23-point shift in customer behavior over twelve months. Continued investment in online ordering infrastructure is warranted.
Menu concentration: The top three menu items (Burrito, Crispy Chicken Sandwich, Cheeseburger) drive 58% of total revenue. Bundling these anchors with slower beverages could lift beverage sales.
Data quality flag: 7% of transactions have missing payment type data, indicating a POS process gap that requires staff training or system reconfiguration.
Technical Details
Tools: Power BI · DAX · Power Query M
Duration: Approximately 6 hours of build time across data modeling, visual design, and DAX authoring
Type: Portfolio project
Duration: Approximately 6 hours of build time across data modeling, visual design, and DAX authoring
Type: Portfolio project