ODBIERZ TWÓJ BONUS :: »

Learn Power Query

(ebook) (audiobook) (audiobook) Język publikacji: angielski
Learn Power Query Linda Foulkes, Warren Sparrow - okładka książki

Learn Power Query Linda Foulkes, Warren Sparrow - okładka książki

Learn Power Query Linda Foulkes, Warren Sparrow - okładka audiobooka MP3

Learn Power Query Linda Foulkes, Warren Sparrow - okładka audiobooks CD

Ocena:
Bądź pierwszym, który oceni tę książkę
Stron:
428
Dostępne formaty:
     PDF
     ePub

Ebook

94,99 zł

Dodaj do koszyka lub Kup na prezent Kup 1-kliknięciem

Przenieś na półkę

Do przechowalni

Power Query is a data connection technology that allows you to connect, combine, and refine data from multiple sources to meet your business analysis requirements. With this Power Query book, you'll be empowered to work with a variety of data sources to create interactive reports and dashboards using Excel and Power BI.

You'll start by learning how to access Power Query across different versions of Excel and install the Power BI engine. After you've explored Power Pivot, you'll see why Excel users find it challenging to clean data in Power Pivot and learn how Power Query can help to tackle the problem. The book will show you how to transform data using the Query Editor and write functions in Power Query. A dedicated section will focus on functions such as IF, Index, and Modulo, and creating parameters to alter query paths in a table. You'll also work with dashboards, get to grips with multi-dimensional reporting, and create automated reports. As you advance, you'll cover the M formula language in Power Query, delve into the basic M syntax, and write the M query language with the help of examples such as loading all library functions offline in Excel and Power BI. Finally, the book will demonstrate the difference between M and DAX and show how results are produced in M.

By the end of this book, you'll be ready to create impressive dashboards and multi-dimensional reports in Power Query and turn data into valuable insights.

Wybrane bestsellery

0 Linda Foulkes, Warren Sparrow

Packt Publishing - inne książki

Zamknij

Wybierz metodę płatności