Microsoft Office 2013 Preview of Excel PowerPivot & PowerView Reports with SQL Azure


The SQL Azure Database is connection oriented Cloud database on Windows Azure platform. The SQL Azure has connectivity with PowerPivot SQL Server 2012 connectivity over sharepoint 2010, Excel 2013 PowerPivot, WCF OData Services. The Excel 2013 has in-built support of PowerPivot, PowerView reports.

Lets start with connecting a SQL Azure database of AdventureWorks from SSMS.

  • Lets connect PowerPivot for Excel 2013 in order retrieve data from SQL Azure Database.

  • Put SQL Query to fetch data from SQL Azure tables into PowerPivot data tables.

  • Lets start with PowerView Reports from PowerPivot Tables. Build a Pivot Table in order to use as data source for PowerView reports.

  • The PowerView report is built on the Pivot Table data sources with background images support on Excel 2013.

  • The coolest feature of PowerView reports on Excel 2013 is the addition Map backgrounds on reports for enterprise Sales , Web Click Stream Analytics for Enterprise Dashboards & PowerView Reports.

  • Save the PowerView Reports on your SkyDrive folder from Office 2013 itself. Login into SkyDrive from Excel 2013 preview itself.

Advertisements

About Anindita
Anindita Basak is working as Big Data Cloud Consultant in Microsoft. Worked in multiple MNCs as Developer & Senior Developer on Microsoft Azure, Data Platform, IoT & BI , Data Visualization, Data warehousing & ETL & of course in Hadoop platform.She played both as FTE & v- employee in Azure platform teams of Microsoft.Passionate about .NET , Java, Python & Data Science. She is also an active Big Data & Cloud Trainer & would love share her experience in IT Training Industry. She is an author, forum contributor, blogger & technical reviewer of various books on Big Data Hadoop, HDInsight, IoT & Data Science, SQL Server PDW & PowerBI.

One Response to Microsoft Office 2013 Preview of Excel PowerPivot & PowerView Reports with SQL Azure

  1. jrichview says:

    I’d like to give this to my client, but I don’t want them to have to keep entering connection information. I just want to get them set up with 2 connections and let them choose one to do their queries against.

    The technical snag is we have 2 Azure dbs and the data they want may, at any given time, be in one or the other. We can give them the information as to which they currently should use for a given set of data. But we want to hide the details of setting up the connection. Just want them to click on “db1” or “db2” and then go.

    If you can think of any technology that might help us address this, please post.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: