Access your Pro+ Content below.
Where to look next for BI applications? Try the cloud
This article is part of the SQL Server Insider issue of August 2010, Vol. 3
In the last year, cloud computing has gained significant traction. Currently, there are two options for database and business intelligence (BI) applications like the PowerPivot product for accessing and consuming data in the Microsoft cloud -- SQL Azure and a new technology code-named “Dallas.” Each of these products has a particular sweet spot for deployment. Here’s a look at how they can benefit you based on your line of business. PowerPivot: BI applications for Excel Users PowerPivot is a free add-on for Microsoft Excel 2010 that provides BI capabilities such as data viewing, reporting, and slicing and dicing from within Excel. Before releasing PowerPivot, Microsoft did an extensive research of BI users, learning which tools they were using and which ones they needed. One of the main findings was that the vast majority of BI users didn’t have any tools, mainly because of their cost and complexity. PowerPivot allows BI users to leverage their knowledge of Excel to create BI applications. It puts the power of BI into the hands ...
Access this PRO+ Content for Free!
Features in this issue
PowerPivot, SQL Azure and ‘Dallas’ combine to create BI applications in the cloud. Is that integration seamless and is it even for you?
Data-tier applications are among SQL Server 2008 R2’s most talked-about new features, though version-one limitations could minimize their impact in the short term.
SQL Azure offers full-blown SQL Server functionality in the cloud and could ease management and development. But whether it’s ready to fully replace SQL Server remains to be seen.