Microsoft Excel 2013 Interactive View

I was reading the Excel blog on a very cool feature that I’m personally looking forward to.  With the Excel Interactive View, I can add a button to my web site that brings up an interactive spreadsheet with data and allows visitors to interact with that data.  Tableau has done some of this with their public version, but  you just cannot beat Excel for people knowing how to use it.

Source: http://blogs.office.com/b/microsoft-excel/archive/2012/08/02/the-excel-button-bringing-excel-everywhere.aspx

image

Enjoy, Patrick

Microsoft Tag: Reporting Tools developed by Extended Results

Well, we had to keep this one quite for a while but no more!   Extended Results had the privilege of working with the Microsoft TAG group on an Excel analytical tool to review your TAG effectiveness.  With all the great new features of Microsoft TAG supporting many different types of scanning codes, it was time for some analytics on them.

Microsoft selected us because of our deep knowledge on social media platforms and analytics.  We event built  the Excel add-ins for Calendar, Twitter, LinkedIn and Facebook.

What do all these social media tools have in common, they all use the simple to use Excel 2010.  Everyone knows Excel, so why not just provide the analytics in there instead of purchasing another tool.

more http://tag.microsoft.com/what-is-tag/reporting-tools.aspx

download: http://www.extendedresults.com/products/

image

Enjoy, Patrick

From Excel to the Cloud

I found this blog post off the Microsoft Research site.  Sounds very interesting and I look forward to following the efforts of using cloud services to process and provide insights using Excel.  As we ALL know, the world of business runs on Excel so the more we can leverage it, the better.

Microsoft ResearchOn June 15, Microsoft’s Washington (D.C.) Innovation and Policy Center will host thought leaders, policymakers, analysts, and press for Microsoft Research’s D.C. TechFair 2011. The event showcases projects from Microsoft Research facilities around the world and provides a strategic forum for researchers to discuss with a broader community their work in advancing the state of the art in computing. Microsoft researchers and attendees alike will have an opportunity to exchange ideas on how technology and the policies concerning those technologies can improve our future.

Source: http://research.microsoft.com/en-us/news/features/dctechfair-061311.aspx

“Excel is a leading tool for data analysis today,” Barga explains. “With 500,000,000 licensed users, there are incredible numbers of people already comfortable with Excel. In fact, the spreadsheet itself is a fine metaphor for manipulating data. It’s friendly, and it allows different data types, so it’s a good technology ramp to the cloud for data analysts.”

Excel DataScope research ribbon

The project enables the use of Excel on the cloud through an add-in that displays as a research ribbon in the spreadsheet’s toolbar. The ribbon provides seamless access to computing and storage on Windows Azure, where users can share data with collaborators around the world, discover and download related data sets, or sample from extremely large—terabyte-sized—data sets in the cloud. The Excel research ribbon also provides new data-analytics and machine-learning algorithms that execute transparently on Windows Azure, leveraging dozens or even hundreds of CPU cores.

Extended Results work in the #Microsoft BI Labs #powerpivot #excel

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.

Source: http://www.microsoft.com/BI

image

LinkedIn Analytics for Excel – Yeah, We Got That.

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

download: http://www.extendedresults.com/products/

Email me with questions

Enjoy, Patrick

image

How to Build a VSTO-Based PowerPivot Workbook

imageOne 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.”

Source: http://blogs.msdn.com/b/analysisservices/archive/2011/08/04/how-to-build-a-vsto-based-powerpivot-workbook.aspx