Sales Insights Data Analysis Project In Power BI - Part 2 - Data Discovery

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/

Website: http://codebasicshub.com/
Facebook: https://www.facebook.com/codebasicshub
Twitter: https://twitter.com/codebasicshub

Видео Sales Insights Data Analysis Project In Power BI - Part 2 - Data Discovery канала codebasics