Getting started with PowerBI — Modeling the data

Sarjakmodi
3 min readOct 28, 2021

Power BI Desktop is a free tool that enables you to connect to, transform, and visualize your data on your local computer. With Power BI Desktop, you may connect to a variety of data sources and integrate them into a data model (a process known as modeling). This data format allows you to create visuals and collections of visuals that you can share as reports with others in your company.

The majority of customers who work on business intelligence projects utilize Power BI Desktop to develop reports and subsequently share them with others via the Power BI service.

The following are the most typical uses for Power BI Desktop:

  • Connect to information
  • To construct a data model, transform and clean the data.
  • Create graphics that give visual representations of the data, such as charts or graphs.
  • On one or more report pages, create reports that are collections of graphics.
  • Use the Power BI service to share reports with others.

Visualization Types In Power BI:

  • Area charts
  • Bar and Column charts
  • Card
  • Combo charts
  • Decomposition Tree
  • Funnel chart
  • Maps
  • Pie chart, etc

Home Screen after installation of Power BI Desktop:

The following association between fields will be established.

Let's get started with Power BI!

  1. Loading dataset in excel format
Review the dataset before loading the dataset

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

3. Preparing data for analysis

4. You can view the model view of data by clicking the model icon.

Before Modeling
After Modeling

Hence we have learned about the Power BI tool and how to use Power BI Desktop and created the dataset model as we wanted. Next, we will try to create a Dashboard in Power BI.

--

--