Brandon shows you how to transform data using Power Query in Microsoft Power BI. This video is an introduction to Power Query-Power Query for Beginners. It answers the question “What is Power Query in Power BI?” and walks you through how to use Power Query.
In this video, you’ll learn what Power Query can do using the Power Query Editor In Power BI including: get & transform, data cleaning, how to separate alphanumeric data, how to remove rows, how to rename columns, and how to create a calendar table in Power Query. You’ll also learn powerful functions like the unpivot Power Query function, and you’ll see the Power Query M language in action.
📒 Show Notes 📒
Download data file:
docs.google.com/spreadsheets/...
Download calendar table script:
radacad.com/download/13519/
⏰ Timecodes ⏰
0:00 - Power BI Power Query Overview
1:41 - How to Get & Transform Data
1:58 - How to Open Power Query
2:06 - Power BI Query Editor
4:03 - How to Filter Rows in Power Query
4:20 - How to Remove Null in Power Query
4:40 - Power Query Transform Function
5:18 - Power Query Split Function
5:43 - How to Rename Column In Power Query (How to Change Column Name in Power Query)
6:07 - How to Remove Column in Power Query
6:25 - How to Edit Applied Steps in Power Query
7:03 - Power Query Use First Row as Headers Function
7:40 - Power Query Unpivot
8:43 - How To Create Calendar in Power Query (How to Create Date Table in Power Query)
QUESTION - Have a question about Power BI or how to get started as an entrepreneur? Post in the comments section of this video!
Connect with Brandon on Social Media:
brandonmichals.com
/ brandonmichals
/ brandonmichals
/ brandonmichals
/ brandonmichals
#PowerBI #PowerQuery #BrandonMichals
About:
In this video, Brandon walks you through how to use Power Query in Power BI. After watching, you’ll know how to use the Power BI Power Query Editor to transform your data from messy to clean.
Our mission is to help entrepreneurs start and grow their businesses, find fulfillment in their work, and have a positive impact on the world around them.
Негізгі бет Тәжірибелік нұсқаулар және стиль How To Use Power Query In Power BI--Automated Data Transform
Пікірлер: 19