Introduction
The 70-779 exam is designed for both Business Intelligence developers and Business power users that have used Excel for many years to help support Analytics in an organization. The book is an even split between the skills needed to Consume and Transform Data, Model Data, and then Visualize Data.
In the Consume and Transform Data chapter the focus is on the sources that Excel can connect with for data, and then how to transform data using the Power Query Editor. It is important to understand the M language that underlies the Power Query Editor and is generated when performing transform tasks using the GUI.
The chapter on Modeling Data turns the focus to the Excel Data Model to build the necessary relationships that glue the data model ...
Get Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
