Data Warehousing Chapter 12: Transportation

Play an AI-generated podcast conversation about this lesson

What does the sale of a ticket represent in the airline industry?

Earned revenue

Refunded revenue

Lost revenue

Unearned revenue (correct)

What is the term for a single flight number flown by a single aircraft?

Leg

Trip

Itinerary

Segment (correct)

What is the level of granularity that provides an accurate picture of customer demand?

Itinerary

Segment level

Leg level

Trip (correct)

What is the term for an aircraft taking off at one airport and landing at another without any intermediate stops?

Leg Signup and view all the answers

What is the purpose of the degenerate dimension in the airline's bus matrix?

To capture the bus process events Signup and view all the answers

What is the equivalent of the entire airline ticket or reservation confirmation number?

Itinerary Signup and view all the answers

What is the purpose of a class change indicator in a data model?

To describe relationships between purchased and flown classes Signup and view all the answers

Why might combining role-playing dimensions be beneficial?

To maintain consistency across the data model Signup and view all the answers

What is a potential challenge of using separate origin and destination dimensions?

Inconsistencies in labeling Signup and view all the answers

Why might business users want to combine origin and destination airports?

To analyze flight activity by distance Signup and view all the answers

What is a potential disadvantage of separate role-playing dimensions?

Difficulty in combining attributes Signup and view all the answers

What is a potential solution to inconsistencies in labeling?

Resolving programmatically Signup and view all the answers

What type of data is often captured in a patient's electronic medical record?

Both quantitative numbers and qualitative notes, as well as images Signup and view all the answers

What is a common challenge in the healthcare industry, especially with legacy operational systems?

Dealing with late arriving data Signup and view all the answers

What type of fact table is used to illustrate the healthcare claim billing and payment pipeline?

Accumulating snapshot grain fact table Signup and view all the answers

What is an example of a metric that healthcare organizations are interested in?

Utilization and availability of assets Signup and view all the answers

What is a common use of freeform text comments in healthcare?

To capture clinical notes Signup and view all the answers

What is the purpose of the enterprise data warehouse bus matrix in healthcare?

To show the relationship between administrative and clinical data Signup and view all the answers

What is the granularity of the second clickstream fact table?

Individual page event in each customer session Signup and view all the answers

Why should you avoid grouping the table at a broader level?

Because it loses details Signup and view all the answers

What is the result of using dynamically created XML-based pages on websites?

The number and type of events grow Signup and view all the answers

What is the purpose of picking the right categories after deciding on the level of detail?

To establish the right categories for analysis Signup and view all the answers

What can be seen in Figure 15-6?

The final layout of the clickstream fact table Signup and view all the answers

What is a strength in dimensional modeling?

Similarity between designs Signup and view all the answers

What can be used to label customers for periods of time with information that is not clear from the page or immediate session?

Customer status attribute Signup and view all the answers

Where should labels derived from auxiliary business processes be placed in the DW/BI system?

Deep within the clickstream Signup and view all the answers

What type of information is usually provided by the web server logs?

URL of the previous page Signup and view all the answers

What is the purpose of the session dimension?

To group sessions for analysis Signup and view all the answers

What should be considered when dealing with a large number of customer statuses?

Creating a separate customer status mini-dimension Signup and view all the answers

What type of analysis can be performed using the session dimension?

Analyzing how many customers consulted product information before ordering Signup and view all the answers