[eBook Code] Microsoft Business Intelligence Tools for Excel Analysts (eBook Code, 1st)

Introduction 1

Part I: Leveraging Excel for Business Intelligence

Chapter 1: Important Database Concepts 7

Chapter 2: PivotTable Fundamentals 19

Chapter 3: Introduction to Power Pivot 47

Chapter 4: Loading External Data into Power Pivot 69

Chapter 5: Creating Dashboards with Power View 93

Chapter 6: Adding Location Intelligence with Power Map 107

Chapter 7: Using the Power Query Add-In 129

Part II: Leveraging SQL for Business Intelligence

Chapter 8: Essential SQL Server Concepts 157

Chapter 9: Introduction to SQL 181

Chapter 10: Creating and Managing SQL Scripts 195

Chapter 11: Calling Views and Stored Procedures from Excel 215

Chapter 12: Understanding Reporting Services 231

Chapter 13: Browsing Analysis Services OLAP Cubes with Excel 249

Chapter 14: Using the Data Mining Add-In for Microsoft Office 269

Part III: Delivering Business Intelligence with SharePoint and Excel Services

Chapter 15: Publishing Your BI Tools to SharePoint 293

Chapter 16: Leveraging PerformancePoint Services 307

Part IV: Appendixes

Appendix A: Understanding the Big Data Toolset 331

Appendix B: Considerations for Delivering Mobile BI 341

Index 347