Power BI brings your data to life

Power BI
Koen Timmers

Educator - Author - Keynote speaker - Global Teacher Prize 2017 finalist

In the previous tutorial we created an Excel file in which we imported data via MS Power Query. Read the article.

Power BI is a cloud based analytics service. It is a cool free tool which is part of Office 365. This tool allows to import, visualize and analyze data; by simply drag and drop you can execute complicated queries, create reports and ask simple questions. Data can be monitored live by any device. This smart tool interprets data automatically. It allows to import data via Excel but also via Services like Google Analytics, Bing, Git, etc.

Navigate to www.powerbi.com or http://powerbi.microsoft.com.

Hit the button Sign In. Sign in using your Office 365 account.

You are now able to import data from

  • your organisation (example: SQL)
  • services (google analytics, bing, github, mailchimp etc)
  • files (Excel, …)
  • databases (SQL, Azure, etc)

Three elements are primary to Power BI’s experience:

Importing data from files (Excel)

Let’s import the data we saved in our Excel file.

Hit the button  in the Files section.

Choose your source: Local file or OneDrive.

Select your file.

The first step is creating a data set.

Choose a kind of statistic on the right and drag this to your canvas.

Select fields in the sidebar at the right side.

The statistics will be automatically created.

You can easily switch from pie to bars etc.

The number of olympic medals per country:

The screen resolutions:

From the moment you save this data set, a new report will be created.

The Number of Phones per country:

By pinning stats at the upper right corner using the  button, you can save statistics to a dashboard.

Choose new or existing dashboard and hit the button pin.

You can repeat by creating new data sets, save them as reports and pin these on your dashboard so this dashboard will be loaded with facts and statistics.

The dashboard offers a very cool feature: the Q&A. This is more than a search box. Simple questions will be instantly converted into elaborate stats.

Isn’t that cool?!

Importing data from services

Power BI allows to import data from lots of different services: Google Analytics, Github, Bing, Mailchimp, etc. In this tutorial we will import data from Bing.

Hit the button  in the Services section.

Choose a Service. Let’s give Bing a try. This service offers you insight into the frequency specific keywords have been searched.

Enter your keyword.

Power BI will import your data and create a dashboard containing all kinds of statistics.

Read the Power Bi documentation: https://support.office.com/en-us/article/Power-BI-Overview-and-Learning-02730e00-5c8c-4fe4-9d77-46b955b71467

Power BI is also available as a standalone tool: Power BI desktop.

Download this tool: https://powerbi.microsoft.com/en-us/desktop

Take a look at this demo.

by PLN Education