Category: excel Power View

Excel Power View – Sheet ”; Previous Next In the previous chapter, you have created a Power View sheet and a Power View on the Power View sheet. Note that you can create multiple Power Views on a Power View sheet. They are called Visualizations. You will learn about the various different visualizations that you can create on a Power View sheet in the subsequent chapters. Before you learn about the different visualizations, you need to understand the various parts of the Power View sheet. Power View Sheet Layout The Power View sheet layout looks as follows − You can find the following different parts on the Power View sheet. Power View Area. Power View Visualizations. Power View Title. Power View Fields List. Filters. Power View Area Power View area is like a canvas on which you can create multiple different visualizations based on the data in the Data Model. You can have multiple visualizations in the Power View area and work on them either collectively or separately. To create a new visualization, you need to click on an empty part of the Power View area, and select the fields that you want to display in the visualization. Power View Visualizations The variety of visualizations that Power View provides is the strength of Power View. You can have any number of visualizations on the Power View area and each with different size and different layout. For example, you can have a Table visualization, a Chart visualization and a Map visualization on a single Power View. The fields that are displayed in the visualizations can be individually chosen. The sizes of the visualizations can be different. To resize a visualization, do the following − Click on the symbol in the top right corner, or Click on the symbol in the bottom right corner and pull the arrow that appears Pop out and Pop in You can make a visualization to occupy the entire Power View area with the Pop out button that appears on the top right corner of the visualization. Move the cursor to the Table visualization. Move to the top right corner of the Table visualization. The Pop out button is highlighted. Click the Pop out button. The Table visualization pops out to the entire Power View area. The Pop out button changes to Pop in button. Click the Pop in button. The Table visualization reverts to the original size. Power View Fields List The Power View Fields list displays all the tables in the Data Model and the corresponding fields. By selecting the fields, you can display the required data in a visualization. Note that you can choose different fields for the different visualizations on a Power View sheet. This makes Power View a versatile and collective tool to visualize the different aspects of the data in the Data Model. While the selected fields in the Power View Fields list determine what data is to be displayed in a visualization, the areas below the Fields list determine how the data is to be displayed. For example, you might choose to display the fields – Country, Sport, Gender, and Medal Count in the visualization. While placing these fields in the Areas, you can opt to display Gender as a Legend. You will learn the different types of Areas and the way they can change the layout of a visualization in the subsequent chapters. Title The Title in a Power View sheet is for the entire sheet. Therefore, while giving a Title, see to that it meets the objective of the entire Power View report. Filters The Filters area allows you to filter the fields for specific data that is to be displayed. You can choose to apply a filter to the entire View, i.e. all the visualizations or only the selected visualization. Click Table visualization. As you can observe, the Filters area has two tabs – VIEW and TABLE. If you click the tab TABLE and apply the filters to fields, only the data in the selected TABLE visualization will be filtered. If you click on the tab VIEW and apply the filters to fields, the data in all the visualizations in the Power View sheet will be filtered. If the visualization is other than Table, say Matrix, then the tabs in the Filters area will be VIEW and MATRIX. You will learn about Filters in detail in the chapter – Combination of Power View Visualizations. Power View Tabs on the Ribbon Power View has three tabs on the Ribbon − Power View, Design, and Layout. When you create a Power View Sheet, the tab – POWER VIEW is added to the Ribbon. When you create a Power View (visualization) such as Table visualization and click it, the tab – DESIGN is added to the Ribbon. When you switch visualization to a Chart or Map, the tab – LAYOUT is added to the Ribbon. Print Page Previous Next Advertisements ”;

Excel Power View – Bar Chart Visualization ”; Previous Next Bar Charts are used for comparing data points in one or more data series. In a Bar Chart, categories are organized along the vertical axis and values along the horizontal axis. As you know from the previous chapters, you need to start with a Table and then convert it to Bar Chart visualization. Select the fields – Country and Medal Count. By default, Table will be displayed. Types of Bar Chart Visualization In Power View, there are three types of Bar Chart visualization − Stacked Bar. 100% Stacked Bar. Clustered Bar. Switching to Bar Chart Visualization Convert the Table to Bar Chart as follows − Click on the Table. Click the DESIGN tab. Click Bar Chart in the Switch Visualization group. Select Stacked Bar from the dropdown list. The Table is converted to Bar Chart. You can see that Y-axis values are sorted by the category values in ascending order. Exploring Data with Bar Chart Visualization You can explore data with Bar Chart in several ways. You will understand the various methods that you can use for data visualization and exploration with Bar Chart in this section and the subsequent sections. You can sort the Y-axis values in Bar Chart by the Medal Count as follows − Take the cursor to above the Bar Chart. On the top left corner, you will find – sort by Country asc. This means the sorting is by Country and in ascending order. Click on Country. It will change to Medal Count. Click asc. It will change to desc. The Bar Chart will be sorted by Medal Count in descending order. Combination of Bar Chart and Table Visualizations You can view the interactive features of Bar Chart visualizations by placing a Table on the same Power View. Create a Table with the fields, Country and Medal Count. Adjust the sizes and positions of Bar Chart and Table to appear as below. From the Bar Chart, you can see that USA has the highest Medal Count. Click on the Bar for USA. That Bar will be highlighted and other Bars will be inactive. The Table is filtered to show the values only for the selected Bar. The highest Medal Count is of USA with 4833 as displayed in the Table. To find the top three Medal Counts, proceed as follows − Click on the Bar with Category USA. Only that Bar will be highlighted. With Ctrl key pressed, click on Bars with Categories URS and GBR that are in second and third places. The Bars for USA, URS and GBR will be highlighted. The Table also shows values for these three Categories only. From the Bar Chart, you can also observe that the values for NED, RUS and CAN are almost equal. Click on the Bar NED. With Ctrl key pressed, click on the Bars RUS and CAN. The Bars for NED, RUS and CAN will be highlighted. The Table also shows values for these three Categories only. Adding a Legend You can observe more powerful features of Bar Chart by adding a Legend. Click on the Bar Chart. Drag the field Medal to LEGEND area. Click on the Table. Drag the field Medal to FIELDS area. As you can see, this is a full-fledged Stacked Bar Chart visualization, showing the Medal Count by Medal type for each Country. Click on the orange color portion of the Bar for GER. You can observe the following − Only the orange color portion of the Bar for GER on which you clicked will be highlighted. The other two portions of the Bar for GER will become inactive. All other Bars will become inactive . The Table will be filtered to show only the values of highlighted region. Note − You cannot make multiple selections in this case. 100% Stacked Bar Chart You can convert the Stacked Bar Chart to 100% Stacked Bar Chart as follows − Click on the Stacked Bar Chart. Click the DESIGN tab on the Ribbon. Click on Bar Chart. Select 100% Stacked Bar from the dropdown list. Your Stacked Bar Chart will be converted to 100% Stacked Bar Chart as shown below. From the Chart, you can visualize the Gold, Silver and Bronze ratios of the total Medal Count for each country. You can also visualize the ratio of the Medals won by Men and Women for each country. Remove the field Medal and add the field Gender to both Bar Chart and Table. Observe that for CHN, the Medal Count for Women is more than that for Men as against other countries. Scroll down the Table to view the values for CHN. In country CHN, the Medal Count for Men is 268 and that for Women is 549. Clustered Bar Chart You can convert the 100% Stacked Bar Chart to Clustered Bar Chart as follows − Click on the 100% Stacked Bar Chart. Click the DESIGN tab on the Ribbon. Click on Bar Chart. Select Clustered Bar from the dropdown list. The 100% Stacked Bar chart will be converted to Clustered Bar chart. Click on the Green Bar for CHN. You will observe the following − Only the selected bar will be highlighted. Other Bars will become inactive. The Table shows only the corresponding values. Print Page Previous Next Advertisements ”;

Excel Power View – Line Chart Visualization ”; Previous Next Line Charts are used for comparing data points in one or more data series. Line Charts distribute category data evenly along the horizontal (category) axis, and all numerical value data along the vertical (value) axis. As you are aware from the previous chapters, you need to start with a Table and then convert it to Line Chart. Select the fields – Country and Medal Count. By default, Table will be displayed. Switching to Line Chart Visualization Convert the Table to Line Chart as follows − Click on the Table. Click the DESIGN tab. Click Other Chart in the Switch Visualization group. Select Line from the dropdown list. The Table is converted to Line Chart. The category data is displayed along the horizontal axis and numerical value data along the vertical axis. Exploring Data with Line Chart Visualization The categories are distributed evenly along the x-axis and all the categories (countries in this case) are not visible in the display. To view the categories that are not in the display, do the following − Click and hold on the Line or the Category (x-axis) axis. Drag to left or right. The categories to the left or right will be displayed and Line Chart will be displayed accordingly. The Status Bar shows you the position of the current display as compared to the complete category range. You can drag the Status Bar to the left or right to display the categories that are on the left or right side of the current display. You might want to know the data values of a data point on the Line Chart. Place the cursor on the data point on the Line Chart. The values corresponding to that data point will be displayed at that point. Print Page Previous Next Advertisements ”;

Excel Power View – Table Visualization ”; Previous Next In Power View, for every visualization you want to create, you start by creating a Table, which is the default and then convert the Table to other visualizations easily. The Table looks like any other data table with columns representing fields and rows representing data values. You can select and deselect fields in the Power View Fields list to choose the fields that are to be displayed in the Table. The fields can be from the same data table or from different related data tables. Creating a Table To create a Table in Power View, do the following − Click on the Power View area. Click on the table – Results in the Power View Fields list. Select the fields Country, Sport, and Medal. A Table will be displayed on Power View with selected fields as columns, containing the actual values. Understanding Table Visualization You can see that the selected fields appear in the FIELDS area under the Power View Fields list. The columns are formatted according to their data type, as defined in the data model that the report is based on. The order of the fields in the FIELDS area represents the order of the columns in the Table. You can change the order by dragging the fields in the FIELDS area. You can sort the Table by any column by clicking on the column name. The sort order can be ascending or descending by values. You can filter the data in the Table by choosing the filtering options in the Filters area, under the Table tab. You can add fields to the Table by dragging the field either to the Table in Power View or to the FIELDS area. If you drag a field to the Power View area and not to the Table, a new Table is displayed. Adding a Field to Table as Count Suppose you want to display the Medal Count as a column. You can do it by adding the field Medal to the Table as Count. Click the arrow next to the field, Medal, in the Power View Fields list. Select Add to Table as Count from the dropdown list. A new column Count of Medal will be added to the Table, displaying the Medal Count values. Adding a Count Field to Table As your data has more than 34000 rows, adding the field Medal as Count to the Table is not an efficient approach, as Power View has to do the calculation whenever you change the layout of the Table. The more effective way is to add a calculated field to the Medals data table in the Data Model. Click on the PowerPivot tab on the Ribbon. Click on Manage in the Data Model group. The tables in the Data Model will be displayed. Click on the Results tab. In the Results table, in the calculation area, in the cell below the Medal column, type the following DAX formula Medal Count:=COUNTA([Medal]) You can see that the medal count formula appears in the formula bar and to the left of the formula bar, the column name Medal is displayed. In the Power View sheet, you will get a Power View message that the Data Model is changed and if you click OK, the changes will be reflected in your Power View. Click OK. In the Power View Fields list, you can observe the following − A new field Medal Count is added in the Results table. A calculator icon appears adjacent to the field Medal Count, indicating that it is a calculated field. Select the fields – Country, Sport, and Medal Count. Your Power View Table displays the medal count country wise and sport wise. Filtering Table in Power View You can filter the values displayed in the Table by defining the filter criteria. Click the TABLE tab in the Filters area. Click Medal Count. Click the icon Advanced filter mode to the right of Medal Count. Select is greater than or equal to from the dropdown list under Show items for which the value. Type 100 in the box below that and then click Apply Filter. The Table will display only those records with Medal Count >= 100. Print Page Previous Next Advertisements ”;

Excel Power View – Visualizations ”; Previous Next Power View is an interactive data exploration and visualization tool in Excel. Power View supports various visualizations such as Tables, Matrices, Cards, Charts such as Bar, Column, Scatter, Line, Pie and Bubble Charts and Maps. You can also create sets of multiple charts (charts with same axis) in Power View. In this chapter, you will understand each Power View visualization briefly. You will understand the details in the subsequent chapters. Table Visualization For every visualization that you want to create on a Power View sheet, you have to start by creating a Table first. You can then quickly switch among the visualizations to find the one that best suits your data. The Table looks like any other data table with columns representing fields and rows representing data values. You can select and deselect fields in the Power View Fields list to choose the fields that are to be displayed in the Table. Switch Visualization Once you create a Table visualization that is default, you can convert it into any other visualization as follows − Click on Table visualization. Two tabs, POWER VIEW and DESIGN appear on the Ribbon. Click the DESIGN tab. There are several visualization options in the Switch Visualization group on the Ribbon. You can choose any of these options. Matrix Visualization Matrix Visualization is similar to a Table Visualization as it also contains rows and columns of data. However, a matrix has some additional features such as displaying the data without repeating values, displaying totals and subtotals by columns and/or rows, drill down/drill up a hierarchy, etc. Card Visualization In a card visualization, you will have a series of snapshots that display the data from each row in the table, laid out like an index card. Chart Visualizations In Power View, you have a number of Chart options: Bar, Column, Line, Scatter, Bubble, and Pie. Map Visualization If your data has fields pertaining to geography, you can use Maps in Power View to display the values. Maps in Power View use Bing map tiles and hence you need to make sure that you are online when you are displaying a Map visualization. You can use Pie Charts for data points in a Map Visualization. Print Page Previous Next Advertisements ”;

Excel Power View – Card Visualization ”; Previous Next In a Card visualization, you will have a series of snapshots that display the data from each row in the table, laid out like an index card. Consider the Data Model, where we have added the table SportPics. You need to start with a Table and then convert it to Card. Choose the fields − Country, Sport, SportImage and Medal Count. The Table representing these fields appears in Power View. Filter the Table to display data with Medal Count more than 275. The values in the column SportImage are images. It is possible to add images to your Power View visualizations. The images are data bound, i.e. a sport image is linked to the corresponding sport. You will learn more about images in subsequent chapters. Switching to Card Visualization Convert the Table to a Card as follows − Click on the Table. Click the DESIGN tab. Click Table in the Switch Visualization group. Select Card from the dropdown list. The Table is converted to Card visualization. Card Style You have two Card Styles for Card visualization. Card Callout The Card Style that you have in the previous section is Card, is the default style. To convert the Card Style to Callout do the following − Click on the Card. Click the Design tab on the Ribbon. Click Card Style in the Options group. Select Callout from the dropdown list. The Card Style changes from Card to Callout. In the Callout Card Style, all the text is displayed in large font. You can change the Card Style back to Card as follows − Click on Card Style. Select Card from the dropdown list. Print Page Previous Next Advertisements ”;

Excel Power View – Multiple Visualizations ”; Previous Next Multiples, also called Trellis Charts are a series of Charts with identical X and Y axes. You can arrange Multiples side by side, to compare many different values easily at the same time. You can have Line Charts, Bar Charts, Column Charts, and Pie Charts as Multiples. You can arrange the Multiples either horizontally or vertically. Multiples Visualization with Line Charts Suppose you want to display the Medal Count by Year for each Country. Start with a Table with fields – Year and Country. Convert the Table to Line Chart. A Line Chart appears with Medal Count by Year. You will observe the following − In the Line chart, Year is on X-axis and Medal Count Values are on Y-axis. In the Power View Fields pane, Year is in AXIS area and Medal Count is in ∑ VALUES area. Create Multiples visualization with Line Charts as follows − Drag the field Country to VERTICAL MULTIPLES area in the Power View Fields pane. A Line Charts appear in a grid with each Line Chart representing a Country. Click the LAYOUT tab on the Ribbon. Click on Grid Height in the Multiples group. Select 3 from the dropdown list. Click on Grid Width in the Multiples group. Select 3 from the dropdown list. Vertical Multiples As you are aware, you have placed the Country field in the VERTICAL MULTIPLES area in the Power View Fields pane. Hence, the visualization that you have is the Vertical Multiples visualization. You will observe the following in the above visualization − One Line Chart per Country (Country is placed in VERTICAL MULTIPLES area). The grid height and grid width that you have chosen determine the number of rows and number of columns for the Multiples. A common x-axis for all the Multiples. A similar y-axis for each row of the Multiples. A vertical scroll bar on the right side that can be used to drag the rows of Line Charts up and down, to make the other Line Charts visible. Horizontal Multiples You can have the Multiples visualization with Horizontal Multiples as follows − Drag the field Country to HORIZONTAL MULTIPLES area in the Power View Fields pane. You will get the Horizontal Multiples visualization as shown below. You will observe the following − One Line Chart per Country (Country is placed in HORIZONTAL MULTIPLES area). The grid height determines the height of the Line Charts, unlike the number of rows of Line Charts in the VERTICAL MULTIPLES. There is a single row of Line Charts with the height determined by the grid height. The grid width determines the number of columns of Line Charts in the row. A common x-axis for all the Multiples. A common y-axis for all the Multiples. A horizontal scroll bar at the bottom, below the x-axis, that can be used to drag the row of Line Charts to the left and the right, so as to make the other Line Charts visible. Multiples Visualization with Bar Charts You can choose Bar Charts for Multiples visualization − Switch visualization to Stacked Bar Chart. Deselect the field – Year. Drag the field Country to VERTICAL MULTIPLES area. Drag the field Medal to LEGEND area. Choose the Grid Height and Grid Width to get a proper display of the Bar Charts. With Grid Height of 6 and Grid Width of 2, you will get the following − You can have Clustered Bar Charts also for Multiples visualization. Switch to Clustered Bar Chart visualization. Multiples Visualization with Column Charts You can choose Column Charts for Multiples visualization. Switch visualization to Stacked Column Chart. Adjust the Grid Height and Grid Width to get a proper display of the Column Charts. With Grid Height of 2 and Grid Width of 6, you will see the following − You can have Clustered Column Charts also for Multiples visualization. Switch visualization to Clustered Column Chart. Multiples Visualization with Pie Charts Pie Charts Multiples visualization gives you enhanced Power View data exploration and visualization options. Switch to Pie Chart visualization. Change the Grid Height to 3 and Grid Width to 3. You will observe the following − Medal Count is in SIZE area, Medal is in SLICES area and Country is in VERTICAL MULTIPLES area in the Power View Fields pane. For each Country, a Pie Chart is displayed, with the Pie Slices showing the Medal Count of Medal Types, with the colors given in the Legend. Suppose you want to highlight the Gold Medal Count for all the Countries. You can do it in a single step as follows − Click Pie Slice representing Gold on any one of the Pie Charts. In all the Pie Charts, only the slices representing Gold will be highlighted and other slices will be grayed. This is a fast way of exploring and comparing the count of gold medals across the countries. Print Page Previous Next Advertisements ”;

Excel Power View – Creation ”; Previous Next Power View is like a canvas on which you can have any number of visualizations based on your Data Model. You need to start with creating a Power View sheet and then add fields from the data tables to Power View to visualize and explore data. Before you start your data exploration with Power View, make sure that the Power View add-in enabled and available on the Ribbon. Click the INSERT tab on the Ribbon. Power View should be visible on the Ribbon in the Reports group. Enabling Power View Add-in If you do not find Power View on the Ribbon, you need to enable the Power View add-in. Click the File tab on the Ribbon. Click Options. Click Add-Ins in the Excel Options dialog box. Click the drop-down arrow in the Manage box. Select COM Add-ins from the dropdown list and click Go. The COM Add-ins dialog box appears. Check the box Power View and click OK. Power View will be visible on the Ribbon. Creating a Power View Sheet You can create a Power View from the data tables in the Data Model. Suppose you have the following Data Model in your workbook. To create a Power View sheet, do the following − Click the INSERT tab on the Ribbon in Excel window. Click Power View in the Reports group. Opening Power View message box appears with a horizontally scrolling green status bar. This might take a little while. The Power View sheet is created as a worksheet in your Excel workbook. It contains an empty Power View area, Filters area and the Power View Fields list displaying the tables in the Data Model. Power View appears as a tab on the Ribbon in the Power View sheet. You will understand these different parts of the Power View sheet in the next chapter. Creating a Power View In this section, you will understand how to create a Power View in the Power View sheet. Suppose you want to display the medals that each country has won. Select the fields Country and Medal from the Results table. These two fields appear under FIELDS in the Areas. Power View will be displayed as a Table with the two selected fields as columns. As you can see, Power View is displaying which medals each country has won. Click the Title of the Power View sheet. Type Medals. Print Page Previous Next Advertisements ”;

Excel Power View – Advanced Features ”; Previous Next In the previous chapters you have learnt about the different possible Power View visualizations, Multiples and Tiles. The fields you select for display in the visualizations depend on what you want to explore, analyze and present. For example, in most of the visualizations that you have seen so far, we have chosen Medal to analyze Medal Count by medal type. You might want to explore, analyze and present the data gender-wise. In such a case, you need to choose the field Gender. Further, visualization also depends on the data you are displaying. Throughout this tutorial, we have chosen Olympics data in order to visualize the power of Power View, the ease with which you can handle large data and switch over different visualizations on the fly. However, your data set might be different. You need to choose a visualization that best suits your data. If you are not sure about the suitability, you can just play around with the visualizations to choose the right one as switching across the visualizations is quick and simple in Power View. Moreover, you can also do it in the presentation view, in order to answer any queries that can arise during a presentation. You have also seen how you can have a combination of visualizations in a Power View and the interactive nature of the visualizations. You will learn advanced features in Power View in this chapter. These features come handy for reporting. Creating a Default Field Set for Table You might have to use the same field set for different visualizations in a Power View. As you are aware, to display any visualization, you need to create a Table visualization first. If the fields for the Table visualization are from the same data table, you can create a default field set for Table so that you can select the default field set with one click, instead of selecting the fields for the Table visualization repeatedly. Click the POWERPIVOT tab on the Ribbon. Click Manage in the Data Model group. The Power Pivot window appears − Click the tab – Results to display the Results data table in the Power Pivot window. Click the Advanced tab on the Ribbon. Click Default Field Set in the Reporting Options group. The Default Field Set dialog box appears. Click the Fields you want to select holding down the Ctrl key in the Fields in the table box. Click Add. The selected fields appear in the Default fields, in order box on the right side. Click the Move Up or Move Down buttons to order the fields in the Default fields, in order box and click OK. Click on the Power View sheet in the Excel window. A message ‘Data Model is changed’ appears and click OK to make those changes in Power View. Click on the data table name – Results in the Power View Fields list. Table visualization with the default field set appears in Power View Note that you have to click only on the data table name in the Power View Fields list to select the default field set. If you click on the arrow next to data table name, it expands showing all the fields in the data table and in Power View, Table visualization does not appear. Click in the empty space to the right of Table visualization in Power View. Click on the data table name – Results in the Power View Fields list. Another Table visualization with the default field set appears in Power View. As you can see, you are able to create a Table visualization with 5 fields in the desired order with a single click using the default field set. This eliminates the cumbersome selection of the 5 fields in the desired order with 5 clicks each time you want to display a Table (or any other) visualization. However, you should be sure of which fields should be in the default field set in a data table. Hence, this feature can be used after data exploration, visualization is complete, and you are ready to produce reports. You might have to produce several reports, in which case this feature comes handy. Setting Table Behavior You can set the default table behavior that Power View uses to create report labels automatically for the data table. This becomes useful when you create visualizations from the same data table, perhaps for many different reports. Suppose you have a data table – Olympics Results in the Data Model Click on the data table Olympics Results in the Power Pivot window. Click the Advanced tab on the Ribbon. Click Table Behavior in the Reporting Options group. The Table Behavior dialog box appears Select EventID under the Row Identifier box. This column should have unique values in the data table. Check the boxes Event and EventID in the Keep Unique Rows box. These columns should have row values that are unique, and should not be aggregated when creating Power View reports. Select Sport in the Default Label box. Select SportImage in the Default Image box. Click OK. To visualize the Table behavior that you have set, select the fields as follows − Click on Power View. Select the fields – Sport, SportImage, Event, Year, Athlete, Country and Medal in that order. By default, Table visualization appears. Switch visualization to Card. The Sport field values are larger than the other field values and appear as headings for the Cards. This is because you have set Sport as the Default Label in the Table Behavior dialog box. Further, you have set SportImage as the Default Image that appears on each Card based on the Sport value. Filtering Values in a View Suppose you have three Power View visualizations – Matrix, Stacked Column Chart and sophisticated Pie Chart in the same Power View, each displaying different aspects of data. You can see that all the three visualizations are displaying data for all the Country

Excel Power View Tutorial PDF Version Quick Guide Resources Job Search Discussion Power View enables interactive data exploration, visualization, and presentation that encourages intuitive ad-hoc reporting. Large data sets can be analyzed on the fly using versatile visualizations in Power View. The data visualizations are dynamic, thus facilitating ease of presentation of the data with a single Power View report. Audience This guide targets professionals with hands-on experience in Excel, to perform the highend data analysis and decision making in a matter of few minutes. Prerequisites Power View is based on the Data Model in your workbook. Either you can start with a Data Model that is already available in Power Pivot or you can create a Data Model from Power View itself. In this tutorial, we assume that you are aware of the Data Model concepts in Power Pivot. Otherwise, we suggest you to go through our Excel Power Pivot tutorial first. Print Page Previous Next Advertisements ”;