Exercises Question 3 - Top Down Approach Given the following requirement for a travel agency: Airline Travel. We want to analyze the turn over (TO) of the travel agency by client, by travel date (& by month, quarter and year), by airline company, by city and by destination The produced dashboards should contain aggregated data such as the total and subtotal of the turn over: All clients together, and/or all dates and/or all companies, and/or all destinations. Prepare you Information Package and Design your STAR schema.
Exercises Question 3 - Top Down Approach Given the following requirement for a travel agency: Airline Travel. We want to analyze the turn over (TO) of the travel agency by client, by travel date (& by month, quarter and year), by airline company, by city and by destination The produced dashboards should contain aggregated data such as the total and subtotal of the turn over: All clients together, and/or all dates and/or all companies, and/or all destinations. Prepare you Information Package and Design your STAR schema.
Question
Transcribed Image Text:Exercises
Question 3 - Top Down Approach
Given the following requirement for a travel agency: Airline Travel.
We want to analyze the turn over (TO) of the travel agency by client, by
travel date (& by month, quarter and year), by airline company, by city
and by destination
The produced dashboards should contain aggregated data such as the
total and subtotal of the turn over: All clients together, and/or all dates
and/or all companies, and/or all destinations.
Prepare you Information Package and Design your STAR schema.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 1 images
