The Ultimate Power Query Cookbook for Power BI and Excel: Leveraging Power Query for collecting, combining and transforming your data
Par :Formats :
Disponible dans votre compte client Decitre ou Furet du Nord dès validation de votre commande. Le format ePub protégé est :
- Compatible avec une lecture sur My Vivlio (smartphone, tablette, ordinateur)
- Compatible avec une lecture sur liseuses Vivlio
- Pour les liseuses autres que Vivlio, vous devez utiliser le logiciel Adobe Digital Edition. Non compatible avec la lecture sur les liseuses Kindle, Remarkable et Sony
- Non compatible avec un achat hors France métropolitaine
, qui est-ce ?Notre partenaire de plateforme de lecture numérique où vous retrouverez l'ensemble de vos ebooks gratuitement
Pour en savoir plus sur nos ebooks, consultez notre aide en ligne ici
C'est si simple ! Lisez votre ebook avec l'app Vivlio sur votre tablette, mobile ou ordinateur :
- FormatePub
- ISBN978-93-5551-725-8
- EAN9789355517258
- Date de parution22/01/2024
- Protection num.Adobe DRM
- Infos supplémentairesepub
- ÉditeurBPB Publications
Résumé
Novice or expert, learn to simplify and optimize data transformations KEY FEATURES ? Practical approaches to cleansing, connecting and transforming data in Power Query.? Real-life examples that readers can apply to their own work.? Master Power Query for Excel and Power BI with step-by-step recipes. 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 FORNovice 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.
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 FORNovice 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.
Novice or expert, learn to simplify and optimize data transformations KEY FEATURES ? Practical approaches to cleansing, connecting and transforming data in Power Query.? Real-life examples that readers can apply to their own work.? Master Power Query for Excel and Power BI with step-by-step recipes. 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 FORNovice 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.
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 FORNovice 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.