Power BI Data Import Playbook
|
Connecting to data is often the first place to begin when starting a new Power BI report. This course will teach you the skills and techniques for connecting to a wide range of data sources from Power BI.
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.
Author Name: Rory Neary
Author Description:
A Microsoft Power Platform Trainer Developer with a finance background and a deep passion to help businesses realize their potential with The Microsoft Power Platform. Rory has been working in the Power Platform since the early days of Power BI and has trained people across Europe in that time, from Italy up to Iceland and from Ireland across to Finland. An accountant by trade, he has worked both as a contractor, trainer and a consultant in the Power Platform space for many years and has seen … more
Table of Contents
- Course Overview
1min - Understanding How Import Fits within the Power BI Model Production Process
6mins - Connecting to Databases, Data Warehouses, SSAS Cubes, and Power BI Data Models Using Power BI
9mins - Connecting to Databases through Direct Query
7mins - Configuring Privacy Levels for Data Sources
7mins - Connecting to Online Sources Using Power BI
3mins - Connecting to SharePoint Data
4mins - Connecting to Text and CSV Data Sources from Power BI
6mins - Loading Data Using an R Script
3mins - Importing Excel Data and Workbooks to Power BI
13mins - Connecting to Web Data Sources from Power BI
10mins - Storing and Connecting to Your Office 365 Data Files
9mins - Using Blank Queries to Create Data Tables
4mins - Entering Your Own Data by Hand
3mins - Creating Tables from Thin Air
10mins - Course Wrap Up
2mins
User Reviews
Be the first to review “Power BI Data Import Playbook”
Related Products
Intro to Data Analysis
Understand the principles of data analysis, including techniques for data collection, cleaning, and interpretation.
Statistics for Data Analysis
Learn statistical methods and techniques for analyzing and interpreting data.
Data Scientist: Inference Specialist
Inference Data Scientists run A/B tests, do root-cause analysis, and conduct experiments. They use Python, SQL, and R to analyze data.
Analyze Data with Python
Learn to analyze and visualize data using Python and statistics.
Discovering Predictive Analytics with Alteryx
Explore predictive analytics techniques and tools using Alteryx to forecast future trends based on historical data.
Business Analytics
Explore data analysis techniques to drive business performance and decision-making.
There are no reviews yet.