Power Query
Sumit Kumar Srivastava
Technology Solutions Provider?Microsoft Certified?Scrum Certified?PMI Certified
1- Power Query is a tool we use for extracting and transforming data.
2- Power Query is essentially like a washing machine, so if you think of a washing machine, it follows a series of steps to take your dirty clothes and turn of them from dirty clothes into nice and clean clothes.
3- Like the washing machine, power query is quite be same, it takes your dirty data and it follows a series of steps and provide clean data which we can use for our reports and dashboards.
4- In Power Query first we connect with the different data sources and then perform steps like remove column, combine columns, rename columns and calculate some columns and so on, by performing like these steps we clean the data and use in different reports and dashboards.