Sales Insights Data Analysis Project In Power BI - Part 4 - Data Cleaning & ETL
In this video, we will plug mysql database with power BI. In power BI we will do data cleaning and ETL (Extract, transform , load). This process is also known as data munging or data wrangling. We will do currency normalization, handling invalid values etc.
Page with power BI formula etc: https://github.com/codebasics/DataAnalysisProjects/tree/master/1_SalesInsights
Previous video: https://www.youtube.com/watch?v=JOrhcV3_NAk&list=PLeo1K3hjS3utcb9nKtanhcn8jd2E0Hp9b&index=3
Next video: https://www.youtube.com/watch?v=pbOJVEsZKJ8&list=PLeo1K3hjS3utcb9nKtanhcn8jd2E0Hp9b&index=5
How to learn data analyst skills for free: https://youtu.be/x6tnVOn4st4
Machine learning tutorial playlist: https://www.youtube.com/watch?v=gmvvaobm7eQ&list=PLeo1K3hjS3uvCeTYTeyfe0-rN5r8zn9rw
Entire playlist for this project: https://www.youtube.com/playlist?list=PLeo1K3hjS3uva8pk1FI3iK9kCOKQdz1I9
Special thanks to my friend, Hemanand Vadivel (https://www.linkedin.com/in/hemanand-vadivel-0b34aab5/) who is an experienced data analyst manager working for a company in UK. He has a major contribution in this project.
Basics of DAX & Data Modelling are the two fundamental technical skills required to author Power BI reports – There are the free courses I recommend from SQLBI.com DAX: https://www.sqlbi.com/p/introducing-dax-video-course/ Data Modelling: https://www.sqlbi.com/p/introduction-to-data-modeling-for-power-bi-video-course/