Power BI Visualization Mastery (Live – Online) – Leila Etaati

Data Visualization with Power BI has been used by data scientists, data analysts, and Managers to present data. Also, it is a way to explore or explain the data and extract insight from the available data.

This is a course that covers end to end of Power BI visualization. In these Ten hours of training (Split in three sessions of 3.5 hours each across 3 consecutive days), you get familiar with some rules and insight about visualization and chart specifications. The training continues with more focus on Visualization components such as different types of charts and visuals and scenarios to use them.  Also, you will learn how to tell a story using advanced visualization techniques in Power BI.

View here for your time zone

In the end, you learn how to create custom visuals with a no-code environment, Charticulator, inside the Power BI desktop.

This training is for anyone who do data analysis and build reports and dashboards using Microsoft Power BI. It is good to have basic knowledge about Power BI Desktop, but not mandatory.

The training includes but is not limited to the topics below:

1. Data Visualization

Data Visualization is the front end of any BI application; this is the user viewpoint of your system. It is critical to visualize measures and dimensions effectively so the BI system can tell the story of the data. In this module, you will learn conceptual best practices of data visualizations which are valid through all data visualization tools. You will learn Power BI visualization skills. You will learn how to create effective charts and dashboards using these tools and best practices for working with Power BI Desktop.

The content that you will learn in this module includes but is not limited to;

• Power BI Desktop Visualization
• Formatting Visuals in Power BI Desktop
• Basic Charts and Visuals in Power BI
• Sorting, Filtering, and categorization
• Custom Visuals in Power BI Desktop
• Maps and Geo-Spatial Visualization

2. Visualization Basics

Visualization is an important part of any BI system. In Power BI, Visualization plays a critical part. In this section, you will learn why visualization is important, with few basics of visualizations such as comparing stacked vs. clustered charts. In this section, you will also learn about data exploration techniques such as drill down/up, using pages, etc.

• Importance of Visualization
• Basic Charts; Bar and Column Charts
• Clustered vs. Stacked Charts
• Q&A for Reports
• Quick Measures in Power BI
• Drill Down and Up using visuals and hierarchies
• Pages

3. Slicing and Dicing

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. You will learn different types of slicers and some advanced features such as syncing slicers through different pages for slicers.

• Filters
• Scopes of Filters: Visual Level, Page Level, Report Level
• Modes of Filtering: Basic, Advanced, Relative, Top N
• Drill through Page Filter: Creating master-details page scenario in Power BI
• Slicers
• Types of Slicers; Date, Text, Number
• Slicer Formatting
• Syncing Slicer between Pages

4. Advanced Visualization in Power BI

Know 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.

• Report Page Tooltip
• Controlling the interaction of Visuals in a page
• Designing Power BI reports for Mobile
• Grouping and Binning
• Bookmark; saving the state of a page
• Buttons; action items
• Selection pane; visibility control in Power BI
• Golden triangle; Bookmark, button, and selection pane
• Colour theme or pallets in Power BI

5. Best Practice Scenarios of Using Visuals

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.

• Line Chart; Trend Analysis
• Combo Charts; Different Scales in one graph
• Ribbon Chart; Ranking
• Waterfall Chart; Cashflow
• Scatter Chart; Storytelling with the data
• Grouping charts: Pie, Donut chart, and Treemap charts
• KPI visual
• Gauge (Custom Visual)
• Card Visual
• Table and Matrix; showing the numbers with conditional formatting

6. Geo Location Visualization: Map Visuals

In Power BI, there are multiple ways of visualizing items on the map. This section 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.

• Map Visual; Using Bing to find spots
• Fine Tuning Address Details
• Map Visual; Using Latitude and Longitude
• Filled Map; Regions and Polygons
• Data Category importance for the filled map
• Shape Map; Having custom map visual
• Azure Map; Map visual which can do everything

7. Custom Visuals with Charticulator

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, but with Charticulator, you can create custom visuals based on your need. You will learn how to work with the Charticulator environment in Power BI desktop and Charticulator studio.

• Simple visuals such as scatter chart and Bar chart.
• Pyramid and Ranking Chart
• Ribbon and Slope Chart
• Link and Node Chart with Simple Cord Chart
• Custom Curve and Spiral Chart
• Bullet and Shape Map Chart

Instructor: Dr. Leila Etaati

Dr. Leila Etaati is the first Microsoft AI MVP in New Zealand and Australia, She has a Ph.D. in Information Systems from the University Of Auckland. And she has been working with information systems since 20 years ago. She is the Co-director and data scientist in RADACAD She is the co-organizer of Power BI and Analytics user group (meetup) in Auckland with more than 2500 members, She is the co-director of conferences such as the Difinity Conference (2017 till now) and the Power BI Summit (the biggest Power BI conference). She is a Data Scientist,  BI Consultant, Trainer, and international Speaker. She is one of the very few AI and Data Platform Dual Microsoft MVPs in the world. Leila is an active Technical Microsoft AI blogger for RADACAD.

• Chair and Director at RADACAD
• Chairman, and Director at Power BI Summit
• Chairman, and Director at Difinity conference (Since 2017)
• Microsoft Data Platform MVP (Since 2016)
• Microsoft AI MVP (Since 2017)
• Leader of Data, Insights, and Power BI user group in Auckland, New Zealand (Since 2016)
• Regional Leader of Global AI Bootcamp
• Leader of Artificial Intelligence user group in Auckland (Since 2018)
• Power BI All-Star award winner
• Dynamic Communities Emerald award winner
• Author of more books on Data Science, AI, analytics, and Power BI
• Speaker at many conferences such as Ignite, Microsoft Business Applications Summit, PASS, and etc.
• Blogger, and content creator
• Consultant, and trainer
• Microsoft Certified trainer
• Microsoft Certified professional

She worked in Industries including banking financial, power and utility, manufacturing. She is an invited lecturer at the University of Auckland. And she is a trainer in Data Analytics, AI, and Data Science courses in RADACAD.

Leila speaks in international SQL Server and BI conferences such as Microsoft Ignite, PASS Summit, PASS Business Analytics, PASS Rally, and many SQL Saturdays in the USA, Europe, Australia, and New Zealand on Machine Learning and Analytics topics.