High Impact Data Visualization in Excel with Power View, 3D Maps, Get & Transform and Power BI
Authors: Aspin, Adam
Download source code Free Preview- Learn powerful visualization techniques for delivering business intelligence in support of sound decision-making and commercial success
- Build expertise in Microsoft's expanding Power suite of self-service business intelligence tools
- Collect data from multiple data sources into coherent data models having clear metrics and attributes
Buy this book
- About this book
-
Take business intelligence delivery to a new level that is interactive, engaging, even fun, all while driving commercial success through sound decision making. Do this through the power of visualization using this updated edition covering new features and added support for visualization in Excel 2016, and describing the latest developments in Get & Transform and DAX. The example data set has also been updated to demonstrate all that Microsoft's self-service business intelligence suite is now capable of.
High Impact Data Visualization in Excel with Power View, 3D Maps, Get & Transform and Power BI, 2nd Edition helps in harnessing 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.
High Impact Data Visualization in Excel with Power View, 3D Maps, Get & Transform and Power BI, 2nd Edition 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.
- Produce designer output that will astound your bosses and peers.
- Drive business intelligence from Excel using BI in the Cloud.
- Gather source data from corporate and public sources.
- Integrate charts, maps, and tables to deliver visually stunning information.
- Discover new insights as you chop and tweak your data as never before.
- Adapt delivery to mobile devices.
- Outshine competing products and enhance existing skills.
Any Power BI Desktop, Excel or SharePoint user. Business Intelligence developers, power users, IT managers, finance experts, and more can use this book to outshine the competition by producing high-impact business intelligence reporting on a variety of devices from a variety of sources.
- About the authors
-
Adam Aspin is an independent Business Intelligence consultant based in the United Kingdom. He has worked with SQL Server for seventeen years, and Business Intelligence has been his principal focus for the last ten years. He has applied his skills for a range of clients, including J.P. Morgan, The Organisation for Economic Co-operation and Development (OECD), Tesco, Centrica, Harrods, Vodafone, Crédit Agricole, Cartier, Alfred Dunhill, The RAC and EMC Conchango. Adam is a graduate of Oxford University. He is a frequent contributor to SQLServerCentral.com. He has written numerous articles for various French IT publications. A fluent French speaker, Adam has worked in France and Switzerland for many years. He is the author of SQL Server 2012 Data Integration Recipes (Apress, 2012), and of Pro Power BI Desktop (Apress, 2016).
- Table of contents (18 chapters)
-
-
Self-Service Business Intelligence with Excel 2016
Pages 1-15
-
Power View and Tables
Pages 17-55
-
Filtering Data in Power View
Pages 57-86
-
Charts in Power View
Pages 87-119
-
Advanced Charting with Power View
Pages 121-142
-
Table of contents (18 chapters)
Bibliographic Information
- Bibliographic Information
-
- Book Title
- High Impact Data Visualization in Excel with Power View, 3D Maps, Get & Transform and Power BI
- Authors
-
- Adam Aspin
- Copyright
- 2016
- Publisher
- Apress
- Copyright Holder
- Adam Aspin
- eBook ISBN
- 978-1-4842-2400-7
- DOI
- 10.1007/978-1-4842-2400-7
- Softcover ISBN
- 978-1-4842-2399-4
- Edition Number
- 2
- Number of Pages
- XXXII, 599
- Number of Illustrations
- 413 illustrations in colour
- Topics