5 Data Warehouse Design Mistakes to Avoid

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

Data Shadow Systems

Mistake 3: Ignoring data shadow systems

It's easy to focus on an enterprise's transactional systems of record and BI, but not all the important information is located there. Key info is also located in "data shadow systems" dispersed throughout the organization. Spreadsheets in Excel contain many of the most useful reports and analytics. Groups of spreadsheets and customized databases make up data shadow systems, especially programs like Microsoft Access and other similar statistical databases. Business processes, like budgeting, forecasting and other reporting tasks are supported by data shadow systems. You will always need to use reporting from your enterprise application and BI, but it would be a grave mistake to ignore the reporting and analysis from data shadow systems.

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 to our Newsletters

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