+353-1-416-8900REST OF WORLD
+44-20-3973-8888REST OF WORLD
1-917-300-0470EAST COAST U.S
1-800-526-8630U.S. (TOLL FREE)

Microsoft Business Intelligence Tools for Excel Analysts

  • ID: 2708365
  • Book
  • 384 Pages
  • John Wiley and Sons Ltd
1 of 3

Self–Service Business Intelligence with Excel

For the first time, Excel is an integral part of the Microsoft BI stack – capable of integrating multiple data sources, defining relationships between data sources, processing analysis services cubes, and developing interactive dashboards that can be shared on the web. With these new tools, it s becoming important for Excel analysts to expand their knowledge to include new skills, like database management, query design, data integration, multidimensional reporting, and a host of other practices.

This book is aimed squarely at business analysts and managers who find it increasingly necessary to become more efficient at working with the new Microsoft BI tools like Power Pivot, Power Query, and Power View.

Let Mr. Spreadsheet show you how to:

  • Use PowerPivot to create powerful reporting mechanisms
  • Automate data integration with Power Query
  • Create geo–spatial reporting with Power Map
  • Develop eye–catching Dashboards with Power View
  • Use SQL Server® to leverage relational and OLAP databases
  • Gain insight and analytical power with Data Mining tools
Note: Product cover images may vary from those shown
2 of 3

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

Note: Product cover images may vary from those shown
3 of 3


4 of 3
Michael Alexander
Jared Decker
Bernard Wehbe
Note: Product cover images may vary from those shown
Order Online - visit: https://www.researchandmarkets.com/reports/2708365