Explain the technology and approach you would use to handle the needs for studying historical trends in the information you have collected, combining it with other databases if needed. What information from the database would you collect over time? Define a star model for a data warehouse for this information. What information will you store in the fact tables? What attributes will it have? What dimension tables will you create? How will you organize the dimension tables? What physical structures (e.g., specialized indexes) will you use to make the data warehouse efficient? Explain, at a level suitable for business management, what they will be able to find out using this, both by breaking down information according to one or more dimensions, or drilling down on individual cells. Combine these items and submit in a 1- to 2-page APA formatted paper.
Previous answers to this question
This is a preview of an assignment submitted on our website by a student. If you need help with this question or any assignment help, click on the order button below and get started. We guarantee authentic, quality, 100% plagiarism free work or your money back.
Get The Answer