You have been assigned to do a study of the daily revenue effect of a pricing model of online transactions. All the data currently available to you has been loaded into your analytics database; revenue data, pricing data, and online transaction data. You find that all the data comes in different levels of granularity. The transaction data has timestamps (day, hour, minutes, seconds), pricing is stored at the daily level, and revenue data is only reported monthly. What is your next step?

You have been assigned to do a study of the daily revenue effect of a pricing model of online transactions. All the data currently available to you has been loaded into your analytics database; revenue data, pricing data, and online transaction data. You find that all the data comes in different levels of granularity. The transaction data has timestamps (day, hour, minutes, seconds), pricing is stored at the daily level, and revenue data is only reported monthly. What is your 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 a driver in the pricing model, and create a daily model based on pricing and transactions only.

View Answer

Answer: A