O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required