1. Self-Service Business Intelligence with Excel 20162. Power View and Tables3. Filtering Data in Power View4. Charts in Power View5. Advanced Charting with Power View6. Interactive Data Selection in Power View7. Images and Presentation in Power View8. Mapping Data in Power View9. 3D Maps10. Discovering and Loading Data with Get & Transform in Excel 201611. Transforming Datasets using Get & Transform12. Data Cleansing with Get & Transform13. Data Mashup with Get & Transform14. Extending the Excel Data Model Using Power Pivot15. Extending the Data Model with Calculated Columns16. Adding Measures to the Data Model17. Analyzing Data over Time with DAX18. Self-Service Business Intelligence with PowerBI.com
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, Credit 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).