I'm a student
I'm an educator
Request full copy

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

Published by Microsoft Press (October 25, 2018) © 2019

  • Gil Raviv

eTextbook

$37.99

  • Available for purchase from all major ebook resellers, including InformIT.com.
  • To request a review copy, click on the "Request a Review Copy" button.
$31.99

  • A print text (hardcover or paperback) 
  • Free shipping
  • Also available for purchase as an ebook from all major ebook resellers, including InformIT.com

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

Students will learn to:
  • Save time by eliminating the pain of copying and pasting data into workbooks and then manually cleaning that data.
  • Gain productivity by properly preparing data
  • Gain effiiciency by reducing the time it takes to prepare data for analysis, and make informed decisions more quickly. 
  • 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

Gil Raviv is a Microsoft MVP and a Power BI blogger at https://DataChant.com. 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 fi elds 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.


In his blog, DataChant.com, Gil has been chanting about Power BI and Power Query since he moved to his new home in the Chicago area in early 2016. As a Group Manager in Avanade’s Analytics Practice, Gil is helping Fortune 500 clients create modern self-service analytics capability and solutions by leveraging Power BI and Azure.

You can contact Gil at gilra@datachant.com.

Need help? Get in touch

Video
Play
Privacy and cookies
By watching, you agree Pearson can share your viewership data for marketing and analytics for one year, revocable by deleting your cookies.

Video transcript (PDF | 16KB) 

Pearson eTextbook: What’s on the inside just might surprise you

They say you can’t judge a book by its cover. It’s the same with your students. Meet each one right where they are with an engaging, interactive, personalized learning experience that goes beyond the textbook to fit any schedule, any budget, and any lifestyle. 

Digital Learning NOW

Extend your professional development and meet your students where they are with free weekly Digital Learning NOW webinars. Attend live, watch on-demand, or listen at your leisure to expand your teaching strategies. Earn digital professional development badges for attending a live session.

Explore webinars