Advanced Power Query Tutorial | 5 Practical Use Cases and Tips for Excel & Power BI Users | M Query
Вставка
- Опубліковано 14 лип 2024
- ▶ Dataset Excel file for practice
bit.ly/3uPIJCh
▶ Have queries regarding Data Analytics or studying abroad? Get in touch!
topmate.io/analyticalguy
Welcome to our latest video on Power Query tips and tricks! In this tutorial, we'll dive into five practical use cases that showcase the power of Power Query in Excel. Whether you're a beginner or an advanced user, these techniques will help streamline your data manipulation process and save you valuable time.
In this video, I will walk you through 5 Business Case studies using POWER QUERY. If you're interested in becoming a Data/Business Analyst, then this video will be very important for you.
▶What is Power Query? (Microsoft Definition)
Power Query is a data transformation and data preparation engine. Power Query comes with a graphical interface for getting data from sources and a Power Query Editor for applying transformations. Because the engine is available in many products and services, the destination where the data will be stored depends on where Power Query was used. Using Power Query, you can perform the extract, transform, and load (ETL) processing of data.
Power Query helps you to automate your tasks, so that you never have to repeat the same steps.
After watching this video, I can assure you that you'll learn a lot about Power Query and its practical use case.
▶ TIMESTAMPS:
00:00 Introduction to POWER QUERY
00:55 TASK 1 | Concatenation using SUMMARIZATION
10:10 TASK 2 | Adding Multiple Columns (Using M Query)
12:45 TASK 3 | TRANSPOSE using M Query & Normal approach
18:10 TASK 4 | Data Cleaning using GROUP BY & INDEXING
25:35 TASK 5 | Combine multiple EXCEL Worksheets from a same Workbook
💡 Relevant POWER QUERY VIDEO
========================
Advanced Power Query Tutorial | Complete End-To-End CASE STUDY | Practical guide with Dataset #excel (22k+ views)
• Advanced Power Query T...
💡 END-TO-END POWER BI DASHBOARD
========================
End-To-End Power BI Dashboard Tutorial for everyone | Data Storytelling in 2023 | Data Visualization
• End-To-End Power BI Da...
📁 Data Analyst Resume:
================
Data Analyst Resume with No Work Experience | Step by Step Guide | Templates + Tips + Examples
• Data Analyst Resume Wi...
🛑Data Analyst Journey:
=====================
How I would Study Data Analytics in 2023 (If I had to start over) | Schedule | Salaries | Skill Set?
• How I would Study Data...
Timetable And Efficient Strategy to Learn Data Analytics while Working | Improve Productivity
• Time Table And Efficie...
💡 LEARN MORE
========================
▶ Power BI Playlist -- bit.ly/3U3NVts
▶ Data Analytics Projects -- bit.ly/3hb84zd
▶ Excel Training - bit.ly/3WvCUTs
#powerquery #powerquery #powerbi #powerbitutorial
Brilliant video on advanced Power Query data cleansing techniques! Thanks for sharing your knowledge.
For the exercise with student marks and results, I decided to create a custom column and use List.Zip() to
pair corresponding [UNIT CODE], [UNIT MARK], and [RESULT] values with the following formula:
List.Zip(
{
Text.Split([UNIT CODES], " "),
Text.Split([UNIT MARKS], " "),
Text.Split([RESULT], " ")
}
)
This created a new column of lists, which I expanded into new rows, each of which contained a list of
{[UNIT CODE], [UNIT MARK], [RESULT}}.
Splitting the lists in that column results in a separate column each for [UNIT CODE], [UNIT MARK], and [RESULT], after
renaming the default column names, of course.
Thank you kindly.
Excellent, Keep it up! Hoping to connect soon on topmate...
Thanks Koushik 🙏
Excellent sir, only voice was low pitch but content was high quality. Thanks
Oh if that’s the case, I’ll try to improve the voice pitch. Thanks for your support🙌
Thats Greate ,keep posting amazing and valuable contents such this , thanks a lot and keep going we are waiting a new things
Thanks for the support. 🙏
Good to see you after a longtime sir, please make SQL queries + power bi advance project other than sales domain.❤
Thank you so much, hopefully this time I post videos regularly.
After a long time, Keep Posting amazing content, waiting for the advanced-level content
Thanks Avinash.
Excellent。Thanks for sharing 👍❤
Thanks Kebin for your kind words 🙌
hey, please make a complete list of SQL from basics to advanced projects. it would be really helpful for us.
did you check other SQL videos? Also: ua-cam.com/video/am-iy2KA1UA/v-deo.html
Hi Atikant, Regarding your Power BI Dax and Data Modeling course....Thanks for creating such a great content...this is Gold 🥇 so please complete that remaining part...is there any update regarding the module 7 and 8 . And please provide the Quick Guide (PPT) along with all the Modules, as you did for the Module 1 it will help us to maintain and refer the notes for the same.
Hi Ajit, thanks for your kind words. There are few changes in how DAX and Power BI will go ahead. If you have seen the updates from Microsoft, I’ll be modifying those content so that it will help everyone even more. The work is in progress. And yes, I’ll share the PPT for each module. 👍
❤❤❤ Brilliant
Thank you.
Thanku for making videos❤ please can you make a detailed video how to explain a dashboard in linkedin
Hi Gagandeep, could you please elaborate. What do you mean by this?
@@analyticalguy I want to say can you make a video how to write dashboard post on linkedin (problem statement , solution)
@@GagandeepSingh-vd9hd okay, I’ll try but I cannot commit to record a video for that. You may connect 1 on 1 where I can explain you in depth. :)
Hi please make videos on power pivot
Hi Nandagopal, let me know what all you want me to cover in power pivot. If you have any specific questions.
@@analyticalguy power pivot using DAX functions in excel
@@nandagopalsura That's a good suggestion. I will work on it, and share after my other scheduled videos :)
@@analyticalguy thank you so much I'm waiting for it
@@nandagopalsurasure.
Make the dataset publicly available. Ty
Hi Aditya, it has been made public. You can access now with the same link. :)
Good video but technically, this are basics, not advanced in Power Query. Advanced Power Query Cleaning and Transformation involves writing code in the Advanced Editor to perform specialized data cleaning ans transformation that is impossible using the Graphical User Interface
Thanks Abiola.