Universal Book Ratings
#1,244,816 in Books (See Top 100 in Books)
#91 in Microsoft Excel
#480 in Business & Home Office Spreadsheets
#1,244,816 in Data Mining (Books)
Computing & Internet
Databases
The Ultimate Power Query Cookbook for Power BI and Excel: Leveraging Power Query for collecting, combining and transforming your data (English Edition)
(0 reviews)
Share
Book Details
Language
English
Publishers
BPB Publications (22 Jan. 2024)
Weight
0.68 KG
Publication Date
22/01/2024
ISBN-10
9355517394
Pages
398 pages
ISBN-13
9789355517395
Dimensions
19.05 x 2.29 x 23.5 cm
SKU
9789355517395
Author Name
Dominick Raimato (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 a database of property assessments to make sure his house is in line with other properties to avoid overpaying taxes. Passionate about people, Dominick strives to create solutions that not just help achieve business objectives, but also make people’s lives better. If he can help someone get home earlier to eat dinner with their family or eliminate time consuming tasks so they can focus on more important things, he is in his element.Dominick currently lives in Bergen County, NJ where he can be found around the house working on projects or cooking in the kitchen. His specialty dishes include his homemade meat sauce in the winter and pulled pork bar-b-que on his smoker during the summer. He also ventures into New York City frequently to see his wife perform as a flutist with small ensembles, orchestras, and theaters.Read more about this authorRead less about this author
Read More
Top Selling Products
-
£27.18£28.33 -
£10.58
£12.58 -
£16.71
£17.13
Reviews & Ratings
3.8
out of 5.0
(0
reviews)
There have been no reviews for this product yet.
Novice or expert, learn to simplify and optimize data transformationsKey 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.
Table of Contents1. Introduction to Power Query2.
Connect to File-Based Data Sources3. Connect to Web-Based Data Sources4.
Connect to Database Sources5. Connect to Third-Party Data Sources6.
Managing Data Types7. Transforming Columns8.
Cleansing Columns9. Creating New Columns10.
Combining and Manipulating Queries11. Using Python, R, and AI12.
Indexing13. Parameters14.
Functions15. Advanced Web Connections16.
Manipulating Supporting Queries. .
● 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.
Table of Contents1. Introduction to Power Query2.
Connect to File-Based Data Sources3. Connect to Web-Based Data Sources4.
Connect to Database Sources5. Connect to Third-Party Data Sources6.
Managing Data Types7. Transforming Columns8.
Cleansing Columns9. Creating New Columns10.
Combining and Manipulating Queries11. Using Python, R, and AI12.
Indexing13. Parameters14.
Functions15. Advanced Web Connections16.
Manipulating Supporting Queries. .
Frequently Bought Products
Product Queries (0)
Login Or Registerto submit your questions to seller
Other Questions
No none asked to seller yet
Top Selling Products
-
£27.18
£28.33 -
£10.58
£12.58 -
£16.71
£17.13
Bookiyos Books Solutions - Quality Books, Unbeatable Prices
Bookiyos Books Solutions is your premier online bookstore offering a vast selection of over 5 crore books. Whether you're looking for the latest releases, timeless classics, or rare finds, we have something for every reader. Our platform serves customers worldwide, including the USA, UK, and Europe, with fast delivery and easy return policies to ensure a hassle-free shopping experience. Discover daily updates, exclusive deals, and a comprehensive collection of books that cater to all your reading needs. Shop with confidence at Bookiyos, where quality books and unbeatable prices meet.
Why Choose Bookiyos?
Extensive Inventory: New, old, and rare books available.
Fast Delivery: Same or next-day shipping.
Easy Returns: Hassle-free refund and return policies.
Global Reach: Serving customers in the USA, UK, Europe, and beyond.
Daily Updates: Thousands of new titles added every day.
Join our community of book lovers and start your literary journey with Bookiyos Books Solutions today!
Subscribe to our newsletter for regular updates about Offers, Coupons & more
Follow Us
Mobile Apps
