Microsoft Business Intelligence Tools for Excel Analysts (Paperback)

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 Excel
• Shows 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 web
• Details 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.

用Microsoft Business Intelligence Tools for Excel Analysts來彌補大數據差距

商業分析師使用Excel進行部門報告和IT部門使用SQL Server和SharePoint工具進行企業報告之間的區別比以往更加模糊。隨著引入了PowerPivot和Power View等強大的新功能，商業分析師有必要熟悉過去僅供IT專業人員使用的大數據工具。由一組商業智能專家撰寫的Microsoft Business Intelligence Tools for Excel Analysts向商業分析師介紹了豐富的工具集和報告功能，可以更有效地在分析中使用大型數據集，同時節省時間並簡化報告過程。

• 逐步引導您使用重要的BI工具，如PowerPivot、SQL Server和SharePoint，並向您展示如何在這些工具和Excel之間移動數據


• 向您展示如何利用關聯數據庫，將數據切片為不同的視圖以獲得不同的可視性，創建引人注目的可視化和儀表板，自動化SQL Server數據檢索和集成，以及將儀表板和報告發布到網絡


• 詳細介紹如何使用SQL Server的內置函數分析大量數據，使用Excel樞紐表訪問和報告OLAP數據，以及使用PowerPivot創建強大的報告機制

通過這本獨一無二的指南，您將全面掌握Microsoft BI堆棧及其在Excel數據分析中的應用，這本指南專為像您這樣的Excel分析師而寫。