Ambysoft logo

2013 Data Warehouse(DW)/Business Intelligence(BI) Survey Results

Follow @scottwambler on Twitter!

How to Measure Anything This survey was performed during December 2013 and January 2014 until under the title .Data Warehousing/Business Intelligence 2013 Survey. and there was 10 respondents. The survey was announced on the Ambysoft announcements list, my Twitter feed, and several LinkedIn discussion forums (Disciplined Agile Delivery, Considerate Enterprise Architecture Group, TDWI, and Agile Data Warehousing).

The Survey Results

Some findings include:

Figure 1. Perceived success rates for DW/BI Teams.

DW/BI Project Success Rates

Figure 2. Effectiveness of DW/BI Teams.

Success factors

Figure 3. Challenges faced by DW/BI Teams.

Challenges faced


Survey questions

The Survey Questions

Survey Data File

Raw Data

Survey Presentation

Summary Presentation

What You May Do With This Information

You may use this data as you see fit, but may not sell it in whole or in part. You may publish summaries of the findings, but if you do so you must reference the survey accordingly (include the name and the URL to this page). Feel free to contact me with questions. Better yet, if you publish, please let me know so I can link to your work.

Discussion of the Results

  1. I'm disappointed in the response rate that I got. The survey was short, so that should not have been a problem (the longer the survey, the lower the response rate in general).
  2. My original goal was to compare the effectiveness of agile, iterative, lean, and traditional approaches to DW/BI projects. Unfortunately very few traditionalists responded to the survey, which is unfortunate because I suspect the majority of DW/BI projects are done in a traditional manner, and a large percentage of those who did respond dropped out when they got to the page that explored the effectiveness of the team.
  3. Although not statistically valid, the data was leaning towards agile teams being significantly more effective than traditional teams. Perhaps another researcher will be willing to put the time in to gather sufficient data to explore this question at some point in the future.
  4. This survey suffers from the fundamental challenges faced by all surveys.

Links to Other Articles/Surveys

  1. My other surveys

Why Share This Much Information?

I'm sharing the results, and in particular the source data, of my surveys for several reasons:

  1. Other people can do a much better job of analysis than I can. If they publish online, I am more than happy to include links to their articles/papers.
  2. Once I've published my column summarizing the data in DDJ, I really don't have any reason not to share the information.
  3. Too many traditionalists out there like to use the "where's the proof" question as an excuse not to adopt agile techniques. By providing some evidence that a wide range of organizations seem to be adopting these techniques maybe we can get them to rethink things a bit.
  4. I think that it's a good thing to do and I invite others to do the same.