Why Power BI?
Power BI Solutions
Power BI and SQL Server Enterprise
Why Power BI?
I have highlighted the key reasons with a green background why Power BI will and is beginning to cause a data revolution particularly within the public sector which is delivering new insights with low cost and easy adoption.
Power BI is a cloud based analytics solution
. The cloud offers greater extensibility whilst reducing cost of infrastructure and licenses.
Power BI should not be looked at in isolation especially when comparing with other products. Rather Power BI should be used in synergy with
. Since all these product are very well integrated.
monthly new feature releases
leading to rapid feature enhancements over the course of a year.
resulting in rapid adoption. There is a highly functional free version. The professional version costs around $10USD per month.
Create very incisive
with little effort and technical knowledge via drag and drop.
The Power BI calculation language
DAX is designed to have a similar syntax to Excel
. This creates much greater synergy between the business intelligence developer, the business analyst and the information requester.
Power Query delivers powerful
with no code. Powerful data transformations such as pivot / unpivot / merge join can be achieved without writing any code.
Power BI can easily be scaled out to the enterprise
Analysis Services tabular
model OLAP solution, since Power BI and Analysis Services tabular model share the same OLAP engine and DAX language.
Extend Power BI using
Develop your own Custom Visualisations
Full integration with
Sharing is Easy
Bar Chart Drill Downs
Zoom into Reports from Dashboards
existing Content Packs
Build your own Content Packs
free high quality training material available
Power BI delivers self service reporting which frees up the Business Intelligence Team to focus on resolving data quality issues and reconciling reference data instead of developing reports. The tools SQL Server
Master Data Services
and SQL Server
Data Quality Services
have existed for at least several years.
Natural Query Language
In Memory technology means that data stored in Power BI can compress data often by a factor of 8 or 10
. This compression also increases the performance of queries.
Publish to Smart Phones
Wide range of
Microsoft has dedicated resources to action the
given by Power BI users.
Power BI supports integration with
. You can also use the publish to web feature to embed Power BI into any other
web based application
. Here is a Power BI collaboration
SharePoint add in
Copyright 2019 by Innovative Business Intelligence Ltd
DNN - .NET Open Source CMS