This is a short section covering What this course covers, why we need visualization, and what you will learn through this training.
This course is the Visualization part of the Power BI for Data Analysts Course. This training is designed for data analysts, who have the data modeled and ready for them to visualize. In this training, you will learn detailed visualization practices of Power BI.
The training has a focus on Visualization components such as different types of charts and visuals and scenario to use them. You will also learn about advanced visualization techniques such as designing mobile reports, changing the interactivity of visual, detailed learning of slicers and filters, creating parent-child reports, etc.
At the end of this training, you will be able to do all visualization requirements for Power BI and build reports and dashboards for your business scenario.
There is no prerequisite for this course. However, it would be beneficial to watch the Power BI Essentials training video before this to have familiarity with some concepts.
Visualization is an important part of any BI system. In Power BI, Visualization plays a critical part. In this section, you will learn about why visualization is important, with few basics of visualizations such as comparing stacked vs. clustered chart. You will also learn in this section about data exploration techniques such as drill down/up, using pages, etc.
The importance of slicing and dicing data in Power BI is critical. Power BI is not a visualization tool only, but it is also a data exploration tool. There are several ways you can filter the data. In this section, you will learn the difference between filters and slicers. You also learn about different scopes of filtering, as well as filtering modes. For slicers, you will learn different types of slicers and some advanced features such as syncing slicers through different pages.
Now that you know about visualizations and slicing and dicing, it is a good time to talk about some advanced techniques which will take your visualizations to the next level in Power BI. You will learn about techniques such as changing the interaction of visuals, report page tooltips, Bookmarks and dynamic visualizations in this section.
It is a good time to learn about all built-in visuals in Power BI now. It is important to know which visual should be used in what scenario. You will also learn in this section about the pros and cons of each visual. You will learn specific features of the visual that can help to solve real-world scenarios. All the examples will be hands-on.
- Column and Bar Charts; Category Analysis
- Line Chart; Trend Analysis
- Area Chart
- Line and Column Charts, Combo Char; Difference Scales in One graph
- Ribbon Chart; Ranking
- Waterfall Chart; Cashflow
- Scatter Chart; Storytelling with the data
- Grouping Charts: Pie Donut and Treemap Charts
- Gauge and KPI Visuals in Power BI
Most of the visuals that you learned through the course are good for aggregated data. For reporting the details, most of the time, we use a grid style report using Table and Matrix visuals. In this section, you will learn about these two types of visuals, and also the conditional formatting that you can apply in these visuals, as well as other visuals in Power BI.
In Power BI, there are multiple ways of visualizing items on the map. In this section, you will learn about all the built-in ways of using map visuals in Power BI, the pros, and cons of each method and special considerations for some of the visuals.
Power BI recently leverages a lot of powerful AI features to provide better analytics through specific visualizations. In this section, you will learn how to use those visuals with no code low code experience of using AI in Power BI visuals.
In addition to the built-in list of Power BI visuals, you can leverage some of the third party visuals created by other companies called Custom Visuals. Creating custom visuals is a developer topic, which we won’t discuss in this training, but you will learn about how to use custom visuals. You will learn about the most useful custom visuals in Power BI through many demos.