Overview
This course will teach you how to use Power Query to load, cleanse, manipulate, and prepare your data for visualization and use in Power BI.
Information today exists in many locations, from a simple text file, to databases and social networks such as Facebook. Retrieving and combining related information from such disparate data sources to provide meaningful insights has, historically, been challenging. In this course, Data Preparation with Power Query in Power BI, you'll see how Power Query provides the cornerstone to Microsoft's Power BI solution which aims to solve this problem.
First, you'll learn how to retrieve and load data from various sources into Power Query. Next, you’ll discover how to manipulate the data by fixing errors and inconsistent values, and learn how to infer new data from the existing data. Finally, you'll explore how to combine data from different sources, and present a single, unified dataset.
When you’re finished with this course, you'll know how to use Power Query to access disparate data sources, cleanse and transform the data, and prepare it to provide new insights into your world of data.
University: Provider: Pluralsight
Categories: Data Analysis Courses, Business Intelligence Courses, Data Visualization Courses, Data Transformation Courses, Data Preparation Courses, Data Integration Courses, Power Query Courses, ETL Courses, Data Cleansing Courses
Syllabus
Taught by
Tags
