Power BI Project For Beginners | Sales Insights Data Analysis Project - 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.

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.

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

#️⃣ Social Media #️⃣

[stephenadewoyin]

Just got a job and i feel anxious but this explanations are making it more understandable. thanks

[anthonychilaka]

'Power BI is just like excel on steriod' 😆 Thanks Sir Dhaval for your tips, I just got to see your videos and on a career learning path to becoming a Data analyst.

[TheJanstyler]

This is so good. I never knew what I wanted to do as a job and nothing really seemed to interest me. So now at 24 I'm an electrician so I at least have a job. But I dont really like my job. A few days ago youtube randomly recommended me a video on data analysis. I never watched anything close to this. And I gotta say: Well done youtube algorithm. Data analysis looks VERY interesting to me. I'm gonna look into it a bit more before I decide if this is something I want to pursue, but right now it really looks like it. Thank you for your Videos. They paint a really good picture and are really informative.

[ravinduabeygunasekara]

Wow I am only watching the second video of this series and already feeling awesome about this! Thanks a lot for doing this!

[keifer]

What a legend. This is the kind of information I needed but couldn't find on youtube. Keep it up, Dhaval!

[Mario-oxdm]

Excited to get started with this project! Thank you for creating this!

[ankursingh]

I got to know a lot about what data analyst has to do and the process before starting the analysis.
Thanks a lot sir ji

[AyishaFiroz-jt]

Thanks a lot for the amazing videos you have been uploading. I sincerely appreciate all the hard work. You are helping many of us through this.

[aniiketpatiil]

Extremely useful info..thank you sooo much sir....This video clear all the confusions that i have in my mind....Again Thanls you so much sir please upload more videos like this so that the beginenrs like me understand whats really happening in the project, how they build the structure, how they define the algorythm etc etc....

[shaikusman]

Watching again on 26-jan-2023....Awsome content

[Mansijswarnkar]

Very nice explanations! - Especially i like the caption line - "PowerBI is like Excel on Steroids" 😀Thank you

[sadiasyed]

You are too good and really teach by heart to make people understand. I want to learn from your video. If you can provide I will appreciate

[muhammadsawaiz]

splendid way of teaching sr (hats of to you)

[yadikishameer]

Please make a full series on statsmodel. No channel is giving a perfect insight on this topic.

[rutupadwal]

Thank you so much. Your easy way of teaching is helping me lot sir

[kaushalsahu]

Thankyou sirr.. you always gives the infromations soo well.. It feels like a my elder brother is teaching me.. 😊 love from Jharkhand

[shreytyagi]

Really nice...its really important to understand how actually the work is done in industry...and knowing your actual role in the company...
really nice video...

[Aykcvc]

Such a fantastic video! That is what I have been looking for to have a bird view of the data analytics project. HATS OFF TO YOU AND YOUR TEAM! MUCH LOVE.

[fahadreda]

All of your videos are literally really good and very useful, Thank you so much 👍👍❤❤

[mensoutfit]

Sir most of student did not reach to this level to understand this project thats why your video is getting low view pls sir most of the student need your project video ....pls upload frequently and thanks so much sir 🙏🙏🙏🙏