Summary
Keywords
Full Transcript
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, handle invalid values, etc. To download all the resource files: https://codebasics.io/resources/sales-insights-data-analysis-project (You can find the SQL queries, setup instructions, and Power BI formula in the Readme file) 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/ #️⃣ Social Media #️⃣ 🔗 Discord: https://discord.gg/r42Kbuk 📸 Codebasics Instagram: https://www.instagram.com/codebasicshub/ 🔊 Codebasics Facebook: https://www.facebook.com/codebasicshub 📝 Codebasics LinkedIn: https://www.linkedin.com/company/codebasics/ 📱 Codebasics X handle: https://twitter.com/codebasicshub 📸 Dhaval's Instagram: https://www.instagram.com/dhavalsays/ 📝 Dhaval's LinkedIn: https://www.linkedin.com/in/dhavalsays/ 📱 Dhaval's X handle: https://x.com/dpcodebasics 🔗 Patreon: https://www.patreon.com/codebasics?fan_landing=true
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
