This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Business Intelligence Analyst at Hilton. The executive team has requested a single flat report that combines data from four core tables to provide a complete picture of every reservation. The report should show who booked (guest name), where they stayed (property name), what room they got (room name and bed type), how they booked (channel), how long they stayed (nights), and how much they paid (total price). This unified view supports cross-functional reporting for operations, marketing, and finance.
You are a Business Intelligence Analyst at Hilton. The executive team has requested a single flat report that combines data from four core tables to provide a complete picture of every reservation. The report should show who booked (guest name), where they stayed (property name), what room they got (room name and bed type), how they booked (channel), how long they stayed (nights), and how much they paid (total price). This unified view supports cross-functional reporting for operations, marketing, and finance.