Collect, Combine, and Transform Data Using Power Query in Excel and Power BI
| Price | $29.28 - $33.99
|
| Rating |   |
| Author | Gil Raviv |
| Publisher | Microsoft Press |
| Published | 2018 |
| Pages | 432 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 1509307958 |
| ISBN-13 | 9781509307951 |
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.
- Gil Raviv
4 5 30
Similar Books
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
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
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
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: $11.40 | Publisher: Manning | Release: 2017
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: $4.58 | Publisher: Addison-Wesley | Release: 2013
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
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
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