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

I luv you dudu❤

very valuable video! thanks.

I’d be asking for overtime lol. But on a serious mote, since some companies don’t like that word, I’d have to ask her to reschedule the meeting. I finish work at 4, computer is off.

Thanks for the helpful video. 👏

interesting, thank you so much for this tutorial

Hi - I am from the UK. When I insert the 'Sales' file into Power Query, it shows 38,540 errors and the issue seems to be around the order_date column. I have tried changing from English UK to English US but there seems to be errors still. If anyone can help, it would be much appreciated. Thank you!

What if I want to refresh my Power Pivot daily? Based on daily refreshing source files? Which drop into new daily folders according to the date? Can I relink the data models from the one workbook to the new files or do I have to start from scratch?

That was wonderful

Great

Sur effets à mouvements retour sur liaisons horizontal;

Trente jours en trois ans; À lire pour calculer .

im in love of your level, I feel that I am a rookie,

absolutely enlightend and easy to follow , Thanks!

thank you!!!

GEM!!

My soldiers, starting now catch the network bullies. Let it be

Excellent!! thank you so much!!

Awesome 👌🏻

Calendar Project file has issue with order date. with 38K+ rows showing me Error. I couldn't do continue project along.

Update : issue was m-dd-yyyy, mine is set as dd-mm-yyyy, had to sort that out. i've followed every step sincerely but last DAX step where i've to SUMX for total revenue, It's just doesn't work. Formula is invalid

Thanks very much
for file sample and tutorial
thanks

He is brilliant. He explains perfectly, I have seen his many videos on Udemy. Awesome teacher 👏

I've learned so much from this video.... but what about if the data is in an Excel file but on two different worksheets in one file and one worksheet in another file. How would I create connections between that data? Or is that not possible. I've tried a variety of things and nothing is working.

I'm so happy I came across this video

Very concise and to the point video!! Thank You!

This is brilliant! Thank you so much!

If static the electricity at the surface maybe coz it's your own company creation cover you have mode pathway on that staticity to navigate through that. The way the frequency of fixed per data horizontal tunable at surface layer have moving frequency identity assess at 2 ND layer, of that's the tech, it's genius.

5 days the initial solution.

I have created obstructions to marks types for the probe, then they're rooting on the belief of faith sealers type with mind manipulate and irritating interferrance of attempt making the unusual, usual. Double to triple agents a trend now?

hi maven, can you add tableou projects for to ımprove on data analysis please? as ı have macbook ı don't use powerbı and ı dont learn it as ı dont have another computer:( ı like your videos so please help :) thanks

That was ridiculous. A TON of data packed into this 17.5 minute.. although in reality for me its an hour and a half video because I'm going to have to watch it again and again... :) Definitely my type of video, no fluff, just information. Great job!!

Amazing skills ....

Cool♥️

Hi. In Dax total revenue formula had no errors. But got error message after executing the formula. "Could
Not add the field total revenue to the pivot table because the formula is invalid".

Thank you.

Which Maven Udemy Excel course would you recommend for a beginner looking to get Into Data Analysis?

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

The think is I keep forgetting every single thing I have learnt come tomorrow. Some people have bladder leakage, but I have brain leakage 😭

This is an awesome tutorial. Thank you!

where are the project files?????

how we approach server AQL file .....?

Thanks for sharing this. It is very helpful.

Hi! I've been trying to find ways NOT to use VBA, but I haven't been able to find a way to trigger an action (whatever that might be - just say calculate a formula in a cell), based on user interaction without it.
Is there a way to perform an action if a user clicks on some kind of button or link etc, without using VBA?

Great Maven, thank you

👍

pivotables with costs, %, dates.... all the videos are the same. I am looking something like a survey in a datacenter where I find the building number, room number, serial number, rack number, device function...

WOW your tutorial was incredible , THANK you ♥

I use power Bi. too many steps for me