Edit: Sep 2019
I wrote this article to be a definitive list of the top reasons you should consider using Power BI in your organisation (in case you haven’t already made the decision to do so). In fact there is only one thing that worries me about this list, and that is I think many people may be sceptical and think “this is too good to be true”. But I faithfully and honestly believe every bit of the story is true. In the future I think there will be those that moved early and quickly to adopt the new approach and are leading from the front, and there will be those that couldn’t, shouldn’t, wouldn’t, and got left behind in the dust. But to be fair, one of the biggest issues a company can face is when it has large financial investments in legacy BI solution. If that is you then the good news is that you don’t have to dump what you have to get started with Power BI as a self service BI tool. And if Power BI is a raging success as a self service tool then you have effectively hedged your bets by starting small and then (hopefully) scaling quickly when the business case supports it.
Strap yourself in – here are my top 30 reasons you and your company should be considering Power BI as a self service and/or enterprise BI solution.
1. It’s Microsoft (the new Microsoft)
No one can deny the strength of Microsoft in the corporate world of business software and IT solutions.
Microsoft hasn’t always been great at listening to specific customer concerns, but it has always been great at building and delivering world class robust commercial software. Power BI is part of that heritage but better, for all the reasons I cover in this article.
When I say “the new Microsoft”, I am talking about Microsoft under the leadership of Satya Nadella, and when it comes to Business Intelligence I am talking about the changes brought about under the leadership of James Phillips.
Satya Nadella James Phillips
You can read more about Sayta Nadella’s success at Microsoft here. And here is an article that James Phillips (and Sayta) talk about what they are doing with BI at Microsoft. https://gigaom.com/2015/01/27/microsoft-throws-down-the-gauntlet-in-business-intelligence/
Both of these first class leaders have brought change to Microsoft like you have never seen before. Who would have thought that SQL Server would ever run on Linux – well it does now. Who would have thought that Microsoft would ask its customers what was important and then prioritise these things for the new tools? Well it does now. Do not under estimate the importance of a power house like Microsoft as the owner and developer of Power BI. Microsoft has deep pockets and it knows how to win with business. I personally wouldn’t want to be competing in this space against Microsoft in the next 10+ years.
2. Power BI is built from the ground up on SSAS heritage
Power BI is a green field product but it has an enormous heritage. Microsoft has been one of the most successful companies out there in the BI space leading with SQL Server Analysis Services Multi Dimensional and to a lesser extent with Microsoft Excel.
When it came time to leverage the new Column Store database technologies to build Power BI, Microsoft called on its crack expert SSAS team to build the DAX engine (Vertipaq) for Power BI from scratch leveraging the skills, knowledge and experience of a pedigree race horse. It is unlikely that a stand alone company could start from scratch like Microsoft has and hit a home run first batter up.
3. Power BI is built from the ground up on SSIS heritage
Just as Vertipaq has been built from scratch using new technologies but with a pedigree, Power Query (the self service ETL tool – Extract, Transform and Load) has also been built from scratch. But once again Microsoft has wheeled in its crack SQL Server Integration Services (SSIS) team that has a long and successful heritage of successful ETL software development. Do not under estimate the benefits of getting this part of the puzzle right the first time, and Microsoft has already proven it is winning in this space.
4. Power BI will ingest data from virtually any source
Most of the major data providers are already built and deployed in production. There is also a “catch-all” ODBC database connector and there are new (less main stream) connectors being developed all the time. In addition there are many cloud based connectors that allow users to easily connect to cloud content like Google Analytics, SalesForce.com, and lots more online software service providers.
5. Power BI is highly compressed and performant
Vertipaq (the data modelling engine in Power BI and Excel) is a highly compressed and performant columnar database. It uses modern tabular database technologies (built from scratch) to create a highly compressed database that loads fully into memory for rapid performance. It is not unusual for a database to compress between 600% –1200%, meaning a 1GB database will compress down to an operating size of between 85MB – 170MB. The performance impact of this compression is amazing and it needs to be experienced to be believed.
6. Power BI has a brand new visualisation engine
There is no baggage to take along for the ride here – no sign of Silverlight for example. Microsoft has built a brand new HTML 5 compliant visualisation engine that is simply awesome. Everything (virtually everything) will slice and dice and cross filter everything else (as shown below).
If you can see a map of your country showing sales by region, then click on the region to see the underlying details. If you can see a bar chart that show performance by year, then drill down on the bar chart to see the monthly, weekly or daily breakdown. Everything is intuitive and simply works.
Gone are the days when you needed a specialised IT report writer to create every new report for the business. Anyone that can create a chart in Excel can create a chart in Power BI (and probably some people that can’t create a chart in Excel too for that matter). Unfortunately for professional report writers, I simply don’t see this role existing in the future as it will be the business users that build what they need.
7. Power BI also has open source visualisations
Microsoft has realised early on (under that strong leadership mentioned earlier) that it can’t solve world peace on its own. Microsoft has be focused with its efforts so rather than try to solve every visualisation problem for every company around the world, it decided to share its visualisation source code so that any capable developer can develop their own visualisations and share them with the community.
Developers can either copy an existing visual and extend it, or they can start from scratch and build something completely new. It is amazing the quality of what has been delivered already and the party hasn’t even started yet. You can see all the current custom visualisations here.
8. Power BI is built for users familiar with Excel, but it’s not Excel
This is self service BI at its best. Who else can design the UI for the business user community better than the company that built and owns Excel? So while it is relatively easy for Excel users to get started, it is not Excel. Microsoft has brought the rigour and structure from SQL Server Analysis Services into this product to ensure that it is a Self Service BI Tool with Enterprise strength features, including row level security, active directory integration etc while it is still familiar enough to Excel users that they can and will embrace it. I can hear a few companies cringing at this point as they think about the BI shelfware they have spent literally million$ on and is not being used.
9. Power BI is in the cloud…
Like it or not, the world is moving to the cloud. This product was built from the ground up with the view of sharing via the cloud. It uses all the modern HTML5 coding techniques to ensure compatibility with browsers across any platform. It has industrial strength security wrapped around the cloud presence and it is definitely secure – Microsoft’s reputation is on the line here. I realise it won’t work for every company, but frankly it will work for most. Of course do your due diligence, but then get on board.
10. Unless it’s not in the cloud
Not every company is ready to move to the cloud for whatever reason. Microsoft has released an on premise version of Power BI called Power BI Report Server meaning companies can keep there data on premise if needed. In addition, the desktop version of the software is free for everyone and is at least as good (if not better) than Excel for BI analytics. You can build and share pbix files just like you can share xlsx files to any other user that has the desktop application. And it is possible to install 64 Bit Desktop even if you are locked into 32 bit Office. Read about that here
11. Power BI has mobile apps
One of the benefits of starting from scratch is you have no legacy to carry around. Microsoft has built mobile apps for Apple and Android (and Windows mobile of course).
Under the leadership of Satya Nadella Microsoft supports every platform and it no longer uses its brand strength in one product to try to force participation in another. The iPhone and iPad apps are simply great – did I mention they are free? You can read more about mobile apps here.
12. You can subscribe via eMail – but please don’t!
I know, I know – some of you just want your static report to appear in your email inbox every morning. OK, Power BI can do that. You just go to the report tab you want to see, click “subscribe via email” and a nicely formatted PDF that is ideal for printing will be there in your inbox when you get to work. But please please think about using the mobile apps instead. These are sooo much better and have full interactivity. All you have to do is remember to open the app in the morning. At worst, subscribe to a report via email and when you see it in your inbox, simply open the app instead :-).
13. Power BI can be embedded into your own custom apps
Another benefit of building from the ground up is you can think about all sorts of issues when you design the architecture. Microsoft has always planned to allow Power BI to be embedded into custom apps. So if you want to build your own website and control user access via your own logon credentials, then that is fine with Microsoft. Just embed Power BI into your application and away you go. Same goes for mobile apps or anything else you can think of for that matter. There is a dedicated licensing agreement specifically built for Power BI embedded that makes the product financially compelling.
14. Power BI is very cheap to buy
Free to try and indeed free to use as long as you want. If you want to take advantage of more of the enterprise features including controlled sharing of data, automatic refreshes using gateways etc. then you have to pay – wait for it – a whole US$9.99 per month per user. It is enough to make the competition shiver in their boots!
Power BI Desktop is free to use on the desktop for ever, and free for any user in the cloud as long as they are not using the features mentioned above. And frankly the professional features are hugely value adding so you really can see the benefits when you start to pass a small pile of pennies over to Microsoft. And it is at least as good (if not better) than Excel is in the BI space already – and it is less than 2 years old as a product. Do you think it will get better in the next 2 years? You bet your life (or better still your position as a corporate decision maker) it will!
15. Power BI is easy to use (and hence cheap to train users)
Anyone that can click on a button can interact with a Power BI report. It is intuitive and easy to learn for anyone that wants to consume the content interactively. The training costs of this product are low making the total cost of ownership very compelling. And that is before the product even gets used and helps users make decisions to drive business results.
16. Power BI has a modelling engine that power users can learn
In addition Power BI is enabling self service BI to a new wave of “developers” from the business community with the Vertipaq engine. No longer is this the sole domain of an MDX programmer to develop a cube that can be used. There will still be a need for IT cube developers in many companies and of course they can now develop in Power BI, however competent Excel users can also now do the work too. Power BI has a language called DAX (Data Analysis eXpressions). This is a functional language that can be learnt by Excel professionals hence it doesn’t have to be the IT pros that do all the work now. And as a bonus, the DAX language in Power BI is also available in Power Pivot for Excel, so Excel users get to learn a new super language that they can leverage in multiple places.
17. Power BI has data loading tools that power users can learn
Power Query is so easy to use it is embarrassing to those skilled in SSIS. I am not saying that we don’t need SSIS developers any more as there will always be a need for this technology for large scale enterprise BI projects. But this is no longer the only robust Microsoft technology that is out there, and any capable Excel professional can learn and use Power Query. Power Query has a user driven interface that generates code (in the M language) to transform the data. The process steps are saved as a process and can be re-run over new data at any time. As a bonus, Power Query is also identical in Excel so you get to learn another language once that can be used in multiple places. Did I mention that Power Query is so much more than just a self service ETL tool. If you use Excel and you don’t use Power Query, you are missing out on something special.
18. Power BI is self service BI…
For the 2 reasons above (Vertipaq engine and Power Query), Power BI is self service BI personified. It is everything you want self service BI to be and more. Any competent Excel user can learn and use these tools and hence they can become semi self sufficient in their analytics and reporting needs very quickly.
19. Except when its not self service BI
But just because Power BI is a very capable self service BI tool, that doesn’t mean that it can’t be an enterprise strength BI tool too – in fact it can be both at the same time. Power BI has the foundation of an enterprise strength tool and a self service capable tool all at once. And don’t underestimate the value in having ad hoc analysis and enterprise analysis capability shared and using the same underlying technology – everyone benefits from this. And what’s more I am fully expecting that in the future users will be able to extend deployed standardised enterprise Power BI reporting by creating user specific measures that allow additional add hoc analysis on top of the core (not here yet, but I can imagine it will come).
20. Power BI has consolidation dashboards
Power BI is among other things a data source aggregator. It doesn’t matter where your data comes from or how/if it interacts with other data you care about. If it is data and you can report on it, you can include it in Power BI and pin your visualisations to a dashboard/cockpit where you can see everything you care about and nothing you don’t. And if you want more detail, then just click on the tile and drill down into the report.
21. Power BI gets better every day – literally!
The Power BI service is on a continuous release cycle. As improvements are made they are released into the cloud service. Microsoft also needs to build parallel improvements to the mobile apps and to Power BI Desktop. The release cycles for these products are monthly rather than daily, however the pace is still incredible. Quite literally, today’s biggest complaint can disappear when you wake up tomorrow morning. You can read about all the latest updates from the official MS Power BI Blog.
22. Power BI has a massive user community
Power BI is less than 2 years old at this writing, however there are 10’s of thousands of users in the community that ask questions and help out other like-minded people. There are showcases demonstrating how people are already exploiting Power BI, and there are more than 100 user groups in the major cities around the world. Specifically with the user forum is not uncommon for people to get answers to their questions in minutes (if not a few hours) and the content of their questions remain on the web for others to learn from.
And of course there are all the other community forums like http://powerpivotforum.com.au that provide help and solutions to users as well.
23. The Power BI user community decides what’s important
Did I mention Microsoft has changed? Instead of building only what Microsoft thinks we need, it is asking the community what new features are most valued by the community. Anyone can sign up and create and/or vote for new ideas on how to improve the product.
Of course Microsoft also needs to build out the foundation of the technology, but I regularly see highly supported features make their way into the core product…sweet! You can add your own suggestions or vote for another here.
24. Power BI has a natural language query engine
This sounds like a gimmick but believe me it is super cool and it works. You can type natural language questions of a well designed Power BI data model like ‘what were my sales yesterday by state?” or “how are bike sales trending vs last year?” and Power BI will give you its best effort to present the answer to you as a table, chart or what ever makes sense.
If you don’t quite like the first response you can tweak the settings from the standard user interface. If you do like the report then pin it to your dashboard and see it updated every day forward. Believe me this is awesome. Oh and the mobile apps have just had an update that allows voice recognition Q&A, so you can literally ask your phone/tablet for some information and it will get the answer for you. Oh and it is integrated into Cortana on the desktop in Windows 10 too.
25. Power BI has quick insights for automatic analysis
There is a quick insights tool that will trawl through your Power BI reports (when you load them to PowerBI.com) and analyse the data for quick insights. When I used Quick Insights on the Adventure Works demo database it returned almost 50 interesting facts about the data in my report.
26. Power BI seamlessly integrates with Excel (no need for export)
The best BI industry joke I know is this (thanks Rob Collie).
Q: What are the 3 most common buttons in any BI solution?
A: OK, Cancel and Export to Excel
But it really isn’t a joke – it’s true. One of the biggest problems BI vendors have with their products is that the business users simply are not familiar with and don’t want to learn a new tool. You can argue all you want that the users should go to training and learn the new tool, but let me tell you – they don’t/won’t do it. So what happens when business users users are under pressure and need that data quickly? They go into the expensive BI tool, grab the data and click “Export to Excel” and then do the manipulation and analysis inside Excel instead – you better believe it is true.
Power BI has 2 killer advantages here over every other player. Firstly it doesn’t need to export to Excel, you just click “Analyze in Excel” and Power BI talks natively to Excel as if they were twins joined by an umbilical cord (this is literally true in fact). Secondly the look and feel within Power BI is so similar to Excel that many users will end up staying in Power BI rather than clicking Analyse in Excel anyway. Over time this we become more pervasive.
27. Power BI seamlessly integrates with PowerPoint
The truth is that most businesses rely on PowerPoint to tell stories and hence integration between Power BI and PowerPoint is highly desirable by many. OK, PowerPoint integration is pretty basic today (you can just export reports to slides), but it works and it will only get better. There is already a third party product that will allow you to embed Power BI reports directly inside PowerPoint and this will allow you to interact with the reports live during a presentation. And the early L&D experiments Microsoft (called PowerView) had a strong PowerPoint integration allowing in-PowerPoint-presentation interactively with live reports – it just worked. There is no doubt native live integration of Power BI reports into PowerPoint is coming soon.
28. Power BI has R Integration
R is one of the most used open source statistics software packages in the world today. Microsoft isn’t trying to compete with R. Instead it has decided to integrate R directly into Power BI so you can use your R insights and packages directly with Power BI. Read more about it here https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-r-visuals/
29. Power BI has Esri Integration
Another great third party integration is Esri. If you need more granular geo mapping and indeed if you need to (or already do) use Esri for routing and other geospatial work, then you can leverage your content, maps and data directly in Power BI. Read more about it here. http://www.esri.com/software/arcgis/arcgis-maps-for-power-bi
30 Gartner Loves Microsoft
Last and by no means least is that Gartner rates Microsoft highly for its completeness of vision and ability to deliver.
Let there be no mistake here. This rating is largely driven by the excellent work Microsoft is doing with Power BI.