Power Bi Track

PowerBI Track

Lesson 3

Tutor

Hello dear,My name is Amara and I would be your Trainer, Welcome!

Index

LESSONS

Visuals

Views in Powerbi

Slicers and Tables

PowerQuery Editor

Transforming Data

Cleaning Data

Filtering

Visualizing Data

Steps in Data Visualization

Data visualization conveys long and bulky raw data with the use of charts, infographics, graphs, scatter plots, and many more. Not all your audience will be technical or data-oriented so, presenting your data in simple visuals will improve communication and analytical efficiency to a large extent.

01

02

03

04

Step 3

Step 4

Step 1

Step 2

Prepare and understand the specifications of the data you are working with

Select a suitable chart type.

Know your audience

Understand the purpose of your project.

+ info

Dataset : https://www.kaggle.com/datasets/aungpyaeap/supermarket-sales?resource=download

01

Views in Powerbi

What is a Powerbi View

We have 3 major views in Powerbi Desktop

• Report: The Report view is the one at the top of the list. It’s also the default view, so it’s the one that you’ll see right away when you open Power BI Desktop. Creators use this view to create visual reports based on their data.
• Data: Data view helps you inspect, explore, and understand data in your Power BI Desktop model. It's different from how you view tables, columns, and data in Power Query Editor. With Data view, you're looking at your data after it has been loaded into the model.
• Modelling:The Relationship view is also called the Model view, and as you’ve probably guessed based on the name, it allows creators to see the relationships between their data models.

VISUALS

• Bar Chart
• Column & Line Chart
• Pie chart
• Donut Chart
• Map

• Matrix
• Tables
• Guage charts
• KPI charts
• etc

Resource : https://mindmajix.com/power-bi-visualization-types

Data

Maps -- Geopraphical Data

80%

SLICERS AND TABLES

Slicers are another way of filtering.

Slicers are a great choice when you want to:

• Display commonly used or important filters on the report canvas for easier access.
• Make it easier to see the current filtered state without having to open a drop-down list.
• Filter by columns that are unneeded and hidden in the data tables.
• Create more focused reports by putting slicers next to important visuals.

190k+

Over a 190+ Analyst use Powerbi

Transforming Data

45M+

Load Vs Transform

Users across the world

Data transformation is the process of converting data from one format, such as a database file, XML document or Excel spreadsheet, into another. Transformations typically involve converting a raw data source into a cleansed, validated and ready-to-use format.

85M+

Reports

+ info

1,2M+

vs

Load Data

Transform Data

If you use transform you can modify the data you already have or importing data. Eg: change column names. tinci

When you load data you can use data directly as you import on power bi desktop

Power Query Editor

What is Power Query Editot

Power BI Desktop comes equipped with Power Query Editor. You can use the Power Query Editor to connect to one or many data sources, shape and transform the data. You could modify the data in hand to meet your needs, make it more usable, and then load that model into Power BI Desktop.

+ info

Choose the right type of visualization.

Declutter your visualization.

Focus your audience's attention.

Think Like a Designer.

Thanks!