Assignment Task:
Congratulations! Because of the wonderful job you did with the report and the executive presentation on Big Data, you are asked to brief management on implementing Dimensional Modeling for Facebook. Your deliverables MUST address the following EDM concerns from Facebook's perspective:
1. Explain your plan to install the Four-Step Dimensional Design Process (use a visual to support your discussion) for Facebook.
2. Discuss how you will handle Basic Fact Tables for Facebook.
3. Offer your insight on online analytical processing available options like OLAP Cubes and other alternatives for Facebook.
4. Present your designs in Dimensions and applicable components (a draft Dimensional Model (visual) is expected).
5. Research EDM schemas (such as star, snowflake, etc. and compare them) and suggest one showing how it applies to Facebook (this requires a visual showing the schema with your company dimensions).