Over the past 10 years, the business intelligence (BI) community has been bombarded with an ever-increasing number of emerging vendors and products, touting new and better functionality than before with more buzzwords and acronyms than even your most savvy IT professional can keep up with. The world of reporting, database and extract, transform and load (ETL) tools as separate commodities is starting to fade as vendors are offering one-stop shopping for all your BI needs. In particular, many database and reporting tool vendors now provide ETL functionality as part of their BI suite, either through enhanced functionality or via acquisition of third-party software. However, even with the tremendous availability of software and functionalities on the market, there is still no shortcut to building a quality BI solution, even with the best tools available. In fact, the task often becomes more difficult as enterprise solutions are often built using best-of-breed technologies from different database, ETL and BI/reporting tool vendors. Developing a quality solution requires quality within and across all components of the BI architecture.

With the front-end focus of many BI projects (after all, this is what sells BI engagements and what the business users see at the end of the day), it is not surprising that organizations often lose sight of the workhorse of the BI effort - the back end of the production line where data is acquired, cleansed and transformed into useful information for  downstream consumption. This effort often accounts for at least 70 percent of the overall development effort of a typical BI project and, if not architected correctly, renders the presentation of data useless. Garbage in is garbage out, whether the data is coming from the source systems or an enterprise data warehouse.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access