Microsoft Business Intelligence Tools for Excel Analysts (2014)
Part 1: Leveraging Excel for Business Intelligence
Chapter 1.Important Database Concepts
Chapter 2.PivotTable Fundamentals
Chapter 3.Introduction to Power Pivot
Chapter 4.Loading External Data into Power Pivot
Chapter 5.Creating Dashboards with Power View
Chapter 6.Adding Location Intelligence with Power Map
Chapter 7.Using the Power Query Add-In
Part 2: Leveraging SQL for Business Intelligence
Chapter 8.Essential SQL Server Concepts
Chapter 10.Creating and Managing SQL Scripts
Chapter 11.Calling Views and Stored Procedures from Excel
Chapter 12.Understanding Reporting Services
Chapter 13.Browsing Analysis Services OLAP Cubes with Excel
Chapter 14.Using the Data Mining Add-In for Microsoft Office
Part 3: Delivering Business Intelligence with SharePoint and Excel Services
Chapter 15.Publishing Your BI Tools to SharePoint
Chapter 16.Leveraging PerformancePoint Services
Part 4: Appendixes
APPENDIX A. Understanding the Big Data Toolset
APPENDIX B. Considerations for Delivering Mobile BI