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?

[@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! 🤣🤣🤣

[@AfricanFashion_PrimeSpot]

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

[@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.

[@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?

[@hyperadapted]

What. I work with PowerBI for a year as a Business Analyst and only NOW I see what Power Query can do? I mean, I love excel and getting really good in PowerBI and DAX but this opens up a whole new dimension! Love it!

[@Zlomonn]

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

[@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!

[@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!

[@dtunni]

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

[@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!

[@rezakian9829]

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

[@canadamike6397]

Fantastic overview! This was quick and thorough, exactly what I was looking for! 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!

[@hardikdave_]

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

[@albedoguardian875]

Hands down to the best channel on YT

[@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!

[@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

[@chandrasamy8466]

Amazing mate, this is the most informative video I’ve come across about Data Analytics…a Big 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!

[@israelking975]

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

[@Chris-at-Maven]

Haha 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!

[@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!

[@JaveriaKhalid-c5i]

Wanna like this thousand times the best teacher❤️

[@Chris-at-Maven]

Thank you for the feedback! :)

[@paulEmotionalaudio]

This is amazing! Thankyou for sharing your knowledge!

[@shankarmidatala2049]

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

[@bumblebee1.0]

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

[@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!

[@muraliiyer7850]

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

[@christianwiah4526]

Cannot disappoint as always. Super!

[@Chris-at-Maven]

Glad you found it helpful!

[@bigmo931]

Great demo!!!

[@santiagolopezgallo4736]

This is just mind-blowing 🤯

[@Chris-at-Maven]

Crazy powerful tools! 💪

[@semiheser]

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

[@gilbertb2969]

I just subscribed.Whoa! You are amazing

[@connclissmann6514]

Great intro, thanks.

[@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.

[@weslleypinheiro5909]

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

[@eliadnahum7338]

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

[@durcastraushun288]

I do not have a clue of all that you said, but I finished the video. I use excel all the time in my 3d job, but data is kind of interesting too. Thank you. I will try to practice, and if I find it interesting, I will come back to this video.

[@ferdirosa7547]

Data rules!

[@osoriomatucurane9511]

I perfectly understand what you mean. It is Not easy at all to get hang of it if you work with flat files (all records in one single file). Check his video on database normalization. Efficient data storage is achieved with data kept in separate related tables/lists objects. PQ and PP are tools useful in typical data analytic workflow: Extract Data from different sources, Clean/transform, Load, Modelling (combine/link), Analyse/describe (summary stats, grouping/aggregate) and Visualize/Share

[@Jesus-is-Lord-Repent]

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

[@milanvulic7947]

This was crazy. Good job.

[@StephanieDavis-vu3bu]

That was total AWESOMENESS!!!!!

[@Chris-at-Maven]

Glad you found it helpful!

[@felixbln503]

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

[@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

[@christianwibowo6420]

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

[@somnathray3492]

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

[@kishan0705]

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

[@farifarahani4641]

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

[@junejaundoo3827]

Great content you’re sharing!

[@M_le-n4r]

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

[@mohaiminulislam6575]

Thank you for making such a amazing tutorial.

[@muneebbolo]

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

[@donharrold1375]

Fantastic! Super powerful if you know what to do!

[@Zesiddiq18]

Amazing. ETL never seemed so interesting.

[@lisitashamatutu1140]

Excellent work maven made this look so simple

[@ferdirosa7547]

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

[@dinahany233]

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

[@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 ...

[@nironaicker7249]

Amazing 👏 thank you

[@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!

[@shemustnotbenamed]

As always👏 Thank you for this awesome content.

[@MavenAnalytics]

Glad you enjoy it!

[@zidkumar08]

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

[@MavenAnalytics]

Glad it was helpful!

[@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

[@Morero1000]

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

[@makarand1985]

Great Video Maven !!!

[@mikeguetti8349]

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

[@Chris-at-Maven]

It really is!

[@AncientWonders-g5q]

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

[@francesdobbins2964]

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

[@wilfredoseiwusu3507]

This is awesome. Thanks Chris

[@Chris-at-Maven]

Thank you!

[@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!

[@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.

[@juanr0919]

Amazing video, learned so much

[@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!

[@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!

[@KongReiDigital168]

Thanks so much! This is really helpful!

[@ewanharris5433]

Awesome Thx for sharing

[@arowojoluglory821]

Thank you, Chris.

[@AliTwaij]

Amazing but not as beautiful as Tableau, although its so much cheaper though. Many thanks for this mate.

[@yuhooh]

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

[@louiseshorten9389]

Great video, thanks!!

[@user-ep7dq5wn9]

This was awesome

[@Chris-at-Maven]

Glad you enjoyed it!

[@khinyaminn6293]

Awesome. Thank you very much. The best teacher 🙏

[@Chris-at-Maven]

Thank you!

[@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?

[@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

[@lisaward611]

My hero! ❤❤

[@Chris-at-Maven]

🦸‍♂😆

[@asimmuhammad280]

Thank you

[@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

[@sik9802]

I hope the course would have screencap or descriptions of what to do on each step so we don’t have to pause the video to see what we need to input on keyboards to follow the work. This is an illustration of I mean on the STEP1: Connecting data with Power Query - 04:39 - Connecting to a CSV File o Data/ Input- Sales w/s/ Transform o View/ the column quality, col distribution, col profile o home / close and load to / Only Create Connection + Add this data to the Data Mode o o Data/ Input- Product w/s/ Transform o View/ the column quality, col distribution, col profile o home / close and load to / Only Create Connection + Add this data to the Data Mode o - 05:53 - Connecting to a PDF o Select entire folder o View/ the column quality, col distribution, col profile o Col ID/ unselect Page001, Page002 o Col Date/ expand tables o Remove the other col (except col 1 -3) o Home/ Use first row as Header o Rename PROPERTIES “Stores” o home / close and load to / Only Create Connection + Add this data to the Data Mode o - 07:26 - Creating a Calendar Table o Right click “Queries & Connections”/ Duplicate sales o Delete all col except “Order_Date” o Rename col “Date” o Rename PROPERTIES “Calendar” o Add Col/ Date/ Day/ Name of Day o Add Col/ Date/ Week/ Start of Week o Add Col/ Date/ Month/ Start of Month o Add Col/ Date/ Year

[@donharrold1375]

This is one of the least understood but most powerful features in Excel

[@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

[@akamike2101]

Thanks Bro. you are one in a million

[@abdulwahedissa.8175]

Great work only I have problems with pdf file I am using Excel 2019 no choice to insert pdf data if changes to Excel CSV better to complete practice

[@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!

[@Yasir7184]

This is Awesome

[@Chris-at-Maven]

Thanks! This was a fun one to shoot :)

[@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?

[@alexandertaylor2960]

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

[@Appcodecafe]

Very nice work, thanks

[@ninors51]

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

[@MCdat123]

Awesome, thanks

[@Chris-at-Maven]

Glad you enjoyed it!

[@xeeshanahmad8757]

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

[@sallyho146]

How to add “$” sign in front of sales number, i.e: 50.55M when I coded the 50,550,000 in format cell-> custom format -> 0.00M