5 Data Warehouse Design Mistakes to Avoid

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
Next 5 Data Warehouse Design Mistakes to Avoid-5 Next


Mistake 4: Not having the right team

In any integration project, it's vital that everyone knows their roles and is able to communicate their pain points effectively. To that end, the primary data warehouse team will build data marts rapidly to achieve high ROI, making use of reusable components such as conformed dimensions, conformed facts and high-level transformation objects.

The team should include ETL engineers, who write processes and load data — ultimately, they are responsible for the quality of the data that enters and leaves the data warehouse. You will also need reports/dashboard engineers who build reports and dashboards, as well as a program manager, and data modelers who build out data models as per best practice. It's also important to have a separate maintenance and enhancement team that responds to user requests for enhancement to completed data marts. Additional team members should include data warehouse administrators, DBAs, source system experts, data stewards, training support personnel and business analysts.

A data warehouse lies at the base of any business intelligence (BI) implementation project. And if you are designing your data warehouse to help you visualize your company's most relevant data (as well as streamline workflows — which can help your company cut down on redundancies significantly), then you need to map out all the areas where there is a potential for your project to fail, before you begin building.

In this article, Himanshu Sareen, CEO at Icreon Tech, has identified five design mistakes that companies should avoid.


Related Topics : APC, Resellers, Data Replication, Extract Transform and Load, Structured Data Integration

More Slideshows

mobile87-190x128.jpg How to Find Business Value in Your Data Through Modernization

Data only becomes a meaningful and valuable asset when organizations can transform it into actionable insights. ...  More >>

LiaisonTechUncontrolledData0x 5 Steps to Wrangle Uncontrolled Data Flow

As the availability of data exponentially increases, unprecedented opportunities exist to do all kinds of amazing things, but these opportunities also come with data wrangling challenges. ...  More >>

Misc70-190x128.jpg 5 Data Warehouse Design Mistakes to Avoid

If you are designing a data warehouse, you need to map out all the areas where there is a potential for your project to fail, before you begin. ...  More >>

Subscribe Daily Edge Newsletters

Sign up now and get the best business technology insights direct to your inbox.