Microsoft Power BI
What is Power BI?
Power BI is a visualization tool that helps you create stunning reports & dashboards. Companies need to make the right business decisions. Power BI can help you do that. In order to make decisions we need business data. These data can come from multiple data sources: Excel files, SQL Server database, CSV-files, … . Or maybe you are using unstructured data as images, or videos. Data can come from al types of places. The whole idee behind Power BI is that you can connect to that data no matter which datatype you are using.
- Power BI Desktop
You can download Power BI desktop for free. Just simply go to the Power BI website and start using Power BI. Have a look what power bi desktop can do for you in terms of working with data.
- Power BI Service
This is a cloud service in the Microsoft cloud offerings. The main focus of the service is to enable sharing and collaboration. You can share dashboards and reports either inside the organization or outside the organization.
- Power BI Mobile App
Analyze reports and dashboards by using your phone, tablet or other smart devices.
- Power BI Pro
This version allows you to access all content and capabilities in the Power BI service. This includes the ability to share & collaborate content with other Power BI Pro users. With the Power BI Pro license you can publish & consume content from workspaces, share dashboards and subscribe to dashboards and reports.
- Power BI Premium
This is an edition on the power bi pro offering. This version of Power BI is meant for large enterprises that enables you on larger data sets and also offers additional features inside the service. Power BI Premium users are able to publish reports, share dashboards and operate their Power BI services as an organization not as individual users.
- Power BI Embedded
This lets you embed dashboards and reports for users who don’t have an account for Power BI. Power BI Embedded is a Microsoft Azure service that lets independent software vendors and developers quickly embed visuals, reports and dashboards into an application.
- Power BI Report Server
The Power BI Report Server gives you access to interactive reports and reporting capabilities of SQL Server Reporting Services within the enterprise.
Power BI is one of the market-leading reporting and dashboarding tools. It is characterized by its easy-of-use, self-service-BI capabilities and attractive price-offering.
Contact us for more information on Power BI and on how to get started in your organization.
History of Power BI
Over the years, Microsoft released a couple of very powerful Excel add-ins in order to facilitate self-service BI in Excel:
- Power Pivot, an in-memory column based data modelling tool (which served as the starting point for Analysis Services Tabular and column-store indexes)
- Power Query, an easy-to-use and very powerful self-service data wrangling tool
- Power View, an intuitive and interactive dashboard tool
- Power Map, a tool to map data onto a 3D globe. At a later point custom maps were introduced as well.
They all started out as Excel add-ins, but over the years they have become integral part of Excel itself. In order to share your results, Microsoft introduced in 2014 Power BI for Office 365. Excel was considering the starting point of your self-service analysis, using the mentioned add-ins. Then you upload your workbook to Office 365, so that your colleagues can view your dashboards and reports in their browser.
However, Microsoft quickly changed strategy and replaced the Power BI for Office 365 environment with a separate cloud environment: the Power BI service.
Furthermore, Microsoft also introduced Power BI Desktop: a free stand-alone development environment where you can develop your queries, data model and interactive reports. Power BI Desktop is basically the combination of Power Query, Power Pivot and an updated version of Power View. There are however some capabilities that set Power BI Desktop apart from its Excel siblings:
- Custom visualizations. Theres a whole gallery of open-source visualizations for you to download and use in Power BI Desktop
- R integration. R is a powerful statistical language, popular by academics and data scientists. You can use it in your queries to mash-up data (or do even profiling, cleaning or predictions) or use it to create advanced data visualizations.
When the analysis is done in either Power BI Desktop or Excel, you can upload it to the Power BI service. There you can create interactive dashboards on top of your reports. You can share these with other people even outside your organization and build row-level security on top of it. The Power BI service also supports alerts where you get notified if the data goes over a threshold and it can also display parts of SSRS reports.
Example Power BI dashboard (left) and Power BI Report builder (right)
Everything published to the service is also available on the native Power BI app, which is available for Windows Phone, iOS and Android. This app can also display SSRS mobile reports as well.
The Power BI service offers the capability to connect directly to on premise data through a gateway. With this gateway its also possible to refresh the data uploaded to the cloud with either Excel or Power BI Desktop.
Another great feature are the content packs: pre-defined queries, data models and dashboards on top of several cloud providers. Its for example possible to create a fully functional dashboard on top of your Google Analytics data in just a few clicks.
What makes Power BI so powerful is that it comes at a really low cost, but also that it is updated very frequently: new features and capabilities are added each month.
Contact us for more information on Power BI.