Along with Excel 2010, Microsoft released a free add-in called PowerPivot. According to MS,
PowerPivot gives users the power to create compelling self-service BI solutions, facilitates sharing and collaboration on user-generated BI solutions in a Microsoft SharePoint Server 2010 environment, and enables IT organizations to increase operational efficiencies through Microsoft SQL Server 2008 R2-based management tools.
It means anyone can analyze and visualize millions of rows of data using powerpivot. It is like pivot tables on SUMPRODUCT (oh, I could totally say steroids, but who wants a cliche on a Friday?)
During the holidays I spent few hours trying to understand this whole powerpivot thing and see if it really wears underwear on top of pants.
Watch my review of Power Pivot in below video
If you are not able to see it here, watch it on youtube.
(make sure you jack up your volume).
The Conclusion
My experience with PowerPivot has been good so far. I like the power behind powerpivot and its ability to facilitate very good analysis on large datasets without leaving excel sheets. The only gripe I have is that it slows down Excel 2010 start up time. I have disabled the add-in for the time being. But I will turn it on as soon as I need to analyze some data from a SQL server DB.
Download PowerPivot Free Add-in
If you have Excel 2010 you can download the powerpivot add-in right away and see it for yourself.
If you don’t have Excel 2010, download that too.
What is your experience with PowerPivot?
Have you tried it? What is your experience like?
3 Responses to “How-to create an elegant, fun & useful Excel Tracker – Step by Step Tutorial”
Hi Chandoo,
I am responsible for tracking when church reports are submitted on time or not and the variations from the due date for submission.
Here is the Scenario;
The due date for the submission of monthly reports is on the 5th of each month. and I would like to know how many reports have been submitted on time (i.e, those that have been submitted on or before the due date) I would also want to track those reports that have been submitted after the due date has passed.
How can I create such a tracker?
Hi Chandoo,
I am a member of your excel school.
I was trying to create SOP Tracker I follow all your steps but I keep this error below.
The list source must be a delimited list, or a reference to a single row or cell.
I try looking on YouTube for answer but no luck.
can you help on this?
thanks
Carl.
Dear Mr. Chando,
Rakesh, I'm working in a private company in the UAE. Recently, I'm struggling to get more details about the staff sick, annual, unpaid, and leaves. I would like to get a tracker in excel. Could you please help me in this situation?
I also watching your videos in YouTube. i hope you can help me on this situation.