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.





5 5 4

Similar Books


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

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

Power Query for Power BI and Excel

Power Query for Power BI and Excel

by Chris Webb

Power Query for Power BI and Excel is a book for people who are tired of copying and pasting data into Excel worksheets. Power Query, part of the Microsoft Power BI suite, is a tool that automates the process of getting data into Excel and will save you hours of dull, repetitive, and error-prone work! Power Query makes it easy to extract ...

Price:  $27.97  |  Publisher:  Apress  |  Release:  2014

Analyzing Data with Power BI and Power Pivot for Excel

Analyzing Data with Power BI and Power Pivot for Excel

by Alberto Ferrari, Marco Russo

How can you use Excel and Power BI to gain real insights into your information? As you examine your data, how do you write a formula that provides the numbers you need? The answers to both of these questions lie with the data model. This book introduces the basic techniques for shaping data models in Excel and Power BI. It's meant for rea...

Price:  $28.39  |  Publisher:  Microsoft Press  |  Release:  2017

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

Data Manipulation with R

Data Manipulation with R

by Jaynal Abedin

One of the most important aspects of computing with data is the ability to manipulate it to enable subsequent analysis and visualization. R offers a wide range of tools for this purpose. Data from any source, be it flat files or databases, can be loaded into R and this will allow you to manipulate data format into structures that support ...

Price:  $17.99  |  Publisher:  Packt Publishing  |  Release:  2014

Practical Binary Analysis

Practical Binary Analysis

by Dennis Andriesse

As malware increasingly obfuscates itself and applies anti-analysis techniques to thwart our analysis, we need more sophisticated methods that allow us to raise that dark curtain designed to keep us out - binary analysis can help. The goal of all binary analysis is to determine (and possibly modify) the true properties of binary programs ...

Price:  $29.99  |  Publisher:  No Starch Press  |  Release:  2018

Bioinformatics with R Cookbook

Bioinformatics with R Cookbook

by Paurush Praveen Sinha

Bioinformatics is an interdisciplinary field that develops and improves upon the methods for storing, retrieving, organizing, and analyzing biological data. R is the primary language used for handling most of the data analysis work done in the domain of bioinformatics.Bioinformatics with R Cookbook is a hands-on guide that provides you wi...

Price:  $32.99  |  Publisher:  Packt Publishing  |  Release:  2014