[[ 3 HOURS ]] Complete Power Query End to End - PowerBI Tutorial { End to End } Full Course Beginner

This FULL course in Power Query, In this video will cover how to write Power query in power bi development. We go through Creating a data transformations, handling data, query folding , data preview and many more concepts.
#PowerBI #PowerBIDesktop #PowerBITutorials
▬▬▬▬▬▬▬▬ Power BI - POWER QUERY- Tutorials - FULL COURSE ▬▬▬▬▬▬▬▬
1) 03:44 - Introduction
Power Query VS Power Pivot VS Power View
2) 12:37 - Excel Transformation
Remove Headers, Rows
Fill gaps, Unpivot
Data Types
3) 25:02 - Common Transformation
Split, derive a Column , remove Column
4) 37:32 - SQL Equivalent Transformation
Append Union / Union All
Merge Left/ Right/ Inner Join
Group By
5) 59:12 - Business Scenarios
Sort by month, Derive Age, Stored in Enter data,
Reading Multiple Excels, Split the delimited value into rows,
6) 01:41:58 - Data Preview Options
7) 01:49:04 - Handling nulls or blanks
8) 01:57:53 - Query Folding in Power BI
9) 02:09:17 - Power Query Tips & Tricks
Column From Examples
Reference vs Duplicate in Power Query
Query Dependency
Change Connection source / Source Type
Source Files:
1) Excel Transformation :
docs.google.com/spreadsheets/...
2) Append:
drive.google.com/file/d/1nCsH...
drive.google.com/file/d/1ZCA5...
3) Merge
drive.google.com/file/d/1fu1w...
4) Excel Automation / Reading Multiple Excel Files
drive.google.com/file/d/1wvFR...
drive.google.com/file/d/1qPMF...
drive.google.com/file/d/1qPMF...
drive.google.com/file/d/1qPMF...
drive.google.com/file/d/1qPMF...
drive.google.com/file/d/1qPMF...
✉ Business Queries / Analytics Consulting ✉ : [e-mail]
💬 For Learners Post queries and Interact 💬
Telegram Channel - t.me/analyticswithnags
Linkedin Page - / analyticswithnags
Complete Playlists
Power BI Tutorials - Complete Playlist 📚📖 • How to do Power BI Ins...
Power BI Desktop Tips and Tricks 📚📖 • How to Remove Top N ro...
Power BI DAX - Complete Playlist 📚📖 • What is DAX in Power B...
Power BI Services Playlist 📚📖 • Introduction to Power ...
Power BI Project Dashboards - Power BI Realtime Projects - Playlist 📚📖 • Loan disbursement Anal...
Data Warehouse Tutorials 📚📖 • Introduction | Data Wa...
SQL Full Course | SQL Tutorial For Beginners 📚📖 • Learn SQL Complete | C...
SSAS Tutorials - SQL Server Analysis Services 📚📖 • Introduction to SQL Se...
SSIS Tutorials - SQL Server Integration Services 📚📖 • Introduction to SQL Se...
Power BI Interview Topics 📚📖 • What to Expect in Powe...
MSBI (SSIS,SSAS,SSRS) Interview Topics 📚📖 • What to Expect in MSBI...
Excel for Data Analysis 📚📖 • Analytics with Nags Yo...
Power BI + R 📚📖 • Analytics with Nags Yo...
Azure for Analytics - Complete Tutorials 📚📖 • Analytics with Nags Yo...
Catch with Nags 📚📖 • Catch Up With Nags - I...
Nags Checklist 📚📖 • 5 Things to Consider w...
Visuals with Nags 📚📖 • Visuals With Nags - Intro

[@lucmpangaje8727]

I have been following you and benefiting from your POWER BI video. They are awesome and straight to the point. Thanks, from all you do to the POWER BI community.

[@AnalyticswithNags]

Most welcome, Keep Learning

[@shajahan-cp3fu]

A Big Thanks to you Nag ⭐!! learnt a lot of things. Moving forward to Visuals and Dashboard

[@AnalyticswithNags]

Glad to help

[@lekansunday6679]

You are a fantastic teacher. Your videos are simple and comprehensive. Please check the classification for the age group video; I think youth should stop at 29 so that it does not clash with the beginning of the middle age of 30. Great teacher!!!

[@AnalyticswithNags]

Thanks for your feedback. Keep learning

[@jaikishank]

Hi. Deeply appreciate your sincere efforts for dissemination of the Power BI Knowledge to the world. Got immensely benefitted by your simple way of teaching. God bless you.

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@arpitjain3132]

Thanks a lot. Amazing content!!!! :)

[@AnalyticswithNags]

Thanks keep learning

[@user-sy5gz4pg8r]

Thank you for the insightful video. Very helpful.

[@AnalyticswithNags]

You are welcome

[@tarunprajapati2952]

This tutorial is good , enough and compressed power query video... Really thank you sir..

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@ParthasarathyLS]

Excellent Video. It was a very good learning experience

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@shreyamukkawar2989]

Awesome Man ! wonderful video😀

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@Learner-hg4hj]

Awesome explanation sir ! Best video covering all the nuances and intricacies of most important scenarios ! Thank you very much

[@AnalyticswithNags]

Thanks keep learning, share this channel with friends and colleagues

[@jamaluddin4308]

Thanks. Just awesome teaching!!

[@AnalyticswithNags]

You're very welcome!

[@SonuSonu-uh2er]

Superb video Sir. Thank you for making this video.

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@balamurugan3901]

Really helpful..thanks a lot...Please keep educating us...🙏🙏🙏

[@AnalyticswithNags]

It's my pleasure

[@sowmyasrinivas6259]

Thank you for the insightful video. Very helpful for me

[@AnalyticswithNags]

Glad it was helpful!

[@nashizanwar7578]

good way of teaching and making concepts easily understandable ... love from pakistan

[@AnalyticswithNags]

Welcome

[@OmkarUmbre]

Very Informative and in easiest way...

[@AnalyticswithNags]

Thanks for liking

[@datawizibility]

Thank you So much for the great contents. God bless you bro.

[@AnalyticswithNags]

So nice of you

[@surajdhumal4187]

Thank you for such amazing content... Please upload end to end power bi service also.. Thank you

[@AnalyticswithNags]

Soon we will upload

[@razzrazz9697]

Thank you so much for responsed my comment It is useful for everyone

[@AnalyticswithNags]

It's my pleasure

[@RajSingh-vb5wl]

Very nice video. I way u explain is very good. 👍

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@rashmimkonnura1136]

Ultimate session sir ..seriously thank you so so much for the informative Vid🙏🙏🙏🙏☝☝

[@AnalyticswithNags]

Always welcome

[@rishithasartcreativitybook4740]

good morning !informative and useful videos. many thanks. i would like to share one difference between replace values and conditional column i.e in condition column, we can fix one default condition in else statement for future data. for ex: in else "other state/new state..." which can not fix any value/condition before getting future data in REPLACE VALUES.

[@krishnachaitanyapanangapal6307]

Thank you very much Iam much confident than before

[@AnalyticswithNags]

All the best

[@kirangarud163]

Thanks Nag...

[@AnalyticswithNags]

Keep Learning

[@dhanalakshimikonda5486]

Thank you sir for good content

[@AnalyticswithNags]

Always welcome

[@deeppatel4002]

Your are the Best Sir . Your Videos are easy to understand . Thank You Please make a Full end to end Video for Tableau , statistic and Python For data analyst Only.

[@AnalyticswithNags]

Sure I will

[@deeppatel4002]

Thank You sir @@AnalyticswithNags

[@thrwtslm8573]

Thanks very much

[@AnalyticswithNags]

You are welcome

[@sumibharali4061]

❤ awesome 👍

[@AnalyticswithNags]

Thank you! Cheers!

[@rajeshsraj]

Analytics with Nags always ROCKS !!!

[@AnalyticswithNags]

Thanks keep learning

[@nishantpurohit100]

Hi, thanks for your videos, plz make videos on Python data analysis.

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@hashanpeiris7266]

Thankz

[@AnalyticswithNags]

Welcome

[@hanumanthreddyreddy1602]

Superb sir

[@AnalyticswithNags]

Thanks keep learning share this Channel with friends and colleagues

[@saketsrivastava84]

Nuce video

[@AnalyticswithNags]

Thanks

[@samsonshewangizaw9971]

Amazing

[@AnalyticswithNags]

Thanks

[@ritudahiya6223]

Thank you naga. Your videos are so beneficial and simple to learn. Please answer one of my question. Is this video enough to learn complete power query or need to refer some other source as well? Please reply

[@AnalyticswithNags]

Thanks. Yes this covers almost everything

[@ritudahiya6223]

Thank you for replying

[@randeniya3697]

hi,highly appreciate your support to gain overall knowledge of power query.can you recommend books or any other resources to explore more.Thanks again.

[@AnalyticswithNags]

I can’t recommend because all knowledge I gained through my experience

[@randeniya3697]

Thanks.

[@aravindkumarak2838]

hi sir, i am learning power bi by your videos and also by google, coming to ETL tool SSIS Or ADF which one I have to learn, plz suggest me

[@AnalyticswithNags]

SSIS first … then go for ADF

[@himanisakhare6326]

hello sir. how are you doing ? I hope you are doing well ! ITS JUST AN REQUEST THAT PLEASE MAKE AN VIDEO ON WHAT PARTICULAR TOPIC ONE SHOULD LEARN AND WHAT TOPICS WE SHOULD LEARN FIRST AND WHAT NEXT IN POWER BI FROM A COMPLETE BEGINEER TO KIND OF KNOWLEGEABLE PERSON WHO KNOWS QUIET WELL ABOUT POWER BI, I AM AT SOMEWHERE IN a INTERMEDIATE STAGE BUT STILL CONFUSE about HOW TO APPROACH THE ROADMAP TO LEARN THE POWER BI AND POWER BI SERVICES

[@AnalyticswithNags]

Watch power Bi complete playlist

[@minakshityagi7785]

Sir, please make a full video of the power pivot concept and give a deep explanation of data modeling from start to finish.

[@AnalyticswithNags]

will try my best

[@sureshrao174]

Remove duplicates means it will remove duplicate from the data presents in the entire single/multi rows

[@AnalyticswithNags]

Yes

[@praveentanikella4078]

Have a doubt that in case removing 1st row we can use promote headers couple of times until it seems good.

[@AnalyticswithNags]

Yes

[@anuragshrivastava7855]

please try to provide in video in 1080P, content is good

[@AnalyticswithNags]

will try

[@poornimarao3455]

Hi..Are you planning to make playlist on ADF ??

[@AnalyticswithNags]

Yes. That is the plan for this year. Thanks keep learning share this channel with friends and colleagues

[@jithendratata3259]

Thanks for uploading this video...can you please share source file

[@AnalyticswithNags]

check the Description, we have updated now.

[@Kushdevfam]

Nag sir do a video on lookup values in excel

[@AnalyticswithNags]

Excel analytics will be separate playlist will do it soon.

[@chetanshinde1992]

Thanks sir for uploading this video sir can you please share source file

[@AnalyticswithNags]

check the Description, we have updated now.

[@sanatabassum3445]

Sir we have a table with east 34%, west 68%, north 20%, south 35% in sql,when iam loading it to power bi and creating a pie chart the west region changed to 70%, why the value changed pls answer.

[@AnalyticswithNags]

Pie chart shows the value as 68 but in percentage it will 70% I.e from total 34+68+20+35=157 the 68 is 70%.

[@dilipkumar-ck1nc]

Tq can u make a video convert snowflake to starschema

[@AnalyticswithNags]

Noted. We will do it soon

[@sumibharali4061]

Can you make video on interview questions

[@AnalyticswithNags]

check the playlists

[@machaaadipoli6941]

Hello sir, what is the importance of learning MSBI TOOLS when we have Powerbi. Is industry looking for MSBI along with Powerbi..?

[@AnalyticswithNags]

Answer in this video kzbin.info/www/bejne/eXa9dqp3pMh1b7M

[@Rakesh_RV]

Prepare data in Power BI Desktop Load data in Power BI Desktop Model data in Power BI Desktop, part 1 Model data in Power BI Desktop, part 2 Create DAX calculations in Power BI Desktop, part 1 Create DAX calculations in Power BI Desktop, part 2 Design a report in Power BI Desktop, part 1 Design a report in Power BI Desktop, part 2 Create a Power BI dashboard Perform data analysis in Power BI Desktop Create a Power BI paginated report these all are available in you playlist??

[@AnalyticswithNags]

yes. check the channel videos

[@VipulArya-lx2cr]

sir can you please upload the source file for calc of birthdate example.

[@AnalyticswithNags]

Check description. If file not exists practice with your own dataset

[@arjunvenkat3329]

Bro iam from science background can i learn power bi???

[@AnalyticswithNags]

Follow the career guidance playlist. You will get the answers

[@ravindrav-kb4mw]

where can i get all this excel files , so that i can practice

[@AnalyticswithNags]

All for your understanding, practice with your own dataset

[@cargouvu]

Can we save the steps and send to a co-worker?

[@AnalyticswithNags]

yeah sure

[@jithendratata3259]

Sir can you please share source file to practice.. please

[@AnalyticswithNags]

check the Description, we have updated now.

[@ravireddyism]

@@jithendratata3259 you are confused and misleading. You said you got a job as a PowerBI developer then again you want it to practice.

[@sanatabassum3445]

sorry but not getting, the percentage of 68 is 43.31 know, 68/157*100 to know percentage of value.

[@AnalyticswithNags]

Not sure what is your issue

[@sivajigade5053]

Upload Resource file plz bro

[@AnalyticswithNags]

check the Description, we have updated now.

[@a123457627]

Nav?

[@AnalyticswithNags]

net asset value

[@swapnadeep2550]

Upload the source file please....

[@AnalyticswithNags]

check the Description, we have updated now.

[@swapnadeep2550]

@@AnalyticswithNags Thank you so much😊

[@ramshataqdees5570]

Later Source Files are missing

[@AnalyticswithNags]

didnt maintain

[@godbhaigod]

u r teaching like we are familiar with every option in the editor, waste

[@AnalyticswithNags]

First learn basics of power bi using complete playlist. Then come to advance videos like this