Power BI for Office 365 Released

Today Microsoft has officially announced the release of Power BI for Office 365.  You can read the Power BI teams post on the release here:

http://blogs.msdn.com/b/powerbi/archive/2014/02/10/announcing-the-general-availability-of-power-bi-for-office-365.aspx

Power BI has some pretty amazing features that allow users take control of their data.  I’ve also written several posts in the past about the Power BI features you can browse here:

Power Pivot

Power Query

Power View

Power Map

Power Q&A

Sign up for Power BI now here!

Final Day for Power BI Voting, Can I Have Your?

Today is the final day for the Power BI Contest voting and I could use your help to move on in the competition!  Please take a moment and vote for my video here  http://tinyurl.com/PowerBIDevin

Thanks for voting!

Power BI Contest Entry Voting

You’ve watched my video (hopefully) now vote for it!  In a previous post I wrote about my Power BI contest entry (Read more about it here).  I really enjoyed making this video and hopefully you enjoyed watching it.  Please take a few moments and vote for my entry here.

http://j.mp/1cFcLGj

 

Power BI Contest Entry

Today I submitted my Power BI contest entry and I’d love for you to take a look!  Here’s a short description of entry and the video itself:

In this submission I have used Power BI to help me plan a vacation with my wife. We both love thrill rides so I wanted to make the best decision on planning our next trip. Using Power Query I imported data from the web to find all possible roller coasters and amusement parks. I then took that raw data and made relationships and calculations using Power Pivot. Next, I visualized the results through Power View to help guide me through the data easier. Finally, I uploaded my workbook to a Power BI site and enabled Q&A to allow my wife to ask the workbook questions about our trip.

 

Find out more about this contest here and put in your own contest entry.

Power View Reporting on Multidimensional Cubes Released

I’m a little late to the celebration but on Friday some there was some exciting news regarding Power View was announced. You can read about the details of it at the Analysis Services and PowerPivot team blog for Microsoft here.

http://blogs.msdn.com/b/analysisservices/archive/2013/05/31/power-view-connectivity-for-multidimensional-models-released.aspx

This is part of a SQL Server Cumulative update pack that you can download here.

http://support.microsoft.com/kb/2833645

One thing to probably make mention of that you can ready on the Microsoft team blog is that this is only for SQL Server and SharePoint Power View.  If you’re using Power View with Excel 2013 only then you’ll have to wait a little longer for an update.

Either way this is great news and for those that were anticipating projects to convert Multidimensional cubes to Tabular or PowerPivot so they could use Power View.

Excel 2013 – Trouble Installing Silverlight for Power View

Last week during my 24 Hours of PASS session on Choosing a Reporting Platform I fielded a question that appeared multiple times during the Q&A so I thought it would be worth post.

When using Power View in Excel 2013 the first thing you may notice is a screen like the below screenshot prompting you to download and install Silverlight.

7-16-2012 9-34-29 PM

The question that many people in the session had was no matter how many times they installed Silverlight they couldn’t make it past this screen prompting to install Silverlight.

Turns out this is an easy fix.  Just make sure when you download and install Silverlight that it is done from Internet Explorer.  Many people use other web browsers these days but remember you’re working in a Microsoft tool and it would only make sense that you would download Silverlight using IE.  After installing using Internet Explorer hit the Reload button and you should be good to go!

Building Your First Power View Report

This has been reposted from a guest blog post I wrote on the Microsoft Business Intelligence team blog.

Fulfilling User Needs

Developing a Power View report has been touted as being so simple that within a handful of clicks you can add rather impressive elements, like effective visualizations, to a report. This isn’t always the case with other tools in the market. The goal of this post is to walk you through Power View as if you were designing a report for the first time, and show you how simple it really is to build a Power View report.

Using the Development Environment

Before we start, it’s important to note that you will need SQL Server 2012 and SharePoint 2010 to create a Power View report. Power View also runs on Silverlight 5, which enables you to edit Power View reports in a browser window, as shown below.

clip_image002[4]

The development interface retains the familiar look and feel of Office tools. If you know how to use Excel, picking up Power View for the first time should be a breeze.

Understanding your Data

Understanding your data and what you want to achieve with it is one of the most important aspects of building a Power View report. The better a report designer understands the layout of the data model, the easier it becomes to produce insightful results. Power View is designed to help you produce fast results in an easy to understand format.

When designing PowerPivot reports with images and visualizations, you may want to consider BISM Tabular data sources for Power View reports. Shown below is a report that leverages a data set with images enabled by BISM Tabular data sources.

clip_image004[4]

Building your First Report

In this demonstration of building a basic Power View report I will be using a data set found on Microsoft’s live demo site. To follow along go here to access the blank Power View Report (this will require a Windows Live ID).

Upon launching this live example you will see a blank report in presentation view. To edit this blank report, select Edit Report in the top left of your screen.

clip_image006[4]

You can create report elements by selecting the data you would like to visualize from the data pane on the right side of your screen. It’s helpful to know how your data model is organized because you may find yourself struggling to find the fields you need otherwise.

Next, from the Product table, select Image and then use the Visualizations toolbar to set the field as Tiles. This will place the product images in slide tile view. You may need to stretch the tiles across the width and the length of the report for layout purposes.

clip_image008[4]

To capture the details of each product in the slide tile view, select a single product image and select Card from the Visualizations toolbar dropdown. Add the fields Product Name, Category, Channels, Item Group, SKU and Retail Pricefrom the Product table. To fit all of the information you may need to resize the Card as shown below. Think of the Card as a baseball card that captures all the key information about a product.

clip_image010[4]

Next, we will add regional sales information to the report. To get the regional data to interact with the product image tiles, select a tile and pick Region Map and Region Name data elements from the Region table. From the Sales table selectRevenue. This gives a tabular view of the region sales for the selected product with an image that highlights the part of the country that makes up that region. Move this table to the bottom right of the report to improve the layout of the report.

clip_image011[4]

To complete the regional view of our report, we will put together a bar chart of profitability metrics by product. Begin by selecting one of the tiles and pick the data elements Profitability from the Sales table and Wholesales Price from the Product table. Turn the new table into a chart by selecting Clustered Bar from the Visualizations toolbar. Resize and move the chart to the bottom left of the report. Lastly, name the report Product Sales Report. The final result of this first view should look like this.

clip_image012[4]

Power View reports can have multiple views, which appear as multiple pages to a user. This allows users to easily flip through multiple reports in a single Power View document. To create a new view, select the View context menu on the left side of the design surface and click New View as shown below.

clip_image014[4]

In the new view we will demo one of the most impressive visualizations in Power View –the Scatter chart. To begin, go to the Sales table and select Revenue, Quantity, and # Products, and from the Product table select Category. Once the data elements are selected, choose Scatter Chart from the visualizations toolbar to turn the table into a chart. The result is a nice scatter that shows which product categories generate the most revenue for the business. To take this chart to the next level, we could add animation to it by dragging Month from the Date table to the Play Axis of the chart. Resize the chart to fill the entire report view and hit the play button on the bottom left to view product category performance over time. Lastly, name the report Sales Analysis by Month.

clip_image016[4]

With this report complete, you can view it as a user by selecting Full Screen under the Home tab of the toolbar. This allows you to flip through multiple views of the report and preview the report views by selecting the button in the bottom left of your screen.

clip_image018[4]

Hovering over the views, you get a larger preview on the top report. When you select a report, it appears in full screen mode.

Going through this demo should have given you the idea of how with just a few clicks, you can create impactful, insight-driving reports with Power View.

Follow

Get every new post delivered to your Inbox.

Join 37 other followers