{"product_id":"data-visualization-with-excel-dashboards-and-reports-isbn-9781119698722","title":"Data Visualization with Excel Dashboards and Reports","description":"\u003cp\u003eLarge corporations like IBM and Oracle are using Excel dashboards and reports as a Business Intelligence tool, and many other smaller businesses are looking to these tools in order to cut costs for budgetary reasons. An effective analyst not only has to have the technical skills to use Excel in a productive manner but must be able to synthesize data into a story, and then present that story in the most impactful way. Microsoft shows its recognition of this with Excel.  In Excel, there is a major focus on business intelligence and visualization.  Data Visualization with Excel Dashboards and Reports fills the gap between handling data and synthesizing data into meaningful reports.  This title will show readers how to think about their data in ways other than columns and rows.\u003c\/p\u003e \u003cp\u003eMost Excel books do a nice job discussing the individual functions and tools that can be used to create an \"Excel Report\".  Titles on Excel charts, Excel pivot tables, and other books that focus on \"Tips and Tricks\" are useful in their own right; however they don't hit the mark for most data analysts.  The primary reason these titles miss the mark is they are too focused on the mechanical aspects of building a chart, creating a pivot table, or other functionality.  They don't offer these topics in the broader picture by showing how to present and report data in the most effective way.\u003c\/p\u003e \u003cp\u003eWhat are the most meaningful ways to show trending?  How do you show relationships in data?  When is showing variances more valuable than showing actual data values?   How do you deal with outliers?  How do you bucket data in the most meaningful way?  How do you show impossible amounts of data without inundating your audience?  In \u003ci\u003eData Visualization with Excel Reports and Dashboards\u003c\/i\u003e, readers will get answers to all of these questions. Part technical manual, part analytical guidebook; this title will help Excel users go from reporting data with simple tables full of dull numbers, to creating hi-impact reports and dashboards that will wow management both visually and substantively. This book offers a comprehensive review of a wide array of technical and analytical concepts that will help users create meaningful reports and dashboards.\u003c\/p\u003e \u003cp\u003eAfter reading this book, the reader will be able to:\u003c\/p\u003e \u003cul\u003e \u003cli\u003eAnalyze large amounts of data and report their data in a meaningful way\u003c\/li\u003e \u003cli\u003eGet better visibility into data from different perspectives\u003c\/li\u003e \u003cli\u003eQuickly slice data into various views on the fly\u003c\/li\u003e \u003cli\u003eAutomate redundant reporting and analyses\u003c\/li\u003e \u003cli\u003eCreate impressive dashboards and What-If analyses\u003c\/li\u003e \u003cli\u003eUnderstand the fundamentals of effective visualization\u003c\/li\u003e \u003cli\u003eVisualize performance comparisons\u003c\/li\u003e \u003cli\u003eVisualize changes and trends over time\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eIntroduction xxi\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart I Display Data on a Dashboard 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1 Dashboard Basics 3\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDetermining When to Use a Dashboard 3\u003c\/p\u003e \u003cp\u003eWhat Is a Dashboard? 5\u003c\/p\u003e \u003cp\u003eKey Performance Indicators 6\u003c\/p\u003e \u003cp\u003eEstablishing User Requirements 6\u003c\/p\u003e \u003cp\u003eTypes of End Users 7\u003c\/p\u003e \u003cp\u003eAssembling the Data 8\u003c\/p\u003e \u003cp\u003ePivotTables 8\u003c\/p\u003e \u003cp\u003eThe GETPIVOTDATA Worksheet Function 13\u003c\/p\u003e \u003cp\u003eWorksheet Functions 14\u003c\/p\u003e \u003cp\u003eThe VLOOKUP Function 14\u003c\/p\u003e \u003cp\u003eThe XLOOKUP Function 15\u003c\/p\u003e \u003cp\u003eThe INDEX and MATCH Functions 16\u003c\/p\u003e \u003cp\u003eThe SUMPRODUCT Function 17\u003c\/p\u003e \u003cp\u003eArray Formulas 19\u003c\/p\u003e \u003cp\u003eTables 20\u003c\/p\u003e \u003cp\u003eStructured Table Referencing 23\u003c\/p\u003e \u003cp\u003eText to Columns 24\u003c\/p\u003e \u003cp\u003eRemoving Duplicates 26\u003c\/p\u003e \u003cp\u003eBuilding the Dashboard 28\u003c\/p\u003e \u003cp\u003eOrganizing Elements 28\u003c\/p\u003e \u003cp\u003eVarying Elements 30\u003c\/p\u003e \u003cp\u003eShowing Trends 31\u003c\/p\u003e \u003cp\u003eFormatting the Dashboard 33\u003c\/p\u003e \u003cp\u003eNumber Formats 36\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2 Dashboard Case Studies 39\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eMonitoring Progress 39\u003c\/p\u003e \u003cp\u003eCase Study: Monitoring a Software Project 40\u003c\/p\u003e \u003cp\u003ePlanning and Layout 40\u003c\/p\u003e \u003cp\u003eCollecting the Data 42\u003c\/p\u003e \u003cp\u003eBuilding the Visual Elements 43\u003c\/p\u003e \u003cp\u003eLaying Out the Dashboard 54\u003c\/p\u003e \u003cp\u003eDisplaying Key Performance Indicators 55\u003c\/p\u003e \u003cp\u003eCase Study: Human Resources KPIs 55\u003c\/p\u003e \u003cp\u003ePlanning and Layout 56\u003c\/p\u003e \u003cp\u003eCollecting the Data 57\u003c\/p\u003e \u003cp\u003eBuilding the Visual Elements 58\u003c\/p\u003e \u003cp\u003eLaying Out the Dashboard 69\u003c\/p\u003e \u003cp\u003eReporting Financial Information 72\u003c\/p\u003e \u003cp\u003eCase Study: Financial Information and Ratios 72\u003c\/p\u003e \u003cp\u003ePlanning and Layout 72\u003c\/p\u003e \u003cp\u003eCollecting the Data 73\u003c\/p\u003e \u003cp\u003eBuilding the Visual Elements 75\u003c\/p\u003e \u003cp\u003eLaying Out the Dashboard 83\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3 Organizing Data for Dashboards 87\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSeparating Data Layers 87\u003c\/p\u003e \u003cp\u003eSource Data Layer 89\u003c\/p\u003e \u003cp\u003eStaging and Analysis Layer 90\u003c\/p\u003e \u003cp\u003ePresentation Layer 91\u003c\/p\u003e \u003cp\u003eWorking with External Data 92\u003c\/p\u003e \u003cp\u003ePower Query vs. Power Pivot 92\u003c\/p\u003e \u003cp\u003eText Files 92\u003c\/p\u003e \u003cp\u003eExcel Files 98\u003c\/p\u003e \u003cp\u003eAccess Databases 105\u003c\/p\u003e \u003cp\u003eSQL Server Databases 111\u003c\/p\u003e \u003cp\u003eTransforming Data in Power Query 114\u003c\/p\u003e \u003cp\u003eManaging Columns and Rows 116\u003c\/p\u003e \u003cp\u003eTransforming Columns 119\u003c\/p\u003e \u003cp\u003eTransforming Data Types 119\u003c\/p\u003e \u003cp\u003eTransforming Numbers 121\u003c\/p\u003e \u003cp\u003eSplitting Columns 123\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart II Visualization Primer 127\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4 The Fundamentals of Eff ective Visualization 129\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCreating an Effective Visualization 129\u003c\/p\u003e \u003cp\u003eKeep It to a Single Screen 130\u003c\/p\u003e \u003cp\u003eMake It Attractive 131\u003c\/p\u003e \u003cp\u003eTell the Story Quickly 131\u003c\/p\u003e \u003cp\u003eMake the Story Consistent with the Data 133\u003c\/p\u003e \u003cp\u003eChoose the Proper Chart 135\u003c\/p\u003e \u003cp\u003eDriving Meaning with Color 137\u003c\/p\u003e \u003cp\u003eHow to Use Color 137\u003c\/p\u003e \u003cp\u003eVarying Color as Data Values Vary 137\u003c\/p\u003e \u003cp\u003eUsing Sharp Contrast to Highlight Data 138\u003c\/p\u003e \u003cp\u003eGrouping Data with Color 139\u003c\/p\u003e \u003cp\u003eTips on Color Use 140\u003c\/p\u003e \u003cp\u003eUse White Space 140\u003c\/p\u003e \u003cp\u003eUse a Simple Color Pallet 141\u003c\/p\u003e \u003cp\u003eUse Colors That Are Consistent with the Data 141\u003c\/p\u003e \u003cp\u003eUse Enough Contrast 141\u003c\/p\u003e \u003cp\u003eUse Non-data Pixels When Necessary 142\u003c\/p\u003e \u003cp\u003eFocusing Attention on Text 142\u003c\/p\u003e \u003cp\u003eFonts 142\u003c\/p\u003e \u003cp\u003eLegends 143\u003c\/p\u003e \u003cp\u003eAxes 144\u003c\/p\u003e \u003cp\u003eData Labels 145\u003c\/p\u003e \u003cp\u003eShowing Insights with Charts 146\u003c\/p\u003e \u003cp\u003eComparisons 146\u003c\/p\u003e \u003cp\u003eCompositions 147\u003c\/p\u003e \u003cp\u003eRelationships 149\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5 Non-chart Visualizations 151\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding Custom Number Formats 151\u003c\/p\u003e \u003cp\u003eThe Four Sections of a Format 152\u003c\/p\u003e \u003cp\u003eSpecial Characters 153\u003c\/p\u003e \u003cp\u003eDigit Placeholders 153\u003c\/p\u003e \u003cp\u003eCommas and Periods 154\u003c\/p\u003e \u003cp\u003eText 154\u003c\/p\u003e \u003cp\u003eUnderscore 155\u003c\/p\u003e \u003cp\u003eAsterisk 156\u003c\/p\u003e \u003cp\u003eEscaping Special Characters 156\u003c\/p\u003e \u003cp\u003eThe Accounting Number Format 156\u003c\/p\u003e \u003cp\u003eDate and Time Formats 158\u003c\/p\u003e \u003cp\u003eConditional Custom Number Formats 159\u003c\/p\u003e \u003cp\u003eUsing Icons 160\u003c\/p\u003e \u003cp\u003eColor Scales 160\u003c\/p\u003e \u003cp\u003eData Bars 165\u003c\/p\u003e \u003cp\u003eIcon Sets 167\u003c\/p\u003e \u003cp\u003eCreating Sparklines 170\u003c\/p\u003e \u003cp\u003eTypes of Sparklines 170\u003c\/p\u003e \u003cp\u003eCreating a Sparkline 171\u003c\/p\u003e \u003cp\u003eSparkline Groups 172\u003c\/p\u003e \u003cp\u003eCustomize a Sparkline 172\u003c\/p\u003e \u003cp\u003eChanging the Source Data 173\u003c\/p\u003e \u003cp\u003eChanging the Color and Thickness 174\u003c\/p\u003e \u003cp\u003eAdjusting the Axis 175\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6 Using Shapes to Create Infographics 179\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWorking with Shapes 179\u003c\/p\u003e \u003cp\u003eInserting Shapes 180\u003c\/p\u003e \u003cp\u003eCustomizing Shapes 182\u003c\/p\u003e \u003cp\u003eFraming Data with Shapes 185\u003c\/p\u003e \u003cp\u003eCreating a Banner 186\u003c\/p\u003e \u003cp\u003eCreating a Binder Tab 188\u003c\/p\u003e \u003cp\u003eWorking with Multiple Shapes 191\u003c\/p\u003e \u003cp\u003eCreating Simple Charts with Shapes 193\u003c\/p\u003e \u003cp\u003eCreating Custom Infographics 195\u003c\/p\u003e \u003cp\u003eAdding Other Illustrations 196\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart III Tell a Story with Visualization 203\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7 Visualizing Performance Comparisons 205\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSingle Measurements 206\u003c\/p\u003e \u003cp\u003eColumn Charts 207\u003c\/p\u003e \u003cp\u003eCase Study: Sales by Quarter 210\u003c\/p\u003e \u003cp\u003eBullet Charts 212\u003c\/p\u003e \u003cp\u003eCase Study: Expenses vs. Budget 212\u003c\/p\u003e \u003cp\u003eClustered Column Charts 216\u003c\/p\u003e \u003cp\u003eCase Study: Production Defects 217\u003c\/p\u003e \u003cp\u003eFunnel Charts 218\u003c\/p\u003e \u003cp\u003eCase Study: Sales Conversion 219\u003c\/p\u003e \u003cp\u003eXY Charts 221\u003c\/p\u003e \u003cp\u003eCase Study: Temperature vs. Sales 222\u003c\/p\u003e \u003cp\u003eBubble Charts 225\u003c\/p\u003e \u003cp\u003eCase Study: Home Mortgages 226\u003c\/p\u003e \u003cp\u003eDot Plot Charts 228\u003c\/p\u003e \u003cp\u003eCase Study: Production Output 229\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8 Visualizing Parts of a Whole 239\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePie Charts 239\u003c\/p\u003e \u003cp\u003eDoughnut Charts 241\u003c\/p\u003e \u003cp\u003eCase Study: Sales by Region 242\u003c\/p\u003e \u003cp\u003eWaffle Charts 244\u003c\/p\u003e \u003cp\u003eCase Study: Employee Participation by Benefit 245\u003c\/p\u003e \u003cp\u003eSunburst Charts 249\u003c\/p\u003e \u003cp\u003eCase Study: Manufacturing Process Time Study 250\u003c\/p\u003e \u003cp\u003eHistograms 252\u003c\/p\u003e \u003cp\u003eCase Study: Restaurant Ticket Totals 254\u003c\/p\u003e \u003cp\u003eTreemap Charts 256\u003c\/p\u003e \u003cp\u003eCase Study: Insurance Policy Averages 257\u003c\/p\u003e \u003cp\u003eWaterfall Charts 259\u003c\/p\u003e \u003cp\u003eCase Study: Net Income 261\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9 Visualizing Changes Over Time 265\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eLine Charts 266\u003c\/p\u003e \u003cp\u003eCase Study: Sales by Product Category 268\u003c\/p\u003e \u003cp\u003eColumn Charts with Variances 273\u003c\/p\u003e \u003cp\u003eCase Study: Houses Sold by Month 274\u003c\/p\u003e \u003cp\u003eCombination Charts 280\u003c\/p\u003e \u003cp\u003eCase Study: Freight Revenue vs. Miles 281\u003c\/p\u003e \u003cp\u003eLine Charts with Differences 284\u003c\/p\u003e \u003cp\u003eCase Study: Current vs. Prior Quarter Revenue 285\u003c\/p\u003e \u003cp\u003eSide-by-Side Box Plots 288\u003c\/p\u003e \u003cp\u003eCase Study: Salaries by Department 290\u003c\/p\u003e \u003cp\u003eAnimated Charts 292\u003c\/p\u003e \u003cp\u003ePivotCharts 293\u003c\/p\u003e \u003cp\u003eStaging Area Formulas 295\u003c\/p\u003e \u003cp\u003eChart Animation Macros 299\u003c\/p\u003e \u003cp\u003eChart Automation 302\u003c\/p\u003e \u003cp\u003eManipulating Chart Objects 302\u003c\/p\u003e \u003cp\u003eCreating Panel Charts 307\u003c\/p\u003e \u003cp\u003eIndex 317\u003c\/p\u003e \u003cp\u003e\u003cb\u003eDICK KUSLEIKA\u003c\/b\u003e is a 12-year Microsoft Excel MVP and the principal contributor at the Daily Dose of Excel Blog.\u003c\/p\u003e  \u003cp\u003e\u003cb\u003eMaster the fine art of data visualization with a veteran Excel guru in this up-to-date new resource\u003c\/b\u003e  \u003c\/p\u003e\u003cp\u003eWhile many people can fumble their way through an Excel spreadsheet, how many of those folks can craft compelling and persuasive reports and visualizations from the data contained within? Data Visualization with Excel Dashboards and Reports walks readers through the most meaningful ways to show trends, find and demonstrate relationships in data, and how to make tough and necessary choices when presenting your data to stakeholders so your information has the greatest impact possible. \u003c\/p\u003e\u003cp\u003eThe accomplished author shows you how to think about your data in ways other than mere columns and rows. It bridges the gap between simply handling data and synthesizing that data into meaningful stories. You’ll learn about how deal with outliers and how to bucket data in the most meaningful way. You’ll learn how to show seemingly impossible amounts of data without inundating and confusing your audience. Finally, you’ll discover how to go from a spreadsheet full of raw data and figures to a high-impact and engaging reports and dashboards that persuade and inform other stakeholders. \u003c\/p\u003e\u003cp\u003ePerfect for sales managers, operations analysts, financial officers, administrative assistance, office managers, government employees, and manufacturing managers. Data Visualization with Excel Dashboards and Reports is also an invaluable resource for every professional who works in a data intensive environment. \u003c\/p\u003e\u003cp\u003e\u003ci\u003eThis unique combination of Excel technical manual and analytical guidebook also offers readers:\u003c\/i\u003e  \u003c\/p\u003e\u003cli\u003e\u003cbl\u003eWays to analyze large amounts of data and report on them in a meaningful way\u003c\/bl\u003e\u003c\/li\u003e \u003cli\u003e\u003cbl\u003eHow to get better visibility into data by using multiple perspectives\u003c\/bl\u003e\u003c\/li\u003e \u003cli\u003e\u003cbl\u003eHow to slice data into various views on the fly without reproducing work\u003c\/bl\u003e\u003c\/li\u003e \u003cli\u003e\u003cbl\u003eHow to automate reporting and analysis\u003c\/bl\u003e\u003c\/li\u003e \u003cli\u003e\u003cbl\u003eWays to create impressive dashboards and What-If analyses\u003c\/bl\u003e\u003c\/li\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47989026652389,"sku":"NP9781119698722","price":42.0,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781119698722.jpg?v=1761782494","url":"https:\/\/k12savings.com\/es\/products\/data-visualization-with-excel-dashboards-and-reports-isbn-9781119698722","provider":"K12savings","version":"1.0","type":"link"}