Advanced Power Query Tutorial | 5 Practical Use Cases and Tips for Excel & Power BI Users | M Query

▶ Dataset Excel file for practice

▶ Have queries regarding Data Analytics or studying abroad? Get in touch!

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)

💡 END-TO-END POWER BI DASHBOARD
========================
End-To-End Power BI Dashboard Tutorial for everyone | Data Storytelling in 2023 | Data Visualization

📁 Data Analyst Resume:
================
Data Analyst Resume with No Work Experience | Step by Step Guide | Templates + Tips + Examples

🛑Data Analyst Journey:
=====================
How I would Study Data Analytics in 2023 (If I had to start over) | Schedule | Salaries | Skill Set?

Timetable And Efficient Strategy to Learn Data Analytics while Working | Improve Productivity

💡 LEARN MORE
========================

#powerquery #powerquery #powerbi #powerbitutorial

[serdip]

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.

[EmailPublicidade]

excellent tip. and if we want to add a list of columns, using a list of names query, how is it done?

[PreMathSci]

Thank you very much @analyticalguy for your detailed and insightful videos. I am a beginner in Power Queries, and I have watched and practiced twice using your previous video, which is 55 minutes and 10 seconds long. I found the content very easy to understand.
If possible, could you kindly share the practice file related to this video? It would be greatly appreciated and helpful for us. I watched along with the first example, but I had difficulty understanding the formula creation part. I also checked the shared files for practice, but I couldn’t find the exact data used in the video.

Thank you once again, and greetings from Sri Lanka!

[aboalbraa]

Thats Greate, keep posting amazing and valuable contents such this , thanks a lot and keep going we are waiting a new things

[koushikmitra]

Excellent, Keep it up! Hoping to connect soon on topmate...

[asdpal]

Good to see you after a longtime sir, please make SQL queries + power bi advance project other than sales domain.❤

[ajityadav-dbqq]

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.

[avinashgupta]

After a long time, Keep Posting amazing content, waiting for the advanced-level content

[rahulamesar]

Excellent sir, only voice was low pitch but content was high quality. Thanks

[shubhamsharma]

hey, please make a complete list of SQL from basics to advanced projects. it would be really helpful for us.

[GagandeepSingh-vdhd]

Thanku for making videos❤ please can you make a detailed video how to explain a dashboard in linkedin

[Abioladavid]

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

[AdityaSingh-rlis]

Make the dataset publicly available. Ty