Introduction to Power BI

In the past couple of years, Big Data has been in the limelight and BI is a big part of it. Don't forget to check out Top 5 Developer Technology Trends for 2014 to learn more.

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 identify, 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

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.

Find more details on Power BI:

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 ( allows users to visualize the data using Power View and Power Maps.

Some of the capabilities include the 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 Components

Power BI has the four components, Power Query, Power Pivot, Power View and Power Map.

Power Query

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:

Introduction to Microsoft Power Query for Excel

Power Pivot

An add-in that enables you to perform powerful data analysis in Excel 2013.

Learn more about Power Pivot:

Get data using the Power Pivot add-in 

Power View

An interactive data exploration, visualization, and presentation experience that encourages intuitive ad-hoc reporting.

Learn more about Power View:

Get started with 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:

Get Started with Power Query and Power Map


This article was an introduction to Microsoft Power BI.