Import & Combine multiple PDF files from WHO
In the last tutorial of the COVID-19 dashboard series here, you learned how to import a single COVID-19 situation report directly from WHO website using Power...
Category: Power Query
Import WHO COVID-19 data from PDF
In the last tutorials of the COVID-19 dashboard series, you learned how to build your own COVID-19 dashboard from CSV files that were provided by Johns...
Guest Story: Maintain a simple database with Power Query
Our guest today is Kolyu Minevski, Director, Financial Management and Reporting at Fadata Group. You can contact him here. This article will demonstrate...
Guest Story: Unpivot Pairs of Columns
Our guest today is Sandeep Pawar. A Simulation & Data Analytics Engineer at Cree Lighting in Racine, WI. Sandeep applies Data Analytics, Statistics, and...
The Impact of Power Query – Survey Results
Recently I shared with you a survey here and asked you to estimate the impact of Power Query: How much time does Power Query save you in a year? How much...
Preserving context from multiple worksheets – Bonus Exercise – Chapter 5 – #PowerQuery Book
This is the third bonus exercise for my book, Collect, Combine, and Transform Data using Power Query in Excel and Power BI. Today's bonus exercise takes...
Preserving Context from CSV – Bonus Exercise – Chapter 5 – #PowerQuery Book
This is the second bonus exercise for my book, Collect, Combine, and Transform Data using Power Query in Excel and Power BI. In Chapter 5 you learn how to...
The potential impact of #PowerQuery – Your story can be featured
Earlier this year I published a survey to assess the impact of Power Query in organizations. I have decided to publish this survey again, and share the results...
My #PowerQuery book has arrived
If you are following me on social media, this video will not be new. Two days ago I received my print copy of the book. The book is real :) I was so excited...
Finding mismatched headers and creating a conversion table – Bonus Exercise – Chapter 4 – #PowerQuery Book
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...
