High Impact Data Visualization in Excel with Power View, 3D Maps, Get & Transform and Power BI

High Impact Data Visualization in Excel with Power View, 3D Maps, Get & Transform and Power BI , 2nd Edition is a book on Microsoft's suite of self-service business intelligence products that are rapidly gaining traction from their appeal to the quite large base of Microsoft Excel customers. The book focuses on visualization, another strong trend sweeping the business intelligence field today. This book shows readers how to mine their data and present their findings in compelling visualizations that grab and hold attention, and that communicate with resounding clarity.

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

Autorentext
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).

Zusammenfassung
Tagline: Going from data to insight with Power BI and Microsoft's self-service BI tool set

Inhalt

1. Self-Service Business Intelligence with Excel 2016.-2. Power View and Tables.-3. Filtering Data in Power View.-4. Charts in Power View.-5. Advanced Charting with Power View.-6. Interactive Data Selection in Power View.-7. Images and Presentation in Power View.-8. Mapping Data in Power View.-9. 3D Maps.-10. Discovering and Loading Data with Get & Transform in Excel 2016.-11. Transforming Datasets using Get & Transform.-12. Data Cleansing with Get & Transform.-13. Data Mashup with Get & Transform.-14. Extending the Excel Data Model Using Power Pivot.-15. Extending the Data Model with Calculated Columns.-16. Adding Measures to the Data Model.-17. Analyzing Data over Time with DAX.-18. Self-Service Business Intelligence with PowerBI.com.