Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
Power BI Project For Beginners | Sales Insights Data Analysis Project - 2 - Data Discovery
Play lesson

Power BI Project For Beginners | Sales Insights Power BI Project - Power BI Project For Beginners | Sales Insights Data Analysis Project - 2 - Data Discovery

5.0 (2)
14 learners

What you'll learn

This course includes

  • 3.3 hours of video
  • Certificate of completion
  • Access on mobile and TV

Summary

Keywords

Full Transcript

In this video we will cover project planning and data discovery aspect of our sales insights data analysis project. Once sales directory of atliQ hardware has decided to invest in data analysis project he will do a meeting with IT director, data analytics team to come up with a plan. They will use AIMS grid to define purpose and success criteria of this project. AIMS grid simple explanation:https://www.youtube.com/watch?v=6118I9HViuQ Once AIMS grid is defined, next step is data discovery. In this step, data analyst team approaches IT team within an organization who owns software system that keep track of sales records. These records are stored in mysql database. Power BI can be plugged to this database to pull necessary information required for data analysis. I also discuss ETL, OLTP, OLAP and data warehouse concepts. Many times we need separate data warehouse or OLAP system to run our data analytics queries but in our project we will directly use mysql database. Previous video: https://www.youtube.com/watch?v=hhZ62IlTxYs&list=PLeo1K3hjS3utcb9nKtanhcn8jd2E0Hp9b Next video: https://www.youtube.com/watch?v=JOrhcV3_NAk&list=PLeo1K3hjS3utcb9nKtanhcn8jd2E0Hp9b&index=3 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

Course Hive

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

FAQs

Course Hive
Download CourseHive
Keep learning anywhere