Collect, Combine, and Transform Data Using Power Query in Excel and Power BI



Bookstore > Books > Collect, Combine, and Transform Data Using Power Query in Excel and Power BI

Price$29.28 - $33.99
Rating
AuthorGil Raviv
PublisherMicrosoft Press
Published2018
Pages432
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101509307958
ISBN-139781509307951
EBook Hardcover Paperback

Using Power Query, you can import, reshape, and cleanse any data from a simple interface, so you can mine that data for all of its hidden insights. Power Query is embedded in Excel, Power BI, and other Microsoft products, and leading Power Query expert Gil Raviv will help you make the most of it. Discover how to eliminate time-consuming manual data preparation, solve common problems, avoid pitfalls, and more. Then, walk through several complete analytics challenges, and integrate all your skills in a realistic chapter-length final project. By the time you're finished, you'll be ready to wrangle any data - and transform it into actionable knowledge.

Prepare and analyze your data the easy way, with Power Query; Quickly prepare data for analysis with Power Query in Excel (also known as Get & Transform) and in Power BI; Solve common data preparation problems with a few mouse clicks and simple formula edits; Combine data from multiple sources, multiple queries, and mismatched tables; Master basic and advanced techniques for unpivoting tables; Customize transformations and build flexible data mashups with the M formula language; Address collaboration challenges with Power Query; Gain crucial insights into text feeds; Streamline complex social network analytics so you can do it yourself.




4 5 30

Similar Books


Exam Ref 70-778 Analyzing and Visualizing Data by Using Microsoft Power BI

Exam Ref 70-778 Analyzing and Visualizing Data by Using Microsoft Power BI

by Daniil Maslyuk

Prepare for Microsoft Exam 70-778 - and help demonstrate your real-world mastery of Power BI data analysis and visualization. Designed for experienced BI professionals and data analysts ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the exp...

Price:  $31.30  |  Publisher:  Microsoft Press  |  Release:  2018

Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel

Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel

by Chris Sorensen

Prepare for Microsoft Exam 70-779 - and help demonstrate your real-world mastery of Microsoft Excel data analysis and visualization. Designed for BI professionals, data analysts, and others who analyze business data with Excel, this Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. ...

Price:  $31.97  |  Publisher:  Microsoft Press  |  Release:  2018

Learning SQL, 3rd Edition

Learning SQL, 3rd Edition

by Alan Beaulieu

As data floods into your company, you need to put it to work right away—and SQL is the best tool for the job. With the latest edition of this introductory guide, author Alan Beaulieu helps developers get up to speed with SQL fundamentals for writing database applications, performing administrative tasks, and generating reports. You'...

Price:  $29.99  |  Publisher:  O'Reilly Media  |  Release:  2020

Learn PowerShell Scripting in a Month of Lunches

Learn PowerShell Scripting in a Month of Lunches

by Don Jones, Jeffery Hicks

Automate it! With Microsoft's PowerShell language, you can write scripts to control nearly every aspect of Windows. Just master a few straightforward scripting skills, and you'll be able to eliminate repetitive manual tasks, create custom reusable tools, and build effective pipelines and workflows. Once you start scripting in Po...

Price:  $34.99  |  Publisher:  Manning  |  Release:  2017

Introduction to Android Application Development, 4th Edition

Introduction to Android Application Development, 4th Edition

by Joseph Annuzzi, Lauren Darcey, Shane Conder

This fully reworked edition of a proven title is the most useful real-world guide to building robust, commercial-grade Android™ apps. The content is revised and updated for the latest Android 4.3 SDK and the newest development best practices. Introduction to Android™ Application Development: Android Essentials, Fourth Edition,covers a...

Price:  $25.00  |  Publisher:  Addison-Wesley  |  Release:  2013

Pro Data Mashup for Power BI

Pro Data Mashup for Power BI

by Adam Aspin

This book provides all you need to find data from external sources and load and transform that data into Power BI where you can mine it for business insights and a competitive edge. This ranges from connecting to corporate databases such as Azure SQL and SQL Server to file-based data sources, and cloud- and web-based data sources. The boo...

Price:  $51.08  |  Publisher:  Apress  |  Release:  2022

Practical Python Data Wrangling and Data Quality

Practical Python Data Wrangling and Data Quality

by Susan E. McGregor

The world around us is full of data that holds unique insights and valuable stories, and this book will help you uncover them. Whether you already work with data or want to learn more about its possibilities, the examples and techniques in this practical book will help you more easily clean, evaluate, and analyze data so that you can gene...

Price:  $49.58  |  Publisher:  O'Reilly Media  |  Release:  2021

Programming Skills for Data Science

Programming Skills for Data Science

by Michael Freeman, Joel Ross

Using data science techniques, you can transform raw data into actionable insights for domains ranging from urban planning to precision medicine. Programming Skills for Data Science brings together all the foundational skills you need to get started, even if you have no programming or data science experience.Leading instructors Michael Fr...

Price:  $40.99  |  Publisher:  Addison-Wesley  |  Release:  2018