As the manager for the data warehouse project, write a project completion report to your CIO and the executive project sponsor. List the major activities completed. Mention the plan for staged deployment of future releases. Indicate the plans for ongoing maintenance. Briefly highlight each topic on growth and maintenance.
You are hired as the new training administrator for the data warehouse in a nationwide automobile dealership. The data warehouse is Web-enabled. The analysts in the headquarters work with the OLAP system based on the MOLAP model. Establish an improved ongoing training program. Describe the highlights of the program.
You are specifically assigned to improve the query performance in your data warehouse, deployed about six months ago. How will you plan for the assignment?
What are the types of statistics you will need? Create a detailed plan.