Summary
Keywords
Full Transcript
In the previous video, we looked at data discovery for our sales insights data analysis project. In this video, we will look at mysql database that is owned by the falcons team. This database has all sales transactions, customers, products, and market information. We will analyse this database and then hook it up with power BI. In power BI we will perform ETL and data cleaning operations to make it ready so that we can build our dashboard. To download the SQL dump file: https://codebasics.io/resources/sales-insights-data-analysis-project (You can find the SQL queries and setup instructions in the Readme file) Install mysql: https://www.youtube.com/watch?v=WuBcTJnIuzo Khan academy SQL course: https://www.khanacademy.org/computing/computer-programming/sql#sql-basics Previous video: https://www.youtube.com/watch?v=9QiZ0-HZG_A&list=PLeo1K3hjS3utcb9nKtanhcn8jd2E0Hp9b&index=2 Next video: https://www.youtube.com/watch?v=6pifKxjyHd8&list=PLeo1K3hjS3utcb9nKtanhcn8jd2E0Hp9b&index=4 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/ 🌎 My Website For Video Courses: https://codebasics.io/?utm_source=description&utm_medium=yt&utm_campaign=description&utm_id=description Need help building software or data analytics and AI solutions? My company https://www.atliq.com/ can help. Click on the Contact button on that website. #️⃣ 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.
