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

Collect, Combine, and Transform Data Using Power Query in Excel and Power BI
Price$29.93 - $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.





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

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...
Power Query for Power BI and Excel

Power Query for Power BI and Excel

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 ...
Analyzing Data with Power BI and Power Pivot for Excel

Analyzing Data with Power BI and Power Pivot for Excel

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...
Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel

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

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. ...
Data Manipulation with R

Data Manipulation with R

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 ...
Bioinformatics with R Cookbook

Bioinformatics with R Cookbook

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...