Skip to content
Responsive image
Vendor
Hanser Fachbuch
Gabriele Josiger
Original language
German
Categories

M - Collect and Process Data with Excel and Power BI

Ignaz Schels

This book is for users of Excel who want to know new gathering tools and for Excel or for Power BI users who have already worked with the user interface for queries and desire to learn more advanced techniques: - Users of Power BI Desktop will learn how to use the full potential of the query editor for their business Intelligence solutions. - Power Query and M will be used to prepare, process and present data for the perfect BI Dashboard


 

Power Query it included in the latest Excel versions and in Power BI Desktop. It makes it possible to import data from a great number of sources, such as text files, Excel workbooks, data bases, online services; it also brings the entered data into a form the user can work with.

 

In order to use the full potential of Power Query it is essential to master the basic programming language; data query and transformation is defined with the Power Query Formula Language, called “M.”

 

This book introduces the functions of the query editor and provides an overview of the basic structures of M. It uses many practical examples to show how PowerQuery and M codes can be used to automate day-to-day and complex tasks.
Available products
Book

Published 2019-07-01 by Hanser , ISBN: 9783446455887

Main content page count: 255 Pages

ISBN: 9783446455887