Microsoft Power BI is a business intelligence platform that provides the nontechnical business users with tools for aggregating, analyzing, visualizing and sharing data. Power BI’s user interface is fairly intuitive for users familiar with the Excel and its deep integration with the other Microsoft products makes it a very versatile self-service tool that requires little upfront training.
A free version of Microsoft Power BI is intended for small to midsize businesses owners; a professional version called the Power BI Plus is available for a monthly subscription fee. Users can download an application for Windows 10, called Power BI Desktop, and native mobile apps for Windows, iOS and Android devices. There is also a Power BI Report Server for companies that must maintain their data and report the on-premises. That version of Power BI requires a special version of the desktop apps — aptly called the Power BI Desktop for Power BI Report Server.
Common uses of Power BI
Microsoft Power BI is used to find the insights within an organization’s data’s. Microsoft Power BI can help connect disparate data sets, transform and clean the data into a data model and create charts or graphs to provide the visuals of the data. All of this can be shared with the other Power BI users within the organization.
The data models created from Power BI can be used in several ways for the organizations, including telling stories through charts and data visualizations and examining “what if” scenarios within the data. Power BI reports can also answer questions in real-time and help with forecasting to make sure the departments meet business metrics.
Power BI can also provide the executive dashboards for administrators or managers, giving management more insight into how departments are doing.
Who uses Microsoft Power BI
Though Power BI is a self-service BI tool (Business Intelligence Tool)that brings the data analytics to employees, it’s mostly used by data analysts and the business intelligence professionals who create the data models before disseminating reports throughout the organization. However, those without an analytical background can still navigate the Power BI and create the reports.
Microsoft Power BI is used by both the department reps and the management, with reports and forecasts created to aid sales and marketing reps, while also providing the data for management on how the department or individual employees are progressing toward their goals.
In addition, Microsoft Power BI offers an admin portal for administrators to help configure the implementation of Microsoft Power BI, as well as usage monitoring and licenses.
Key features of Power BI
Microsoft has added a number of data analytics features to the Power BI since its inception and continues to do so. Some of the important and best features include:
- Artificial Intelligence — Users can access image recognition and text analytics in Power BI, create machine learning models using automated machine learning capabilities and integrate with Azure Machine Learning.
- Hybrid deployment support — This feature provides built-in connectors that allow Power BI tools to connect with a number of different data sources from Microsoft, Salesforce and other vendors.
- Quick Insights — This feature allows users to create subsets of data and automatically apply analytics to that information.
- Common data model support — Power BI’s support for the common data model allows the use of a standardized and extensible collection of data schemas (entities, attributes, and relationships).
- Cortana integration — This feature, which is especially popular on mobile devices, allows users to verbally query data using natural language and access results, using Cortana, Microsoft’s digital assistant.
- Customization — This feature allows developers to change the appearance of default visualization and reporting tools and import new tools into the platform.
- APIs for integration — This feature provides developers with sample code and application performance interfaces (APIs) for embedding the Power BI dashboard in other software products.
- Self-service data prep — Using Power Query, business analysts can ingest, transform, integrate and enrich the big data into the Microsoft Power BI web service. Ingested data can be shared across the multiple Power BI models, reports and dashboards.
- Modeling view — This allows users to divide complex data models by subject area into separate diagrams, multi-select objects and set common properties, view and modify properties in the properties panel, and set display folders for simpler consumption of complex data models.
Microsoft Power BI updates
Power BI was originally called the Project Crescent and was initially available in July 2011, bundled with SQL Server, code name Denali. It was then renamed as Power BI and unveiled in September 2013 as the Power BI for Office 365. Initially based on the Excel features like Power Query, Power Pivot and Power View, Microsoft added features over time, including enterprise-level data connectivity and security options. Power BI was released as a stand-alone product in the month of July 2015.
Today, Microsoft updates the Power BI application with the new features and improvements on a monthly basis. To get the updates, users can download the latest editions from the Power BI site or Windows 10 users can get Power BI Desktop from the Windows Store.
Microsoft Power BI works by connecting the data sources and providing a dashboard of business intelligence (BI) to the users. It can connect with just an Excel spreadsheet or bring together cloud-based and on-premises data warehouses. Data pulled from cloud-based sources, such as Salesforce CRM, is automatically refreshed. With applications such as an Excel workbook or Power BI Desktop file connected to online or on-premises data sources, Power BI users must manually refresh or set up a refresh schedule to ensure the data in Power BI reports and dashboards use the most current data available.
Power BI components
Power BI consists of a collection of the apps and can be used either on the desktop, as a SaaS product or on a mobile device. Microsoft Power BI Desktop is the on-premises version, Power BI Service is the cloud-based offering and the mobile Power BI runs on mobile devices.
The different components of Microsoft Power BI are meant to let users create and share business insights in a way that fits with their role.
Included within Power BI are several components that help users to create and share data reports.
- Power Query: It’s a data mashup and transformation tool
- Power Pivot: It’s a memory tabular data modeling tool
- Power View: It’s a data visualization tool
- Power Map: It’s a 3D geospatial data visualization tool
- Power Q&A: It’s a natural language question and answering engine
Additionally, there are dozens of data sources that connect into Power BI, ranging from files (Excel, PDF, SharePoint Folder, XML), databases (SQL Server Database, Oracle Database, IBM databases, Amazon Redshift, Google BigQuery), other Power BI data sets, Azure data connections and many online services (Dynamics 365, Salesforce Reports, Google Analytics, Adobe Analytics, Facebook and others).
How to use Microsoft Power BI
Microsoft Power BI Desktop is where analysts and the other users can create the data connections, data models and reports. The Microsoft Power BI service is where those reports can be shared, so other users can view and interact with the reports.
Building a Microsoft Power BI report begins by connecting the data sources. Users then query the data to create reports based on their needs. The report is published to Power BI Service and shared so the cloud and mobile users can see and interact with the reports. Permissions can be added to give colleagues the ability to edit reports or create dashboards or limit their ability to edit.
Power BI cost
There are three levels of Power BI for users: Power BI Desktop, Power BI Pro and Power BI Premium. The desktop version is free, while the Pro model costs $9.99 per user, per month (as of November 2018). Pricing for Power BI Premium depends on the size of the deployment and the user amount.