Power Query Archives - Page 2 of 9

Finding mismatched headers and creating a conversion table – Bonus Exercise – Chapter 4 – #PowerQuery Book

Gil RavivOctober 26, 20182

This is the first post of a series of bonus exercises that will accompany my book, Collect, Combine, and Transform Data using Power Query in Excel and Power...

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

Book

The Digital Version of the New #PowerQuery Book is Ready

Gil RavivOctober 9, 20187

This is exciting! The digital version of the book "Collect, Combine and Transform Data Using Power Query in Excel and Power BI" is out. You can purchase it...

Book

First Page of Chapter 1 “Introduction to Power Query”

Gil RavivAugust 15, 20182

Today I got from the production team the first chapters of the book for final proofreading. I had to share with you a screenshot of the first page of Chapter...

Reader’s Corner

Welcome to the Reader's Corner. This is your entry point to learn more about Power Query, get answers about the book's toughest challenges, help other...

Power Query

The Potential Impact of #PowerQuery – A Crowd Wisdom Survey

Gil RavivJune 20, 20182

Answer this short survey to estimate the potential business impact of Power Query. Once you answer the survey, you can scroll down to review the results below....

Automatic Detection of Column Types in #PowerQuery

Gil RavivMay 14, 201812

Working with column types can be challenging in Power Query. The default conversion of types may not always work well for you, and may create future refresh...

Book

Book Excerpt: Basic Text Analytics using Power BI and Power Query in Excel

Gil RavivFebruary 7, 20185

Today I am excited to share a second excerpt from the draft manuscript of my book. Today's excerpt is the first part of chapter 11, which discusses basic text...

Power BI

Complex Data Prep: Hawaii Tourism Analysis in #PowerBI

Gil RavivDecember 26, 20174

Better late than never. Prior to 2017 Power BI Data Insights Summit, Microsoft published here three challenges, including a complex data preparation. So, I...

Book

Book Excerpt: Appending Worksheets from a Workbook

Gil RavivDecember 4, 20175

I am excited to share with you an excerpt from the draft manuscript of my book. You can pre-order the book in Amazon here. I expect to publish more excerpts in...

1 2 3 4 … 9 Page 2 of 9