Q
Problem solve Get help with specific problems with your technologies, process and projects.

Biggest business intelligence (BI) problem: overloading data

What’s the biggest BI problem companies keep running into? Overloading data at the expense of functionality, says an expert. Find out how to avoid this common BI problem.

You talk and blog a lot about BI best practices and how to adopt them. What’s a BI problem or worst practice you’ve...

seen consistently that doesn’t seem to go away?

Overloading data – hands down. I still can’t believe how much time companies spend on extract, transform and load (ETL) processes at the expense of deploying user functionality. After all, the data model is done – isn’t it time to populate tables? This is when we have the “we love you, but we have to kill you” conversation with our clients.

It’s so much easier just to load all of the data. Except for two problems. One, you’ll never load all of the data as long as new requirements keep cropping up. (And I hate to break the news, but if new requirements don’t keep cropping up, you’ve got bigger issues.) And two, your business users are thinking, “They’re still loading data? What about my scorecard/portal/dashboard/reports? They must not understand my business.”

Fair? Probably not. But perception is reality, and sometimes reality bites. Chunk up slices of functionality and load the data proportionally. Of course there’s going to be some rework! But the price of data loading in a vacuum is disaffected constituents. And that reality bites even harder.

 

This was last published in November 2010

Dig Deeper on Business intelligence best practices

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchAWS

SearchContentManagement

SearchCRM

SearchOracle

SearchSAP

SearchSQLServer

SearchSalesforce

Close