Getting started with PowerBI

PRACTICAL_7

This blog is for educational purposes only on getting started with PowerBI.

What is PowerBI?

Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data may be an Excel spreadsheet or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualize and discover what’s important, and share that with anyone or everyone you want.

Visualization types in PowerBI

• Area charts
• Line charts
• Bar charts
• Column charts
• Combo charts
• Pie charts, Doughnut charts, etc.

There are a lot more apart from these. You can view it here.

The home screen of PowerBI

1. Fields Pane — Displays the tables, folders, and fields in your data that are available for you to use to create visualizations.
2. Visualizations Pane — Where you can change visualizations, customize colors or axes, apply filters, drag fields, and more.
3. Filter Pane — Where you can apply filters
4. Report View or Canvas — Where visualizations are created and arranged.
5. The report, Data, and Model views- You can switch between Report, Data, and Model views by selecting the icons in the left column.

We will create the following relationship between fields

Model Structure

Loading the dataset in PowerBI

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

Open the field tabs for exploration.

Click on the individual 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:

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