Power BI Data Import Playbook
By Rory Neary
Course info
Course info
Description
Every Power BI report starts with data, which can be housed in a multitude of ways. In this course, Power BI Data Import Playbook, you’ll learn fundamental skills for making and using connections to sources of data in your reports. First, you’ll explore how data importation fits within the context of building a simple end to end Power BI report. Then, you'll delve into other data sources starting with structured sources such as databases all the way through to unstructured ones including Excel and web data sources. Finally, you'll learn about data privacy and even get to discover how to create tables from thin air using DAX (Data Analysis Expressions). When you’re finished with this course, you’ll have the skills and knowledge of Power BI data importation needed to enable you to begin building insightful Power BI reports.
About the author
A Microsoft Power Platform Developer with a finance background and a deep passion to help businesses realize their potential with Office 365.
Section Introduction Transcripts
Course Overview
Hi everyone. My name is Rory Neary, and welcome to my course, Power BI Data Import Playbook. I'm a Power Platform consultant at DataSpinners. I've been working with data as an accountant analyst and developer for over 20 years. This course is relevant to almost every single Power BI report that has ever lived. Not only that, but connecting to data is very often the first place you're likely to begin when starting a new report. So, if you're starting out with Power BI, you've come to the right place. In this course, we're going to cover the creation of connections from Power BI to a very wide range of sources of data. Some of the major topics that we'll cover include connecting to databases, Excel files, connecting to online sources, and creating tables from thin air. By the end of this course, you'll know how to import data into Power BI and you'll also have an understanding of the importance of where to store your data files. Before beginning the course, you should be familiar with Windows operating system, and it will help to have an understanding of data modeling concepts, such as tables, fields, and relationships. You're also going to need an installation of the Power BI Desktop, which can be downloaded from powerbi.microsoft.com. From here, you should feel comfortable diving further into Power BI with courses on Retrieve, Transform, and Combine Data Using Power Query and Getting Started with DAX Formulas in Power BI, Power Pivot, and SQL Server Analysis Services. I hope you will join me on this journey to learn Power BI with the Power BI Data Import Playbook course, at Pluralsight.