Aesthetic Power View Reports - Excel Data Analysis

What is Aesthetic Power View Reports?

You have got learnt how to explore data interactively the use of power View in the earlier chapters of this tutorial. Every power View sheet can in turn be used as an interactive file. To make the power View document more appealing, you may select any of the topics, chart palettes, fonts and background colors that power View offers you.

When you convert the topic, the new topic applies to all of the power View visualizations in the report. further, you can upload background images, select background formatting, layout numbers, and change the Font or the text size.

Report Layout Finalization

As with another file, you need to first decide on what you are going to report and the best layout so that you can highlight the huge data points.

Suppose you want to report the information of the medals received by Australia in aquatics. As you are aware, the information consist of the disciplines in aquatics, medal depend, and the medal types (Gold, Silver and Bronze).

You can have three perspectives in the document for the best portrayal of the data points in this example −

  • Matrix that includes the data - country, sport, and medal depend.
  • Card that includes the data – country, sport, area and medal depend.
  • Stacked Bar chart that contains the data this is drilled down to area, medal and medal depend.

Aesthetic Power View Reports

As you may observe, the information in the Matrix and Card is scrolled so that −

  • Matrix shows the information of Australia for all sports and aquatics got 354 medals.
  • Card shows Australia – sport aquatics, disciplines Diving, Swimming and Water polo and medal depend in each of them.
  • Stacked Bar chart shows the medal depend through medal type in those three disciplines.

Now that the document format is prepared, you may start making it appealing. but, you want to preserve points in thoughts during this project −

  • The look of the document need to be based at the audience (Managers / top management / clients).
  • Do not recover from bored with the different formatting options. simply preserve it easy and highlight the information points that require attention.

In the following sections, you will recognize a way to arrive at a sample report with the following options −

  • Selecting the background.
  • Selecting the theme.
  • Changing the Font.
  • Changing the text size.

Selecting the Background

You can have a background color in your power View file. through default, it is white. you may change it with the background command.

  • Click the power VIEW tab at the Ribbon.
  • Click background inside the topics group.
  • Click on Light1 center Gradient. (you can select the one that best suits your report).

The background color changes to the selected one.

Aesthetic Power View Reports

You may even set a background picture. For e.g. you may put your company logo or a view of your company facility.

Selecting The Theme

Power View helps several topics. select the one that suits your document as follows −

  • Click at the power VIEW tab at the Ribbon.
  • Click on on topics inside the topics group.

You may get many options to select from. if you are not sure about the right one, just play around with some to locate how the show looks.

  • Click on at the topic aspect.

Your record may be displayed in the selected topic.

Aesthetic Power View Reports

Changing the Font

As you can study, the text in the file is not conspicuous. you can change the font as follows −

  • Click on on the power VIEW tab at the Ribbon.
  • Click on on Font in the topics group.
  • Click on Verdana in the dropdown list of fonts. (you can select the only that best suits your file).

Next, you have to make the text show a bit larger.

Changing The Text Size

Change the text size as follows −

  • Click on the power VIEW tab at the Ribbon.
  • Click on text size inside the topics group.
  • Click on on 150% in the dropdown list. (you can select the only that best suits your report).
  • Adjust the widths of the columns in Matrix.
  • Adjust the size of every view in the file.

Aesthetic Power View Reports

Your sample report is ready.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Excel Data Analysis Topics