Access "Where to look next for BI applications? Try the cloud"
This article is part of the August 2010, Vol. 3 issue of Exploring SQL Azure features and opportunities
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 of millions of Excel users ... Access >>>
Access TechTarget
Premium Content for Free.
What's Inside
Features
-
-
Where to look next for BI applications? Try the cloud
by Roman Rehak, Contributor
PowerPivot, SQL Azure and ‘Dallas’ combine to create BI applications in the cloud. Is that integration seamless and is it even for you?
-
Are we there yet? The slow road to SQL Azure
by Eric Johnson, SQL Server MVP
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.
-
Where to look next for BI applications? Try the cloud
by Roman Rehak, Contributor
-
-
Pros and cons of the DACPAC with SQL Server 2008 R2
by Denny Cherry, Contributor
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.
-
Pros and cons of the DACPAC with SQL Server 2008 R2
by Denny Cherry, Contributor
More Premium Content Accessible For Free
Understanding Microsoft SQL Server business intelligence options
E-Handbook
Microsoft has made a great effort to turn SQL Server into a viable enterprise database platform, and part of that has been boosting its business ...
Should you upgrade to SQL Server 2012?
E-Zine
Are you going to upgrade to SQL Server 2012? This edition of SQL Server Insider sets out to help you decide whether the investment is worth it or not...
SQL, NoSQL technologies coming together in new Microsoft project
E-Zine
Everyone knows SQL and NoSQL technologies don't co-exist well. But can they? Check out Issue 3 of SQL Server Insider E-Zine to find out about the ...