This page has 0 threads | Add post

Finding our videos useful? Please consider helping us to share more!

Training videos for learning POWER BI

We have 9 Power BI videos listed below.

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.

Show this video

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!

Show this video

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.

Show this video

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.

Show this video

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.

Show this video

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.

Show this video

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.

Show this video

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.

Show this video

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.

Show this video

You might also like to consider booking a place on one of our online or classroom Power BI courses, where you could meet the owls behind the videos!

This page has 0 threads

Add a new post

VIDEOS BY CATEGORY

POWER BI CATEGORIES

POWER BI VIDEOS

VIDEOS BY AUTHOR

Training videos for learning POWER BI

Power BI Part 1.1 - Installing Power BI Desktop

Power BI Part 1.2 - Creating and Publishing Your First Report

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

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

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

Power BI Part 3.1 - Getting Data from Excel

Power BI Part 3.2 - Import Multiple Text or Excel Files

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

Power BI Part 3.4 - Get Data from Websites

Head office

London

Manchester