Exploring Data with Power View Tiles


Advertisements


Suppose you have lot of data to display with significant data points at varied places. In such a case, you might have to scroll very often in your Power View visualizations to find the data you are looking for. This would be tedious and also might not be smooth when you are presenting the results.

You can overcome this drudgery, using the tile feature in Power View. With tiles, you can gain insights from your data much more quickly. Tiles act as navigation strips, with a single tile for each possible field value. When you click on a tile, only data related to that field value is displayed. As it is easy to scroll the values in the navigation strip that dynamically changes the corresponding values in the visualization, tiles become an easy to use tool for you.

You can have Tiles in a Table, Matrix, Card or Chart visualization. You can have a combination of these in Power View and get them filtered with Tiles. A Tile can be simple text or an image.

Table with Tiles

Start with a Table Visualization as follows −

  • Drag the fields NOC_CountryRegion, Sport and Medal Count to Power View. As you observe, as the number of rows is large, it is difficult to scroll up and down to highlight values.

  • Drag the field Sport from FIELDS area to TILE BY area in the Power View Fields list.

Navigation Strip appears at the top of the Table.

Table with Tiles

You can observe the following −

  • By default, the first Tile in the Navigation Strip is selected.

  • In the Table, the values are filtered to that of the Tile selected. In this case, the Sport that is selected.

  • There are arrow buttons at the left and right edges of the Navigation strip to enable scrolling.

You can select a different Tile as follows −

  • Scroll the Navigation Strip to display the Tile representing the Sport you are looking for, for e.g. Badminton.

  • Click the Tile – Badminton. The values in the Table are filtered to those of Badminton.

Select Different Tile

You can observe the medal count Total is also displayed. You have an option to turn Totals on or off from the Ribbon. You also can make the Tiles more appealing and meaningful by having images in place of Text.

  • Include a column that has hyperlinks to the image files corresponding to each of the Sports.

  • Include that field, for e.g. Discimage in TILE BY. You will get the Tiles as images, portraying each sport.

Include Field

Tile Navigation Strip - Tab Strip

There are two types of navigation strips in Excel - Tile Flow and Tab Strip.

In a Tab strip, you can observe the following −

  • Tab strip displays the navigation strip across the top of the Visualization.

  • By default, the first Tile in the navigation strip that is the leftmost is selected.

  • There are arrow buttons at the left and right edges of the navigation strip to enable scrolling.

  • You can scroll to the left or right to display the Tiles.

  • The highlighted Tile moves to the left or right as you scroll the tab strip. It can also go out of view, while scrolling.

  • You can click on a Tile to select it. The Tile gets highlighted at the same position as it was before.

  • In the Table, the values are filtered to that of the Tile selected. In this case, the Sport that is selected.

Tile Navigation Strip - Tile Flow

You can covert the navigation strip from tab strip to tile flow as follows −

  • Click a Tile on the navigation strip.
  • Click the DESIGN tab on the Ribbon.
  • Click Tile Type in the Tiles group.
  • Click Tile Flow in the dropdown list.
Tile Navigation Strip

The navigation strip shifts to the bottom of the Table.

Navigation Strip Shifts to Bottom

In a Tile Flow, you can observe the following −

  • Tile flow displays the navigation strip across the bottom of the Visualization.

  • By default, the first Tile in the navigation strip is selected. It will be displayed at the center of the tile flow.

  • There are no arrow buttons for scrolling.

  • You can scroll to the left or right by clicking on any of the Tiles to the left or right of the center Tile.

  • The Tiles flow to the left or right and the center Tile will always get highlighted.

  • You can click on a Tile to select it. The Tile gets highlighted and moves to the center of the Tile flow.

  • As the selected Tile is always the center Tile, the following happens −

    • Selected Tile does not go out of view.

    • When you scroll to the left or right, the Tile that comes to the center position gets automatically selected and highlighted.

    • The original selection disappears.

    • The Visualization, Table in this case, automatically is updated to the Tile in the center of the Tile flow.

  • In the Table, the values are filtered to that of the Tile selected. In this case, the Sport that is selected.

Values Filtered

Matrix with Tiles

Suppose you want the medal count by medal type – Gold, Silver and Bronze and also the total medal count, by country for a selected sport, you can display the results in a Matrix Tile visualization.

  • Switch Visualization to Matrix.
  • Add the field Medal to Matrix.

You will get the desired results as follows −

Matrix with Tiles

Stacked Bar Chart with Tiles

You can make your explored results more conspicuous by switching your visualization to Stacked Bar Chart Tile Visualization −

Stacked Bar Chart with Tiles

Maps with Tiles

As your data contains geographic locations, you can also switch over to Map Tile Visualization −

Maps with Tiles

Advertisements
E-Books Store