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

Published: 25 June 2020
on channel: codebasics

376,706

6.4k

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...
(You can find the SQL queries and setup instructions in the Readme file)

Install mysql:    • How To Install MySQL on Windows 10

Khan academy SQL course: https://www.khanacademy.org/computing...

Previous video:    • Power BI Project For Beginners | Sale...

Next video:    • Power BI Project For Beginners |  Sal...

How to learn data analyst skills for free:    • Skills required for data analyst | Ho...

Machine learning tutorial playlist:    • Machine Learning Tutorial Python -1: ...

Entire playlist for this project:    • Power BI Project For Beginners | Sale...

Special thanks to my friend, Hemanand Vadivel (  / 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-d...
Data Modelling: https://www.sqlbi.com/p/introduction-...

🌎 My Website For Video Courses: https://codebasics.io/?utm_source=des...

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:   / discord
📸 Dhaval's Personal Instagram:   / dhavalsays
📸 Codebasics Instagram:   / codebasicshub
🔊 Facebook:   / codebasicshub
📱 Twitter:   / codebasicshub
📝 Linkedin (Personal):   / dhavalsays
📝 Linkedin (Codebasics):   / codebasics
🔗 Patreon: https://www.patreon.com/codebasics?fa...