Business Intelligence and Power View: a Subtle Change or an Inflection Point?

Can organisations be brave enough use their data to get along the ‘inflection point’? If so, how can they do it? Can Power View help?

Andrew Grove wrote a book Only the Paranoid Survive, which discusses how Intel survived change after change in the computing industry. Grove had a very interesting idea: businesses are affected by six forces, both internal and external:

– existing competition
– complementary businesses
– customers
– potential customers
– possibility of alternative ways of achieving the same end
– suppliers
Grove proposed that, if these forces stayed equivalent, that the company will steer a steady course.
However, what happens if any of the forces increase or decrease in terms of their pressure? Can this change turn into an inflection point? An inflection point is illustrated below, courtesy of Wolfram Mathworld.  

In other words, the inflection point is where the curvature of a line goes from negative to positive.

Translated into business terms, this can be considered as part of a maturity process, whereby the immature company goes through a turbulent ‘adolescence’, to reach maturity.

If you’ve been part of this process, you’ll recognise the signs. Team members who do not like change, for example, and are resistant to new ideas. Perhaps you see that your organisation is offering new products and services from the business perspective, but IT is simply not keeping up with the changes foisted on them. That’s when silly mistakes can happen; for example, server failure since ‘everybody’ was too busy trying to paste over the cracks but didn’t look at the fundamental issues because they were chasing their tails.
From a Business Intelligence perspective, I think it can be important to understand that Business Intelligence problems can actually be Change Management problems; they have to be understood as exposing less visible failures in the system. In other words, it isn’t the SSRS report that’s wrong; it’s the failure of the processes that produce the report in the first place, so it no longer answers the ‘business question’.
Essentially, the business has changed but isn’t served any longer, by the supporting players.
How does the enterprise get upwards and onwards? There are whole books written on this issue, but one way to look at it is to move people away from ‘gut feel’ towards data-based analysis. This can be extremely hard to do.  For some people, they will simply never listen to what the data is showing them. Perhaps they may even recognise that they aren’t producing the ‘supporting act’ data in the first place, to move the business forward.
One way to engage people in data is to give them access to it, and Power View in Excel 2013 is an accessible way of doing just that. There is a lot of value in letting people ‘see’ the answers for themselves. There is danger too; they will soon see the ‘failures’ in the data – where it is poor, wrong, or just plain missing.
It’s an adventure with data. It’s up to the organisations themselves to see if can be brave enough use their data to get along the ‘inflection point’. It might just be a subtle change for them; or it could open up the opportunity to allow people to see their data. 
Power View is more than just pretty pictures because it can really mean engagement with the data, and encourage exploration to an Excel-oriented audience who didn’t have the opportunity to visualise and play with their data in this way before.
Don’t be fooled because it is in Excel – it can help your business users to ask new questions of their data. It’s a change of thinking about data, putting it into the hands of business users who can change the organisation. Perhaps they will help organisations to move along the ‘inflection point’ towards maturity.
That’s the real power of Power View.

Visualising the Tabular Model in Power View

Here are my slides from my recent presentation at SQLServerDays in Belgium. I love this conference; the team do a great job of organising it, and they always make me feel genuinely welcome. If you get the chance to go along, I recommend you take the experience!

Here are my slides for you to view.


IP address query selection for High Availability Listener

One of my customers contacted me; they had set up High Availability but had a concern. They couldn’t ping all of the IP addresses associated with each of their listeners.

I gave it a go, and sure enough, I could see one of the IP addresses, but not the ‘sleeping’ one, which was on a different subnet. The listener had two IP addresses, one for each subnet.
Then it suddenly made sense that this is ‘by design’. The IP addresses are not online at the same time, since the server can’t host an IP address that’s not in its subnet, so you can only have one ‘up’ at a time.
When the cluster group is owned by one of the nodes, one IP address is up. The other is down, sleeping but ‘healthy’.  When the cluster group is owned by the other node, the original ‘sleeping’ IP Address is up, and the original IP address is down.
This was easy enough to show. I induced failover, and then bringing it back up again. It is possible to see the swapover of the IP addresses, and the original ‘awake’ IP address going offline whilst the other comes up. 
It is still there; just not accessible since the server can’t host an IP address which is not part of its subnet.

Freakonomics author Steven Levitt is presenting Keynote at PASS Business Analytics Conference

Fantastic news about the PASS BA Conference!

Award-winning economist and author Dr. Steven D. Levitt – co-author of the best-selling book Freakonomics and its sequel SuperFreakonomics – will keynote at the inaugural PASS Business Analytics Conference in Chicago, April 10-12.

Dr. Levitt will take the stage on Day 2 to share his passion for data and the stories it tells. If you’d like a flavour of his discussion, please take a look at on of his TED talks, which I’ve taken from the TED site for you to view, so please see below:
What is the  2-day PASS BA Conference? It is a conference, featuring 60+ sessions across 5 topic tracks – will bring together 1,200 business analysts, data scientists, architects, and business analytics/business intelligence practitioners to connect, share, and learn.  I’m hugely proud that I’m speaking.

If you’d like a flavour of it, please join us for our 24 hours of PASS webinars. Held on 30th January, these webinars are not repeats or previews of the PASS BA sessions, but will give you an idea of the speakers and the broad brushstrokes of the Business Analysis oriented content.

I was massively excited about speaking at the PASS BA Conference, and this is just fantastic news – icing on the cake!

You can learn more about the PASS BA Conference at

See you there!