In power View, you have got a number of Chart options: Pie, Column, Bar, Line, Scatter, and Bubble. The Charts in power View are interactive. if you click on on a value in one chart −
Consequently, power View Charts serve as interactive, pictorial data analysis tools. Similarly, the charts are interactive in a presentation putting also, which could permit you to highlight the analysis effects.
You may use Line charts for comparing data points in one or more data collection. Line charts distribute category data evenly along a horizontal (category) axis, and all numerical value information along a vertical (value) axis.
Assume you need to show the Medal depend for each country.
The values similar to that data point can be displayed at that point.
You can use Bar charts for comparing data points in one or more data collection. In a Bar chart, categories are prepared along the vertical axis and values along the horizontal axis. In power View, there are three Bar chart subtypes −
You may convert a table Visualization to Bar Chart Visualization as follows −
The table Visualization on the right gets converted to Bar Chart Visualization. As you observe, the y-axis values are sorted by way of the category values in ascending order.
In both the visualizations, click the Gender field also in the Power View Fields list.
Click the left part of the Bar – GER. it is highlighted. in the table, only the data for GER and men can be displayed.
Note − You cannot make multiple choices in this example.
You may use Column charts for showing data changes over a period of time or for illustrating comparison among gadgets. In Column charts, classes are along the horizontal axis and values along the vertical axis.
In power View, there are three Column chart subtypes −
You may convert a table Visualization to Column Chart Visualization as follows −
The table Visualization on the right is transformed to Bar Chart Visualization. As you observe, the x-axis values are sorted by using the class values in ascending order.
Click on the lower portion of the Bar with Category GER. It gets highlighted.
In the Table, only the information for GER and Men will be displayed.
Pie charts in power View are easy or sophisticated. you may analyze simple Pie charts in this section. you will study sophisticated Pie charts in the next phase.
Start with creating a Pie chart as follows −
The table Visualization under the Stacked Column chart is converted to Pie Chart Visualization. As you study, there are too many slices in the Pie chart as there are many classes (countries). note that Pie charts work well only when the number of classes is 8 or less.
You can reduce the number of categories through filtering the values as follows −
Note − you have to define and follow filtering to each of the visualizations separately.
Now, you have a easy Pie Chart Visualization, in which the count of Medals are shown through the Pie size, and countries through colors.
Click on on a Pie slice. That slice is highlighted and others get grayed. The corresponding column in the Column chart also is highlighted. in the table, only the values similar to the highlighted Pie slice can be displayed.
You can make your Pie Chart Visualization sophisticated, via adding extra features. you can make a pie char that −
In the Pie chart, in the power View Fields list, drag the field Gender to color area, to under the field NOC_CountryRegion. this means you have two categories.
Your power View looks as follows –
As you observe, there is a single slice with one color for each category - country.
At the Pie chart, double-click on the usa slice.
The Pie chart to your power View may be modified to show values via Gender, which is the second category, for the chosen category (usa). the colors of the pie chart now display the percentages of the second field, i.e., Gender, filtered for the pie color you double clicked. In other words, the Pie chart was drilled down. As you observe, a small arrow seems on the top right corner of the Pie chart. if you place the mouse over it, the arrow is highlighted and Drill up can be displayed.
Click the drill up arrow. The Pie Chart returns to its previous state.
In the Pie chart, in the power View Fields list, drag the field Gender from color area to SLICES region.
Your power View seems as follows –
As you can see, inside the Pie chart, there are two slices of same color for the class usa.
Click on one of these slices.
You may be able to see the following changes in power View −
You may use Scatter charts to show many related data in one chart. In Scatter charts, the x-axis shows one numeric field and the y-axis shows another, making it easy to see the relationship among the two values for all the objects in the chart.
To create a Scatter Chart Visualization, continue as follows −
You will get the Scatter Chart Visualization, with the data points displayed as circles of same size, showing how the be counted of event and Medal count values are related for every sport.
The sport Wrestling has less variety of medals in more number of events as compared to the sport Aquatics that has extra number of medals in less number of events.
You can use Bubble charts to show many related data in a single chart. In Bubble Charts, the x-axis shows one numeric area and the y-axis shows any other, making it easy to see the relationship between the two values for all the items within the chart. a third numeric field controls the size of the data points.
To create a Bubble Chart Visualization, proceed as follows −
As you observe, the size of each bubble shows the medal count. The data labels show the Sport.
You can also color the bubbles by a category as follows −
As you observe, Legend indicates the values of the category this is in color area and the respective colors. The data labels correspond to the category in info area. the size of the data points is by the area ∑ size.
Next, you can see how choosing a category in Legend changes the visualization −
Click on on a value in the Legend. only the data factors of that color (i.e., similar to that value) will be highlighted. all the other data points will be deactivated.
As you study, all the sports similar to the selected country are displayed and the size of each bubble represents the medal count.
If you need to recognize the info of a single data point −
Best that bubble is highlighted and the rest of the bubbles get grayed. all of the information about that data point can be displayed in a box next to the data point.
You may visualize the data changes over a period of time using Play Axis as follows −
A timeline with a Play button is inserted to your Bubble chart visualization. you can adjust the timeline by filtering the version field values within the Filters. this will be useful if you need to focus on a selected time range or if the timeline is too extensive.
You can pause at any point to study the data in more detail.
Excel Data Analysis Related Tutorials
|VBA For Excel Tutorial||Microsoft Excel Tutorial|
|Microsoft Word Tutorial||Microsoft Powerpoint Tutorial|
|Microsoft Entity Framework Tutorial||Microsoft Azure Tutorial|
|Microsoft Project Tutorial||Advanced Excel Charts Tutorial|
|Advanced Excel Functions Tutorial||Excel Dashboards Tutorial|
|Excel pivot tables Tutorial||Excel Power View Tutorial|
Excel Data Analysis Related Interview Questions
|VBA For Excel Interview Questions||Microsoft Excel Interview Questions|
|Microsoft Word Interview Questions||Microsoft Powerpoint Interview Questions|
|Microsoft Entity Framework Interview Questions||Microsoft Azure Interview Questions|
|Microsoft Project Interview Questions||Excel Data Analysis Interview Questions|
|Excel pivot tables Interview Questions||Excel Power View Interview Questions|
|Microsoft Interview Questions|
Excel Data Analysis Tutorial
Excel Data Analysis
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.