
Here I will take you through an overview of the course. We will take a look at what we will be covering and I will give you the presentation as a resource. I will also give you a copy of the final PowerBI desktop file, and the sample data, that we will be building in this course, so you can have a look at it if you get stuck along the way. Udemy does not allow the ".pbix" file extension, so I have added a ".xls" to the end of the filename, please remove this once you have downloaded the file. So you will remove the ".xls" from the end of "PowerBIZeroToHeroIntroduction.pbix.xls"
Here I will show you the data we will be using to build our model.
Here I will show you PowerBI desktop and explain how to navigate the software.
Here I will take you through the PowerBI query editor, this is where we will be doing our data importing and transformation.
Here I will show you how to download PowerBI desktop.
In this lecture I will show you how to import the sample Excel data. I will also take you through some tips on transforming and formatting the data.
Here I will show you the different ways you can define relationships in PowerBI desktop
Here I will show you how to save some time by creating a template for your reports
Here I will take you through how to build the sales by sales rep and region page
Here I will take you through building the sales by store page
Here I will take you through building the sales by product page
Here we will use the matrix visual on a report page. I will take you through exactly how it works
Here we will use the decomposition tree visual on a report page. I will take you through exactly how it works
Here I will show you the PowerBI service, even though it is not a part of this course it will help with explaining how PowerBI is used and how reports are consumed from the cloud.
Here will will run through the introduction presentation again and cover what we have learned in this course and some of the best practices for PowerBI
Here I will show you an example of an intermediate level model and what can be expected in future courses
Get up and running on PowerBI desktop in the shortest time possible! In this course we will look at importing your data. Once imported we will format and transform the data. We will create a data model through defining relation ships. Once we have our data model we will create visuals that will make sense of the data.