Course Overview
Power BI Desktop Mastering Data Visualization is a course designed to help participants overcome the challenges of working with complex data and gain confidence in interpreting and presenting insights effectively.
Are you tired of feeling perplexed by complex data and unsure of how to interpret it? Do you aspire to elevate your data analysis proficiency? Look no further! Our course is tailored to help you master the art of Business Intelligence using Power BI Desktop.
This course is suitable for business analysts, data analysts, and individuals who are eager to learn about BI and data analytics, whether you’re a recent graduate, a young professional, or a manager. With the guidance of our expert instructor, you’ll gain a comprehensive understanding of Power BI, from connecting to various data sources to creating interactive dashboards and visualizations. You’ll also learn how to use advanced features, such as tooltips, animation, and bookmarks, to make your data more captivating and design effective dashboards.
Root Cause Analysis is a systematic, evidence-driven process that helps you find the true underlying (and often hidden) causes that result in unwanted events. Minor failures do matter and can escalate out of control. It is, therefore, critical to:
- Select the problems and issues that matter the most (prioritisation)
- Utilise structured and proven approaches to explore potential causes and root causes (process)
- Apply the right techniques to seek the relevant evidence (tools)
- Know how to find and select the right solutions (action planning)
- Rigorously review and fine tune solutions employed (continuous improvement)
Course Objectives
By the end of this course:
- Help you learn Power BI Desktop from scratch
- Covers all the essential features and functions
- Skills you need to effectively use Power BI Desktop for data analysis
- You will be able to analyze & visualize data like a pro
- You will be able to make data-driven decisions with ease
- You will also learn how to design effective dashboards
- How to use Power BI’s many features to effectively analyze and present your data
- You’ll be ready to take your data analysis skills and your career to the next level
Which Microsoft Office Version Suitable for Power BI Desktop?
Power BI Desktop is a standalone application and not a part of the Microsoft Office suite. Therefore, any version of Microsoft Office is not required for using Power BI Desktop.
However, if you want to export data from Power BI Desktop to Excel, then you can use Microsoft Excel, which is a part of the Microsoft Office suite. Power BI Desktop can export data to Excel in several formats, including CSV, XLSX, and PDF. So, it is recommended to use the latest version of Microsoft Excel for optimal compatibility with Power BI Desktop.
Course Content
1.0 Power BI Desktop
1.1 What is Power BI?
1.2 Why Power BI?
1.3 How Power BI Works
1.4 How to Install Power BI Desktop
2.0 Basic Charts in Power BI Desktop
2.1 Column Chart
2.2 Stacked Column Chart
2.3 Pie Chart
2.4 Donut Chart
2.5 Funnel Chart
2.6 Ribbon Chart
2.7 Filter – Keep only and Exclude
2.8 View Data and Export
3.0 How to Create a Map in Power BI
3.1 Map
3.2 Filled Map
3.3 Map with Pie Chart
3.4 Formatting in Map
3.5 How to Change Background in Power BI Map
4.0 Table and Matrix in Power BI
4.1 Creating a Simple Table
4.2 Formatting in Table
4.3 Conditional Formatting in Table
4.4 Changing Aggregation in Table
4.5 Creating a Matrix in Power BI
4.6 Automatic Hierarchy in Matrix
4.7 Subtotal and Grand Total
4.8 Number Formatting in Table and Matrix
5.0 Other Charts in Power Bi Charts
5.1 Line Chart
5.2 Drill down in Line Chart
5.3 Area Chart
5.4 Line vs Column Chart
5.5 Scatter Plot
5.6 Waterfall Chart
5.7 TreeMap
5.8 Guage Chart
6.0 Cards and Filters
6.1 Number Card
6.2 Text Card
6.3 Date Card
6.4 Multi-Row Card
6.5 Filter on Visual
6.6 Filter on Page
6.7 Filter on All Pages
6.8 Drill through
7.0 Slicers in Power BI Desktop
7.1 Slicer for Text
7.2 Format Text Slicer
7.3 Date Slicer
7.4 Format Date Slicer
7.5 Number Slicer
8.0 Advanced Charts in Power BI
8.1 Animated Bar Chart Race
8.2 Drill Down Donut Chart
8.3 Drill Down Column Chart
8.4 Word Count
8.5 Sankey Chart
8.6 Infographic
8.7 Play Axis
8.8 Scoller
8.9 Sunburst Chart
8.10 Histogram
9.0 Object and Actions (Hyperlinks)
9.1 Insert Image
9.2 Insert Text
9.3 Insert Shapes
9.4 Insert Buttons
9.5 Action – Web URL
9.6 Action – Page Navigation
9.7 Action – Back
9.8 Action – Bookmark
10.0 Power BI Services Introduction
10.1 Creating a Report
10.2 Publish Report to Power BI Service Account
10.3 Export (PPT, PDF, PBIX) Report and Share
10.4 Create a dashboard in Power BI Service
