Alexander / Decker / Wehbe Microsoft Business Intelligence Tools for Excel Analysts

1. Auflage 2014
ISBN: 978-1-118-82155-8
Verlag: John Wiley & Sons
Format: PDF
Kopierschutz: Adobe DRM (»Systemvoraussetzungen)

E-Book, Englisch, 384 Seiten, E-Book

Bridge the big data gap with Microsoft BusinessIntelligence Tools for Excel Analysts
The distinction between departmental reporting done by businessanalysts with Excel and the enterprise reporting done by ITdepartments with SQL Server and SharePoint tools is more blurry nowthan ever before. With the introduction of robust new features likePowerPivot and Power View, it is essential for business analysts toget up to speed with big data tools that in the past have beenreserved for IT professionals. Written by a team of BusinessIntelligence experts, Microsoft Business Intelligence Tools forExcel Analysts introduces business analysts to the rich toolsetand reporting capabilities that can be leveraged to moreeffectively source and incorporate large datasets in theiranalytics while saving them time and simplifying the reportingprocess.
* Walks you step-by-step through important BI tools likePowerPivot, SQL Server, and SharePoint and shows you how to movedata back and forth between these tools and Excel
* Shows you how to leverage relational databases, slice data intovarious views to gain different visibility perspectives, createeye-catching visualizations and dashboards, automate SQL Serverdata retrieval and integration, and publish dashboards and reportsto the web
* Details how you can use SQL Server's built-in functionsto analyze large amounts of data, Excel pivot tables to access andreport OLAP data, and PowerPivot to create powerful reportingmechanisms
You'll get on top of the Microsoft BI stack and all it cando to enhance Excel data analysis with this one-of-a-kind guidewritten for Excel analysts just like you.

Autoren/Hrsg.

Alexander, Michael

Decker, Jared

Wehbe, Bernard

Inhaltsverzeichnis

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

Über Autor(innen)

Michael Alexander is a Microsoft Certified ApplicationDeveloper (MCAD) and author of several books on advanced businessanalysis with Microsoft Access and Excel.
Jared Decker is the co-founder of StatSlice Systems and acertified BI developer with more than 14 years' experiencetraining and developing enterprise reporting solutions.
Bernard Wehbe a is a veteran BI consultant and co-founderof StatSlice Systems where he helps organizations implementbusiness analytics and data visualization solutions.
John Walkenbach is arguably the foremost authority onExcel. He has written more than 30 books and maintains the popularSpreadsheet Page at www.j-walk.com/ss.