Introduction to PowerBI and Get started with PowerBI, Prepare data for analysis and Model data in Power BI.

Power BI

Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.

Power BI Flow:

Generally, the flow starts at the Power BI Desktop, where a report is created, which can be published to the Power BI Service and finally shared so that the users can use it from the Mobile apps.

This is the most common approach for sharing reports. There are other approaches but we will stick to this flow for this entire tutorial to help learn the different aspects of Power BI.

Steps to use Power BI:

The common flow of activity in Power BI looks like this:

  1. Bring data into Power BI Desktop, and create a report.
  2. Publish to the Power BI service, where you can create new visualizations or build dashboards.
  3. Share dashboards with others, especially people who are on the go.
  4. View and interact with shared dashboards and reports in Power BI Mobile apps.

Building blocks of Power BI:

The basic building blocks in Power BI are:

  • Visualizations : A visualization is a representation of data in a visual format. It could be a line chart, a bar graph, a color coded map or any visual way to present the data.
  • Datasets : A datasets is a collection of data that Power BI uses to create its visualizations. You can have a simple datasets that’s based on a single table from a Microsoft Excel workbook, similar to what’s shown in the following image.
  • Reports : a Report is a collection of visualizations that appear together on one or more pages. A report in Power BI is a collection of items that are related to each other. We will be working with the gap minder data to create the report below that looks at the GDP, population and life expectancy by global regions.
  • Dashboards : A Power BI dashboard is a collection of visuals from a single page that you can share with others. Often it is a selected group of visuals that provide quick insight into the data or story you are trying to present.

Which different types of visualization it provides?

Here are the visualizations types in Power BI:

1. Area Charts

2. Line Charts

3. Bar Charts

4. Column Charts

5. Combo Charts

6. Pie Charts, and many more.

Let’s get started with Power BI:

  1. Load the data in Power BI

2. You can view your data in tabular form by clicking Data icon.

Data from the excel
select the Item name column and change the type from text to binary

When you click on the model, you can see the table name and details of table in model section.

So, That’s all for introduction of Power BI. See the next blog to create the simple dashboard in Power BI. Hope you like it.

Thank You!!

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store