Power BI Master Class Dashboards and Power BI Service 2022

 

 

Learn how to create interactive dashboards and to publish to the Power BI Service

 

 

Click here to Start

 

 

What you'll learn
Enjoy CLEAR and CONCISE step by step lessons from a best selling Udemy instructor in FULL HD 1080 P video
Learn to use the EASIEST Business Intelligence tool to create INTERACTIVE Reports and Dashboards in Power BI
Lifetime access to course materials and practice activities. 100% money back guarantee
Load Dashboards and Reports into the Power BI Service and Configure the Power BI Service
Learn to use FILTERS and SLICERS to ask the MEANINGFUL questions of your data
Learn how to use different graph VISUALIZATIONS such as column, line, pie, combo, treemap, geographical and waterfall
Learn to create POWERFUL tables and matrixes of reporting data
Work with Power BI and Excel together - Learn to use Excel to analyze Power BI data
Learn to use CUSTOM Visualizations and Themes in Power BI

 

Requirements
You will require Power BI desktop and access to the Power BI Service on the Internet
You should be able to work with data in Excel and do basic reporting
You will require a work email address to sign up for the Power BI Service
Download the Power BI Desktop app which is available free from Microsoft for Windows

 

 

Description
If you are new to Power BI or want to fill in some gaps in your knowledge, THIS is the course for you. We've focused on providing you with the fundamentals you need to work with Power BI effectively!Don't sit through days of boring training to understand how Power BI works! This course will get you up to speed and working in half the time, giving you the crucial foundation to start you on the journey to becoming a Power BI expert. WHAT STUDENTS ARE SAYING:Students who have taken this course have this to say:"Course had a lot of detailed information, I learned a lot. Would highly recommend this to anyone at a beginner or intermediate level.""I think the course is very detailed, concise and at the right pace. I would recommend this course to everyone starting with PBI""After completing this course, I got to know, how much powerful is Power BI. This is excellent for interactive dashboards as well as easy to create any critical report."**** Lifetime access to course materials and practice activities. ****ABOUT THE TRAINERThis course is lead by Ian Littlejohn - an international trainer, consultant and data analyst with over 200 000 enrollments & 150 000 students on Udemy. Ian specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, Google Data Studio & Amazon Quicksight & his courses average over 4.5 stars out of 5. ABOUT THE COURSESkills in data analysis, reporting and the creation of dashboards are HIGHLY valued in today's business environment. Microsoft Power BI is now recognized as the leading Business Intelligence tool in the world for the development of reports, data analysis and dashboards.In this course you will learn the to use the AMAZING Power BI tool to create dashboards and how to use the power BI service to publish your work. In this class (the last module of my 3 part "Power BI Master Class" Series), you will cover:Introduction and Course ContentSigning up for Power BI and Loading DataTables , Cards, Matrix and Multi Row CardsColumns, Bar, Line, Pie, Treemap, Geographical and Scatterplot graphsFilters, Slicers and Asking questions of your dataPerforming trend analysis Creating Interactive Reports and DashboardsPublishing to Power BI Service and Configuring Power BI ServiceSecurity and setting up row level securityData Gateways and refreshing data setsUsing Drill throughs, bookmarks, advanced tool tips and groupingUsing Custom visualizations and themesPower BI and analyzing data with Microsoft ExcelPublishing and embedding dashboards and reportsWe look forward to having you on our course as we learn and explore the incredible power of Microsoft Power BI.Please note that this course is the third course in a series of three courses for the Power BI Master Class series. Search for my instructor profile to purchase these other courses.Course 1 - Query EditorCourse 2 - Data Modeling and DAX FormulasCourse 3 - Dashboards and Power BI Service

 

 

Overview

 

 

Section 1: Introduction

Lecture 1 Introduction to the Course

Lecture 2 About the Course

Lecture 3 Download the Training Data Files

Lecture 4 Loading Data into Power BI

 

 

 

Section 2: Power BI Tables

Lecture 5 Introduction to Power BI Tables

Lecture 6 Creating Tables in Power BI

Lecture 7 Formatting and Sorting Tables

Lecture 8 Using Multiple Measures in Tables

Lecture 9 Cross Filtering Tables

Lecture 10 Practical Activity - Tables

Lecture 11 Completed Activity - Tables

Lecture 12 Methods of Aggregation

Lecture 13 Practical Activity - Methods of Aggregation

Lecture 14 Completed Activity - Methods of Aggregation

Lecture 15 Percentage Calculations

 

 

Section 3: Matrix and Cards

Lecture 16 Introduction to Matrix and Cards

Lecture 17 Creating the Matrix Visualization

Lecture 18 Methods of Aggregation for Matrix

Lecture 19 Percentage of Calculations for the Matrix

Lecture 20 Conditional Formatting Matrix Visualization

Lecture 21 Multi Row Visualization

Lecture 22 Card Visualization

Lecture 23 Practical Activity - Cards, Multi Row and Matrix

Lecture 24 Completed Activity - Matrix and Card

 

 

Section 4: Filters and Slicers

Lecture 25 Introduction to Filters and Slicers

Lecture 26 Text Slicers

Lecture 27 Numeric Slicers

Lecture 28 Date Slicers

Lecture 29 Visual Level Text Filters

Lecture 30 Visual Level Numeric Filter

Lecture 31 Visual Level Date Filters

Lecture 32 Page and Report Level Filters

Lecture 33 Practical Activity - Filters

Lecture 34 Completed Activity - Filters

Lecture 35 Drill Through Filters

Lecture 36 Synchronising Slicers

Lecture 37 Hierarchical Slicers

 

 

Section 5: Column Visualizations

Lecture 38 Introduction to Column Visualizations

Lecture 39 Column Visualizations

Lecture 40 Analytics Features

Lecture 41 Stacked Column Visualizations

Lecture 42 Cross Filtering and Slicers

Lecture 43 Practical Activity - Column and Bar Visualizations

Lecture 44 Completed Activity - Column and Bar Graph

Lecture 45 Graph Options

 

 

Section 6: Trend Analysis

Lecture 46 Introduction to Trend Analysis

Lecture 47 Line Graphs

Lecture 48 Area Graphs

Lecture 49 Ribbon Graphs

Lecture 50 Practical Activity - Trend Analysis

Lecture 51 Completed Activity - Trend Graphs

 

 

Section 7: Other Graph Types

Lecture 52 Introduction to Other Graph Types

Lecture 53 Combination and KPI Visualizations

Lecture 54 Pie and TreeMap Graphs

Lecture 55 Geographical Graphs

Lecture 56 Scatterplots and Bubbleplots

Lecture 57 Decomposition Tree

Lecture 58 Key Influencers

Lecture 59 Q and A Visualization

 

 

Section 8: Interactive Dashboards

Lecture 60 Introduction to Interactive Dashboards

Lecture 61 Practical Activity - Create an Interactive Report

Lecture 62 Create the Interactive Dashboard

Lecture 63 Report Features

Lecture 64 Grouping and Groups

Lecture 65 Advanced ToolTips

Lecture 66 Bookmarks

Lecture 67 Action Buttons

Lecture 68 Personalize Visualizations

Lecture 69 Publish Interactive Dashboards

 

 

Section 9: Power BI Service

Lecture 70 Introduction to Power BI Service

Lecture 71 Review the Report

Lecture 72 Setting Up Dashboards

Lecture 73 Set up Alerts and Subscriptions

Lecture 74 Getting Insight from your Data

Lecture 75 Setting up the Mobile View

Lecture 76 Natural Language Queries

 

 

Section 10: Power BI Security, Workspaces and Refresh

Lecture 77 Introduction to Power BI Security, Workspaces and Refresh

Lecture 78 Understanding Data Gateways

Lecture 79 Data Gateways

Lecture 80 Row Level Security

Lecture 81 App Workspaces

Lecture 82 Publishing Apps

 

 

Section 11: Power BI and Excel

Lecture 83 Introduction to Power BI and Excel

Lecture 84 Power BI and Excel Connections

Lecture 85 Excel Data Types with Power BI

Lecture 86 Excel Online Workbooks

 

 

Section 12: Custom Visualizations

Lecture 87 Introduction to Custom Visualizations

Lecture 88 Custom Visualizations

Lecture 89 Themes

 

 

Section 13: Administration and Embed Dashboards

Lecture 90 Introduction to Administration and Embed

Lecture 91 Power BI Administration

Lecture 92 Embed Reports

Lecture 93 Power BI Usage Reports

Section 14: Corona Virus Case Study

Lecture 94 Links to the Corona Virus dashboard

Lecture 95 Corona Virus Case Study

Section 15: Course Conclusion

Lecture 96 Course Conclusion

Excel users who want to learn how to create professional reports in Power BI