Dynamic Pivot Table with Multiple Tables using Power Query

#PivotTable #PowerQuery
Hello Friends,

In this video, You will learn how to create Dynamic Pivot Table with Multiple Tables using Power Query. We have taken 4 different yearly Sales Table and one Employee Master Table. We have used Power Query to Consolidate the data and display in final Pivot Table Report with Slicers and Sparklines.

Download the practice files from below given link:

Download the Free Project Management Dashboard


Download our free Excel utility Tool and improve your productivity:

See our Excel Products:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Pinterest:

Visit our Amazon Store

[amirsaiftaz]

Great Sir, always teaching new techniques. Amir

[kofi-tawiahagyeman]

Hello PK. Keep up the good deeds. You've been very helpful.

[nsanch]

I really enjoyed the video PK. Thank you. It was fun using the Power Query, merge function and Sparkline's.

[santiiceabs]

Thank you much for this wonderful knowledge.

[KrishnaKumar-znkg]

You have a wonderful and simple way of explaining the topics. Hats off to you.

[sakhtaronline]

Can we set emails with custom filter to get Google Forms data entered by users via Google Forma

[tariqanwar]

You are such a wonderful instructor. Clear, concise and crisp. Thank you.

[bharatpokhriyal]

Hello sir pls google sheet pe Dashboard ki video banao

[karimsamnani]

Excellent explained Power Query along with 3 D Table

[rajsahu]

I have seen your videos in I-Pad. Today, I have seen seen /visit your wave-site, I found that very very useful things are available. Very honestly, I am tailing that I am seeing your videos as my hobby. I found that your information in charts are represented in very very beautiful manner. But, I am not know vba. However, If I try then, I may learn VBA also. Your videos are also available. I am seeing in Hindi videos of Abhimanyu Bhardwaj, Dipak Nehra, Satish Dhanwale but when I listening your videos your lecture is very clear. I also viewing Leela Gharani. You are doing very good work. I hope that your subscriber base may increases.

[rajeevhirlekar]

Sir Thanks you very much.. such wonderful tutorials.. I always learning from your videos...👍

[carlosrobertomartinezandra]

Excellent, power query is the best ... together with all the graphics that you show us, hopefully and you can show us the relationship between power query, power pivot and power view, it would be the best video between data transaction and high impact graphics ... thanks

greetings from Lima, Peru

[samyraad]

Nice knowledge PK, can you show us how to create liquor and beer keg calculator 🙏🙏.
Thank you

[MrDhunpagla]

Enjoyed & loved a lot . Thanks for this, please make a comparison report like this with PQ Sir 🙏👍

[bikassingh]

How to combine different set of data with sane dimension names example, salaries and bonus

[bapumote]

Very nice video & very useful information.

[saurabhsharma]

Sir this can be work on office 2007?
plz reply sir

[kofi-tawiahagyeman]

PK can i have your email to discuss something with you?

[sulemanismail]

Sir this is very good but I have no other words to praise Thank U so much Thank

[santanugupta]

Dear sir, how to jump on "Name Box" without mouse