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!
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.
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.
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.
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.
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
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)
@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.
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.
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
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
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).
+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.
Thank you, I will. Please watch the videos on Power Query and Power BI too. Power Query - th-cam.com/video/PiFAa_jjaEI/w-d-xo.html Power BI - th-cam.com/video/CJW-Yb4PfZ8/w-d-xo.html
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 - th-cam.com/video/eCuPRqQNe6Y/w-d-xo.html
@@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 😎
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.
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. th-cam.com/video/5u7bpysO3FQ/w-d-xo.html
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.
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.
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
Great content, thank you. Idea: You may want to consider adding your own Close Caption to the video. The TH-cam Close Caption System doesn’t get your accent.
Chandoo is always great... being Indians, his language is very easy to understand. I learned a lot of things from chandoo.org
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.
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.
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!
This was so useful to learn. I look forward to your videos as they are very informative with simple to follow instructions.
Glad you like them!
Never had such wonderful teaching on online... Thank you very much sir!!
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.
I open the video, hear and indian accent and immediately know that the tutorial will definitely worth my time.
Thank you for the video! I like your plain, right to the point, no nonsense approach in explaining Power Pivot.
Excellent, simple explanations....
very useful... Thanks Chandoo....
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.
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.
U r Great ❤️💕🙏 SIR
Thanks
Before 9 years u had explained
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.
Very clear cut explanations for a beginner. Awesome!!!
SIR, HAPPY GANESH CHATURTHI
THANKS FOR MAKING THIS TYPE VIDEO S FOR US.
WE ALL 💕 #POWERBI N #Data
This is a great video!! Thanks this just made my job a million times easier!!
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
Thank you very much sir..nice demo..it is very helpful. The way you teach is awesome.
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
Nice.. never heard about this before. I like the slicers concept quite a bit. It will help the dashboards quite a bit.
Chandoo - many blessed thanks ✨
Power pivot is the analysis tool which added in Excel 2010 and above versions.
Excellently explained with good example, so gooood !
Thank you for this. It's not easy to learn Excel by yourself.
Fantastic! Concise and informative. Thank you!
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)
Thanks Chandoo for this awesome video. Really excited to use this feature.
Simply superb. Can you please provide the sample excel sheets that you have used in this.
Wow. That's powerful. So much better than just Pivot Tables.
Great feature, great video. Thanks Chandoo!
Very Helpful and easy to understand. Thank you so much!
Excellent presentation Chandoo...thumps up !!!!
@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.
thank you for a introduction of this powerful pivot excel as for the first time and love to find out more from you here ..
Excellent. Nicely presented with good content
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.
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
Awesome video, is there somewhere I can find the excel with data used in the video?
Nice. You have explained Powerpivot very well.
Hi, really appreciating effort . have u lunched the complete course as you said in the end?
Thanks for this tutorial, very easy to understand. thank again
Excellent..Great Job!! Do you have a comprehensive list of all such tutorial videos?
Great video, thank you. You state in the video that you are also creating additional tutorials on PowerPivots - is this still going ahead?
Very Good Video, It helps me lot and hope it will help others
awesome video... explained very well. Keep up the good work.
Superb, Chandoo! AWESOME! It is indeed very helpful!
Congrats and thank you! :)
Very nice video. We'll done. Has anyone used FME or AlterYX...if so, do you prefer PowerPivot?
Good Presentation skills Chandu. Saw your Bio too incredible and best wishes.
This is awesome!!!! Thanks Chandoo.
It's like access, but I like excel better.
Fantastic explanation Sir
Very useful tool, described extremely well. Thanks !
Great job....Where can we download sample files so we can try?
thank you for the excellent quick video of PP.
where can i get some sample power pivot files to practice?
Thank you. It was a very good explanation.
Pls give us the link to download this Power-pivot-demo-workbook..thanks!
Beautifully Explained, Thanks
Most welcome!
Chandoo good job. Thanks a lot for power pivot intro.
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
+Nasir Kazmi I recommend this book. Perfect and easy to learn. www.powerpivotpro.com/the-book/
Excellent explanations and examples...thanks.
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).
+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.
+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. :)
Please share link of the power pivot course.
Excellent. Please add more videos on the subject.
Thank you, I will. Please watch the videos on Power Query and Power BI too.
Power Query - th-cam.com/video/PiFAa_jjaEI/w-d-xo.html
Power BI - th-cam.com/video/CJW-Yb4PfZ8/w-d-xo.html
Can a single sheet or table data can be analyzed in power pi ot or its mandatory to have multiple tables
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 - th-cam.com/video/eCuPRqQNe6Y/w-d-xo.html
@@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 😎
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.
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. th-cam.com/video/5u7bpysO3FQ/w-d-xo.html
Awesome video. I think i will do the full course
Very good PIVOT beginning for me. Thanks
The best! i hope you continue doing this!
Great job! How can I enter a course for power pivot?
Thank you for this video Chandoo.
Greats presentation. Cleared explanation.
i want to download this data please help me where get
this data
Muito bom o tutorial para uma primeira impressão da ferramenta!!! Thanks...
Could you share me the Excel file with the data what you used.
How to calculate fields between 2 different sheets in power pivot?
hmm.. not sure what you mean "fields between 2 sheets"? See this video, it might help.
th-cam.com/video/NVve19gQGbw/w-d-xo.html
Good example, however, this can be done directly under MS Query without the need to bring all the data in different tables.
Chandoo.... good name
First thanks for this video :) can you share the file used for this demo please
THIS was EXCELLENT! THANK you!
I do not see the diagram view in the ribbons and I am using 2010...
awesome!!!! Thanks Chandoo
I will start to work with
This video is great. Thanks!
This is awesome . Thank you so much it really helped me.
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.
Is it current? Can I benefit from this video now?
While the information and technology is same as ever, Please watch the 2022 update here - th-cam.com/video/PQ5lALdFHCU/w-d-xo.html
@@chandoo_ thanks a lot! :)
Excelente, saludos chandoo
Guys this feature is awesome in excel.
Many thanks, Chandoo
Thank's a lot for the info.... it's seem pretty awsome!!! Thank's again for the explanation...
Great video.. Awesome job man..!
Please take a look also to Vizubi
thank you sir, very good explanation .
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.
thank you for the knowledge GM...
Thanks for the information. It was very useful.
Is this really 8 yrs old video, was there POWER PIVOT AVAILABLE 8 Yrs ago
Yes. Power Pivot has been around for much longer than that.
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
Well done! A great into to PowerPivot!
Great content, thank you.
Idea: You may want to consider adding your own Close Caption to the video. The TH-cam Close Caption System doesn’t get your accent.