You have been assigned to perform a study of the daily revenue effect of a pricing model of online transactions. All data currently available to you has been loaded into your analytics
database. This includes revenue data, pricing data, and online transaction data.
You discover that all data comes in different levels of granularity. The transaction data has timestamps consisting of day, hour, minutes, and seconds. Pricing is stored at the daily level and revenue data is only reported monthly.
What is the next step?
A . Report back to the business owner that the current data model does not support the business question.
B . Interpolate a daily model for revenue from the monthly revenue data.
C . Aggregate all data to the monthly level in order to create a monthly revenue model.
D . Disregard revenue as the key reason in the pricing model and create a daily model based on pricing and transactions only.
Answer: A
Leave a Reply