Reference no: EM133229913

Once again, just to align the outline. 

I am generally confused about this course.

I can prepare my own presentation no worries there. 

You have been hired as a consultant to lead a discussion of the various considerations and issues that are associated with data modeling requirements. Prepare a presentation or document to be used during this discussion, including the following issues:

• Major design issues that need to be addressed before proceeding with the data design.
• Different approaches to dimensional modeling.
• Hierarchies and categories as applicable to a dimension table.
• Differences between dimension tables (wide) and fact tables (deep).
• The star schema and component tables.
• Data granularity in a data warehouse.
• Three advantages of the star schema and any disadvantages of the star schema.
• From the tools that are available for data modeling, identify the ones that would be the proper application for your project proposed in Unit 1.

Your presentation or document should open with a broad discussion of data modeling requirements and close with a summation of your points. The issues listed above can be addressed in short responses, consisting of one or two paragraphs each and introduced by headings