Reference no: EM133531410

Question

The client organization wishes to better understand shipping performance based on the observable variance in shipping estimation and the actual time of arrival. To perform analysis on this data, they require a data warehouse (data mart) that will help identify critical data regarding shipping data as gathered from the Orders Database Orders Schema. 1) The Data Mart From: Matt Kozi &[email protected]> To: You Subject: New Data Mart Hello. I thought it would be helpful to send you a summary of what we discussed during the last meeting. The higher-ups want to kick-off a new initiative that will have our Analytics team evaluate shipping performance so that we can better understand which shipping methods are falling short on delivery time expectations and to what regions/cities this is most commonly occurring. However, I do agree with what you stated during the meeting, that giving the Analyst's direct access to the Orders database was an unnecessary risk, and that providing them with a cleansed data mart would be the best choice. We had some additional meetings and everyone agrees that your data mart idea would ensure that we wouldn't need to add more users to the Orders database, and would allow us to.