Microsoft Business Intelligence Tools for Excel Analysts

Front Cover
Wiley, Apr 17, 2014 - Computers - 384 pages
0 Reviews

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.

What people are saying - Write a review

We haven't found any reviews in the usual places.

Other editions - View all

About the author (2014)

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

Bibliographic information