Resources

  • Click for the BI/DW Index Click for the On-Demand or SaaS index

« Nerds Rock! | Main | Prepare for the Big-Data Labor Shortfall »

TrackBack

TrackBack URL for this entry:
http://www.typepad.com/services/trackback/6a00d8345444f069e20162ffbe8247970d

Listed below are links to weblogs that reference BI’s Dirty Secrets – Why Business People are Addicted to Spreadsheets:

Comments

Feed You can follow this conversation by subscribing to the comment feed for this post.

Jagan Gudur

Business intelligence / decision support initiatives that focus solely on the presentation of data are doomed to fail, at least over the long run. The emphasis should be as much and, preferably, more on quality data and business rules to interpret the data. This is hard work and often requires a cross-functional approach to correctly understand the data and draw the right conclusions. A flexible, feature-rich BI reporting tool can see successful adoption, but only after the quality of data and business rules guiding data interpretation have been sufficiently addressed.

chet

One of my favorite sites is this one: http://www.eusprig.org/stories.htm

I hear and agree with what you are saying though. How do we, as IT, get them on board (without scare tactics)?

We are a bottleneck...how do we better empower the people that pay our bills?

chet

Gil Pizano

Very good article here. I really enjoyed some of the interesting notes such as "they need a compelling return on investment before learning a new tool" because it helps to point out a real concern that I have when it comes to the mindset of some BI people out there. Being able to speak in terms of ROI is a must for any BI professional in order to be successful. We can't forget the main purpose of BI. To help business decision makers make better business decisions. It's with truthful data that people are (supposed to be) able to make better decisions. It can be the CEO all the way down to the entry level analyst.

This said, another area that the article mentions is the original method of an IT department creating a report or a dashboard for people to use.

Why not help the end-user create their own reports, their own dashboards where IT would be there to support and enable the end users of BI. The end-user will often be the ones who understand their data best. Probably better than anyone else in the company simply because it's data that they are consistently working with. Allowing them direct ability to be able to perform their own BI related inquiry will go a long way in providing satisfaction to the end-user. If they have any quarrels with performing such a task on their own, then I utilize the Steve Jobs school of thought for innovations and the end user. "Asking the end user for what they want is usually a waste of time because they may not understand exactly what they want. Instead, show them what they can have and the value that it will bring them (value in the eyes of the end user, not the IT person) and let them have a need for what they can have."

Thanks again for such a good thought provoking article.

Bill Cabiro

I Fully agree. With well over 500 million users around the globe, it’s no wonder that spreadsheets are the de-facto Business Intelligence/ Analytics application.

Many companies have no choice but to use spreadsheets because their BI solution does not provide the strategic answers Marketing, Sales and Management need to grow the business. These companies typically populate their BI with internal raw data from the ERP. This is only half of the story. People in strategic areas need other original sources of data not found in the transaction system.

They need to access external market intelligence to compare it with company performance metrics. This can be market and customer segmentation, updated customer and competitor merger and acquisition status, competitive opportunities, business and products under threat, market size, etc. Unfortunately, this information usually only resides in market intelligence spreadsheets developed by Marketing, Sales or Finance. full article http://bit.ly/Aknk7z

Regards, Bill

The comments to this entry are closed.