Business Impact of Power Query – Survey Results
2020 was a tough year, but Power Query users have prevailed. A few weeks ago I published this survey to assess the business impact of Power Query. The results...
Category: Power Query
The Impact of Power Query
Two years ago, I published a survey to measure the impact of Power Query. Since then, Power BI has gained tremendous momentum and accelerated the evolution of...
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...
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...
