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

Introduction

Did you know that there is a data transformation technology inside Microsoft Excel, Power BI, and other products that allows you to work miracles on your data, avoid repetitive manual work, and save up to 80% of your time?

• Every time you copy/paste similar data to your workbook and manually clean it, you are wasting precious time, possibly unaware of the alternative way to do it better and faster.

• Every time you rely on others to get your data in the right shape and condition, you should know that there is an easier way to reshape your data once and enjoy an automation that works for you.

• Every time you need to make quick informed decisions but confront massive data cleansing challenges, know you can now easily address these challenges ...