How is what we are building helping you make better decisions?

This is a followup to a good article by Timo Elliott on making information understandable. It underlines a good point – good information is useless unless it is presented in a way the users can understand. I always try and build any reports with the philosophy; “How do I make it so the most number illiterate recipient can grasp what this report is showing?” – working for a bunch of Lawyers in one job really honed this mode of thinking!

Why Bus Timetables are a great example of BI

For a comparable transport analogy (and general moan), Sydney has terrible bus information. At most stops is a sheet of A4 (if you’re lucky) with bus numbers and times in order of time. No maps. No explanation of what bus number goes where. Unless you know in advance which bus you need, this data is useless. It’s not a surprise I never bother getting the bus – I can’t hop on one because I have no idea when a useful one is coming, and if one does come, whether its route is good for me. Compared to London with its simple route maps and timetables ordered by route and time, I hopped on the bus regularly, because if I passed a bus stop in a strange part of town I could rapidly figure out if it was a good option.

What question makes the difference between a Report and Information?

A common failure point for BI is that too much emphasis has been put on the tools, and getting data in shape – so you have a fantasic warehouse and toolset to read it – but users who aren’t “educated” enough to use it, because there seems to be the mindset among developers that BI systems are just that – systems. Training is usually functional – “how to access Report B, how to rerun the Data” – not practical – “How does Report B give me the ability to make better decisions”? There is a gap in expectations – the developers assume management know what they are asking for. Managers assume what they get will get the answers from the reports. No-one in the equation is brave enough to pipe up and ask: “Do you know what you really want? Because I don’t think this will help.”

A good consultant should continually be asking this question of their clients – “How is what we are building helping you make better decisions?

6 thoughts on “How is what we are building helping you make better decisions?

  1. Hi monkey
    I think you are doing (blog) a grat job but it lacks some thing (not intresting). I know you are SSIS specialist but as a Microsoft BI professional you need to focus other stuff like Reporting, Analysis cubes and Business Performance Management (Dashboards) etc. thanks.

  2. Hi James,
    I found this website when i was searching for SSIS Resource.I am new to SSIS and have worked on SSRS and little bit of SSAS.Can you guide me where i can learn from scratch on SSIS.Looking for your reply.


  3. Thanks Rockey – I do try to cover different areas (see my recent posts on Data Mining) – obviously I can only cover what I come up against in my day job – as an ETL monkey obviously I face SSIS the most!

  4. I agree absolutely that a major weakness of the mass BI deployment of the last 10 – 15 years is the lack of user sophistication. I spent some time working for one of the larger BI tool vendors, who sold truckloads of the stuff. As a post-sales consultant, my job was to help install and configure the software, and educate BI users as to its use (in formal classes). Given this experience, my question is:

    When a BI analyst runs into the room, shouting “Two out of three of our customers also use Brand X!”, what does that really mean? 67% of thousands? …or literally 2 out of 3?

    I seriously question what fraction of people using these tools are well equipped to understand their output.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>