How to get started & ingest data in Power BI
Power BI Video 1: Introduction & Getting Data
In this video, which is the first in an introductory series, we will first learn how to download Microsoft Office (freely available to all UNB students, faculty and staff) in order to gain access to Power BI desktop. We will then get a sense of the Power BI environment and some of its features/views, many of which we cover in more depth in later videos. Finally, we will learn how to ingest data from a Microsoft Excel file into Power BI which will set us up nicely for the next video in this series where we will start working with the data in Power BI.
To download Microsoft Office (UNB only): unbcloud.sharepoint.com/sites/ITSSelfServe
📊 Power BI Series:
Getting Data (this video)
Refining and Linking Your Data
Creating Visual Elements
Using Slicers to Gain Insights
Share Report To Wider Audience
Chapters:
0:00 Introduction
0:43 What is Power BI?
1:00 Installing Power BI
2:18 Opening Power BI & creating a blank report
2:36 Touring the Power BI environment (tabs, ribbons, views)
3:33 Working with report pages
4:06 Recommended settings & options
5:03 Steps to building a report
5:35 Exploring our Excel data (fact vs. dimension tables)
6:54 Data disclaimer
7:05 Getting data with Power Query
8:19 Loading tables into Power BI
9:31 Recap
For more information on basic Power BI skills, see my Power BI Basic Guide at https://lib.unb.ca/guides/power-bi-ba...
Intro and outro music from Stereoalex at https://icons8.com/music/track/synthw...