Search This Blog

Creating PowerView Report in Excel 2013

Creating PowerView Report in Excel 2013


Power View is an interactive data exploration, visualization, and presentation experience that 
encourages intuitive ad-hoc reporting. 

Power View is a feature of Microsoft Excel 2013, and of Microsoft SharePoint Server 2010
and 2013 as part of the SQL Server 2012 Service Pack 1 Reporting Services
 Add-in for Microsoft SharePoint Server Enterprise Edition.



 Power View and Power Pivot are available in the Office Professional Plus and Office 365
 Professional Plus editions, and in the standalone edition of Excel 2013.

 In order to getting Started with Powerview Sheets you have to follow certain things.
 1-Install Silver light.
 2-Turn On power view add-in from excel Options below are the steps.
 Go to File > Options > Add-Ins.
In the Manage box, click the drop-down arrow > COM Add-ins > Go.
Check the Power View check box > OK.


Once done above we will start with our first Power view Report.

1-Select a blank work book.
2-connect to a datasource.
Two ways to connect to Data source-First by Data Tab
second using PowerPivot
We will use powerpivot.
Click Powerpivot Tab(Turn On Same as Powerview throgh option-Add-Ins)
Manage
Home
From Database
Select a table or query (using adventurework2008 DB -Person Table)
Finish
Click on excel sheet in top

--Inserting a power view sheet
Insert tab
Powerview.Screenshot1

--Now here we start  power view where  we will show multiple things in a single Power view sheet.

you can drop any column in any place and show them in table,barchart or pie chart like in screenshot2.


check the boxes you want to show in Table in our case we will check
First Name and last name in table
first table done

Now click on empty space

In order to covert table in chart select table

above click on Design
Bar chart
if you want pie chart click on other chart
drop Person type and Email promotion field in table
It will convert the Table in chart as your need.


The magic of powerview is click on any bar it will filter the dashboard based on bar values.
You can also add filter by clicking on table or chart corners.



Once done save your Dashboard in Share point site.

Note:In order to view power view Report in share point site we have to configure the Power view in share point first then only we can view Powerview Dashboard and reports in SP site.



No comments:

Post a Comment