Excel_Power_View_Tutorial.pdf - Tutorialspoint

2y ago
33 Views
3 Downloads
1.86 MB
36 Pages
Last View : 2m ago
Last Download : 4m ago
Upload by : Jayda Dunning
Transcription

Excel Power ViewAbout the TutorialPower View enables interactive data exploration, visualization, and presentation thatencourages intuitive ad-hoc reporting. Large data sets can be analyzed on the fly usingversatile visualizations in Power View. The data visualizations are dynamic, thus facilitatingease of presentation of the data with a single Power View report.AudienceThis guide targets professionals with hands-on experience in Excel, to perform the highend data analysis and decision making in a matter of few minutes.PrerequisitesPower View is based on the Data Model in your workbook. Either you can start with a DataModel that is already available in Power Pivot or you can create a Data Model from PowerView itself. In this tutorial, we assume that you are aware of the Data Model concepts inPower Pivot. Otherwise, we suggest you to go through our Excel Power Pivot tutorial first.Copyright & Disclaimer Copyright 2016 by Tutorials Point (I) Pvt. Ltd.All the content and graphics published in this e-book are the property of Tutorials Point (I)Pvt. Ltd. The user of this e-book is prohibited to reuse, retain, copy, distribute or republishany contents or a part of contents of this e-book in any manner without written consentof the publisher.We strive to update the contents of our website and tutorials as timely and as precisely aspossible, however, the contents may contain inaccuracies or errors. Tutorials Point (I) Pvt.Ltd. provides no guarantee regarding the accuracy, timeliness or completeness of ourwebsite or its contents including this tutorial. If you discover any errors on our website orin this tutorial, please notify us at contact@tutorialspoint.comi

Excel Power ViewTable of ContentsAbout the Tutorial . iAudience . iPrerequisites . iCopyright & Disclaimer . iTable of Contents . ii1.Power View – Overview . 1Power View Visualizations . 1Advanced Features in Power View . 22.Power View – Creation. 4Enabling Power View Add-in . 4Creating a Power View Sheet . 5Creating a Power View . 73.Power View – Sheet . 9Power View Sheet Layout . 9Power View Tabs on the Ribbon. 134.Power View – Visualizations . 15Table Visualization . 15Switch Visualization . 15Matrix Visualization . 16Card Visualization . 17Chart Visualizations . 17Map Visualization . 185.Power View – Table Visualization . 19Creating a Table . 19Understanding Table Visualization . 19Adding a Field to Table as Count . 20Adding a Count Field to Table . 21Filtering Table in Power View . 236.Power View – Matrix Visualization . 25Switching to Matrix Visualization . 25Advantages of Matrix Visualization . 26Combination of Table and Matrix Visualizations . 27Filtering Matrix in Power View . 29Totals . 307.Power View – Card Visualization . 35Switching to Card Visualization . 36Card Style. 378.Power View – Chart Visualizations . 40Types of Chart Visualizations . 40Line, Bar and Column Charts . 40Scatter and Bubble Charts . 42Pie Charts . 43ii

Excel Power ViewInteractive Nature of Chart Visualizations. 459.Power View – Line Chart Visualization . 46Switching to Line Chart Visualization . 46Exploring Data with Line Chart Visualization . 4810. Power View – Bar Chart Visualization . 50Switching to Bar Chart Visualization . 51Exploring Data with Bar Chart Visualization . 53Combination of Bar Chart and Table Visualizations . 55Adding a Legend . 59100% Stacked Bar Chart . 61Clustered Bar Chart . 6511. Power View – Column Chart Visualization . 67Switching to Column Chart Visualization . 68Exploring Data with Column Chart Visualization . 69Sorting in Column Chart . 71Combination of Column Chart and Table Visualizations . 73Adding a Legend . 76100% Stacked Column Chart . 79Clustered Column Chart . 83Combining Bar Chart Visualization . 8412. Power View – Scatter and Bubble Chart Visualizations . 88Switching to Scatter Chart Visualization . 90Adding Data Labels to Scatter Chart . 91Converting to Bubble Chart Visualization . 93Exploring Data with Bubble Chart Visualization . 94Visualization with Colors . 96Filtering in Bubble Chart . 97Combination of Bubble Chart and Table Visualizations . 100Visualization with Play Axis . 10213. Power View – Pie Chart Visualization . 108Switching to Pie Chart Visualization . 110Exploring Data with Simple Pie Chart Visualization . 113Sophisticated Pie Chart Visualizations . 11414. Power View – Map Visualization . 120Setting Data Category for Geographic Field . 121Switching to Map Visualization . 123Zooming and Panning in Map . 126Pie Charts in Map Visualization . 127Exploring Data with Pie Charts in Map Visualization . 127Highlighting a Pie Slice in Map Visualization . 12915. Power View – Multiple Visualizations . 131Multiples Visualization with Line Charts . 131Vertical Multiples . 133Horizontal Multiples . 134Multiples Visualization with Bar Charts . 135iii

Excel Power ViewMultiples Visualization with Column Charts . 137Multiples Visualization with Pie Charts . 13916. Power View – Tiles Visualization . 141Table Visualization with Tiles . 141Exploring Data with Table Tiles Visualization . 143Tile Navigation Strip - Tab Strip . 145Tile Navigation Strip - Tile Flow . 146Matrix Tiles Visualization . 149Card Tiles Visualization . 150Stacked Bar Chart Tiles Visualization . 151Map Tiles Visualization . 152Combination of Power View Tiles Visualizations . 153Exploring Data with Tiles Visualizations . 15417. Power View – Advanced features . 156Creating a Default Field Set for Table . 157Setting Table Behavior . 162Filtering Values in a View . 164Adding Title to Power View . 166Adding Data Labels in a Chart Visualization . 168Interactive Data Visualization in Power View . 169Changing the Sort Order of a Field . 170Filtering Visualizations with Slicers. 176Creating Interactive Bar and Column Charts . 18118. Power View and Data Model . 184Power View and Data Model . 184Creating Data Model from Power View Sheet . 185Modifying Data Model from Power View Sheet . 19019. Power View – Hierarchies . 194Viewing a Hierarchy from Data Model . 194Creating a Hierarchy in Power View . 196Drilling Up and Drilling Down the Hierarchy in Matrix . 197Hierarchy in Bar Chart . 199Hierarchy in Column Chart . 201Hierarchy in Pie Chart . 204Filtering Hierarchy in Pie Chart with Column Chart. 20520. Power View – Key Performance Indicators . 209Identifying the KPIs . 210Defining KPIs in the Data Model . 210Visualization of KPIs in Power View . 215Editing KPIs in Power View . 216Defining KPIs in Power View . 219Aesthetic Reports with KPIs in Power View . 22321. Power View – Formatting a Report . 225Changing Theme . 225Setting Background Image . 229Changing Background Colors . 234iv

Excel Power ViewChanging Font in a Power View Report . 236Changing Text Size in a Power View Report . 238Formatting Numbers in a Power View Report . 240Changing Number Aggregates . 24322. Power View – Sharing . 246Sharing Power View in Excel . 246Printing Power View Reports . 246v

1. Power View – OverviewExcel Power ViewPower View enables interactive data exploration, visualization, and presentation thatencourages intuitive ad-hoc reporting. Large data sets can be analyzed on the fly usingversatile visualizations in Power View. The data visualizations are dynamic, thus facilitatingease of presentation of the data with a single Power View report.Power View is based on the Data Model in your workbook. Either you can start with a DataModel that is already available in Power Pivot or you can create a Data Model from PowerView itself. In this tutorial, we assume that you are aware of the Data Model concepts inPower Pivot. Otherwise, we suggest you to go through the Excel Power Pivot tutorial first.Creating Power ViewTo create a Power View, first you need to make sure that the Power View add-in is enabled inyour Excel. You can then create a Power View sheet that contains Power View, which can holdseveral different data visualizations based on your Data Model. You will learn how to create aPower View sheet and Power View in the chapter - Creating a Power View.Understanding Power View SheetThe Power View sheet has several components such as Power View canvas, Filters area, PowerView Fields list, Power View Layout areas and Power View tabs on the Ribbon. You will learnabout these components in the chapter – Understanding Power View Sheet.Power View VisualizationsThe core of the Power View is in its various types of data visualizations that will enable youto portray the data, visualize, and explore, all in a dynamic mode. You can handle large datasets spanning several thousands of data on the fly switching from one visualization to another,drilling up and drilling down the data displaying the essence of the data.The different Power View visualizations that you can have are the following Table Matrix Card ChartsoLine ChartoBar ChartoColumn Chart6

Excel Power View oScatter ChartoBubble ChartMapYou will learn about these visualizations in different chapters in this tutorial. You will alsolearn about combination of visualizations on a Power View and their interactive nature.Visualization with MultiplesAnother domain of Power View is its facility to visualize the Chart visualizations in Multiples.You can have a grid of Charts in Power View with the same axis. You can have HorizontalMultiples or Vertical Multiples. You will learn Multiples in Power View with different types ofcharts in the chapter - Visualization with Multiples.Visualization with TilesWhen you have large data to display at a time, browsing up and down could take time. PowerView makes this task very easy for you with Tiles. Tiles are containers on a navigation stripthat is based on a field in your data. Clicking on a Tile is equivalent to selecting that value ofthe field and your visualization is filtered accordingly. You can have data bound images suchas sport images for Tiles that will give a visual cue to your navigation strip. You will learnabout Tiles in the chapter – Visualization with Tiles.Advanced Features in Power ViewWhenever you have to create a visualization, you need to first create a Table and then switchvisualization to the required one. This would make you create the Tables several times duringdata exploration and reporting. Even after you decide on what fields to portray in yourvisualizations, you have to repeatedly select all these fields every time. Power View providesyou with an advanced feature to define a default field set that enable you to select all thefields with a single click on the table name in the Power View Fields list.You can set table behavior, filter all the visualizations together with the VIEW tab in filters,change the sort order of a field, filter visualizations with Slicers, add data labels and add atitle to the Power View. You will learn about these and more in the chapter – AdvancedFeatures in Power View.Power View and Data ModelWe said Power View is based on the Data Model. You can either work on the Data Model thatis already present, as is the case in all the previous chapters, or create one from the PowerView sheet. You will learn about adding data tables to Data Model, creating relationshipsbetween tables and modifying Data Model from Power View sheet in the chapter – Power Viewand Data Model.7

Excel Power ViewHierarchies in Power ViewIf you data has nested fields you can define a hierarchy so that you can treat all the nestedfields as one field. You can have a defined hierarchy in the Data Model that you can visualizefrom Power View or you can create a hierarchy in Power View and use it for visualization. Youcan drill p and drill down the hierarchy in Matrix, Bar Chart, Column Chart and Pie Chartvisualizations. You can filter hierarchy in Pie Chart with Column Chart. You will learn all thesein the chapter – Hierarchies in Power View.Key Performance Indicators (KPIs) in Power ViewKey Performance Indicators (KPIs) enable you to track the progress against the set goals.You can create KPIs in the Data Model from Power View. You can then create appealing PowerView visualizations that depict the KPIs and produce aesthetic reports. You can also edit theKPIs from Power View as it is possible that the KPIs might have to be modified as the timeprogresses. You will learn about KPIs in the chapter - Key Performance Indicators (KPIs) inPower View.The chapter also has a brief introduction on KPIs, KPI parameters and how to identify KPIs.But, note that this is not exhaustive as KPIs depend on the field you have chosen to track theprogress – for e.g. business performance, sales, HR, etc.Formatting a Power View ReportThe Power View visualizations as you learn throughout the tutorial are ready to present anytime, as they are all appealing and presentable. Because of the dynamic nature of thevisualizations, it is easy to display the required results on the sport without much effort ortime. As everything is visual, there will not be any need to preview the results. Hence, inPower View reporting is not the final step and can be at any point of time with your PowerView and visualizations.In the chapter – Formatting a Power View Report, you will learn some more features that canchange the look and feel of your already appealing Power View reports. These includechanging Theme, setting background image, changing background colors, font and text size,formatting numbers and changing number aggregates.Sharing Your WorkYou can share your work with the concerned as the Power View sheets in your Excel workbookitself on server / cloud by giving appropriate permissions to read /edit. As Power View is alsoavailable on SharePoint, you can share your Power View reports as SharePoint reports. Youcan print Power View sheets, but as they are static, it would not make much sense to printthem because of their innate powerful features of interactivity and dynamic nature. You canpublish Power View sheets to Power BI.8

Excel Power ViewData AcknowledgementsThe data that is used to the maximum extent is the Olympics results data for the years 1900– 2014. The data table has around 35,000 rows of data that could reveal the power featuresof the optimistic Data Model and Power View visuali

Power Pivot. Otherwise, we suggest you to go through the Excel Power Pivot tutorial first. Creating Power View To create a Power View, first you need to make sure that the Power View add-in is enabled in your Excel. You can then create a Power View sheet that contains Power View, which can hold

Related Documents:

Excel 5.0 Excel 5.0 1993 Excel 5.0 1993 Excel 7.0 Excel 95 1995 Excel 8.0 Excel 97 1997 Excel 98 1998 Excel 9.0 Excel 2000 1999 Excel 2001 2000 Excel 10.0 Excel XP 2001 Excel v.X 2001 Excel 11.0 Excel 2003 2003 Excel 2004 2004 2.1.2 Worksheet Document Definition: Worksheet Document A worksheet document consists of a single sheet only.

Power Map Power Map provides a new perspective for your data by plotting geocoded data onto a three-dimensional view of the earth and optionally showing changes to that data over time. To use Power Map, you import raw data into a Microsoft Excel 2013 workbook, add the data to an Excel data model, and enhance the data in the data model if necessary.File Size: 1MBPage Count: 17Explore furtherGetting an excel list of all Azure Virtual machinesdbaharrison.blogspot.comDownload Azure Devops Board To Excelwww.how-use-excel.comGetting an excel list of all Azure Virtual machines .www.firstcloud.ioGetting an excel list of all Azure Virtual machines .laptrinhx.comRunning Excel On Azurewww.how-use-excel.comRecommended to you based on what's popular Feedback

grid orthographic drawing 3rd angle top view left view front view left view front view top view top view top view front view right view front view right view top view front view right view front view right view a compilation of drawings for developing the skill to draw in orthographic

2 excel power query tutorial ( Image Search ) 2 power query training ( Image Search ) 2 vba excel power query power pivots ( Image Search ) 1 excel and power query report ( Image Search ) www.accessanalytic.com.au 2 excel power query power pivot ( Image Search ) 2 power query excel 2010 ( Image Search ) 2 vb

This Microsoft Excel tutorial teaches you how to create and use Excel functions. You can use Excel functions to perform various mathematical, statistical, logical calculations. This tutorial takes you step-by-step through the process. Audience This tutorial is intended for people who use Excel but are intimidated by the concept of formulas and .

tutorialspoint.com or this tutorial may not be redistributed or reproduced in any way, shape, or form without the written permission of tutorialspoint.com. Failure to do so is a violation of copyright laws. This tutorial may contain inaccuracies or errors and tutorialspoint provides no guarantee regarding the

tutorialspoint.com or this tutorial may not be redistributed or reproduced in any way, shape, or form without the written permission of tutorialspoint.com. Failure to do so is a violation of copyright laws. This tutorial may contain inaccuracies or errors and tutorialspoint provides no guarantee regarding the

Loughborough College Local Offer Des Gentleman Learner Services Manager des.gentleman@loucoll.ac.uk . 2 Regulation 3 Special Educational Needs and Disability (Information) Regulations (2014) School/College Name: Loughborough College Address: Radmoor Road, Loughborough, Leicestershire Telephone Number: 01509 618375 Principal and CEO: Jo Maher Executive Lead Learner Services: Heather Clarke .