Microsoft Business Intelligence Tools for Excel Analysts(2014)

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 9.Introduction to SQL

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