Descriptive Analytics II: Business Intelligence and Data Warehousing - Data Warehouse Implementation Issues

3 important questions on Descriptive Analytics II: Business Intelligence and Data Warehousing - Data Warehouse Implementation Issues

What are the major DW implementation tasks that can be performed in parallel?

tbd

List and discuss the most pronounced DW implementation guidelines.

As implementing a data warehouse, strong sponsorship is needed
Project champion needed with focus on what the user needs, not the technology.
Consider various risks
Assess risks at the inception phase of the data warehouse project
User participation in the development of data and access modelling
Team skills including in)depth knowledge of the database technology

What is scalability? How does it apply to DW?

Scalability is the possibility to grow.  A data warehouse must grow horizontally and vertically.
Grow as a function of data growth and the need to expand the datawarehouse to support new business functionality.
Main issues pertaining to scalability:
  • amount of data in the data warehouse
  • how quickly is the data warehouse expected to grow
  • the number of concurrent users
  • the complexity of user queries.    

The question on the page originate from the summary of the following study material:

  • A unique study and practice tool
  • Never study anything twice again
  • Get the grades you hope for
  • 100% sure, 100% understanding
Remember faster, study better. Scientifically proven.
Trustpilot Logo