What differentiates power BI from other tools?

PowerBI has a unique foothold among the other BI tools operating in it’s space.  Leveraging the dominance of the office suite of tools, power BI is literally standing on the shoulders of a giant.

Consider the gartner magic quadrant for business intelligence and analytics.  Other contenders such as IBM, TIBCO and SAP notably have platforms backing them up as well, but there’s a crucial differentiation there.  Those platforms are ERP’s, which are functionality more prescriptive than what office is.

Tableau and Qlik are vigorously competing with powerBI, but they don’t have the same platform to leverage.  HBR has an interesting take on the platform business model.  They identify the three goals platforms achieve;

    1. The toolbox – infrastructure to provide interactions between participants.
    2. The magnet – ability to pull in producers and consumers of the service.
    3. The matchmaker – facilitating good matches between producers and consumers.

Office 365, sharepoint, and powerBI provide the toolbox.  Both powerBI and sharepoint have developer marketplaces, in other words the magnet.  Integrated sharing of data between all of these platforms represent the matchmaker.  Incidentally, that’s what Microsofts aquisition of Yammer was all about.

As it becomes clear that Microsoft is moving to a software as a service model,  the way we deliver BI products and insights will change slightly.  Just as waterfall was eaten by agile development, and as Inmon was eaten by Kimball approaches, classic data warehousing will be eaten by something else.

Kimball believes that the field will not go away.  There’s an interesting prediction where he points out that traditional DW structures will continue to exist and grow, while non-structured data forms will extend those structures.  Fundamentally, the whole point of the data warehouse is precomputation.  That methodology will likely not go away, but will be challenged by methodologies that allow for faster execution by better matchmaking of data.

The data mart/warehouse space has traditionally been a poorly executed space, likely due to the nature of it’s inflexibility.  It typically suffers a long development execution time, as the data mart or warehouse have to follow the traditional software development cycle.  That makes it hard to garner trust in the business, and build trust in the data.  Information is timely, the longer it takes to get it, the less valuable it becomes.  Software development is not data science.

The sharepoint, office, and powerBI stack all exist with every connector you can imagine.  You can share data between objects in the platform, or leverage the multitude of connectors to pull in Oracle, HANA, ODATA, JSON, linkedin or from the web itself.  That means you can extend your traditional data warehouse with just about anything you want.

PowerBI offers a semantic model, which is really not new.  What is new, is the ability to build that semantic model from just about anything.  Powerquery can offer some simple transformations while pulling that data into the model.  More complex calculations can be done in DAX to create calculated measures and columns.  Microsoft has effectively taken the SSAS tabular engine, and built it into powerBI.  When developing locally, that instance runs natively in the power BI desktop application.  Effectively, powerBI in the cloud is the same data engine, which Microsoft is a free service provided with powerBI.  This is the same idea as SQL Server in the cloud.  The speed of the application (hardware and software) has just been commoditized.

This is where Microsoft will eat away at the traditional DW methodologies.  Rapid prototyping can occur within the model, where it can be leveraged in the cloud where computational power is very cheap.  In other words, these rapid prototypes can be used to immediately deliver and answer questions.  If the information sticks and is useful, the underlying model can be refactored without disrupting the behaviour you’re trying to orchestrate.  The power of the cloud enables that rapid prototyping to occur with larger and dirtier data structures.  In other words, there will be less need for pre-computation.

It’s not the speed at which you can process that determines success, but rather the speed at which your data scientists/developers/BA’s can iterate.


Far better an approximate answer to the right question, which is often vague, than the exact answer to the wrong question, which can always be made precise. -John Tukey
The plural of anecdote is not data. - John Myles White

Recent Posts

RSS PowerBI blog

  • Optimize your Processes and Gain Deep Insights with Process Mining  January 25, 2022
    Process mining, provides direct data insights across an organization’s daily business processes, helping identify inefficiencies to improve how they work. Now with the preview of process mining in process advisor, leveraging Power BI Embedded , you can use your business data to produce analytics and detailed process maps, gleaning new insights into ways to optimize your business processes.
  • Power BI Report Server January 2022 Feature Summary January 24, 2022
    We’re excited to bring you a new version of Power BI Report Server this Winter! With the January 2022 update, we have a variety of new enhancements, including page and bookmarks navigators, new sorting options for legend, new formatting options for text, pie and donut chart rotations and many more.
  • Deployment pipelines- Azure DevOps extension, multiple pipelines working together, Dataflows GA January 19, 2022
    This month we have released highly-anticipated features for deployment pipelines: Azure DevOps extension, to automate your deployments and pipeline creation using Tasks in your Azure pipeline. Multiple pipelines working together, to sync the connections between items managed in different pipelines. Dataflows GA and support for linked entities