Use Excel Like a PRO | Learn Power Query, Power Pivot & DAX in 15 MINUTES (project files included!)

[@MavenAnalytics]

Thanks for watching! If you liked this and want to learn more, check out our self-paced courses, guided projects, and create your own free personalized learning plan! 👉 mavenanalytics.io/

[@swatidas7069]

Can I use your course for free as I am unemployed since long. I want to learn from you.

[@juancarlosmiranda6830]

Hi, os cohort learning incluyes in the pro subscription maven pro?

[@Chris-at-Maven]

@@juancarlosmiranda6830 Cohort learning is a separate product. We run 10-week immersives for Power BI, Python, SQL, and Advanced Excel.

[@craigwatkins2285]

PQ is extremely underrated! I’m an old fart - but was tasked with quite a large excel project requiring data from 3 sources on a weekly basis - and then sending out an individual email to each person on my team containing their personal metrics. Seriously, I had never used excel. In the beginning, manually entering all the data weekly and then creating a pdf page for each metric and then emailing all the info to each operator - took me 6-7 hours on a Monday. But with age comes wisdom - started watching KZbin videos on the weekends… Leila, Randy Austin, this channel and a few more…. Holy cow! I learned VBA coding - and then PQ. What took me 6-7 hours to do now only takes me FIVE to SIX minutes each week! I applaud all the experts in this excel field and thank them all for the excitement I get when this old dog learns a new trick!

[@ferdirosa7547]

PQ, PP and DAX are pure heaven! People at my work are stunned what I can do with it. And frankly (and I don't say that off course), it's waaaaaaaaaaaay easier than all those pesky 30 foot long formules haha.

[@israelking975]

@@craigwatkins2285 Impressive! Thanks for the testimony.

[@craigwatkins2285]

@@ferdirosa7547 it’s funny you mention a “30 foot long formula”! My very first formula was a MASSIVELY LONG “IF” formula - had probably 25 cases in it. The following week, I stumbled across VLOOKUP… changed everything! 🤣🤣🤣

[@lavatr8322]

Just hire me as an intern ffs

[@Etude-pr5ru]

Can you teach me how you do please

[@pablotorobala954]

This is by far the best Excel tutorial I have ever seen on KZbin, and I've seen quite a few! Learned from this while performing my real life work following all these steps. Thanks!!!

[@Noble.Hustler]

Chris is truly legendary and if you haven't seen any of his full courses on Linkedin Learning etc, you really ain't seen nothing yet.

[@omolerebeautyolatawura5533]

This is the most powerful video on Data Analysis i have watched. Amazing! thank you so much

[@Chris-at-Maven]

So glad to hear that - thanks for the feedback!

[@jaypatkar]

Amazing Man ! Not a single second wasted and to the point. Probably the first tutorial on KZbin that I did not have to skip a single second. You Rock !!

[@Noble.Hustler]

Sir. Chris Dutton, it is so great to find you here on KZbin! I've watched much of your work including the 4hour DAX & Power Query CPE course you offered on LinkedIn Learning, and which I must say was simply priceless! It was my baptism by fire but totally did the trick. As such, I'm now happy to report that when it comes to Data Analysis and Expressions, I am eager and ready to hold my own any day, many thanks to your incredible professorial/ teaching skills!

[@IuliaElena97]

Can you provide a link for this course?

[@rezakian9829]

This is the most valuable channel I’ve subscribed to on KZbin. Thank you!

[@Jojms123]

After following a course in Udemy with this guy I am passionate about the way he can explain stuff! I have done other courses with Maven, but this guy has a very nice, detailed but simple way of explaining. Keep up, I will try to follow this on youtube as well.

[@ferdirosa7547]

He is the best, BUT, Leila Gharani is defenitly number two!

[@Anthony50009]

Enjoyed working through this example using the sample data provided and was really impressed with what can be achieved in excel without necessarily needing to use Power BI. Am in the UK so had an extra step to try to work out how to change the dates in the sales file from mm-dd-yyyy to dd-mm-yyyy. Thanks for the valuable content Chris!

[@Chris-at-Maven]

Nice! Did you use Power Query's locale option, or manipulate the actual date values?

[@Anthony50009]

@@Chris-at-Maven I eventually found that it is an easy step to highlight the date column in power query editor and right click the column header and select change type - using locale to date type and locale English (United States)

[@Chris-at-Maven]

@@Anthony50009 nice, that’s what I would have suggested trying first 👏

[@swatidas7069]

I am also from UK

[@israelking975]

Maven Analytics? YOU ROCK. Mav A For PRESIDENT. AWESOME WORK BRO.

[@Chris-at-Maven]

Haha thank you!

[@AfricanFashion_PrimeSpot]

This just helped me understand EXCEL BETTER...THANK YOU SIR

[@Zlomonn]

If you wanted to show that you know what you’re teaching, you nailed it

[@dtunni]

Hey, thanks. Long term excel user but not PQ PP or DAX user. Very helpful!

[@douglasteixeiracoelho5304]

I attended a Udemy course where you explained how to get started with Power BI. It was amazing and I learned a lot from you. I love the way you teach --> straight to the point, getting down to the most important details. I just want to say thank you for the great job you are doing. By the way, this video is great too! Thanks again!!!

[@Chris-at-Maven]

Thank you so much!

[@hardikdave_]

I'm on 65% on your Udemy course. This feels like a good refresher for the past lessons.

[@ferdirosa7547]

Hi Chris, I did several of your courses on Udemy. These are absolutely the best tools that I use in my work daily. THANK YOU THANK YOU!

[@zeeshansabro3163]

Great help. You really make my things easy through very interactive and easy-to-understand simulations.

[@Chris-at-Maven]

Glad you found it helpful!

[@JohnDChaney]

Nice work. Not only was the data analysist work explained well, the presentation is top notch.

[@MavenAnalytics]

Glad you liked it!

[@Chris-at-Maven]

Glad you found it helpful!

[@PatrickBateman12420]

It's Chris from MAVEN. What did you expect? He's an Excel Rock Star!

[@canadamike6397]

Fantastic overview! This was quick and thorough, exactly what I was looking for! Thank you!

[@thew5611]

i subscribed after watching this. ive never seen how power pivot and dax are used in excel. very helpful video.

[@Chris-at-Maven]

Thanks for subscribing!

[@chandrasamy8466]

Amazing mate, this is the most informative video I’ve come across about Data Analytics…a Big Thank You!

[@joyetapal5406]

Thank you Chris for this amazing video. I always love your contents as there is something new to learn everytime. When it comes to Excel, you are the Best Excel Wizard I ever found. I hope you keep teaching Excel for a very long time 🙏

[@Chris-at-Maven]

Thank you very much, I appreciate it!

[@santiagolopezgallo4736]

This is just mind-blowing 🤯

[@Chris-at-Maven]

Crazy powerful tools! 💪

[@bobdavis443]

Chris, Your tutorial on Power Query, Power Pivot and DAX is by far the best I've seen in KZbin. Just when I think I've mastered Excel, I find your videos and realize there is a LOT more to learn! Thanks for producing this tutorial. I will have to check out your other training courses.

[@Chris-at-Maven]

Thank you!

[@shankarmidatala2049]

I found your explanations simple and easy to follow, Thanks for sharing.

[@Libwebs]

Cannot disappoint as always. Super!

[@Chris-at-Maven]

Glad you found it helpful!

[@JaveriaKhalid-c5i]

Wanna like this thousand times the best teacher❤️

[@Chris-at-Maven]

Thank you for the feedback! :)

[@bumblebee1.0]

I'm definitely doing this course next. I'm so excited. I'm going to solve so many problems!

[@muraliiyer7850]

Wonderful, without PowerbI, Excel itself has all facilities like PBI. Great learning today, thanks a lot.

[@kishan0705]

This is Amazing, I got to know how I can swiftly use Power Tools in just 17 minutes. Thanks,

[@albedoguardian875]

Hands down to the best channel on YT

[@Jesus-is-Lord-Repent]

Wow I'm blown.. learned much much..keep sharing your skills 🙏

[@semiheser]

That's the best tutorial ever! So clear. Thank you!

[@elmekawy-v7m]

WOW your tutorial was incredible , THANK you ♥

[@StephanieDavis-vu3bu]

That was total AWESOMENESS!!!!!

[@Chris-at-Maven]

Glad you found it helpful!

[@mohaiminulislam6575]

Thank you for making such a amazing tutorial.

[@mikeguetti8349]

Wow this was fascinating!! I never knew excel was so awesome. THANK YOU!!

[@Chris-at-Maven]

It really is!

[@paulEmotionalaudio]

This is amazing! Thankyou for sharing your knowledge!

[@somnathray3492]

Simply Love it Chris! Thanks for showing Want more on DAX calculations thnks in advance

[@zidkumar08]

Awesome! This is one of best educational video I have ever seen. Thank you so much.

[@MavenAnalytics]

Glad it was helpful!

[@milanvulic7947]

This was crazy. Good job.

[@felixbln503]

YOU DID GREAT SIR.... WOW! AMAZING TUTORIAL, Liked and Subscribed Sir.

[@donharrold1375]

Fantastic! Super powerful if you know what to do!

[@farifarahani4641]

Excellent content and presentation. Subscribed. Interested in learning more!

[@shemustnotbenamed]

As always👏 Thank you for this awesome content.

[@MavenAnalytics]

Glad you enjoy it!

[@thebesttechnical3608]

Best Explanation at all.Proved such a helpful for me.

[@adelinogoncalves9963]

Wow this is the best presentation I´ve seen from a Data Analyst on YT, you´ve just gained 1 more subscriber. Well done Sir!

[@uc7602]

I just subscribed too! Thank you for including the DAX formulas for the calculated fields. This video was easy to understand and extremely useful. Thank you for saving me so much time!!!

[@Chris-at-Maven]

Glad you found it helpful, and thanks for subscribing!

[@lisitashamatutu1140]

Excellent work maven made this look so simple

[@ferdirosa7547]

Believe me, if you study this, it IS waaaaaaaaaaaaaaaaaaaay simpler then formulas.

[@dennisbalajadia7714]

Thanks for sharing this. It is very helpful.

[@eliadnahum7338]

Solid tutorial; super helpful! any additional videos on DAX specifically?

[@solarwinds-]

Great Vid, concise, to the point without side stories. The bosses will be amazed at the efficiency. But I fear a good performance would be rewarded with more of the same. Definitely use this, BUT don't let the bosses make the same request repeatedly. The first time is ok but politely let them know this can't be a habit. You work to live, not the other way around. I am SO GLAD I no longer have to work.

[@PatrickBateman12420]

tell them you worked all weekend and take Monday off 🙂

[@solarwinds-]

@@PatrickBateman12420 I no longerwork.

[@gilbertb2969]

I just subscribed.Whoa! You are amazing

[@christianwibowo6420]

In one video i have learn alot, Thank you so much

[@dinahany233]

thank u for best project demonstration .. u made t simple .. God bless u.. would u make more project tutorials plz ?????

[@junejaundoo3827]

Great content you’re sharing!

[@Morero1000]

Amazing presentation! Some great learning i got here!! Definitely following your work from now.

[@wilfredoseiwusu3507]

This is awesome. Thanks Chris

[@Chris-at-Maven]

Thank you!

[@francesdobbins2964]

This tutorial is a game-changer for me! Thank you

[@yuhooh]

Thanks Chris, I've follow you from LinkedIn course.

[@muneebbolo]

Amazing to see this great tutorial ♥ Thank you so much, Chris.

[@DoraWork-i3b]

This is an awesome tutorial. Thank you!

[@M_le-n4r]

This makes excel so much easier to use. I hate all the formulas. Tysm

[@weslleypinheiro5909]

Simple, fast and straight to the point 👏🏻👏🏻

[@khinyaminn6293]

Awesome. Thank you very much. The best teacher 🙏

[@Chris-at-Maven]

Thank you!

[@juanr0919]

Amazing video, learned so much

[@bigmo931]

Great demo!!!

[@AncientWonders-g5q]

I bought your course still i am watching it is very nice

[@connclissmann6514]

Great intro, thanks.

[@erickshioso8227]

Wow! Marvelous Maven Analytics. Had to subscribe after watching this. Otherwise i need to have a word with George from IT!😂

[@Chris-at-Maven]

Thanks for the feedback, and for subscribing! George thanks you :)

[@makarand1985]

Great Video Maven !!!

[@sallyho146]

Thank you for the video. I use Dax formula to write Text over value for monthly status. That’s very helpful for users who use the text to track the expenses against the headcount. Btw, do you know how many DAX formulas are out there?

[@PatrickBateman12420]

Great. However, I would argue that the value from DAX is being able to combine different tables for calculations ...

[@KongReiDigital168]

Thanks so much! This is really helpful!

[@ajibolaazeez104]

Hi Maven, Thank you so much for the great work. Can you please share the source of the data you used for the analysis? I would like to practice with them. Thank you

[@Chris-at-Maven]

Link in the description!

[@Wowdex8]

hello, on the DAX revenue formula, how is it determining which quantity row matches the price row in the other table? also, what is the reason for a calendar table when you can use the date from the quantity table, then group in the power pivot by month if you wanted? thanks!

[@Chris-at-Maven]

Good questions! For the Total Revenue formula, the RELATED function acts like a lookup, that basically traverses the relationship between the Sales and Products tables to retrieve the correct unit price for each row in the Sales table. As for the calendar table, it's much more flexible (and scalable) to have a dedicated table containing any date/time fields you might need, including ones that aren't available in the default PivotTable grouping tools. I also tend to avoid PivotTable grouping because a) it can get messy, and b) those grouped fields ONLY exist in the context of that pivot, and can't be used in other measures (this is the same reason we always recommend explicit vs. implicit measures). Hope that helps!

[@hoodedgood]

I like this. I don’t currently use excel this way but it would be cool for some on the fly work. Normally what I would do is use python and pandas to insert the data into my sql server and then manage the query on the back end and re-run the process when new data source files are added. I could run this code whenever new files are added to a specific folder or sharepoint… that does take more time and you need to learn Python / vba / sql.

[@Amitosh86]

Great video! Thank you so much for putting it together! With the help of your video, I created a file that pulls data from several tables in an ODBC which requires monthly refreshing which does take a lot of time. - Is there any way to make it so that instead of ALL tables being refreshed, only certain ones do? - Is there a way to make it so that data within a table only refreshes from a specified date? For example, if the data for the years 2018 to 2023 is never going to differ from refresh to refresh, set it up so that that specific data doesn't change but everything since 01/01/2024 refreshes? Hopefully, I'm making sense. Thanks again!

[@Chris-at-Maven]

Yes in the Queries & Connections pane you can right click a query, view properties, and deselect the "Refresh this connection on Refresh All" option. As for loading only incremental data, there are a few ways you could potentially approach it depending on the context. I'd recommend searching the Microsoft Answers Forum to explore some options!

[@Amitosh86]

@@Chris-at-Maven thanks Chris!

[@jagansarah]

Great Maven, thank you

[@fewazbenachi6081]

I subscribed in the first 3min of the video, ❤❤❤. Wonderful and great 👍

[@fewazbenachi6081]

I have question, after doing all work in excel, I can use power bi without any more formatting?? Is it right

[@Chris-at-Maven]

@@fewazbenachi6081 you can import an entire Excel model into Power BI, which preserves your model, DAX measures, etc.

[@user-ep7dq5wn9]

This was awesome

[@Chris-at-Maven]

Glad you enjoyed it!

[@funny_nikky1537]

In the data set, there are different currencies. Does Excel automatically converts any other currency to USD based on the actual exchange rate at the time of opening the document?

[@lovelyblackskin4565]

His Udemy on this is priceless

[@Chris-at-Maven]

Glad you enjoyed it!

[@PatrickBateman12420]

Cheaper for a single MAVEN course? Yes! However, on the MAVEN site, you learn so much more you might have never bought on Udemy .... my two cents

[@AncientWonders-g5q]

I got his udemy course

[@ibrahim82649]

Can you share the name of the course ?

[@johnboscoobi4529]

Please share the link to the particular course you're referring to. Thanks

[@onyinyeMbonu-c6f]

I am an upcoming data analyst and i really enjoyed this video and have also learnt a lot from it. My question is, how do I get the data that you used, so that i can also practice by myself. Keep it up. I have also subscribed

[@stefankleinhans4895]

Thank you for this video. It provided some use full information. Will I be able to use 1 sheet with 1 data table and convert it to power query, or does this tool mostly work with multiple data sources big data type scenario. I am creating a more interactive and details budget dashboard and would like to try this if it means to improve the performance and the formula structure... cause excel formulas that i used are crazy

[@alexandertaylor2960]

I love Excel. It’s making me look so good at my job in the military lol

[@sohailarshad426]

Thanks ,some pretty good tips , But I have some problems following 1-My Sub- categories split out in another column 11:47 2- Dax Formula always gives an error , I wish I could upload screen shots.

[@aroglobal1]

Thank you, Chris.

[@Lavendergirl_8649dti]

Thanks for the amazing video

[@akamike2101]

Thanks Bro. you are one in a million

[@SANDATA764]

So freaking good , thank you

[@Chris-at-Maven]

Thank you, this was a fun one to put together 😊

[@SANDATA764]

@Chris-at-Maven, we need to see in different platforms like big data. As you know, most enterprises are using the Oracle database, so please make more projects based on Oracle.

[@Chris-at-Maven]

@@SANDATA764 we’re starting to build some new courses in cloud/analytics engineering soon - stay tuned!

[@asifjambagi8732]

It's just awesome, thanks for this video

[@ninors51]

Wow! so valuable is this video!😮😮 Amazing!! 🎉🎉🎉 Thanks!!

[@andrehinojosa1198]

This was a great breakdown of connecting some seemingly disparate features. One question I have, is it better to merge tables or just create a relationship via data model? In which case would one or the other be preferred. I have a data set that requires a ton of xlookups, but feel it might be overkill by merging all the tables into one. Thanks!

[@osoriomatucurane9511]

Stay away from binding/merging/combining/joining tables. That is the point of database, effient data storage and management. Just relax and rely on the keys to relate the relevant tables and leave the rest with DAX to perform the relevant calculations with the concerned fields in related tables. Ocasionally you may join one single or two fields from one table ou two tables. Not all fields

[@andrehinojosa1198]

@@osoriomatucurane9511 fair, I only every join a field or two from each table, not trying to create some sort of master table. But as I am using more array formulas (filter, sortby, etc.) it feels like merging queries is actually easier than using power pivot/ data model. I guess it depends on the final output

[@louiseshorten9389]

Great video, thanks!!

[@longager]

Great and informative video! A question: Wouldn't it be possible to do all the steps in Power Query? E.g. use the 'Merge' function in PQ instead of building relations in Power Pivot. The reason I am asking is that when you merge big datasets i PQ it often gets very slow so maybe this method with using Power Pivot is a better practice - or is it more to show the different options available? Thx

[@Chris-at-Maven]

You could, but generally speaking merging tables is much less performant than configuring relationships in the data model

[@Appcodecafe]

Very nice work, thanks

[@chesko7753]

Thanks for this great insight I follow through but had issues with the Ordered dates in the sales sheet from the file you shared. It has errors meanwhile the one you used to demonstrate does not. Is there a reason for this?

[@diassetefle9775]

Very useful tutorial,👍👍👍

[@Chris-at-Maven]

Thanks for the feedback!

[@KKB-tt4lj]

Well explained! Thanks!

[@xeeshanahmad8757]

Yes💪, I did it. Thank You very much .