Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel

Prepare for Microsoft Exam 70-779–and help demonstrate your real-world mastery of Microsoft Excel data analysis and visualization. Designed for BI professionals, data analysts, and others who analyze business data with Excel, this Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. 

Focus on the expertise measured by these objectives: 

• Consume and transform data by using Microsoft Excel 
• Model data, from building and optimizing data models through creating performance KPIs, actual and target calculations, and hierarchies 
• Visualize data, including creating and managing PivotTables and PivotCharts, and interacting with PowerBI  

This Microsoft Exam Ref: 

• Organizes its coverage by exam objectives 
• Features strategic, what-if scenarios to challenge you 
• Assumes you have a strong understanding of how to use Microsoft Excel to perform data analysis 

準備 Microsoft 考試 70-779，並幫助展示您在 Microsoft Excel 數據分析和可視化方面的實際掌握能力。本考試參考書專為商業智能專業人士、數據分析師和其他使用 Excel 進行業務數據分析的人士設計，重點關注在 MCSA 級別所需的批判性思維和決策能力。

著重於以下目標所衡量的專業知識：

- 使用 Microsoft Excel 消耗和轉換數據
- 建模數據，從構建和優化數據模型到創建性能 KPI、實際和目標計算以及層次結構
- 可視化數據，包括創建和管理樞紐分析表和樞紐圖，以及與 PowerBI 互動

本 Microsoft 考試參考書：

- 根據考試目標組織內容
- 提供戰略性的假設情境來挑戰您
- 假設您對如何使用 Microsoft Excel 進行數據分析有很好的理解