Introduction to Power Pivot for Excel

[@srinivasraogampala4420]

Chandoo is always great... being Indians, his language is very easy to understand. I learned a lot of things from chandoo.org

[@TheOriginalDJArnoldo]

I can see why you are so excited about PowerPivot, Chandoo. For the first time you can do do relational queries against an n dimensional data cube without writing any SQL. And it's in Excel! Thanks, Chandoo.

[@davidfothergill9473]

Great presentation Chandoo. It has helped me get past the initial curiosity stage and then move on to try it on some of my messy data.

[@brasdamu9820]

Useful as a warm up to an internal Power Pivot course which I shall be attending. Chandoo - you have made it understandable for all levels. Well done.

[@John-qe3ky]

This was so useful to learn. I look forward to your videos as they are very informative with simple to follow instructions.

[@chandoo_]

Glad you like them!

[@km9369]

I've watched a few of your videos today, brushing up for job testing on Monday. Thank you so much for the pleasant, accessible and relevant content you present. Best wishes to you!

[@charlesrayappan8649]

Never had such wonderful teaching on online... Thank you very much sir!!

[@cleangene17]

Thank you for the video! I like your plain, right to the point, no nonsense approach in explaining Power Pivot.

[@shafivs]

Excellent, simple explanations.... very useful... Thanks Chandoo....

[@prefontaine9940]

I open the video, hear and indian accent and immediately know that the tutorial will definitely worth my time.

[@safuanlatif]

Interesting video. Although, your accent sounds like a typical Indian, I still can understand you. It's clear and well explained. I think it will be better if you include sub-title to your video so that viewers who are not familiar with Indian accent can understand you better. Anyway, it's a GREAT JOB. Thanks a lot.

[@jagatkrishna1543]

U r Great ❤️💕🙏 SIR Thanks Before 9 years u had explained

[@maksms]

Fantastic video Chandu and very well articulated, I have'nt seen a better video explaining Powerpivots in the whole of youtube. To start from ABCs and get ideas on XYZ this should be the most appropriate video.

[@centurychallenger]

Microsoft is brilliant. Combine part of Access and Excel finally..but of course, thank you for that clear explanation on PowerPivot. Without reading through all the material in Microsoft tutorial site.

[@mehalanagarajah6677]

Very clear cut explanations for a beginner. Awesome!!!

[@dphaniraj]

Nice.. never heard about this before. I like the slicers concept quite a bit. It will help the dashboards quite a bit.

[@ExcelStrategy]

Hi Chandoo I really appreciate your job with your site videos and courses, Im an Excel enthusiast from many years now and i know the "latest version" problem ! In my country many companies are still using Excel 2003 version and some of them even the earlier versions like Excel 2000 Excel XP and Excel 97 :S

[@Lightuser20201]

Chandoo - many blessed thanks ✨

[@jagatkrishna1543]

SIR, HAPPY GANESH CHATURTHI THANKS FOR MAKING THIS TYPE VIDEO S FOR US. WE ALL 💕 #POWERBI N #Data

[@ChandooD]

@ExcelStrategy.. I agree. Since a majority of our visitors are still on Excel 2007 or 2010, I choose this version to demonstrate the capabilities. In our course we will be using a mix of Excel 2010 & 2013. I plan to include few modules on Excel 2013 alone so that our students can learn to harness all new features.

[@skeeterburke]

Mind=blown you are changing my whole world. I am using all my spare time on power pivot now, not VBA.net, not python. They will have to wait

[@LauraChristinaWarren]

Fantastic! Concise and informative. Thank you!

[@MKS-hn6eb]

Thank you very much sir..nice demo..it is very helpful. The way you teach is awesome.

[@macdinvestor7233]

Wow. That's powerful. So much better than just Pivot Tables.

[@paravej]

Excellently explained with good example, so gooood !

[@honestabe954]

This is a great video!! Thanks this just made my job a million times easier!!

[@jpawloski1]

Great feature, great video. Thanks Chandoo!

[@rsudakar]

Thanks Chandoo for this awesome video. Really excited to use this feature.

[@danfx8]

thank you for a introduction of this powerful pivot excel as for the first time and love to find out more from you here ..

[@RaviKumar-gz9my]

Excellent. Nicely presented with good content

[@chiefbrades]

Very Helpful and easy to understand. Thank you so much!

[@sridharhyd1]

Excellent presentation Chandoo...thumps up !!!!

[@nalipapaiah8384]

Power pivot is the analysis tool which added in Excel 2010 and above versions.

[@shanonabishek8377]

Fantastic explanation Sir

[@eugenevakulenko4229]

Thank you for this. It's not easy to learn Excel by yourself.

[@AshutoshPathak_in]

Nice. You have explained Powerpivot very well.

[@SPeri6]

Good Presentation skills Chandu. Saw your Bio too incredible and best wishes.

[@sairamca]

Thanks for video and excellent explanation. Got following queries, please help me understand 1) how much space consumed when powerpivot is used and simple data is used ( traditionally we code to get all the details and paste as values) 2) Power pivot compared with Access 3) data can be spooled from multiple sources but for calculations need to rely on traditional way ( in example from sales data) 4) is it possible to spool data from two different fields, example sale price changes effected frequently. whether sale price can be spooled from both product id and sale price date (customer banding can be changed from Gold to silver on a given date and sales Rep bonus is based on target sales to gold customers)

[@dharmenderkumar8508]

Very useful tool, described extremely well. Thanks !

[@mayuriparekh2900]

Simply superb. Can you please provide the sample excel sheets that you have used in this.

[@hitendramehra5439]

awesome video... explained very well. Keep up the good work.

[@ekjibon]

Thanks for this tutorial, very easy to understand. thank again

[@tabey1000]

thank you for the excellent quick video of PP.

[@shaikhjaveed5598]

Beautifully Explained, Thanks

[@chandoo_]

Most welcome!

[@thedyslexic9936]

Excellent explanations and examples...thanks.

[@gurusamyselvan7753]

Very good PIVOT beginning for me. Thanks

[@manojbehera2840]

Very Good Video, It helps me lot and hope it will help others

[@danielescaleira]

Superb, Chandoo! AWESOME! It is indeed very helpful! Congrats and thank you! :)

[@remotecont888]

Thank you. It was a very good explanation.

[@santhoshedamana]

Excellent. Please add more videos on the subject.

[@chandoo_]

Thank you, I will. Please watch the videos on Power Query and Power BI too. Power Query - kzbin.info/www/bejne/hpqpcpSVn8-Ue6s Power BI - kzbin.info/www/bejne/eXu6XoyYabWZkJo

[@habibullamohamed2283]

Chandoo good job. Thanks a lot for power pivot intro.

[@mananaeem]

Chandoo.... good name

[@mohamadizhambinmohlis628]

Greats presentation. Cleared explanation.

[@baloopune]

Excellent..Great Job!! Do you have a comprehensive list of all such tutorial videos?

[@joysrayil5973]

Many thanks, Chandoo

[@danakapla5907]

Thank you for this video Chandoo.

[@milkbattle]

Brilliant introduction. I have a question for you or anyone here. I don't get the 2 slicer options in the "Power Pivot Field list section. I only see Report Filters, Column Labels, Row Labels and Values. How do I add these. Thank you

[@wilsonsantiago39]

thank you for the knowledge GM...

[@vness12]

This video is great. Thanks!

[@FDNFABIO]

Muito bom o tutorial para uma primeira impressão da ferramenta!!! Thanks...

[@M4D5K1L2]

This is awesome!!!! Thanks Chandoo. It's like access, but I like excel better.

[@glenroy1410]

Awesome video. I think i will do the full course

[@caballero4321]

Hi Sir. I am trying to work around a pivot table using power pivot add-in excel 2010. The Data base consist on importing four files. The largest file (out of those 4) has 4 tabs with 280 k rows and 30 columns so I went and import the information into the power pivots and worked as charm. The issue comes when I extract the data from excel using a pivot table: When I insert the row labels is ok but when I insert the first calculated field (call it a column) the it really slow down that much that it gets stuck and I am never able to get the pivot table created. Can you tell me what at your thought about it. Thanks in advance.

[@pakistansfunniestvideos3799]

Hi, really appreciating effort . have u lunched the complete course as you said in the end?

[@sachinkishore4115]

thank you sir, very good explanation .

[@Edgaraza]

awesome!!!! Thanks Chandoo I will start to work with

[@rw9122]

Very nice video. We'll done. Has anyone used FME or AlterYX...if so, do you prefer PowerPivot?

[@marcvanderpeet1]

Awesome video, is there somewhere I can find the excel with data used in the video?

[@agustingt8]

Excelente, saludos chandoo

[@funmieodun9490]

Great presentation !

[@louisewooding124]

Great video, thank you. You state in the video that you are also creating additional tutorials on PowerPivots - is this still going ahead?

[@rohitthakkar8072]

many thanks dear.. Great help

[@joseantoniomartinez3125]

The best! i hope you continue doing this!

[@ApoincUs]

Well done! A great into to PowerPivot!

[@8T8Keez]

THIS was EXCELLENT! THANK you!

[@javiscodegt]

Thank's a lot for the info.... it's seem pretty awsome!!! Thank's again for the explanation...

[@coreyculbreath9771]

Great job....Where can we download sample files so we can try?

[@navnishhosur]

Nice & detailed explaination. Keep up the good job ! 1. But only concern would be how fast or effectively power pivot perform when the data table has really huge data, say around 5lakh rows & 15 columns. would there be any optimization possible. 2. Also this feature is not compatible with on MAC machines, which will be a barrier to the developers. Is there any workaround for the above limitaions (2nd point especially).

[@safuanlatif]

+Naveen Hosur Install Virtual Box in your Mac machine. Then setup any Microsoft Windows O/S in that virtual machine, e.g. Windows 8.1. Finally, install MS Office 2013 for Windows O/S in that virtual machine. That will solve the compatibility issue.

[@safuanlatif]

+Safuan Abdul Latif Ha ha ha. Forgot to look at the posting date/time. I had replied to a post that was a year ago. :)

[@petermaina7111]

great teacher...rabbi

[@chandoo_]

Thanks and welcome

[@kendallandrew]

Good video, well explained. Thank you.

[@ExcelStrategy]

Hello there, first time I comment here, I think it's better to talk about the powerpivot inside Excel 2013 that hase changed a lot compared to the Excel 2010 version.

[@skurniawan88]

Great video.. Awesome job man..!

[@shankargeeth]

Thanks for the information. It was very useful.

[@castorec]

Increible fue mas claro imposible gracias

[@zing326]

Hi, One of my friends is stuck is a problem. He needs to calculate monthly average of his household budget heads. He wants to calculate average of e.g. vacations related expense over a period of 10 months, while the expense is incurred in only 5 months out of 10. But he wants to use entire period i.e. 10 months instead of 5 for getting average. Can it be done using formulas?Regards

[@jonbaylis2203]

+Nasir Kazmi I recommend this book. Perfect and easy to learn. www.powerpivotpro.com/the-book/

[@findpatterns]

Hi, Thanks for the great presentation.

[@dannodee3727]

This is awesome . Thank you so much it really helped me.

[@sandeeppramanik9518]

Excellent tool for me to learn

[@mithunsahaxanderage]

Can a single sheet or table data can be analyzed in power pi ot or its mandatory to have multiple tables

[@chandoo_]

You can use a single table too. The measures (DAX) feature of Power Pivot makes data analysis with pivots easy and powerful. If you need an updated version of Power Pivot intro, check my recent live stream here - kzbin.info/www/bejne/m3TYgYWnhrOYbLs

[@mithunsahaxanderage]

@@chandoo_ thanks a lot I made a presentation in power BI it took 2 days to learn from your video and then I realise that without subscription I can't export it to PowerPoint 😂😂 and 😭😭 I have to rely on power pivot 😎

[@mihaiteodorescu2506]

3 sheets: one FACT table and 2 DIMENSION tables. Everything else is slice and dice. Thanks chandoo, i will not buy anymore MicroStrategy or Cognos , Excel is enough for small companies.

[@kgangavaram]

Excel Guru.. Nice video .. Do you have VBA sample macro connecting two tables with calculated fields .Please do spread to us . I used to write various formula in vba to calcuate new fields and then construct the pivot . Please do send me macro

[@AgentCell]

where can i get some sample power pivot files to practice?

[@pradeepkaruppiah]

Guys this feature is awesome in excel.

[@PetLover007]

Thanks.. Very nice & informative...

[@kevinmckennanar]

Great job! How can I enter a course for power pivot?

[@ExcelBI]

Please take a look also to Vizubi

[@avdutpednekar7007]

Good Job ! Keep the good going ! God Bless !

[@Excel-power-users]

Please share link of the power pivot course.

[@johnwallen7985]

Excellent work, Thank you

[@vinitdoshi4433]

Hi! I work on data which is very high size I.e. exceeds excel limit. Thus, we break it up in multiple sheets of 9 lakh rows. How do I make a pivot from such heavy multiple sheets. System stops responding when done s. Could you please help with this.

[@chandoo_]

Hi Vinit... I suggest using Power Query + Data model to load large volumes of data for Pivot Tables. See this video for tips on how to set it up. kzbin.info/www/bejne/a6aak6OvqLRmfLM