Data Analysis Power BI Project For Beginners | Sales Insights Data Analysis Project – 3 – Data Analysis Using SQL

Power BI Project For Beginners | Sales Insights Data Analysis Project – 3 – Data Analysis Using SQL

Power BI Project For Beginners | Sales Insights Data Analysis Project – 3 – Data Analysis Using SQL post thumbnail image



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
📸 Dhaval’s Personal Instagram: https://www.instagram.com/dhavalsays/
📸 Codebasics Instagram: https://www.instagram.com/codebasicshub/
🔊 Facebook: https://www.facebook.com/codebasicshub
📱 Twitter: https://twitter.com/codebasicshub
📝 Linkedin (Personal): https://www.linkedin.com/in/dhavalsays/
📝 Linkedin (Codebasics): https://www.linkedin.com/company/codebasics/
🔗 Patreon: https://www.patreon.com/codebasics?fan_landing=true

source

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post