Data Science Series | Modeling the data with PowerBI

Learn how to analyze and create models of data using Power BI

Karan Patel
Geek Culture
3 min readOct 27, 2021

--

What is Power BI?

Power BI is software to create & publish reports and data stories from your data sets. You can make highly interactive, engaging, and powerful reports, dashboards, or visuals with Power BI. You can connect to any data (Excel files, SQL databases, BI warehouses, Cloud data, APIs, web pages, and more), mashup the data, link one table with others, create clickable visualizations, and then share them with your audience securely thru Power BI.

Visualization Types In Power BI

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

The Power BI home screen

  1. Ribbon — Displays common tasks that are associated with reports and visualizations present below the taskbar.
  2. Fields Pane — Displays the tables, folders, and fields in your data that are available for you to use to create visualizations.
  3. Visualizations Pane — Where you can change visualizations, customize colors or axes, apply filters, drag fields, and more.
  4. Filter Pane — Where you can apply filters
  5. Report View or Canvas — Where visualizations are created and arranged.
  6. Report, Data, and Model views- You can switch between Report, Data, and Model views by selecting the icons in the left column.
  7. Pages tab — Located along the bottom of the page, this area is where you would select or add a report page.

We will create the following relationship between fields

Model Structure

Loading The Dataset In Power BI

Select Navigator, now select the .xlsx file, which contains data

DS_A2_PR-7.xlsx loaded
Dataset loading in the fields pane

Open the fields tab to explore the data.

All the fields loaded.

Click on the respective field to open the required field for exploration.

Now, let's manage the relationships between the fields. Open the manage relationship tab from the taskbar which will show output like below:

Relationships present in the dataset
Autodetecting relationships present in the dataset

Once the relations are maintained, let's generate the model. Open the model generate option in the pages tab, and it will create a model.

Model Generation

Next, we will see the creation of a dashboard in the next blog.

--

--

Karan Patel
Geek Culture

AI Enthusiast, Technocrat, Photographer, Wildlife, Nature