Collect, Combine, and Transform Data Using Power Query in Excel and Power BI [Paperback]

Gil Ravivis a Microsoft MVP and a Power BI blogger at https://DataChant.com. As a Senior Program Manager on the Microsoft Excel Product team, Gil led the design and integration of Power Query as the next-generation Get Data and data-wrangling technology in Excel 2016, and he has been a devoted M practitioner ever since.

With 20 years of software development experience, and four U.S. patents in the fi elds of social networks, cyber security, and analytics, Gil has held a variety of innovative roles in cyber security and data analytics, and he has delivered a wide range of software products, from advanced threat detection enterprise systems to protection of kids on Facebook.

In his blog, DataChant.com, Gil has been chanting about Power BI and Power Query since he moved to his new home in the Chicago area in early 2016. As a Group Manager in Avanade’s Analytics Practice, Gil is helping Fortune 500 clients create modern self-service analytics capability and solutions by leveraging Power BI and Azure.

You can contact Gil at gilra@datachant.com.

Introduction

Chapter 1Introduction to Power Query

What Is Power Query?

    A Brief History of Power Query

    Where Can I Find Power Query?

Main Components of Power Query

    Get Data and Connectors

    The Main Panes of the Power Query Editor

Exercise 1-1: A First Look at Power Query

Summary

Chapter 2Basic Data Preparation Challenges

Extracting Meală°