High Impact Data Visualization with Power View, Power Map, and Power BI

1. Front Matter

   Pages i-xxx

   PDF

2. Self-Service Business Intelligence

   • Adam Aspin

   Pages 1-18

3. Power View and Tables

   • Adam Aspin

   Pages 19-55

4. Filtering Data in Power View

   • Adam Aspin

   Pages 57-83

5. Charts in Power View

   • Adam Aspin

   Pages 85-117

6. Advanced Charting with Power View

   • Adam Aspin

   Pages 119-140

7. Interactive Data Selection

   • Adam Aspin

   Pages 141-171

8. Images and Presentation

   • Adam Aspin

   Pages 173-200

9. Mapping Data in Power View

   • Adam Aspin

   Pages 201-219

10. PowerPivot Basics

    • Adam Aspin

    Pages 221-267

11. Extending the Excel Data Model Using PowerPivot

    • Adam Aspin

    Pages 269-303

12. PowerPivot for Self-Service BI

    • Adam Aspin

    Pages 305-328

13. Discovering and Loading Data with Power Query

    • Adam Aspin

    Pages 329-354

14. Transforming Data with Power Query

    • Adam Aspin

    Pages 355-396

15. Power Map

    • Adam Aspin

    Pages 397-441

16. Self-Service Business Intelligence with Power BI

    • Adam Aspin

    Pages 443-504

17. Sample Data

    • Adam Aspin

    Pages 505-507

18. Back Matter

    Pages 509-517

    PDF

High 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.

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 High Impact Data Visualization with Power View Power Map, and Power BI (Apress, 2014).

Policies and ethics