Training videos for learning POWER BI

Power BI - 9 videos

Power BI Part 1.1 - Installing Power BI Desktop

Posted by Andrew Gould on 03 June 2019

This first video in the Power BI tutorial explains how to install the Power BI Desktop application both from a standalone installer and from the Microsoft Store. You'll see how to run the software for the first time and how to sign in to a Power BI account.

Power BI Part 1.2 - Creating and Publishing Your First Report

Posted by Andrew Gould on 03 June 2019

This video gives you an overview of building a Power BI report from scratch, through to publishing it to the Power BI service. You'll learn the basics of getting data from Excel workbooks and text files and how to use the Power Query Editor to transform the data before it's loaded into your data model. You'll also see how to create relationships between tables along with some other simple data modelling tasks. You'll learn how to create visualisations in a report such as tables, charts, gauges and maps as well as how to control the interactions between those visuals. You'll discover how to use slicers to allow users to filter data in the report and how to make those slicers easy to use on different devices. You'll see several formatting features including conditional formatting in charts, tables and maps. Finally, you'll learn how to upload a report to the Power BI service and then publish it so that the whole world can see it!

Power BI Part 2.1 - Install and Configure Power BI Report Server

Posted by Andrew Gould on 17 June 2019

This video explains how to install and configure a Power BI Report Server so that you can deploy reports to an on-premises server rather than publish them to the Power BI service in the cloud. You'll also learn how to install the special version of Power BI Desktop needed for Power BI Report Server and how to use this application to deploy your reports. The video also shows you how to access your deployed reports via the Power BI Report Server Web Portal.

Power BI Part 2.2 - Report Builder for Power BI Report Server

Posted by Andrew Gould on 18 June 2019

This video shows you how to install and use Report Builder for Power BI to create and upload paginated reports to on on-premises report server.

Power BI Part 2.3 - Connect Power BI Reports to Shared Datasets

Posted by Andrew Gould on 18 June 2019

This video explains how to connect a Power BI report to a shared dataset deployed to a Power BI Report Server. You'll learn how to use the REST API for Power BI with an OData connection to import data from the shared dataset. You'll also see how to configure a scheduled refresh of the report to ensure it shows up-to-date information.

Power BI Part 3.1 - Getting Data from Excel

Posted by Andrew Gould on 17 June 2019

This video shows you how to import data from Excel into a Power BI report. You'll learn about the importance of Excel tables and range names and how to select the appropriate range to import. You'll see how to import multiple tables and create one-to-many relationships between them. You'll also learn about using the Power Query Editor to clean up untidy data by deleting rows, promoting headers and altering data types. The final part of the video explains a couple of techniques for appending multiple tables into a single list, and how to merge multiple queries into a single table to make it easier to create reports.

Power BI Part 3.2 - Import Multiple Text or Excel Files

Posted by Andrew Gould on 17 June 2019

This video explains how to import multiple text files or Excel files from a folder into a single table in Power BI. You'll learn how to use the Query Editor to append multiple separate queries. You'll see how to use the Get Data tool to import all the files in a folder in a single query. You'll also see how to filter a list of mixed files to import only those that you need for your report and then use the Query Editor to combine them.

Power BI Part 3.3 - Import and Transform Data from PDF Files

Posted by Andrew Gould on 19 June 2019

This video shows you how to import data from PDF files in Power BI. You'll learn how to transform your data in the Power Query Editor including how to merge queries, append queries, transpose tables and unpivot columns.

Power BI Part 3.4 - Get Data from Websites

Posted by Andrew Gould on 01 July 2019

In this video you'll learn how to import data from websites into a Power BI report. You'll use the basic web import tool to get data from simple HTML tables and use the Power Query Editor to clean up the data before using it in the report. You'll also learn how to use the web table inference feature to import data from structures that aren't recognised as HTML tables. Along the way you'll learn a little about using the drilldown feature in visualisations and how to add calculated values to a table using Quick Measures. The final part of the video shows you how to use parameters to get data from a website in a dynamic way.

This page has 0 threads Add post