Building PowerView Reports on Sharepoint 2010 with SQL Server 2012 RC by PowerPivot Excel Consuming Big Data from Hadoop Hive table on Windows Azure


PowerView Reports has its excellency in implementing cool dashboards of the data coming from SQL Server Analysis Services (OLAP Cubes) in tabular mode, PowerPivot Excel 2010 data , SQL Server Reporting Services Data or OData Services feed. The PowerView Reports has its major add-in for SQL Server 2012 edition. The data model can come from even Big Data Hadoop HDFS  or Windows Azure Marketplace OData feed.

The Hadoop on Windows Azure has support for running Pig/latin jobs with interactive javascript, executing Map/Reduce jobs on HDFS with jar on Azure VM. Basically NOSQL Apache Hadoop framework is literally comes with Windows Azure which can be explored more on http://hadooponazure.com

Once Hive Tables on HDFS are populated with Big Data it’s possible to render the data from the Hadoop framework to Microsoft BI tools (Excel 2010 PowerPivot tools) & put on SharePoint 2010 as web parts by the help of HiveODBC Connector Tool which is available on Hadoop on Azure portal. 

  • Lets check the Excel 2010 Data-in after installing Hive ODBC connector & find the Hive Pane. By selecting from Hive Pane , you can populate your Hive Table data onto Excel PowerPivot Table & Chart.

  • Lets check some PowerPivot Dashboards on Excel 2010 hosted on SharePoint 2010 as Webparts priliminary in order to build up the PowerView Reports.

  • Lets build up the PowerView Reports on SharePoint either by clicking on PowerView report icon beside the powerpivot excel bar .

 

  • Build up the PowerView reports  Dashboard from the powerpivot data & render it on SharePoint 2010 Web Part.

 

Advertisements

Build ASP.NET Web App on Windows Azure SDK 1.7 June 2012 Release on Visual Studio 2012 RC on Windows 8 Release Preview


The Windows Azure SDK 1.7 June 2012 has released on June 4th, 2012 with enhanced features of supporting VS 2012 RC platform. So, lets develop Windows Azure app in ASP.NET on VS 2012 RC on Windows 8 Release Preview platform & host it on Windows Azure portal. Windows Azure tools for Visual Studio has side by side support for VS 2010 SP1 & VS 2012 RC with Windows Azure SDK 1.7. So, you can build Windows Azure apps on VS 2010 SP1 as well as on VS 2012 RC on Windows 8 Release Preview.

Lets download first the Windows Azure SDK 1.7 June 2012 Release from here

So , start a new Windows Azure Cloud service app from Visual Studio 2012 RC.

  • Next select a WebRole from the available options of Windows Azure Service.

  • Now , check the development fabric environment on VS 2012 RC of Windows Azure ASP.NET apps.

  • Lets start debug the app & check the initialization of Windows Azure Storage emulator.

  • Run the Windows Azure ASP.NET Webrole on local Dev Fabric from VS 2012 RC.

  • Lets publish the Azure app on Windows Azure portal on Production Stage as Release platform. So click on Publish by right-clicking from Azure Project on VS 2012.  

  • Create your certificate to publish your Windows Azure app from Visual Studio 2012 RC.

  • Choose your Azure Subscriptions  & provide Azure Subscription Name along with the Subscription ID.

  • Select your Storage Service name on Production & provide location of your Azure Hosted Service. 

  • Lets Start publish the Windows Azure app from VS 2012 RC on production stage.

  • Lets check the final Windows Azure ASP.NET Web app on Production with cloudapp.net URL.

  • Check the final Cloudapp.net Azure ASP.NET Website on SmartPhones (iPhone 4s, HTC Evo, BlackBerry, Palm Web Os, Windows Phone 7.5) . The Azure Web Template is already smartdevice optimized for VS 2012 RC.

 

Microsoft BI (Build up PowerView Reports) SQL Server 2012 PowerPivot for SharePoint 2010 works in iPad 2, iPhone 4S, Windows 8 Tablets, Windows Phone 7.5 & SmartPhones


The latest interactive BI tool of SQL Server 2012 is PowerView Reports which runs as an integrated Reporting Services app of SharePoint 2010. The PowerView Reports provides interactive support for Bubble Charts, Line Graphs along with the Matrix, Cards support having Metro Style UI approach.

Lets build an app to consume Windows Azure Data Market feed API on Excel PowerPivot . So, open Excel PowerPivot & select Azure DataMarket Feed API.

  • Lets Sign up for the Data Feed from Azure MarketPlace & get the dataset Atom feed URL. You need to provide the Account Key.

  • Lets populate the Azure DataMarket Feed data on Excel PowerPivot & develop the PivotCharts to analyse the World Health Statistical Analytics.

  • Now, save the Excel sheet & send it to SharePoint PowerPivot Gallery where we can start to build the PowerView Reports.

  • Lets run the PowerView report build on SharePoint 2010 on iPhone 4S device & check the PowerView reports run on iPhone , iPad , Windows 8 tablets, Windows Phone , Android & all smartphones.

Running SQL Azure Reports on Windows 8 Release Preview Metro Apps, iPad, iPhone, BlackBerry, Android & Windows Phone with SQL Server 2012


Runing SQL Azure Reports on SmartPhones are quite easier as it renders for any HTML 5 compatible browsers (IE10, Mobile Safari etc). So , lets build up a SQL Azure Report & render it on various smartphone platforms.

  • Lets open SQL Server 2012 Data Tools to create a new SQL Azure Report.

  • Check out the SQL Azure database Tables & render the queries to build the report.

  •  Next, Deploy the report properly first on local Report Server & check the report preview.

  • Check the SQL Azure Reporting URL & deploy the report on your SQL Azure Reporting Server.

  • Now render the SQL Azure report on Windows 8 Release Preview Internet Explorer Metro App.

  •  

 

  • Next , Check the Report on iPad 2 & render it on mobile safari.

  • Lets render the report on Ipad 2.

  • Check the preview on iPhone 4S.

  • Lets run it on major smartphone platforms(Android HTC, BlackBerry Storm)

%d bloggers like this: