We all know that Power Bi is one of market leader software to create visuals and dashboards. Dealing with unstructured data has become a challenge to many professionals, should they normalize it first before importing it to Power BI using excel or other data software. The key item to demonstrate in this webinar how we can normalize data inside Power BI using the power query editor to remove duplicates, format data based on type, promote headers, remove unwanted rows and columns, manipulate text and merge different data sources.