Selecting the right Self-Service BI Tool

Self service BI is getting lot of attention, and there are lot of tools out there in the market from multiple vendors. Some with real great visualization and leveraging the new in-memory processing models. Remember that when it comes to Self-service BI you want to make it as easy as possible for the people in your organization to explore and mine the data. They shouldn’t have to spend a lot of time learning new tools, new syntax, new ways to load data, instead work with familiar tools they are already aware of. This is where the strengths of Excel 2010 and the PowerPivot add-in (free) are, you can use the already great knowledge base of Excel within your organization and provide them with a faster and easier way to deal with large amounts of data from multiple sources.


I would recommend taking a look at the below case study from The Weather Channel who had gone down the route of selecting QlikView and back tracked that implementation and now have implemented PowerPivot.

Initially, The Weather Channel planned to implement QlikView as a BI tool. However, after experiencing scalability issues, the company decided to switch to a solution based on Microsoft BI tools including Power View, a new BI tool in Microsoft SQL Server 2012 Reporting Services. “We wanted to bring in data from multiple sources and add features that were either not possible or not easy to implement with QlikView,” says Drooker. “Another benefit of the Microsoft BI solution is that training is minimal. Why add complexity and increase costs with a third-party solution when we can use SQL Server 2012 and Power View to simplify integration with our existing technologies?”

Remember that for your self service BI solution to be truly self service you want to make it as easy as possible for the people in your organization that work with the data and derive insight.

Comments (4)

  1. You can access Power Pivot solutions published to SharePoint on your iPads. For a great session on Mobile BI using Microsoft stack see –…/DBI327

  2. Eoin_BI says:

    But can they use Power View on their iPads?

  3. WQ says: Sure, the process of flinging a spinnerbait may catch a rogue fish off of nothing here and there, but I’ve found that during the course of the average true cover-seeking day, your only looking for a few extra bites from “between” bass. I’d rather be locked and loaded for the gentle pitch, then carelessly unleashing the firing– squad. What I mean is that in most cases I’d rather be putting along “between” at a moderate pace with the same jig in my hand that I had success with on
    http://www.burberry– the docks all day, and looking for that unique cast/pitch to something

  4. aw says:

    I think your article is very useful, it might be in more detail further suggest the method clearer method, can be of several categories that you created or any of several methods that should be done in the process of it, thank you very much