Learn Power Pivot in Excel (Better Than Pivot Tables)

Подписаться 526 тыс.

Просмотров 80 тыс.

50% 1

Learn Power Pivot in Excel full tutorial.
🚀Get the FREE Data Analytics Guide from Hubspot: clickhubspot.com/zsm
🆓 DOWNLOAD Free Excel file for this video: careerprinciples.myflodesk.co...
In this tutorial on Excel Power Pivot, you'll learn all the essentials of Power Pivot and how to use it with real examples. Power Pivot is a super powerful data analysis tool, where you can combine multiple excel files into one, create relationships between different tables, and work with datasets much larger than what Excel can handle. You can even make pivot tables with not just one table like is Excel's limit, but with multiple tables as well.
LEARN:
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Intro
0:35 - The Dataset
1:18 - Power Pivot Basics
3:01 - Establishing Relationships
5:14 - Power Pivot Calculations & Measures
8:04 - Data Analysis With Power Pivot
9:23 - KPIs and Other Visuals

Опубликовано:

19 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

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

@KenjiExplains 4 месяца назад

🚀Get the FREE Data Analytics Guide from Hubspot: clickhubspot.com/zsm

@SathishKumar-oq7tz 4 месяца назад

Thank you Kenji, looking forward for the next part of it. 😊

@smc7688 4 месяца назад

Thanks Kenji! Need Part 2 video explaining basic and essential DAX measures. Crisp and clear explanation makes your channel unique. Congrats!🎉

@jsimmons834 Месяц назад

I like your vids that they are precise and not meandering with small talk of sort. THX

@abdirazakmohamedibrahim2281 Месяц назад

Woow! this made me understand how to use powerpivot instantly, thank you very much, I am a big fan of your videos Kenji.

@DewanMahesh Месяц назад

You are truly Awesome man. Your ability to make such difficult topic in simple word is simply awesome.

@happynewyeara 4 месяца назад

Thank you for making the video, definitely wants to see part 2!!!

@tonybm1016 3 месяца назад

Super! Definitely need a part 2.

@UChiiL 3 месяца назад

Brilliant! Just Brilliant Kenji!

@camlex6310 Месяц назад

Thanks Kenji, a part 2 would be great!!

@MohitYadav-vk8sq 4 месяца назад

Hi Kenji I'm fan of your YT channel.... very well doing... Thanks Kenji Keep it up 👍❤

@ikadconsultancytraining5112 3 месяца назад

Super stuff - Thank you

@mariasaba8091 3 месяца назад

Love this ! and yes for part 2 :)

@revalinosahattuasibarani1884 10 дней назад

This is the best! we need part 2 Kenji!

@Mahendarreddy-wrkyt 4 месяца назад

Thank you sir❤

@lobnaessam1972 4 месяца назад

Thanks Kenji, Please I need a playlist for that not just part 2 :)

@Joda-es5xd 2 месяца назад

Excellent video.

@oyetunjioluwafemiemmanuel632 4 месяца назад

Thank you

@dembabatv4422 3 месяца назад

such a good guy

@david_gr13 3 месяца назад

Great video Kenji! Is Power Pivot not available for Mac? Thank you!

@lazyengineer85 4 месяца назад

wow. everyday i learn new skills from your video. i didnt know excel so powerful can do this stuff!!

@KenjiExplains 4 месяца назад

Glad to hear that!

@JeffreyJeffersonUK 4 месяца назад

Where can I learn more about PowerPivot and the KPI side, please? This is super interesting but I cannot find any useful resource beyond this fantastic video.

@Haroonkhan-qs3uv 4 месяца назад

Hello sir i am your big fan.

@shaileshmayekar2495 4 месяца назад

Hi Kenji what if there is duplicate data in the file e.g when we compare budget with actuals same codes/project site will be repeated in both budget and actual file as we have to compare actual against budget.

@krantikumar894 4 месяца назад

Wt is the diff b/w Power query and Power pivot.

@QrankChannel 4 месяца назад

But how can this be automated? Your connection is to one file with hard coded numbers, so for the next month you need create this again or just add the data of the new month?

@fluffyhoneytina 4 месяца назад

i would like to know how to make a relationship between two tables many to many

@user-ov4th5db6o 4 месяца назад

Part 2!!!

@shadeburst 2 месяца назад

Pretty good, like MS Access only easier.

@sunmonuabdulkareem1604 4 месяца назад

Thank very brother. Your video is really helping. Please make more video on power bi visualization.

@tomasarguelles8433 Месяц назад

Part 2 please

@Joda-es5xd 2 месяца назад

When using Power Pivot I struggle when you have a table of invoices where an invoice has many line records. Can you please create if we need a junction table to match many to many. Thank you

@user-zm4jc2si4y Месяц назад

Please I can't see the power pivot when I press Add-in

@averageboy5 2 месяца назад

Thanks! My only concern is 99% of examples assume the ideal perfect data structure whereas it’s not the case in real life. In the ordinary course we see tables packed with nuisances and exceptions like dealing with many to many relationships. How do you create relationships efficiently when there are duplicates values in the connected data? I think that’s where the real heavy-lifting begins and if one doesn’t get past such issues it becomes a waste. In this case I believe you’d need to create bridge tables etc. But what’s the normal cadence or most efficient method to get around many-to-many relationships w/o adding too much superfluous information to your workbook?

@rotationpronation7997 4 месяца назад

I Keep getting error when i put in related(employee[name]) any advice?

@Haroonkhan-qs3uv 4 месяца назад

Please van you make a series for Fresh new accountant that how to take start and become expert from zero level to advance level please.

@Travel203 4 месяца назад

Need part 2

@shannonrobson2237 3 месяца назад

Hi Kenji, anyway I can get in contact with you ?

@Genci0 4 месяца назад

Part 2 please you are golden

@ruslanazimov8616 4 месяца назад

We couldn"t see you for a long time

@KenjiExplains 4 месяца назад

Hey! What do you mean couldn’t see me? 😆

@edmonsantos8042 4 месяца назад

Interesting topic. May i know what ms excel version you used for this topic. Thank you

@SeaOfMadness 4 месяца назад

I'd love to but PP doesn't work on a Mac 😕

@Suda1s 4 месяца назад

can you please tell me what version of Excel you are using?

@muhammadkausar2842 4 месяца назад

May be Excel 365, the latest version

@Suda1s 4 месяца назад

thanks

@graceminiano8325 3 месяца назад

👍

@willzinner8813 4 месяца назад

is this simialr to power query?

@sallyho146 4 месяца назад

Thinking the same. How is the power pivot different from power query?

@qwerty.4450 3 месяца назад

@@sallyho146because one is called power pivot and the other is called power query😂

@phillgrim 2 месяца назад

Power pivot is ultimately an analytical framework, while power query is a transformative one. Analysis can be done in power query as well, but power pivot basically streamlines your analytical process.

@albertomartin70 2 месяца назад

Why all these Power Pivot examples are using external static data tables, no one shows how to add tables (multiple) from the same excel file that is been updated constantly depending on the data entered. It is not just a dumb data base from a company wanting to know stuff. Sometimes you can create tables for project take-off that have different categories and many items that have different evaluation parameters thus making it difficult to put all on the same table, but you want to match them all in a pivot table to be able to prepare a proper proposal.