Introduction
And because of Big Data trends, I became interested in learning Power BI and found that what Microsoft is trying to do with Office 365, SharePoint 2013, and Excel 2013 very interesting. Recently, I met a client with a need to build charts, analytics, and reports based on a huge consumer data. If it was just reporting then I usually recommend the Report Viewer or Reporting Services, or Crystal Reports. But this client needs analytics, charts, filters, and much more. So that's my story of getting interested in Power BI.
Data vs Information
One can't understand business intelligence without understanding the difference between data and information. I remember my college days and the difference between data and information.
Data is the raw form of facts that does not make any sense unless processed. For example, data stored about C# Corner authors views, downloads, and such.
Information is processed and structured data that is meaningful when read by humans. For example, charts displaying the number of views, downloads, and such per month.
Business Intelligence
From Wikipedia:
“Business intelligence (BI) is a set of theories, methodologies, architectures, and technologies that transform raw data into meaningful and useful information for business purposes. BI can handle enormous amounts of unstructured data to help identity, develop and otherwise create new opportunities. BI, in simple words, makes interpreting voluminous data-friendly. Making use of new opportunities and implementing an effective strategy can provide a competitive market advantage and long-term stability.”
Power BI is a business intelligence solution developed by Microsoft to convert data into information. Power BI is a self-service tool delivered using Microsoft Excel and Office 365. Using Power BI, users can generate charts and reports for data analysis and data visualization purposes.
Microsoft Power BI not only works with Office 365 and Excel but also integrates with SharePoint 2013, SQL Server, Access, and other data sources.
As you can see from the Table Import Wizard, data in Excel can be imported from SQL Server, Azure, Access, Oracle, Terada, Sybase, and several other data sources.
Recently, the Power BI team announced the public preview of Power BI connectivity to SAP BusinessObjects BI. Using this connector, developers and users can now connect with SAP and use data in Power BI. Power BI (
www.powerbi.com) allows users to visualize the data using Power View and Power Maps.
Some of the capabilities include seamless access to trusted enterprise data from the SAP world, data access, and visibility in Excel, discover and merge data with public and corporate data sources such as Windows Azure HDInsight, analytics, and much more.
Power BI has four components, Power Query, Power Pivot, Power View, and Power Map.
Microsoft Power Query for Excel is a query language used to access and filter data from the various data sources listed below.
-
Power Query functionality:
-
Find and connect data across a wide variety of sources.
-
Merge and shape data sources to match your data analysis requirements or prepare it for further analysis and modeling by tools such as Power Pivot and Power View.
-
Create custom views over data.
Power Query Data Sources can be nearly any kind of data, including Excel, CSV, XML, Text, SQL Server, Access, Oracle, MySQL, Azure Database, DB2, PostgreSQL, Sybase, Teradata, SharePoint List, OData feed, Windows Azure Marketplace, Hadoop File (HDFS), Windows Azure HDInsight, Active Directory, Microsoft Exchange, Facebook, and SAP.
Learn more about Power Query:
Power Pivot
An add-in that enables you to perform powerful data analysis in Excel 2013.
Learn more about Power Pivot:
Power View
An interactive data exploration, visualization, and presentation experience that encourages intuitive ad-hoc reporting.
Learn more about Power View:
Power Map
A three-dimensional (3D) data visualization tool for Excel 2013 that provides a powerful method for geospatial analysis.
Learn more about Power Map:
This article was an introduction to Microsoft Power BI.