Power BI: cleaning and transforming sales data in Power Query
Bad data is a big pain for everyone. It is said that data analysts spend most of their time cleaning data, as it rarely comes in the format they need.
#PowerQuery comes as a perfect solution to this problem. After importing data to the Power Query editor, users can rely on functions, such as trim and format data, split columns using delimiters, change data types, filter, merge and unpivot columns and rows.
None of these functions require a special knowledge of coding, they are quite simple and can be performed with the right-click of a mouse in the Power Query editor.
Learn more about Power BI and Power Query: https://centida.com/index.php/blog/
Keywords:
#PowerBI #PowerQuery
#cleaning #sales #data