En savoir plus 
Introduces business analysts to the toolset and reporting capabilities that can be used to source and incorporate large datasets in analytics, including PowerPivot, SQL Server, and SharePoint, covering such topics as how to move data between these tools,how to leverage relational databases, and creating visualizations and dashboards.
Table des matières
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