Dummies.com
  • Print
  • Share
Microsoft Business Intelligence Tools for Excel Analysts (1118821521) cover image

Microsoft Business Intelligence Tools for Excel Analysts

ISBN: 978-1-118-82152-7
Paperback
384 pages
May 2014
US $49.99 Add to Cart
Other Available Formats: E-book

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

  • Print
  • Share