Software

Microsoft Power BI: The smart person's guide

This smart person's guide explains everything you need to know about Microsoft's data visualization toolset, Power BI.

hero

Image: Microsoft

The big data revolution continues in earnest and enterprises continue to generate more and more data about every business interaction they can track. Couple this with the volume of data now being generated by devices and sensors connected via the Internet of Things, and you begin to appreciate the universal need for better data visualization.

All of this generated data must be transformed into actionable information that decision makers can use. Data visualizations in the form of dashboards and reports must be developed and shared throughout the enterprise, crossing departmental and sometimes even international lines.

Microsoft's Power BI suite of data visualization tools is designed to accomplish the transformation of data into useful information. This smart person's guide explains everything you need to know about Microsoft's data visualization toolset, Power BI.

SEE: All of TechRepublic's smart person's guides

Executive summary

  • What is Microsoft Power BI? Power BI is a set of data visualization tools that allows users to transform collected data into actionable information for decision makers.
  • Why does Microsoft Power BI matter? In a modern enterprise, the ability to transform data into something useful is paramount to overall success.
  • Who does Microsoft Power BI affect? Power BI is a vital tool for any enterprise employee trying to communicate information to management, stakeholders, or other decision makers.
  • When is Microsoft Power BI available? Microsoft Power BI is available now.
  • How do I get Microsoft Power BI? A free trial version of Power BI is available for download from Microsoft. Office 365 subscribers already have access to Power BI as part of the general suite of applications.

SEE: Microsoft Power BI: Data analytics goes mainstream (Tech Pro Research)

What is Microsoft Power BI?

Power BI is Microsoft's suite of data visualization tools. The suite allows users to transform data found within, and even outside of, the enterprise. Power BI can tap into numerous data sources, including SQL Server, Excel, Salesforce, and Google Analytics.

As of November 2016, Power BI can readily access more than 60 data sources.

Image A

Additional resources

Why does Microsoft Power BI matter?

The ability to transform the huge amount of data generated by business enterprises into some form of actionable information that decision makers can use on a regular basis is critical to the success of the enterprise. Power BI provides tools for transforming raw data into information that can be presented in dashboards, documents, and reports.

Competitors to Microsoft Power BI

As the need for informative data visualizations within enterprises has risen so has the level of competition. The concept of tools that allow the democratization of data analysis and visualization has created a new niche market that is nearly irresistible.

Prominent products in this market competing directly with Power BI include IBM Watson Analytics, Tableau Desktop, and Google Analytics. There are also dozens of smaller companies offering specialized data visualization products and all of them are vying to take share from the largest players and each other.

But they are not the only companies vying for this market. Enterprise-wide database software producers like Oracle and SAP are also looking to move their large-scale analytic products down to departments and individuals. These companies are attempting to move tools that once were the domain of a few highly-specialized individuals down the organization hierarchy, which should help keep customers within their sphere of influence.

Additional resources

Who does Microsoft Power BI affect?

Anyone in an enterprise who needs to communicate information to their department, managers, vendors, or to the organization in general can use Power BI's data visualization tools to make it happen. Power BI has a number of templates to get even the most technology-challenged user started, and Microsoft provides many free educational training videos that can help turn novice users into experts.

Additional resources

When is Microsoft Power BI available?

Microsoft Power BI is available now, and new features are added to the suite of tools periodically.

Additional resources

How do I get Microsoft Power BI?

Power BI is available in several different ways. The most obvious is as a free web service users can access with a standard web browser. The free service is limited to cloud data sources and simple dashboard sharing, and it's restricted to individual use. The free service is limited to 1GB of capacity per day.

The Power BI Pro service is subscription-based and costs $9.99 per user per month. The Pro version allows users to access all supported data sources and is designed for business use. This version is limited to 10GB of capacity per day.

A desktop version of Power BI is also available for download. And enterprises with large mobile workforces can use the mobile version of Power BI, which is available on Windows 10, Apple iOS, and Android platforms.

For Office 365 subscribers, Power BI is available at no additional cost as part of the productivity suite. Users with the appropriate Office 365 subscriptions and administrative credentials can also download a desktop or mobile version of Power BI to use at their workstations or on their mobile devices. Power BI and its data sources are administered at the enterprise level, so you may have to ask your IT department for access.

In June 2017, Microsoft released Power BI Premium, which is an enterprise version of the data visualization product. The Premium version allows reports and dashboards to be distributed widely throughout an enterprise, and even externally, without requiring the audience to have individual licenses. This version of Power BI is cloud-based with capacity that can adjust to usage as necessary. The base price is $625/month, but pricing will likely vary for each enterprise.

Additional resources

Power BI 101

Get a leg up on your career by learning the basics of data visualization and Microsoft Power BI with these TechRepublic articles.

About Mark Kaelin

Mark W. Kaelin has been writing and editing stories about the IT industry, gadgets, finance, accounting, and tech-life for more than 25 years. Most recently, he has been a regular contributor to BreakingModern.com, aNewDomain.net, and TechRepublic.

Editor's Picks

Free Newsletters, In your Inbox