1. Before starting anything you need a Data Model. Getting a common comprehension of what data is important to the business will be fundamental to the success of the data warehouse. In some cases the organizations themselves don’t have a clear idea about their own data needs. Good communication is absolutely necessary for a successful data model

2. Keep the architecture as simple as possible. There is usually no need to overcomplicate the implementation unless it’s absolutely essential for your current project but as a concept data warehousing is quite simple and it involves three steps:
   1. Extraction

1. Extraction
2. Transformation
3. Loading

3. Choose a data warehousing architecture and stick with it. There are advantages and disadvantages to most of the established architectures (Star schema, 3NF, Data Vault, etc) but choosing one over the others and sticking with it is highly recommended as it will make any future support or troubleshooting you may need to perform a lot easier and quicker

4. Know the Data Source. Before starting the data warehouse design you need to familiarize yourself with all the different data types and formats that are used in the data source. This will help you choose the ETL framework which soothes your needs the best and it will help you avoid any unpleasant surprises when developing the extraction and transformation logic

5. Provide flexibility. One of the most important things to remember is that a data warehouse takes a long time to develop and integrate therefore it is crucial for the finished product to be more flexible. Businesses change and evolve and the data warehouse needs to be able to follow

• Share on Facebook
• Share on LinkedIn