LEADER 07119nam 22007335 450 001 9910300470803321 005 20200704224103.0 010 $a1-4302-6617-1 024 7 $a10.1007/978-1-4302-6617-4 035 $a(CKB)3710000000143758 035 $a(EBL)1781938 035 $a(SSID)ssj0001275977 035 $a(PQKBManifestationID)11746181 035 $a(PQKBTitleCode)TC0001275977 035 $a(PQKBWorkID)11255976 035 $a(PQKB)10329199 035 $a(MiAaPQ)EBC1781938 035 $a(DE-He213)978-1-4302-6617-4 035 $a(CaSebORM)9781430266174 035 $a(PPN)179762664 035 $a(OCoLC)961354125 035 $a(OCoLC)ocn961354125 035 $a(EXLCZ)993710000000143758 100 $a20140624d2014 u| 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aHigh Impact Data Visualization with Power View, Power Map, and Power BI /$fby Adam Aspin 205 $a1st ed. 2014. 210 1$aBerkeley, CA :$cApress :$cImprint: Apress,$d2014. 215 $a1 online resource (536 p.) 225 1 $aExpert's Voice in Business Intelligence 300 $aIncludes index. 311 $a1-322-13195-3 311 $a1-4302-6616-3 327 $aContents at a Glance; Introduction; Chapter 1: Self-Service Business Intelligence; The Microsoft Self-Service Business Intelligence Solution; The Excel BI Toolkit; Power BI; The Excel BI Toolkit and Power BI; Power Query; PowerPivot; Power View; Power Map; Power BI; Preparing the Self-Service BI Environment; PowerPivot; Power View; Power Query; Power Map; Power BI; Adding a Power BI Site; The Windows Power BI App; Corporate BI or Self-Service BI ?; The Excel Data Model; How This Book Is Designed to Be Read; Discovering Data; Creating a Data Model; Taking Data and Preparing It for Output 327 $aTaking Existing Excel BI and Sharing ItDelivering Geodata; Delivering Excel BI to Mobile Devices; To Learn the Product Suite Following a Real-World Path; The Self-Service Business Intelligence Universe; Conclusion; Chapter 2: Power View and Tables; The Power View Experience; Adding a Power View Sheet to an Excel Workbook; The Power View Interface; The Power View Ribbon; The Field List; Using the Field List; Renaming or Deleting a Power View Report; Tables in Power View; Adding a Table; Deleting a Table; Changing the Table Size and Position; Changing Column Order; Removing Columns from a Table 327 $aTypes of DataData and Aggregations; Enhancing Tables; The Design Ribbon; Row Totals; Formatting Columns of Numbers; Default Formatting; Changing Column Widths; Font Sizes in Tables; Copying a Table; Sorting by Column; Table Granularity; Matrix Tables; Row Matrix; Column Matrix; Sorting Data in Matrix Tables; Drilling Through with Matrix Tables; Drilling Down; Drilling Up; Reapplying Matrix Visualization; Drilling Through with Column Hierarchies; Card Visualizations; Card Visualization Styles; Sorting Data in Card-View Tables; Switching Between Table Types; Key Performance Indicators (KPIs) 327 $aConclusionChapter 3: Filtering Data in Power View; Filters; Hiding and Displaying the Filters Area; View Filters; Adding Filters; The (All) Filter; Clearing Filters; Deleting Filters; Expanding and Collapsing Filters; Subsetting Large Filter Lists; Searching for Specific Elements in a Filter; Clearing a Filter Subset; Filtering with Wildcards; Clearing a Filter Element Search; Filtering Different Data Types; Numeric Data; Range Filter Mode; List Filter Mode; Quickly Excluding Outliers; Date and Time Data; Other Data Types; Multiple Filters; Advanced Filters; Applying an Advanced Filter 327 $aClearing an Advanced FilterAdvanced Wildcard Filters; Numeric Filters; Date and Time Filters; Complex Filters; Advanced Text Filter Options; Advanced Numeric Filter Options; Advanced Date Filter Options; Visualization-Level Filters; Filter Hierarchy; Filtering Tips; Don't Filter Too Soon; Drill-Down and Filters; Annotate, Annotate, Annotate; Conclusion; Chapter 4: Charts in Power View; A First Chart; Creating a First Chart; Deleting a Chart; Basic Chart Modification; Basic Chart Types; Column Charts; Line Charts; Pie Charts; Essential Chart Adjustments; Resizing Charts; Repositioning Charts 327 $aSorting Chart Elements 330 $aHigh Impact Data Visualization with Power View, Power Map, and Power BI helps you take business intelligence delivery to a new level that is interactive, engaging, even fun, all while driving commercial success through sound decision-making. Learn to harness the power of Microsoft?s flagship, self-service business intelligence suite to deliver compelling and interactive insight with remarkable ease. Learn the essential techniques needed to enhance the look and feel of reports and dashboards so that you can seize your audience?s attention and provide them with clear and accurate information. Also learn to integrate data from a variety of sources and create coherent data models displaying clear metrics and attributes. Power View is Microsoft's ground-breaking tool for ad-hoc data visualization and analysis. It's designed to produce elegant and visually arresting output. It's also built to enhance user experience through polished interactivity. Power Map is a similarly powerful mechanism for analyzing data across geographic and political units. Power Query lets you load, shape and streamline data from multiple sources. PowerPivot can extend and develop data into a dynamic model. Power BI allows you to share your findings with colleagues, and present your insights to clients. High Impact Data Visualization with Power View, Power Map, and Power BI helps you master this suite of powerful tools from Microsoft. You'll learn to identify data sources, and to save time by preparing your underlying data correctly. You'll also learn to deliver your powerful visualizations and analyses through the cloud to PCs, tablets and smartphones. Simple techniques take raw data and convert it into information. Slicing and dicing metrics delivers interactive insight. Visually arresting output grabs and focuses attention on key indicators. 410 0$aExpert's voice in business intelligence. 606 $aMicrosoft software 606 $aMicrosoft .NET Framework 606 $aApplication software 606 $aMicrosoft and .NET$3https://scigraph.springernature.com/ontologies/product-market-codes/I29030 606 $aComputer Applications$3https://scigraph.springernature.com/ontologies/product-market-codes/I23001 615 0$aMicrosoft software. 615 0$aMicrosoft .NET Framework. 615 0$aApplication software. 615 14$aMicrosoft and .NET. 615 24$aComputer Applications. 676 $a005.3 700 $aAspin$b Adam$4aut$4http://id.loc.gov/vocabulary/relators/aut$0895187 801 0$bUMI 801 1$bUMI 801 2$bUMI 906 $aBOOK 912 $a9910300470803321 996 $aHigh Impact Data Visualization with Power View, Power Map, and Power BI$92000025 997 $aUNINA