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

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.

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: