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

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

Maven Analytics

9 месяцев назад

320,607 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@quedaking1252
@quedaking1252 - 30.11.2024 22:40

I use power Bi. too many steps for me

Ответить
@elmekawy-v7m
@elmekawy-v7m - 02.12.2024 18:43

WOW your tutorial was incredible , THANK you ♥

Ответить
@heronleal3582
@heronleal3582 - 05.12.2024 00:58

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

Ответить
@GuyElhadef
@GuyElhadef - 05.12.2024 20:25

👍

Ответить
@jagansarah
@jagansarah - 06.12.2024 13:20

Great Maven, thank you

Ответить
@antonyroussel
@antonyroussel - 08.12.2024 12:36

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?

Ответить
@dennisbalajadia7714
@dennisbalajadia7714 - 09.12.2024 09:33

Thanks for sharing this. It is very helpful.

Ответить
@umiumi8741
@umiumi8741 - 09.12.2024 15:22

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

Ответить
@tugbaakdogan6066
@tugbaakdogan6066 - 11.12.2024 00:22

where are the project files?????

Ответить
@DoraWork-i3b
@DoraWork-i3b - 11.12.2024 18:23

This is an awesome tutorial. Thank you!

Ответить
@JerusalemArtichok3
@JerusalemArtichok3 - 13.12.2024 20:46

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

Ответить
@thebesttechnical3608
@thebesttechnical3608 - 15.12.2024 18:35

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

Ответить
@isukwithnames1811
@isukwithnames1811 - 20.12.2024 05:15

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

Ответить
@SaifJamChronicles
@SaifJamChronicles - 24.12.2024 23:41

Thank you.

Ответить
@sunny7859
@sunny7859 - 01.01.2025 22:20

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".

Ответить
@mavelsaldi3316
@mavelsaldi3316 - 05.01.2025 08:27

Cool♥️

Ответить
@shibusam8710
@shibusam8710 - 10.01.2025 10:35

Amazing skills ....

Ответить
@jasonb2553
@jasonb2553 - 19.01.2025 23:00

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

Ответить
@edaa1861
@edaa1861 - 21.01.2025 16:09

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

Ответить
@francishubertovasquez2139
@francishubertovasquez2139 - 25.01.2025 16:35

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?

Ответить
@francishubertovasquez2139
@francishubertovasquez2139 - 25.01.2025 16:41

5 days the initial solution.

Ответить
@francishubertovasquez2139
@francishubertovasquez2139 - 25.01.2025 16:49

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.

Ответить
@veronikaluneva9457
@veronikaluneva9457 - 28.01.2025 16:03

This is brilliant! Thank you so much!

Ответить
@ranveermane1083
@ranveermane1083 - 02.02.2025 10:19

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

Ответить
@rodahchep
@rodahchep - 04.02.2025 15:24

I'm so happy I came across this video

Ответить
@ericafath
@ericafath - 07.02.2025 18:42

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.

Ответить
@01yatin
@01yatin - 08.02.2025 17:38

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

Ответить
@RusdihartoSumardjo
@RusdihartoSumardjo - 09.02.2025 16:20

Thanks very much
for file sample and tutorial
thanks

Ответить
@MohdAsif-Alpha
@MohdAsif-Alpha - 10.02.2025 22:07

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

Ответить
@shrishailnaik1403
@shrishailnaik1403 - 12.02.2025 20:19

Awesome 👌🏻

Ответить
@sharifashikurrahman3314
@sharifashikurrahman3314 - 17.02.2025 21:22

Excellent!! thank you so much!!

Ответить
@francishubertovasquez2139
@francishubertovasquez2139 - 18.02.2025 08:05

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

Ответить
@onyemaifuma2805
@onyemaifuma2805 - 19.02.2025 00:24

GEM!!

Ответить
@BrandonKellyYT
@BrandonKellyYT - 19.02.2025 21:09

thank you!!!

Ответить
@rikoabdillah257
@rikoabdillah257 - 20.02.2025 13:46

absolutely enlightend and easy to follow , Thanks!

Ответить
@alvarhernandez2683
@alvarhernandez2683 - 23.02.2025 03:59

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

Ответить
@moniakarmi-c5z
@moniakarmi-c5z - 24.02.2025 19:05

Trente jours en trois ans; À lire pour calculer .

Ответить
@moniakarmi-c5z
@moniakarmi-c5z - 24.02.2025 19:07

Sur effets à mouvements retour sur liaisons horizontal;

Ответить
@jet-joyexceltraining8418
@jet-joyexceltraining8418 - 28.02.2025 18:19

Great

Ответить
@DaveDo-ht9mg
@DaveDo-ht9mg - 01.03.2025 22:47

That was wonderful

Ответить
@Mrfreshtollgate
@Mrfreshtollgate - 02.03.2025 05:04

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?

Ответить
@enverozdemir8209
@enverozdemir8209 - 04.03.2025 15:46

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!

Ответить
@alchemimi7
@alchemimi7 - 05.03.2025 06:41

interesting, thank you so much for this tutorial

Ответить
@TheIntellect8
@TheIntellect8 - 07.03.2025 00:38

Thanks for the helpful video. 👏

Ответить
@glassbottle15
@glassbottle15 - 09.03.2025 13:51

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.

Ответить
@glassbottle15
@glassbottle15 - 09.03.2025 14:08

very valuable video! thanks.

Ответить
@chandrakanth213
@chandrakanth213 - 09.03.2025 14:18

I luv you dudu❤

Ответить