Exam Ref 70-779 Analyzing and Visualizing Data by Using 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 

Chris Sorensen, MCSE (Data Management and Analytics) and MCT, is the Founder and President of Iteration Insights Ltd. He is a consultant, architect, educator, and coach who has been working in the Analytics space for nearly 20 years. Over his career, he has provided strategic and architectural advisory services to many clients and most recently he has been involved with leading numerous Power BI and Excel PowerPivot projects. He has evangelized both Excel and Power BI with Microsoft since July 2015. Follow him on both Linkedin and Twitter as @wjdataguy.