Goodnight Inn, part of Pillow & Key Group.
Goodnight Inn, a Pillow & Key Group brand, grew revenue while its operating profit declined. This report investigates that gap and asks a practical question: which investments create the most value by 2032 without committing the entire $60M budget? Context and Objectives From 2023 to 2025, Goodnight Inn’s revenue rose by $8.9M, but operating profit fell by $2.6M. The goal was to understand what changed, compare the proposed investments and give the board a clear recommendation grounded in the provided data. Methodology and Approach The experience follows a simple path: understand the brand’s performance, then make the investment decision. The first page explains the profit decline and lets readers explore hotel performance. The second compares investment options, timing and scenarios. Further detail is available when readers want to examine the reasoning behind a result. I evaluated all 1,024 combinations of the ten proposed projects. Of these, 456 satisfy the challenge constraints. The recommendation is based on value created within the 2032 horizon, using the dataset’s 8% discount rate. Challenges and Learnings The central challenge was separating a larger investment from a better investment. Some portfolios produce higher annual profit by 2032 but fail to recover enough value within the evaluation period. I also learned that a recommendation is more useful when its downside is visible alongside its expected result. Insights and Discoveries The profit decline is closely linked to distribution. Online travel agencies accounted for 32% of room nights in 2023 and 49% in 2025. Commission rates did not change, but the shift in channel mix added about $2.05M in distribution costs—roughly 80% of the $2.6M profit decline. This calculation describes the financial effect of the mix shift; the dataset does not establish why guests changed channels. Impact and Outcome The recommended portfolio combines a direct booking app, revenue management and self check-in kiosks. It requires $9.4M, leaving $50.6M of the budget in reserve. It ranks first among the 456 compliant portfolios in all three scenarios and produces an Expected NPV of +$3.25M, with payback in 2031. the others mine projects: THE ANATOMY OF FEAR — When Monsters Grow Up Lights, Camera, Insight — What Makes a Movie Successful? LEGO — The Color Explosion | Brick by Brick, World Champs BCN Round 2 PitchSide Pro - Executive Growth & Commercial Efficiency Dashboard Olympic Performance Dashboard — Project Description Week 3 slindsay Leanore tayloramy Santhanalakshmi PauloGrijoMaison d'Or Profitability & Performance Dashboard
Investment Insight | Expected scenario - We recommend 5 initiatives: $119.6M of the $210M budget. $90.4M stays uncommitted. Within budget. - Return: +$23.8M operating profit a year at full run-rate. * Energy Retrofit: $0M direct revenue, but generates +$16.4M profit via operating cost savings. - By 2032: $81.4M earned net of running costs. Risks & trade-offs - Result ranges from +$13.5M (Low) to +$33.6M (High) a year. - Works disruption costs $41.8M. - Rejected: Lisbon ($136M) earns only 7.4% a year on cost, below the 8% discount rate. - Alternative rejected: Rome + New York + Lisbon would cost $201M for only +$20.0M. How it answers Page 1 - Margin 39.4% to 38.0%: Fixed via Energy Retrofit (cuts expenses) & Loyalty platform (direct bookings cost 4% vs 16% for OTAs). - Guest score 8.60 to 8.34 and NPS 38.8 to 32.0: Rome renovation (score 7.8, last renovated 2009) and Loyalty. - Growth: New York at 86% occupancy, so +40 suites; Maui best rate ($754 ADR), so the Spa. Text shows the Expected scenario; the chart and KPI follow the Scenario slicer.Maison d'Or Profitability & Performance Dashboard
Investment Insight | Expected scenario - We recommend 5 initiatives: $119.6M of the $210M budget. $90.4M stays uncommitted. Within budget. - Return: +$23.8M operating profit a year at full run-rate. * Energy Retrofit: $0M direct revenue, but generates +$16.4M profit via operating cost savings. - By 2032: $81.4M earned net of running costs. Risks & trade-offs - Result ranges from +$13.5M (Low) to +$33.6M (High) a year. - Works disruption costs $41.8M. - Rejected: Lisbon ($136M) earns only 7.4% a year on cost, below the 8% discount rate. - Alternative rejected: Rome + New York + Lisbon would cost $201M for only +$20.0M. How it answers Page 1 - Margin 39.4% to 38.0%: Fixed via Energy Retrofit (cuts expenses) & Loyalty platform (direct bookings cost 4% vs 16% for OTAs). - Guest score 8.60 to 8.34 and NPS 38.8 to 32.0: Rome renovation (score 7.8, last renovated 2009) and Loyalty. - Growth: New York at 86% occupancy, so +40 suites; Maui best rate ($754 ADR), so the Spa. Text shows the Expected scenario; the chart and KPI follow the Scenario slicer.
Decoding the Unknown - Survey & Fear Analytics (Halloween Contest Entry)
About the Poster: I made this single-page dashboard as an A4 standalone poster. My main goal was to tell a simple story about what scares the data community in childhood versus what scares them today as adults. Key Insights from the Data: - Biggest Current Fear: 'Animals & Insects' is the most common active fear for adults (76 entries). - Hardest Fear to Forget: 'Confined & Physical Spaces' is the most stubborn fear. 33% of people who feared this in childhood still fear it today. - Top Location: Europe is the biggest hotspot, with the most responses in the survey (356 entries). Design Choice: I used a dark theme with neon highlights and an easy-to-read Matrix chart. The design is simple so anyone can understand the full story easily at a glance, without needing to click or hover on anything.Sales vs Forecast | Dashboard
This dashboard was developed as part of an interview assessment to compare actual sales against forecast across Americas, EMEA and Asia. The solution used SQL Server for data ingestion, staging, cleaning, standardization and reporting views, followed by Power BI and DAX measures for KPI calculation and interactive analysis. A key insight was that actual sales exceeded forecast across the analyzed years, while approximately 7% of sales records had no matching forecast and require further business review. eyJrIjoiYmUzMTNkNTQtMmQzMC00M2U0LWE2MmItMzgzMDBiOTIzYWZlIiwidCI6ImI0MzBjNjVhLTlmY2ItNGQ4Yi1hNDU4LTBhNzJhYTI0YzQzMyJ9
Beyond the Box Office: The Anatomy of Movie Success
Beyond the Box Office explores what really makes a movie successful. Through financial performance, audience response, market popularity, and production factors, this report reveals that success cannot be defined by a single metric. Each perspective tells a different part of the story—highlighting the importance of balanced, responsible data-driven analysis.
Workout Wednesday 2026 Week 25 - Sales Difference
Here is my submission for the Data Days QuickViz - Workout Wednesday Remix (2026 Week 25). Challenge: Diverging Bar Chart showing sales differences compared to the selected sub-category. Features Built: Custom DAX measure for sales variance, dynamic labels with (+) and ( - )formatting, and custom color rules. QuickViz Challenges | Fabric Data Days Workout Wednesday 2021 | Week 6 - Long Labels 2026 Week 25 | Power BI: Find the difference from a selected value / Power BI, Workout Wednesday / By Meagan Longoria Introduction, We have a new contributor to WoW for Power BI, Robbin Vernooij.
THE LEGO BIG BANG
🧱 THE LEGO BIG BANG — A Data Story in Four Chapters In 1949, LEGO released 1 set. Today it exceeds 1,000 per year. This report tells the story of that explosive growth through four chapters: Chapter 1 — The Beginning: The scale of the LEGO universe today (27,000+ sets, 251 colors, 62K parts, 17K minifigures) Chapter 2 — The Growth: How annual releases grew exponentially, and how sets got bigger decade by decade Chapter 3 — The Catalyst: Licensed themes (Star Wars, Harry Potter, Marvel) rewired LEGO from "toy" to "platform" Chapter 4 — The Universe Today: The biggest sets ever made (World Map: 12,107 parts), and how color diversity expanded alongside complexity KEY TAKEAWAY: LEGO's growth is exponential, not linear — and licensed franchises were the catalyst that transformed a simple brick into an infinite creative universe. Design: Book/storybook theme with narrative-first layout. Each page reads like a chapter, with text guiding the audience through the data. Source: Rebrickable LEGO Database (rebrickable.com)
