Various
types of visuals can be created in Power BI to highlight different aspects of
data. Here are some popular visuals and their uses:
.jpg)
Transforming Data Using Power Query Editor
1. Charts
1. Bar Chart:
- Vertical Bar Chart: Displays categorical
data comparatively, where the bars are vertical.
- Horizontal Bar Chart: Bars are arranged
horizontally, usually used for data with long category names.
2. Column Chart:
- Clustered Column Chart: Used to compare
multiple categories.
- Stacked Column Chart: Displays multiple
series together in a stacked manner.
3. Line Chart:
- Line Chart: Used for showing changes over
time, such as monthly sales.
4. Pie Chart:
- Pie Chart: Divides a whole circle to
display the relative proportions of different parts.
5. Donut Chart:
- Donut Chart: Similar to a pie chart but
with a hole in the center, providing more visual space.
6. Area Chart:
- Area Chart: Shows trends over time by
filling the area under a line.
2. Graphs
1. Scatter Plot:
- Scatter Plot: Used to show the
relationship between two variables. It helps identify the correlation of the
plotted data.
2. Bubble Chart:
- Bubble Chart: Displays three variables,
where bubbles appear in different sizes controlled by different variables.
3. Maps
1. Filled Map:
- Filled Map: Displays different values
within geographical regions, such as showing the average income per country.
2. Shape Map:
- Shape Map: Displays data using custom-shaped
geographical regions.
3. ArcGIS Maps:
- ArcGIS Maps: Used for advanced
geographical analysis.
4. Tables
1. Table:
-
Table: Displays multiple columns and rows of data to easily show detailed
information.
2. Matrix:
- Matrix: Similar to a table but allows you
to group data by columns and rows and aggregate data in each cell with detailed
information.
5. Other Visuals
1. KPI (Key Performance Indicator):
- KPI: Compares the current status of a key
metric against a target.
2. Card:
- Card: Displays a single value, such as the
total sales number or average grade.
3. Slicer:
- Slicer: Acts as an interactive filter that
affects data visuals.
4. Treemap:
- Treemap: Displays relative values within
hierarchical data. It's used to show relationships across different levels.
5. Funnel Chart:
- Funnel Chart: Used to show changes across different stages of a process or sales, such as a sales funnel.
By using these visuals, you can analyze your data from different perspectives and present information that is easily understandable to users.
.jpg&description=Transforming Data Using Power Query Editor - AnalysisWithSadiul){kind=link}