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

by Chris Sorensen

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  



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  



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 

272 pages, Kindle Edition

Published June 7, 2018

Reviews

[Rafael Moreno · Rating 4 out of 5]

Great walkthrough for the Power Query and Power Pivot tools. No the most detailed book for learning from scratch, but I managed to learn a couple of things by going through the step-by-step review for the certification.