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 Schools sample report and model
Tailspin Toys sample report and model
Picnic sample report and model
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.
Wonderful! This allows everyone to have some fun trying out Power View. Thanks for making this wish become a reality.
Very cool. Thanks for setting this up for people to demo.
Can you please provide the link of Contoso Oil And Gas Power View sample report. I opened it but it is blank.
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.
Very useful, appreciate your effort and time on this.
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
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!!!!!!!!!
can i know how to create an image in the visulization card
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
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.
This is just amazing.... I fell in love with Power View !!