Fr. 70.20

The Ultimate Power Query Cookbook for Power BI and Excel - Leveraging Power Query for collecting, combining and transforming your data (English Edition)

English · Paperback / Softback

Shipping usually within 2 to 3 weeks (title will be printed to order)

Description

Read more










Novice or expert, learn to simplify and optimize data transformations

¿DESCRIPTION
"The Ultimate Power Query Cookbook for Power BI and Excel" serves up easy-to-follow recipes that transform data into meaningful insights. You will learn to clean messy files, combine datasets, and even use AI magic to Power BI and Excel.

This book will walk you through the basics of getting connected to data with Power Query. You will understand how to ingest data from files, folders, databases, websites, APIs, and other third party sources. Once connected, you will learn how to transform the data so it is ready for your use. We will clean up columns, filter, replace, extract, and classify data in Power Query to meet your needs. The book offers over 100 practical recipes, ensuring you understand each step with clear explanations and examples. Lastly, we will go over advanced techniques to help optimize and simplify your transformations allowing fast refreshes all while helping you manage them in the future.

This book will help you know how to apply these techniques and recipes to your data all while understanding the implications of making certain decisions. This will enable you to have better conversations with other data professionals who are providing data for your use.

WHAT YOU WILL LEARN
¿ Learn to connect to files, databases, and third-party services.
¿ Manage data types and formats to optimize storage.
¿ Transform, create, and manipulate queries.
¿ Combine, merge, filter, and cleanse queries.
¿ Integrate artificial intelligence to accelerate insights.
¿ Perform complex and scalable transformations.

WHO THIS BOOK IS FOR
Novice or expert, this book is designed for all Excel users, data analysts, Power BI power users, business professionals and data enthusiasts to get the most out of your data solutions when transforming your data in Power Query.

About the author










Self-identified as a data nerd, Dominick Raimato has had a huge passion for identifying insights and building solutions. You never know what kind of data projects he might be working on such as tracking temperature and humidity trends in his house to building adatabase of property assessments to make sure his house is in line with other properties to avoid overpaying taxes.

Product details

Authors Dominick Raimato
Publisher BPB Publications
 
Languages English
Product format Paperback / Softback
Released 22.01.2024
 
EAN 9789355517395
ISBN 978-93-5551-739-5
No. of pages 398
Dimensions 191 mm x 235 mm x 22 mm
Weight 741 g
Subject Natural sciences, medicine, IT, technology > IT, data processing > Operating systems, user interfaces

Customer reviews

No reviews have been written for this item yet. Write the first review and be helpful to other users when they decide on a purchase.

Write a review

Thumbs up or thumbs down? Write your own review.

For messages to CeDe.ch please use the contact form.

The input fields marked * are obligatory

By submitting this form you agree to our data privacy statement.