Collect, Combine, and Transform Data Using Power Query in Excel and Power BI
Author:   Gil Raviv
Publisher:   Microsoft Press,U.S.
ISBN:  

9781509307951


Pages:   432
Publication Date:   19 December 2018
Replaced By:   9780138115791
Format:   Paperback
Availability:   Available To Order   Availability explained
We have confirmation that this item is in stock with the supplier. It will be ordered in for you and dispatched immediately.

Our Price $105.57 Quantity:  
Add to Cart

Share |

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


Add your own review!

Overview

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. Samples Preview sample pages from Collect, Combine, and Transform Data Using Power Query in Excel and Power BI >

Full Product Details

Author:   Gil Raviv
Publisher:   Microsoft Press,U.S.
Imprint:   Microsoft Press
Dimensions:   Width: 19.00cm , Height: 2.50cm , Length: 23.00cm
Weight:   0.680kg
ISBN:  

9781509307951


ISBN 10:   1509307958
Pages:   432
Publication Date:   19 December 2018
Audience:   Professional and scholarly ,  Professional & Vocational
Replaced By:   9780138115791
Format:   Paperback
Publisher's Status:   Active
Availability:   Available To Order   Availability explained
We have confirmation that this item is in stock with the supplier. It will be ordered in for you and dispatched immediately.

Table of Contents

Section 1: Transforming Data Chapter 1: Introduction to Power Query Chapter 2: Basic Data Challenges Chapter 3: Combining Data from Multiple Sources Chapter 4: Unpivoting and Transforming Data Chapter 5: Pivoting & Handling Multiline Records Section 2: Exploring Data Chapter 6: Ad-Hoc Analysis Chapter 7: Using Query Editor to Further Explore Data Section 3: Scaling Up Queries for Production or Larger Data Sets Chapter 8: Introduction to the M Query Language Chapter 9: Lightweight modification of M formulas to improve query robustness Section 4: Real Life Challenges Chapter 10: Solving Real-Life Data Challenges Chapter 11: Social Listening Chapter 12: Text Analytics Chapter 13: Concluding Exercise – Hawaii Tourism Data

Reviews

Author Information

Gil Raviv is a Microsoft MVP and a Power BI blogger. As a Senior Program Manager on the Microsoft Excel Product team, Gil led the design and integration of Power Query as the next-generation Get Data and data-wrangling technology in Excel 2016, and he has been a devoted M practitioner ever since. With 20 years of software development experience, and four U.S. patents in the fields of social networks, cyber security, and analytics, Gil has held a variety of innovative roles in cyber security and data analytics, and he has delivered a wide range of software products, from advanced threat detection enterprise systems to protection of kids on Facebook.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions
Latest Reading Guide

MRG2025CC

 

Shopping Cart
Your cart is empty
 Shopping cart
Mailing List

 

Sign up now