Exam Ref 70-779 Analyzing and Visualizing Data by Using Microsoft Excel

Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-779 Analyzing and Visualizing Data by Using Microsoft Excel certification exam.

Exam Ref 70-779 Analyzing and Visualizing Data by Using Microsoft Excel offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. It focuses on the specific areas of expertise modern IT professionals need to successfully consume, transform, model, and visualize data with Excel 2016. Coverage includes:

• Importing data from external data sources
• Working with Power Query
• Designing and implementing transformations
• Applying business rules
• Cleansing data
• Creating performance KPIs
• And much more

Microsoft Exam Ref publications stand apart from third-party study guides because they:

• Provide guidance from Microsoft, the creator of Microsoft certification exams
• Target IT professional-level exam candidates with content focused on their needs, not "one-size-fits-all" content
• Streamline study by organizing material according to the exam’s objective domain (OD), covering one functional group and its objectives in each chapter
• Feature Thought Experiments to guide candidates through a set of "what if?" scenarios, and prepare them more effectively for Pro-level style exam questions
• Explore big picture thinking around the planning and design aspects of the IT pro’s job role

For more information on Exam 70-779 and the MCSA: BI Reporting credential, visit microsoft.com/learning.

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.