Intro to Power Query || Load Data from Power Query to the Data Model - #07
This video will give you a glimpse of what power query in Excel is all about. You will learn key aspects of power query and how to load data from power query into the data model. Please check out other Power Pivot videos on my channel and don't forget to like, share, subscribe and click the bell icon so you'll get a notification when the next video is uploaded. Thanks!
@Wyn Hopkins(Microsoft MVP)’s channel / accessanalyticaus
Content
0:04 Introduction
1:44 Power Query Editor
2:25 Import Data
3:30 Queries & Query Settings
4:11 Data Transformation
5:52 Close & Load options
7:14 Launch Power Pivot Window
7:24 Create Connections
7:42 Create a Measure
8:03 Insert a PivotTable
8:24 Update with New Information
Connect with me on:
Instagram and Facebook @youexceltutorials
Twitter @youexceltutor
LinkedIn @bunmisanusi
Other Videos
Excel tables and Pivot tables • Excel Tables & Pivot Tables
Connect Multiple Excel Tables in a Pivot Table (with Power Pivot) • Connect Multiple Excel Tables in a Pi...
Power Pivot and Power Query • Power Pivot and Power Query
Download the practice file here https://drive.google.com/file/d/1EtfF...
“Each of you should use whatever gift you have received to serve others, as faithful stewards of God’s grace in its various forms.” (1 Peter 4:10) NIV
#msexcel #youexceltutorials
Смотрите видео Intro to Power Query || Load Data from Power Query to the Data Model - #07 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь YouExcel Tutorials 22 Апрель 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,671 раз и оно понравилось 23 людям.