ISBN 9788126550357,Microsoft Business Intelligence Tools for Excel Analysts

Microsoft Business Intelligence Tools for Excel Analysts



Wiley India Pvt Ltd

Publication Year 2010

ISBN 9788126550357

ISBN-10 812655035X


Number of Pages 792 Pages
Language (English)

Computer programming

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 Power Pivot, SQL Server and Share Point 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. Not only can these tools allow Excel analysts to save time and simplify their processes, they will also enable them to substantially enhance their data analysis and reporting capabilities. Leveraging Excel for Business Intelligence Important Database Concepts Pivot Table Fundamentals Introduction to Power Pivot Loading External Data into Power Pivot Creating Dashboards with Power View Adding Location Intelligence with Power Map Using the Power Query Add-In Leveraging SQL for Business Intelligence Essential SQL Server Concepts Introduction to SQL Creating and Managing SQL Scripts 1 Calling Views and Stored Procedures from Excel Understanding Reporting Services Browsing Analysis Services OLAP Cubes with Excel Using the Data Mining Add-In for Microsoft Office Delivering Business Intelligence with Share Point and Excel Services Publishing Your BI Tools to Share Point Leveraging Performance Point Services