Power BI

The world of data evolution

Over the last few years, Microsoft has dramatically reshaped the way we think of Business Intelligence. Many areas that used to require significant investments in hardware, skilled resources and development effort, no longer require and expensive appliance as comparable levels of performance can now be achieved with commodity hardware.  In order to fully leverage this change in technology landscape and capabilities, organizations must realize that many architectural patterns and best practices that have been developed over the last 30 years are no longer applicable.

Some statistics show

  • There is a 10x increase in data volume every five years, 85% of which is currently from new data types
  • Each adult now has on average 4.3 connected devices and 27% of them are using social media input
  • According to Gartner, organizations that build a modern information management system will outperform their peers financially by 20 percent
  • Today only about 10% of an organization’s business users can do business analytics – that’s a very low percentage

Everyone should have easy access to the data they need to make informed decisions. The challenge with enabling easy access to data is that accessing and analyzing data can be a daunting task. Questions arise such as: Where does the data live? How do I access it and get it into the right format so that I can analyze it?  To solve this problem, we need to make data of all types much easier to find, access, analyze, and share. And that’s the focus of the PowerBI solution.

Power BI is a business analytics solution that lets you  visualize  your data and share insights across your organization or embed them in your app or website. You can connect to hundreds of data sources and bring your data to life with live dashboards and reports.

The Power BI Solution allows you to create reports and live dashboards that connect to wherever your data lives and visualize it in many ways and collaborate and share your insights with others inside and outside your organization.

You can embed your reports and dashboards in your apps or websites.

You can integrate with other tools, including Microsoft Excel and Office 365 so you can get up to speed quickly and work seamlessly with your existing solutions.

You can take action from your desk or while on the go with the Power BI apps.

There are several applications available with the Power BI solution

  • Power BI Desktop
  • Power BI Service
  • Power BI Mobile
  • Power BI Embedded
  • Power BI Report Server

Power BI Desktop is a free complete data analysis and report creation tool. You can connect to many different sources of data and combine them (often called modeling) into a data model.

The Power BI service is a cloud-based, online service for light report editing and collaboration for teams and corporations. You can connect to data sources in the Power BI service, as well, but modeling is limited.

Power BI Mobile provides secure access and to live Power BI dashboards and reports on any device, with native Power BI apps for Windows, iOS, and Android.

Power BI Embedded provides the ability to embed interactive Power BI visuals in your applications, websites, or portals to bring world-class analytics directly to your customers.

Power BI Report Server is an on-premises report server with a web portal in which you display and manage reports and KPIs. Power BI Report Server is similar to both SQL Server Reporting Services and the Power BI Service, but in different ways. Like the Power BI Service, Power BI Report Server hosts Power BI reports (.PBIX) and Excel files. The Power BI Report Server is a superset of SQL Server Reporting Services (SSRS): everything you can do in SSRS, you can do with the Power BI Report Server, with additional support for Power BI reports. Power BI Report Server is available through two different licenses: Power BI Premium and SQL Server Enterprise Edition with Software Assurance. With a Power BI Premium license, you can create a hybrid deployment mixing cloud and on-premises.

Power BI for Office 365 is a complete self-service BI solution delivered through Excel and Office 365 that provides data discovery, analysis, and visualization capabilities to identify deeper business insights from data in Excel.

Most report designers who work on business intelligence projects use Power BI Desktop to create reports, and then use the Power BI Service to share their reports with others.

The importance for data visualization is still on the rise and Microsoft continues to invest in areas such as deeper interactivity that blend analysis and visualizations even more fluidly, newer types of visualizations that enable you to see deeper insights more easily, richer experiences on the devices customers use most, and great storytelling experiences.

We hope you have found this edition of “To The Point” by Jan Crowe to be helpful and informative. Look out for our next installment as we continue to explore unique topics from business to the latest technology.

We want to hear your point! If you have any ideas, suggestions or any questions about our weekly blog, please contact us at: info@pointalliance.com.

Warm regards,

Point Alliance Team