Read Anywhere and on Any Device!

Subscribe to Read | $0.00

Join today and start reading your favorite books for Free!

Create Free Account

Microsoft Business Intelligence Tools for Excel Analysts

Michael Alexander

3.8/5 ( ratings)

Bridge the big data gap with "Microsoft Business Intelligence Tools for Excel Analysts"

The distinction between departmental reporting done by business analysts with Excel and the enterprise reporting done by IT departments with SQL Server and SharePoint tools is more blurry now than ever before. With the introduction of robust new features like PowerPivot and Power View, it is essential for business analysts to get up to speed with big data tools that in the past have been reserved for IT professionals. Written by a team of Business Intelligence experts, "Microsoft Business Intelligence Tools for Excel Analysts" introduces business analysts to the rich toolset and reporting capabilities that can be leveraged to more effectively source and incorporate large datasets in their analytics while saving them time and simplifying the reporting process.Walks you step-by-step through important BI tools like PowerPivot, SQL Server, and SharePoint and shows you how to move data back and forth between these tools and ExcelShows you how to leverage relational databases, slice data into various views to gain different visibility perspectives, create eye-catching visualizations and dashboards, automate SQL Server data retrieval and integration, and publish dashboards and reports to the webDetails how you can use SQL Server's built-in functions to analyze large amounts of data, Excel pivot tables to access and report OLAP data, and PowerPivot to create powerful reporting mechanisms

You'll get on top of the Microsoft BI stack and all it can do to enhance Excel data analysis with this one-of-a-kind guide written for Excel analysts just like you.

Language: English

Pages: 384

Format: Paperback

Publisher: Wiley

Release: May 05, 2014

ISBN: 1118821521

ISBN 13: 9781118821527

Microsoft Business Intelligence Tools for Excel Analysts

Michael Alexander

3.8/5 ( ratings)

Bridge the big data gap with "Microsoft Business Intelligence Tools for Excel Analysts"

The distinction between departmental reporting done by business analysts with Excel and the enterprise reporting done by IT departments with SQL Server and SharePoint tools is more blurry now than ever before. With the introduction of robust new features like PowerPivot and Power View, it is essential for business analysts to get up to speed with big data tools that in the past have been reserved for IT professionals. Written by a team of Business Intelligence experts, "Microsoft Business Intelligence Tools for Excel Analysts" introduces business analysts to the rich toolset and reporting capabilities that can be leveraged to more effectively source and incorporate large datasets in their analytics while saving them time and simplifying the reporting process.Walks you step-by-step through important BI tools like PowerPivot, SQL Server, and SharePoint and shows you how to move data back and forth between these tools and ExcelShows you how to leverage relational databases, slice data into various views to gain different visibility perspectives, create eye-catching visualizations and dashboards, automate SQL Server data retrieval and integration, and publish dashboards and reports to the webDetails how you can use SQL Server's built-in functions to analyze large amounts of data, Excel pivot tables to access and report OLAP data, and PowerPivot to create powerful reporting mechanisms

You'll get on top of the Microsoft BI stack and all it can do to enhance Excel data analysis with this one-of-a-kind guide written for Excel analysts just like you.

Language: English

Pages: 384

Format: Paperback

Publisher: Wiley

Release: May 05, 2014

ISBN: 1118821521

ISBN 13: 9781118821527

More books from Michael Alexander

Excel Dashboards & Reports

Access 2013 Bible

101 Ready-To-Use Excel Macros

4.1/5 ( ratings)

Excel 2007 Dashboards & Reports for Dummies

3.6/5 ( ratings)

Pivot Table Data Crunching

3.8/5 ( ratings)

Access 2016 Bible

4.3/5 ( ratings)

Pivot Table Data Crunching: Microsoft Excel 2010

4.2/5 ( ratings)

Pivot Table Data Crunching for Microsoft Office Excel 2007

3.8/5 ( ratings)

Excel 2007 VBA Programmer's Reference

3.9/5 ( ratings)

Excel Dashboards and Reports for Dummies

3.7/5 ( ratings)

Excel 2019 Bible

4.4/5 ( ratings)

101 Ready-to-Use Excel Formulas (Mr. Spreadsheet's Bookshelf)

3.7/5 ( ratings)

Office 2013 Bible: The Comprehensive Tutorial Resource

4.3/5 ( ratings)

Excel 2016 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)

4.3/5 ( ratings)

Access 2019 Bible

3.6/5 ( ratings)

Excel 2019 Power Programming with VBA

4.3/5 ( ratings)

Excel 2016 Formulas

4.3/5 ( ratings)

Excel VBA Programming For Dummies

4.3/5 ( ratings)

Excel Power Pivot & Power Query For Dummies (For Dummies (Computers))

4.3/5 ( ratings)

Euro Par 2009, Parallel Processing Workshops: Hppc, Hetero Par, Proper, Roia, Unicore, Vhpc, Delft, The Netherlands, August 25 28, 2009, Workshops ... Computer Science And General Issues)

4.3/5 ( ratings)

Rate this book!

Write a review?