Data Visualization in Power BI using Power View

The estimated reading time for this post is 3 minutes

In the ‘previous blog post called ‘All About Power BI’, I came across to describe ‘what is PowerBI’, and ‘what is Power BI components’. Therefore in this blog post, I would like to focus more on how to visualize data in Power View and Power Map components.

When business users have obtained the data that they want to analyze and have used it to create a data model, they often want to explore the data visually by creating charts and other graphical representations. Microsoft Excel supports a range of chart types that can be used to visualize data, but traditional charts on a worksheet offer limited interactivity and are more appropriate for representing the results of analysis than for using to analyze the data in the first place. Power View is a data visualization technology that enables users to quickly create and change graphical representations of data values that encourage exploration of the data in an intuitive, interactive experience.

Data Visualization in Power View

Power View is an easy-to-use data visualization and exploration tool that enables you to produce ad hoc reports that deliver information in a range of visually interesting ways. Along with PowerPivot and Power Query, it promotes self-service business intelligence (BI), enabling data workers to quickly and easily find the information that they require without depending on BI developers to create reports and data visualizations for them.

Power View is a data visualization application that enables you to interactively explore data and to create reports that have a strong visual impact. Power View is available as an add-in for Excel, or as an interactive reporting interface in Microsoft SharePoint Server when SQL Server Reporting Services is installed in SharePoint integrated mode.

 Power View in Excel

Power View in Excel is an add-in that is provided with Excel 2013 Professional Plus. The Power View interface is built into Excel, and each Power View report that is created in a workbook is added as a Power View worksheet. To create a Power View report, select the data that you want to include in the report, and then on the Insert tab, click Power View. You can create a Power View report from any range of cells in a worksheet. This enables you to quickly start visualizing data in the workbook. However, Power View is optimized for visual exploration of tabular data models, so Power View works best after you create a PowerPivot data model in the workbook. You can select any cell in a PivotTable that is based on the PowerPivot data model and insert a Power View report that automatically includes the tables that are defined in the data model.

You can create Power View reports by choosing from a range of charts and tables, which are called visualizations. Power View reports are very easy to create, and the user interface is very simple and intuitive. Power View generates data visualizations dynamically as you add fields to the report, apply filters, and specify fields for specific chart areas. Initially, data that is added to a Power View report is shown as a table, but you can choose from a selection of visualization and chart types in the Visualizations gallery. 

Power View Demonstration

I would like to use Power Station Sample data to demonstrate the basics of Power View. You may follow the following Steps to generate the same result.

You do need to install Power View add-ins for Microsoft Excel before you start the following steps.
You may click on download button to get sample data.  

Step1: Open Power View

Click on the ‘Insert’ ribbon tab, and then click on ‘Power View’ button to open the Power View design view.

step1

step 1-1

Step 2: Choose Required Fields

After step 1, you need to choose the required fields by the visualization. Then you click on ‘Map’ icon.

step 2

Therefore, you will see such visualization.

step 2-1

Above visual, illustrates the capacity of the power station in each county with different color based on the energy used.

Step 3: Add Slider

To filter data and make the visualization meaningful, you may add a Slider to filter the entire power view visualizations.

step 3

Conclusion

Power View is designed to provide a dynamic data visualization experience in which displaying data is an interactive process. You have already seen how Power View makes it possible to create data visualizations quickly, and how to apply filters and highlight data interactively.

You may attend our customized Power BI training class to explore further ways to display data, and discusses how to optimize an Excel data model for intuitive data visualization in Power View.

Hamid J. Fard

I am SQL Server Data Platform Expert with more than 9 years’ of professional experience, I am currently Microsoft Certified Master: SQL Server 2008, Microsoft Certified Solutions Master: Charter-Data Platform, Microsoft Data Platform MVP and CIW Database Design Specialist. I also do Pig, Hive and Sqoop development regarding Hadoop Big Data platform. After a few years of being a production database administrator I jumped into the role of Data Platform Expert. Being a consultant allows me to work directly with customers to help solve questions regarding database issues for SQL Server.

More Posts

Follow Me:
FacebookLinkedIn


Leave a Comment

Be the First to Comment!

Notify of
avatar
1000
wpDiscuz