Aaron Meyers, BI Consultant here at Extended Results has placed 2nd in the PowerPivot Data Mash-up, earning him a total of $2,000. Not bad for only a couple hours of work! We would like to congratulate him on his big win. We are truly fortunate to have the best BI consultants on our team, and it sure feels good to be rewarded for all of that hard work at the end of the day.
Below is an example of Aaron’s dashboard. As you can see, it combines crime, unemployment rates and education stats; and lets you effortlessly compare data by year, region and type. You can even drill-down into one or more specific categories for a visual histogram analysis. Very cool tool! Great job, Aaron!
We built this Calendar Analytics solution for Microsoft several months ago. Nice to see Microsoft marketing it as it has had thousands of downloads. Works with Microsoft Exchange, Excel 2010 and PowerPivot. If you haven’t tried it, click on over, download it and take it for a spin. Amazing what you can do in Excel and you’ll become the hero in your company.
We have been working with the little birdy on doing analytics in Excel for LinkedIn. Wouldn’t it be cool to do that?! Well, in a couple weeks you should be able to too! We used Microsoft Excel 2010, PowerPivot and the LinkedIn API’s to pull data on your network and do some analytics off of it. Pretty cool. Below is a sneak peak of what is to come
Email me with questions
One of my team members forwarded me this article on building VSTO-Based PowerPivot workbooks. The article is based on the work we did for our PowerPivot App for Twitter in Excel and it is written very well. Worth the read if you are interested in implementations.
“Microsoft Visual Studio Tools for Office (VSTO) is an awesome development suite for building advanced Office solutions, such as Excel applications that go above and beyond default features and capabilities. Even our PowerPivot for Excel add-in is based on VSTO. However, it is important to note that VSTO does not define application programming interfaces (APIs) for applying customizations on top of customizations. In other words, you can develop applications on top of Excel by using VSTO but you cannot develop applications on top of PowerPivot because VSTO does not include any APIs for this purpose and the PowerPivot add-in does not add any such APIs either. Appropriate APIs are only available with PowerPivot for SharePoint and SQL Server Analysis Services.”
Everyone in our office was pretty excited about this blog entry. If you are using PowerPivot and what it to auto refresh, here is how to do it!! Thanks Tom!
Love the video on the Twitter for Excel. Check it out
Ever wanted to do Twitter Analytics in Excel? Well now you can! We built this solution with Microsoft Excel 2010, PowerPivot and the Twitter APIs to give you better insight into your social media efforts. If you want to do more with the solutions, send us an email and we can extend the solution for you.