Microsoft Business Intelligence Tools for Excel Analysis

Michael Alexander

ISBN: 9788126550357

380 pages

INR 599


This book is aimed squarely at business analysts and managers who find it increasingly necessary to become more efficient at working with large datasets traditionally reserved for IT professionals. This book is written from a business analyst's point of view, guiding readers through the mysterious world of PowerPivot, SQL Server and SharePoint in terms they understand. Readers are introduced to the rich set of tools and reporting capabilities that can be leveraged to more effectively source and incorporate large datasets in their analytics.


Part I: 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 II: Leveraging SQL for Business Intelligence

Chapter 8: Essential SQL Server Concepts

Chapter 9: Introduction to SQL

Chapter 10: Creating and Managing SQL Scripts 1

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 III: Delivering Business Intelligence with SharePoint and Excel Services

Chapter 15: Publishing Your BI Tools to SharePoint

Chapter 16: Leveraging PerformancePoint Services

Part IV: Appendixes

Appendix A: Understanding the Big Data Toolset

Appendix B: Considerations for Delivering Mobile BI