More demos of Power View available

In my previous blog, I talked about the Auto Sales video and demo that you can try out yourself. Today, I wanted to let you know that we have a few more demos for you to try out. Click on the image of the report to take you directly to the sample. If you want to use the model and create your own report, click on the text to do so. I’ll walk through how to use the interface after the sample list:

Contoso Oil and Gas sample report and model		Click here to create your own report
Contoso Schools sample report and model		Click here to create your own report
Tailspin Toys sample report and model		Click here to create your own report
Picnic sample report and model		Click here to create your own report
Car Auto sales and models		Click here to create your own report

Let’s walk through how to use the sample, and then how to create your own report.  I’ll use the car Auto Sales sample report and model.  To use the sample report, just click on the report image (or here).  You are taken to the report (after you’ve logged in using your LiveID and have Silverlight 5 installed – you only need to do this once) which is in reading mode.  The report is fully interactive so you can select any of the bar chart items, and it will show you only the make of those cars for that type selected, and sales for previous quarters.

You’ll also notice that this report has 3 Views to it.  You can click this icon to see all the views at once located in the bottom left-hand corner, or paginate through the different views using the control located in the bottom right-hand corner .  Each view is fully interactive so click on the various areas to dive deeper into the data.  You can also click on the Full-Screen mode to remove the chrome and be fully immersed.    If you want to change any of the items on the report, click on Edit Report.  You’ll now be exposed to all the Views in the report as well as the Business Intelligence Semantic Model (BI SM),  Ribbon, and object field well.

Simply select an object on the screen and modify it.  Maybe you want to have a clustered bar instead of a bar chart, or add more measures to the line chart.  Feel free to modify the report as much as you want.  I am going to describe how to create this report using the Click here to create your own report link.  You’ll notice that when you first click this link you are taken to a blank report.  Not very exciting.  Click on the edit report to begin.  You now have a clean View to create your own report. 

Let’s begin.  Click anywhere on the view and then click on Cars in the BI SM.  You’ll see the wait cursor and then a table of information will appear.   The Cars item in the BI SM is also bold meaning you’ve selected items from it.

Let’s change this view from a table to a card.  Click anywhere in the table and then from the Ribbon, select Design, in Visualizations select the down arrow, and the at the bottom click on Card.  You can also scroll in the Visualizations box.

Go ahead and resize this view so you an add more items on the page.  Click outside of the Card view in any empty area.  Expand the Cars item from the BI SM and then click on Type.  Expand the Sales item and then click on Cumulative Sales.  You’ll notice as you do, data begins to appear in the View, and the default action was to total the measure.

Click on the new table and then under Designs, select Column.  Resize this object so you can see all the different Types of cars and their sales.

The report is fully interactive so you can click on a bar item and only those cars in that type are displayed.  Now that you’ve tried this out, let’s go ahead and add the last object for this View.  Click on the empty white space to the bottom of the column chart and then expand Time, and select Quarter, and then from Sales select Sales Amount.  From the Design tab in the Ribbon select Line.  Resize this object to the width of the View.  Your final view should look like this:

Just one more thing to do to this View.  Click on the Line chart in the View, and then from the Home tab in the Ribbon, select Filter Area .  In the View, you’ll notice the Filters Area pop open.  Click on Chart to see the and then click Quarter.  Select (All) and the uncheck Q1 2006 to Q4 2006.  This means we are going to display all the Quarters except 2006.  The Filter Area allows you to identify what items to display on each view, or for each object (in this case the Chart).  You can simply drag and drop items into the Filters Area, use search to find items to include/exclude, as well as use sliders to limit timeframes.  You can close the filters area by selecting the icon in the Ribbon tab (don’t worry, your filters are still applied), or minimize the area by selecting the arrow in the heading .  I’ve done this in the picture below. 

Now that you’ve completed your first View, go ahead and click on column chart items to see which models are selling well and which ones are declining.  Click on the same column item to return the view to all items.

I am going to stop here but feel free to continue creating your own reports, using any of the models provided.  If you want to continue with Auto Sales, in the Ribbon, select Home tab and then click on New View .  Insert a blank view to continue adding more items or duplicate view if you want to modify anything to tell more of the story.  Use copy and paste to bring items from the original view forward if you don’t duplicate it and remember that each item can pop out to reveal more of what’s happening with the data.  Most of all, have fun. 

Comments

• Anonymous
  December 27, 2011
  Wonderful!  This allows everyone to have some fun trying out Power View.  Thanks for making this wish become a reality.

• Anonymous
  December 28, 2011
  Very cool. Thanks for setting this up for people to demo.

• Anonymous
  December 29, 2011
  Can you please provide the link of Contoso Oil And Gas Power View sample report. I opened it but it is blank. Thanks

• Anonymous
  December 29, 2011
  Hi Farrukh, if you click on any of the images in the table, they will take you to the sample report.  If you click on the text - click here to create your own report - it will take you to a blank report.  Thanks for checking the site out. -Pej.

• Anonymous
  March 02, 2012
  Very useful, appreciate your effort and time on this.

• Anonymous
  August 14, 2012
  Please check out my self-service BI suites comparison (including Power View) @ bicortex.com/implementing-self-service-bi-with-tableau-public-microsoft-powerview-and-worldwide-telescope-with-excel-add-in

• Anonymous
  September 23, 2012
  I have installed a picinic sample to my power view but when I select an image field a power view not render it while the image path is correct!!!!!!!!! Why???

• Anonymous
  January 10, 2013
  Hi thanks can i know how to create an image in the visulization card

• Anonymous
  March 05, 2013
  This site does not work. I click any of the things I suggest you click, it takes me to a place which asks me to sign in or open another account. I even did that and there seems to be a problem. Perhaps it is browser related

• Anonymous
  March 05, 2013
  As I guessed it was a problem, unfortunately with IE 9.0 browser. It came up OK on Chrome. I stand corrected about the site.

• Anonymous
  March 14, 2013
  This is just amazing.... I fell in love with Power View !!

• Anonymous
  July 23, 2013
  The samples are great and I appreciate the opportunity to try creating my own.  It worked for a couple of times 7/21, but since then I can't get to the samples.  It reports the page as not being found.  It doesn't matter if I am authenticated or not. Is the server up?

• Anonymous
  July 30, 2013
  None of those links are working right now.

• Anonymous
  August 06, 2013
  Thanks for going through the effort of creating the demos, but none of the links are currently working. If they have been decommissioned then please remove them from the site.

• Anonymous
  October 23, 2013
  The comment has been removed

• Anonymous
  November 22, 2013
  Hey just wondering if those demos are still working. I've seen this before and tried to go back. And see them. Please advise if they will be back up soon or not? Thanks

• Anonymous
  December 04, 2013
  Are these samples removed I am not able to navigate to any report mentioned here Am I missing on something here, to view these Power View reports?

• Anonymous
  February 16, 2014
  These still appear to be not working.  Please update the links.

• Anonymous
  March 20, 2014
  These links used to work.. what did you do!???

• Anonymous
  May 04, 2014
  Thank you team for making it happen at the end. We wish lot more. May Long live MS

• Anonymous
  March 11, 2015
  Hyperlinks does not work. Please update.

• Anonymous
  July 04, 2015
  The links on this page no longer work, what is the status of this site now? businessintelligencedemoportal.com

• Anonymous
  September 03, 2015
  This article is totally cool. Unfortunately as guys have highlighted the hyperlinks added like <a href="www.simbacar.com">Car Auto sales</a> and models "Contoso Schools sample report and model" are not working as they lead to this parked domain businessintelligencedemoportal.com Thanks