Leveraging Microsoft Azure for Mobile BI

image

Quick little write up on our PushBI solution using Microsoft Azure to get the data out.

GregOliver

Founded in 2006, Redmond, Washington based traditional ISV Extended Results (http://www.extendedresults.com) specializes in business intelligence solutions.  They sell primarily to enterprises worldwide across many verticals.

Companies spend a lot of money these days building business intelligence capabilities based on various vendor technologies.  Workers sitting at their desks or connected via VPN are in great shape – their KPI’s are right where they need them.  Extended Result’s PushBI product sees to that.  But what about when they’re NOT at work?

Mobile devices operate outside the firewall.  They don’t have direct access to a company’s internal systems and for good reason – it’s too easy to lose one.  So – what’s the answer to most computing problems?  Add a level of indirection!  That’s what Extended Results did with the Windows Azure component of PushBI Mobile.  (http://www.pushbi.com)  Now users of popular mobile devices (Windows Phone 7, iPhone, iPad, Android, Blackberry, Windows 7 Slate) can get access to their critical business information while on the road or in the coffee shop via a short hop through a cloud component running in Windows Azure.

This long time Microsoft partner chose Windows Azure because they know .NET well.  This familiarity allowed them to create this innovation quickly and get it to market in record time.

Congratulations, Extended Results!

Source:  http://blogs.msdn.com/b/golive/archive/2012/06/21/go-live-partners-series-extended-results-inc.aspx

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.

Making data work–Exchange and Azure

Extended Results developed a PowerPivot dashboard that brings insight into how a sales executive spends his or her time. The solution imports meeting information from an Exchange calendar and displays various metrics such as total customers met with and customer face time. In addition, the solution mashes up meeting data with the Dunn & Bradstreet dataset on the Azure Data Market to bring a company’s credit ratings and company size into context.

Technologies:

  • · Excel 2010
  • · PowerPivot
  • · SQL Azure DataMarket
  • Enjoy, Patrick

makingdatawork