Complete Introduction to Microsoft Power BI [2020 Edition]
**** Updated April 2020 – This best selling Udemy Power BI course has been updated to the new Power BI interface ****
“Great experience of learning and a bunch of thanks for those Challenges. It helped a lot and are very helpful while revising the sections rather than going through each lesson.”
“Really good course, easy to follow and wonderful examples combined with useful insights.”
“Clear and concise, the course provided all the information needed for using power BI, and did so while providing enough details and examples however without stretching too long”
In this course you will learn the BEST techniques and tools for turning data into MEANINGFUL analysis using Microsoft Power BI
This course is lead by Ian Littlejohn – an international trainer, consultant and data analyst with over 100 000 enrollments on Udemy and consistently high reviews. Ian specialises in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI and Google Data Studio.
**** Life time access to course materials and practice activities. ****
In this course we are going to show you how to SUPERCHARGE your Power BI skills, and learn to create INTERACTIVE Dashboards and INCREDIBLE reports.
In this course we are going to teach you the following:
Using the Table and Matrix visualizations for cross filtering and drill downs
Creating Drill through between different sheets. For example you could be reviewing a list of Products and want to select one Product to view a summary of this product
Themes – Learn how to add Power BI Themes from the Community Theme Gallery
Changes in Custom Visuals – We look at how to easily add Custom Visualizations from the new Microsoft Office Store
Creating Apps – Learn how to easily share your dashboards and reports using Power BI apps and App workspaces
Relative Date Filters – In this lesson we show how to easily create a dashboard displaying Microsoft stock data. Easily filter your data to display the last 7 days, last 14 days, last month or previous 3 months using relative date filters
Drill Through – Create drill throughs between different pages in a report
Ribbon Chart – Learn to use the new Ribbon Chart to visualize the ranking of items across dates ranges or other categories.
Microsoft Power BI is the easiest to use reporting, data analysis and interactive dashboard tool available today! Microsoft Power BI is available for free – all you need to do is sign up!
In this course I will teach you how to easily turn your data into powerful intelligence and insight to drive your business decisions. Power BI uses simple drag and drop techniques that make it a breeze to create reports and dashboard. I will also show you how easy it is to publish your dashboards and to access them through your smartphone, tablet or laptop.
This course is for anybody who works with data and wants to learn how to quickly and easily get to speed with the cloud version of Power BI or learn the more powerful Power BI Desktop Designer.
The course has the following topics:
Introduction to Power BI and how to signup
How to create your first online report and dashboard
How to download the Power BI Desktop Designer
Loading, transforming and filtering data in Power BI
Creating tables and reports
Using filters and slicers
Learning how to use the wide range of graphs and visualizations
Creating relationships between tables of data
Creating powerful calculations, key metrics and key performance indicators
Creating interactive dashboards
Publishing dashboards to Power BI
In this course we use a step by step video based approach to show you how to create reports, analyze data and develop interactive dashboards. The videos are extremely easy to follow and data is provided so you can follow the instructions at the same time.
In this introduction we discuss the different topics and modules that we will be covering in the course. Different topics include Loading data, creating tables and reports, creating visualizations, developing dashboards and sharing data through the PowerBI cloud solution.
Download the data files that will be used during the course
Sign Up for Power BI
In this lesson we will show how you will sign up for the PowerBI service. This will create a user login and password for the PowerBI service.
In this lesson we learn how to load data into the Power BI Service
Practical activity to sign up and start using Power BI
The Power BI Desktop
Introduction to the Power BI Desktop section
In this lesson we will learn how to access and use the PowerBI interface. The PowerBI Interface consists of functions to upload or access data, create reports and create dashboards.
Creating Reports in Power BI Desktop
In this lesson we learn how to create tables in Power BI
In this lesson you will learn to format and style your table
In this lesson we go through the answers to the practical
In this lesson you will learn to change the method of aggregation from Sum to other options such as Average, Count, Max, Min and Distinct
In this lesson we will go through the answers to the practical activity
In this lesson we will review how to create cards and multi row cards in Power BI
Graphs and Visualizations
In this lesson you will learn how to create clustered column and bar graphs. Clustered Column and Bar graphs are ideal for displaying data when you want to know which is the largest item or which is the smallest item or how much bigger one item is then another.
In this lesson we will review the stacked bar and column graph. The stacked column and bar graph places each series on top of each other and displays the aggregated total.
In this lesson you will learn the different features that can activated with Power BI
In this lesson you will learn how to create line charts to display trends. Displaying and analyzing how data changes over time is a powerful method of analysis that provides input into forecasting.
In this lesson you will learn how to use area graphs to chart and understand trends
In this lesson you will learn how to create a Ribbon graph visualizations. The ribbon graph dispalys the ranking of the items that are being displayed. If for example you are displaying Sales by Product Category then it will display the Product Category with the highest Sales at the top and then the second highest and so on
In this lesson we will learn how to different types of graphs in Power
In this lesson we will learn how to create scatterplot and bubbleplot graphs.
In this lesson you will learn to create calculated columns using DAX formulas. DAX formulas are very similar to Excel
In this lesson you will learn how to create new time intelligence fields such as Year, Month and Week
In this lesson you will learn about the power of calculated measures to create powerful key metrics and key performance indicator calculations.
In this lesson you will learn how to use the = calculate function to filter
In this lesson you will learn how to create relationships between tables
Power BI Query Editor
In this lesson you will learn the Edit Query interface and how to load data
In this lesson you will learn how to transform data into aggregations using the Query
Analyze Data with Excel
Corona Virus Case Study
Conclusion for the course