Data warehousing (DW) and business intelligence (BI) have been evolving and getting more sophisticated over the years. As IT folks, consultants and analysts gain more experience, they often share those experiences when they work at other companies, publish articles or conduct training. By sharing their knowledge, they have helped to improve the overall intelligence of our industry. This has led to the creation of conventional wisdom about how to design, build and deploy DW and BI solutions. This wisdom is a great guide, especially for people who are just getting involved in implementations and don’t yet understand what they need to do.
But there is a dark side to conventional wisdom when people treat it like gospel. Too often, people blindly follow the usual advice without making sure that it actually applies to their particular situation. Sometimes you should challenge conventional wisdom.
Our industry is still in a stage of active and sometimes turbulent evolution. It’s not always wise to put too much faith in conventional wisdom, especially when the industry is evolving and expanding in ways that could help deliver much more robust performance management, BI and DW solutions.
Conventional wisdom says that DW is independent of applications. Wrong! This is most apparent in financial applications, in particular budgeting, forecasting and planning. Business users need the flexibility to perform a number of iterations on a set of numbers before agreeing to a budget, forecast or plan. They also need to be able to examine historical data to make their projections. But enterprise applications don’t have the capability to do this. And data warehouses can’t meet this need because they aren’t supposed to support applications. So, business users resort to using spreadsheets, which waste their time and productivity. The use of spreadsheets has led to errors and made it impossible to document how the numbers were derived. With the current business and regulatory climate, this is not acceptable for most CFOs.A very effective approach has been to build these financial systems with an application closely linked to the DW. The DW becomes both the system of distribution sending the data to whatever business process or user that needs it as well as the system of record where the “official” budget, forecast or plan is stored.Data flows from source systems to data warehouses, then to data marts and cubes and is finally consumed by BI applications. Every architectural diagram shows this one-way flow. The sources for the DW environment have expanded from back-office to include customer-facing applications, external data exchanged from suppliers and partners and many formerly workgroup or desktop applications. The data flow is from across the enterprise and sometimes beyond. The DW environment has now become the information hub that distributes data from and to many applications and data stores. DW is now the system of distribution to any business process, application or person who needs this information.
A new emerging “truth” is that you need to use standalone master data management (MDM) or customer data integration (CDI) because your data warehouse can’t provide that capability.Of course you want a new shiny application that will solve all your reference data problems for either MDM or CDI. But the hard truth is that the biggest reason why attempts at getting consistent reference data don’t succeed is people.Sometimes it’s because businesspeople have not agreed on consistent definitions for the reference data. Or you can blame IT for not taking the time to get those definitions from the businesspeople. Either way, the gap is people-driven, not technology-driven.Too often, the MDM or CDI solution gets bogged down in the same people-related issues again and again. Rather than investing in a new standalone MDM or CDI solution, why not invest in getting all the people cooperating and on board? Then build out the solution in the DW. After all, the DW was built with the idea of creating consistent data to start with; why not leverage what you have rather than build or buy from scratch with an MDM or CDI solution?Another new “truth” is that you have to buy corporate performance management (CPM) software to implement a CPM solution. When you look at what you are buying, it is DW and BI software bundled with applications. It may make sense to buy the CPM application, but make sure it’s an extension of your DW environment, not a new data warehouse. Whatever else you do, you don’t want to build any new data silos!Whether you’re faced with conventional wisdom or new truths, don’t be afraid to challenge them. You may find that the advice is totally broken. Or, you may be able to alter it and spawn new ideas that match your own business or technical conditions.