Excel Power Pivot Introduction - How to Use Power Pivot

This video is an introduction to Power Pivot in Excel. It will explain what Power Pivot is, why and when to use it and walk through a complete example.

Below are the timings for the video;
00:00 - Introduction
00:23 - Why use Power Pivot?
04:32 - Installing Power Pivot
06:00 - Importing Data into Power Pivot
11:39 - Modeling the Data
20:40 - Why use DAX?
23:06 - Writing DAX Measures
35:07 - Creating PivotTables and Slicers from our Model

This only serves as an introduction to Power Pivot to get started. There is plenty more to explore with Power Query, modelling and writing DAX. There are further videos in the related playlists on this channel to learn more.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[skimpylemon]

Thank you for the wonderful introduction to DAX. I enjoyed your delivery of this content with simple and concise explanations of use-cases of PowerPivot when standard Excel formulas can become a limitation. Many thanks Sir!

[markandrews]

Excellent tutorial with well thought out examples. Thanks for your efforts to educate others!

[harishp]

Well explained with appropriate examples, it was easy to learn & implement. I did it my self it worked. Thank you

[Matt-wgxn]

Highly recommend 1.35x playback speed for this video (at minimum).

[Volker-br]

Super Test! Habe ALLE G Klasse Videos gesehen (weil ich selbst eine alte W460 habe). Das beste Material zu dem Thema! Werde mich an genau die gleiche Roststelle uam Innenkotflügel machen wie in Deiner Folge 81. Danke für das Video.

[Ugk]

Thank you very much. Your tutorials is easy to follow. 👍🏻

[wayneedmondson]

Hi Alan. Thanks for this great intro to Power Pivot and some DAX! I followed along but got stuck since I am in the US and your dates are UK. Found the solution in comments below.. good learning experience. Thanks for the tutorial and also for providing the files to practice.. helpful and appreciated :)) Thumbs up!!

[rebekahpardillo]

Thanks so much for the informative intro video to PowerPivots 👏🏻

[barbararaiji]

Excellent explanation. Waiting the next part where you describe the KPI.

[hermanmentink]

Thank you very much for this brilliant video; within 1 hour I learned all, great! I bought some merchandise as a thx!

[macolloyd]

Great Lear for new user of Power Pivot

[satheeshkumar]

Excellent for your time and great explanations... Thanks

[providencewilliams]

Good morning Sir, I so much appreciate you for the video, thank you sir. I think I have learnt something new today. I also appreciate your step by step guide, showing all the steps and procedures you took. But sir Why are we using the calendar Table as the Data Table? also What could have happen if we did not use the calendar table as the Data Table? The measures created, Were they based on the condition given by the Company?

[kulkarniearly]

Thank you, this was really what i was looking for

[MuhammadAsif-loie]

Excellent briefing you explain many things in just one keep up the good work.

[jihadalbustanji]

Very informative and supportive video ... than you so much for your true efforts.

[marketbeans]

Awesome video 👏👏👏👏 why did the percentages get messed up in the end

[pliopy]

Great video with really good insights on how Power Pivot works!

[alxmampilly]

Thank you for the video. Didnt know such a feature was in excel.

[otienoluke]

Alan. Great Intro. if I try adding data in my data source, it doesn't automatically update. How to I make it to automatically update my data model after changing the data source? Any help will be highly appreciated😰.