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 image Click here to create your own report

 

 

Contoso Schools sample report and model

image Click here to create your own report

 

 

Tailspin Toys sample report and model

SNAGHTML457043b Click here to create your own report

 

 

Picnic sample report and model

SNAGHTML4598819 Click here to create your own report
Car Auto sales and models SNAGHTML45d4697 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.

Hybrid Cars showing

You’ll also notice that this report has 3 Views to it.  You can click this icon to see all the views at once image located in the bottom left-hand corner, or paginate through the different views using the control located in the bottom right-hand corner image.  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.

SNAGHTML46ed475

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. 

SNAGHTML471e0f3

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.

image

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.

image

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.

image

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.

image

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:

image

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 image.  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 image.  I’ve done this in the picture below. 

image

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 image.  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. 

Digg This