Dear sir same question in my mind, what is the role of python in data analyst. Bcoz powerbi already have power query editor to cleaning data then role of python plz guide us
@@shahnawazatharkazmi2826 here data we get clear format but most of time data we get in multiple sources in different format their python is used in which numpy and pandas library are useful
Thank you for this video, you took your time and effort into putting this video together - step by step - so that we all could follow along. The quality of this content is something that I and probably many others would pay a considerable amount of money to be able to benefit from, and yet you did it for free! Thanks again!
I'm amazed by how proficiently you demonstrated the use of both SQL and Power BI in a single project (start to finish).Your approach makes it easy to comprehend and practicalise, yet simple to follow, even for an average user. I am happy to have encountered your work. Thank you for sharing your expertise!
Absolutely amazing video, I have finally realised that as a beginner in the financial investment market, you can achieve close to nothing yourself because you still have a lot to learn. Trading with a professional broker is more profitable and my advice for beginners is to always take advantage of that.
Instead of timing the market, you should try to diversify your portfolio in order to get a dollar-cost average when it’s time to retire. Keep in mind that you don't need a ton of money to invest. Investing in small amounts can build long-term wealth too!
I know I am seeing your video late but wanted to thank you so much for taking all the time it took to make this video for everyone and walk step by step through your process. So very kind of you to help those of us trying to master the whole PBI project/process.
I'm really grateful for the immense knowledge I've gathered from you. Within 2 months I've designed 3 completely interactive dashboard with you. . 2: Please, try and always include data dictionary of each dataset for those of us that are documenting. I've documented the Ecommerce, HR and working on this pixza dataset. Thanks once again
Thank you so much Sir , I have done several dashboard by watching others tutorial. I personally felt this is the best . That too for free . I have learnt so many things.
The way you explained the concepts from begining to end, made it really easy for us to understand it. Thank you so much for sharing your knowledge and the effort that you put in is commendable.
Thank you so much! Your explanation is clear and easy to understand. Anyone looking to learn Power BI from beginner to end, this is the best practice. Thanks again!!
I want to express my heartfelt gratitude for your dedication to sharing knowledge. It's evident that you have invested a lot of time and effort into creating this tutorial, and it has undoubtedly made a significant impact on my learning journey. Thanks to you, I now feel empowered to tackle SQL and Power BI projects confidently.
I want to appreciate you for the time spent and dedication to this work to instill the basic requirements and the needful things to know as a data analyst. I would love you to make a video on how to display our dashboard on our web page, Please.
You are a pro in terms of explaining and providing valuable content to us. I have learned many new and important steps help me to groom myself more widely. Thank you so much for the help.
Just wanted to take a minute to say a huge THANK YOU for all the amazing content you create! Your videos have been so helpful in my learning journey, and I'm seriously grateful for your willingness to share your knowledge with the world.
Your dedication to sharing expertise is commendable, and your video significantly contributed to my learning journey in BI. Thank you for your valuable contribution; I look forward to exploring more of your content.
A great learning and beautiful visualization. Thanks ! Small suggestion to always create a date & time table and link it to the main table. this will reduce the complexity in main table and would query the results faster.
Thank you somuch brother , I have done several dashboard by watching others tutorial. I personally felt this is the best . That too for free . I have learnt somany things. This is the first vedio I watched . As you said " I liked , subscribed and commenting ❤👏
First of all Thanks a lot because your teaching way incredible. I have never seen and watched like this video before. I really appreciate you to do this work, Definitely you are the wonderful personality as we as wonderful human being, I pay to god gives you happiness and prosperity Thanks a trillion again.
Thank you for this amazing portfolio project which will be truly helpful for mine data analyst journey. I just completed this amazing video, and I must appreciate your time & efforts behind such a great work which shows the real industry experience behind it. Glad to subscribe your channel. Much Appreciated!
I truly appreciate your efforts, thank you for the clear and straightforward explanation. I comprehended everything in the video, and you've contributed to enhancing my skills.
Best video ever!!!!!! I have learned these two program but I didn't know how to start a project it took 3 hours from me but I really benefited and I will watch your other videos thank you very very much for this work! everything is perfect and clear even that the Word file thank you again. I just hope that you will make a video on how I can determine the KPI so that I can work with dataset and know how to clean it because it was really easy for SQL and visualization when you explained that, and no one has clarified this point. I was always asking how I can find out that columns I need in order to implement the queries.
I'm out of words sir....it does look like some real project now❤....the feeling after watching the whole video of more than 2.5 hrs is really good....thank you for this sir🎉❤
this is content really helpfull for me as beginner which who want learn Data Analyst process.. i hope u cant keep update about simillar things coz i will follow ur update for further 👍🙏
Wow, thank you so much for this incredible Power BI tutorial! 🙌 Your explanations are clear, and your step-by-step approach made it so easy for someone like me, who's relatively new to Power BI, to follow along. I've been struggling with some aspects of data visualization, and your video not only clarified those concepts but also gave me the confidence to dive deeper into Power BI. Your dedication to helping others learn is truly admirable. I can see the effort and time you've put into creating this tutorial, and it's greatly appreciated. Please keep up the fantastic work! Looking forward to more of your tutorials. 💪
I did learn SQL a few days ago but could not find any useful SQL project and luckily ur this project came in front of my eyes. The SQL queries u performed were a mix of beginner and intermediate difficulty and ur power BI skills are really phenomenal. I learnt a lot. Thank you and God Bless!
Thank you for sharing your knowledge. I understand you have connected the SQL server to Power BI but you didn't use the queries that you created. I see you have used only DAX functions in your visual then what's the purpose of creating queries in SQL. I just wanted to learn! But very informative session
Great work. A slight mistake I noticed was how for the 2nd page, in the worst sellers section, its suppots to written that the Brie Carre Pizza contributes to the minimum Total Orders instead of the "maximum".
I have no words to say after seeing this dashboard which gives me an accurate knowledge of how to use MySQL and PowerBI together. I watched your video from beginning and learn lot of things like what is MySQL server management studio and how to connect it with PowerBI. I also learn some new DAX Queries with the help of this dataset and I also created this dashboard through your guidance and lot of support. Thanks for this video and keep it up.
This was great, thank you! One thing I did notice when adding an additional column for the day of the week (on Building the Monthly and Daily trends) is that the data on the excel sheet has a large amount of dates not formatted correctly, or different, and it shows as blank when transforming the data. When making a bar chart with this data, it shows around 29k blank spots for the day.
One of the best project for power bi available on youtube
Glad you think so!
This project looks like real time .This makes as understand how SQL and power bi works together. Please upload python ,power bi project
Dear sir same question in my mind, what is the role of python in data analyst. Bcoz powerbi already have power query editor to cleaning data then role of python plz guide us
@@shahnawazatharkazmi2826 here data we get clear format but most of time data we get in multiple sources in different format their python is used in which numpy and pandas library are useful
I think so 🤔
@@shahnawazatharkazmi2826 AA vP by by by by by by by Dr ko CT CT CT
@@shahnawazatharkazmi2826first of all python had less role in data analysis its more towards data science and data engineering
Thank you for this video, you took your time and effort into putting this video together - step by step - so that we all could follow along. The quality of this content is something that I and probably many others would pay a considerable amount of money to be able to benefit from, and yet you did it for free! Thanks again!
One of the best TH-cam channel for all Aspiring Data Analyst 😊
I'm amazed by how proficiently you demonstrated the use of both SQL and Power BI in a single project (start to finish).Your approach makes it easy to comprehend and practicalise, yet simple to follow, even for an average user. I am happy to have encountered your work. Thank you for sharing your expertise!
Thabks
Absolutely amazing video, I have finally realised that as a beginner in the financial investment market, you can achieve close to nothing yourself because you still have a lot to learn. Trading with a professional broker is more profitable and my advice for beginners is to always take advantage of that.
Instead of timing the market, you should try to diversify your portfolio in order to get a dollar-cost average when it’s time to retire. Keep in mind that you don't need a ton of money to invest. Investing in small amounts can build long-term wealth too!
I'm an amateur making terrible picks and I really need assistance.
Trading is Profitable with the help of a seasoned broker managing your trading account.
@@stellamoore720 'BRIDGET MARY TUROW"".
@@raymondbarnes5264 How can i reach her?.
I know I am seeing your video late but wanted to thank you so much for taking all the time it took to make this video for everyone and walk step by step through your process. So very kind of you to help those of us trying to master the whole PBI project/process.
Incredibly insightful video on TH-cam of end to end project of Data analysis.
I'm really grateful for the immense knowledge I've gathered from you. Within 2 months I've designed 3 completely interactive dashboard with you. . 2:
Please, try and always include data dictionary of each dataset for those of us that are documenting. I've documented the Ecommerce, HR and working on this pixza dataset.
Thanks once again
Thanks, I have just completed your full tutorials. leaned a lot from your tutorials. Please give us more Power Bi and SQL Related Projects
Best project available on TH-cam thank you so much sir
Thank you so much Sir , I have done several dashboard by watching others tutorial. I personally felt this is the best .
That too for free . I have learnt so many things.
Glad it helped
Definitely I have learnt a lot from this end to end project , plss make a real time project more and more atleast two in a month
This project walkthrough has been very helpful. Thank you sir!
The way you explained the concepts from begining to end, made it really easy for us to understand it. Thank you so much for sharing your knowledge and the effort that you put in is commendable.
THE BEST YT CHANNEL FOR PROJECTS
Thank you so much! Your explanation is clear and easy to understand. Anyone looking to learn Power BI from beginner to end, this is the best practice. Thanks again!!
Beautifully explained each and every concept
in the comfortable way the lesson is prepared, really helpful.
Glad it helped you ✨
I want to express my heartfelt gratitude for your dedication to sharing knowledge. It's evident that you have invested a lot of time and effort into creating this tutorial, and it has undoubtedly made a significant impact on my learning journey. Thanks to you, I now feel empowered to tackle SQL and Power BI projects confidently.
Best Video for PBI! Great work
I want to appreciate you for the time spent and dedication to this work to instill the basic requirements and the needful things to know as a data analyst. I would love you to make a video on how to display our dashboard on our web page, Please.
i wish i could like this a thousand times. great work.
Wow, thank you!
Really your Dashboard is so impressive, always try to learn lots of things on Power BI dashboard creating.
You are a pro in terms of explaining and providing valuable content to us. I have learned many new and important steps help me to groom myself more widely. Thank you so much for the help.
Glad it was helpful 💐
Just wanted to take a minute to say a huge THANK YOU for all the amazing content you create! Your videos have been so helpful in my learning journey, and I'm seriously grateful for your willingness to share your knowledge with the world.
sir u r the greatest of all the teacher an step by step process.... Respect Respect and Respect
Your dedication to sharing expertise is commendable, and your video significantly contributed to my learning journey in BI. Thank you for your valuable contribution; I look forward to exploring more of your content.
Very good explanations and thanks you man for share your knowledge to us without any expectations ❤❤❤❤❤
I want to express my heartfelt gratitude for your dedication to sharing knowledge..thanku somuch
You’re such a good teacher
The best video i haev found to learn power BI and SQL , Thanks for the time and effort U have invested in this project
Thankyou for this video, learnt many new things from just 1 video.👍🏻
Wow what a video….You really cover most of my doubts….thank you so much for making this video
This is ground breaking, thanks for the dedication 🎉🎉
Always!
This was easy to follow and amazing video on power BI and SQL. Thank you and I learned various functions through this. Thank you again!
thank you....best content ever i watched...waiting for SQL tutorial
A great learning and beautiful visualization. Thanks !
Small suggestion to always create a date & time table and link it to the main table. this will reduce the complexity in main table and would query the results faster.
Thank you so much for teaching us how to do this project. The dashboard is beautiful!
Thank you somuch brother , I have done several dashboard by watching others tutorial. I personally felt this is the best .
That too for free . I have learnt somany things.
This is the first vedio I watched . As you said " I liked , subscribed and commenting ❤👏
You are most welcome
Thank you
I have learned many things from this video. Thank you for sharing.
First of all Thanks a lot because your teaching way incredible. I have never seen and watched like this video before. I really appreciate you to do this work, Definitely you are the wonderful personality as we as wonderful human being, I pay to god gives you happiness and prosperity Thanks a trillion again.
bro have you downloaded SQL server managment Studio ?
@@karthikvijay5626
Yeah Sir
@@thakurarvindrasingh7093 brother could you help me to download ms SQL server & sql server management studio
Great tutorial, I have a lot of queries in power bi but after watching this tutorial I cleared those. Thank you so much.
Glad it helped
Beautifully explained each and every concept. As I am new to power BI ,it is so helpful for me to understand the end to end process. Great work 👍
Really wanna thank you to explain everything bit by bit ,it was so so helpful.Loved the video and I learned a lot through this video.
I have watched full video with patience. It helped me learn some new tricks that can boost my working capacity with data.
Thank you so much.
Thank you so much! Your explanation is crispy and clear. Best for anyone looking to learn Power BI from beginner to end. Thanks again!!
Glad it was helpful!
you make it so simple ..... thankyou for making these kind of videos ..........to the point videos .....very systematic.😇
Thank you for this amazing portfolio project which will be truly helpful for mine data analyst journey. I just completed this amazing video, and I must appreciate your time & efforts behind such a great work which shows the real industry experience behind it. Glad to subscribe your channel. Much Appreciated!
I truly appreciate your efforts, thank you for the clear and straightforward explanation. I comprehended everything in the video, and you've contributed to enhancing my skills.
Amazing Amazing this is one the best well walked through project from start to end i have learned a lot keep up the good job!!
Great to hear!
Amazing Video, your explanation is amazing. Thanks for making this project.
Excellent Information. Very well explained.
Wow, this video is fantastic, good presentation and very explicit. Thank you
Glad it was helpful!
Thanks for uploading this project. I learned a lot
Many thanks so much for you time🧑🏫🧑🏫🧑🏫🧑🏫🧑🏫
Very systematic explanation and easily understandable content. Thanks for such a knowledgable video.
Just awesome Thank you so much sir.
Best video ever!!!!!! I have learned these two program but I didn't know how to start a project it took 3 hours from me but I really benefited and I will watch your other videos thank you very very much for this work! everything is perfect and clear even that the Word file thank you again. I just hope that you will make a video on how I can determine the KPI so that I can work with dataset and know how to clean it because it was really easy for SQL and visualization when you explained that, and no one has clarified this point. I was always asking how I can find out that columns I need in order to implement the queries.
Thak you bro make this wonderful video please do this like video more 🙏🙏🙏
Excellent explanation,bole toh maaza aagya ❤❤❤❤
This is really great and easy to follow. I created the same report and have posted it on my linkedin profile as well. Thank you
Boss genuinely acha content banate ho AAP ❤❤
THANK YOU VERY MUCH for describing it so clearly
Very good explanation for beginners, thank you so much neat explanation 👏👏
Thank you so much for very clean and easy way you explain all from beginning.
I'm out of words sir....it does look like some real project now❤....the feeling after watching the whole video of more than 2.5 hrs is really good....thank you for this sir🎉❤
Thankyou soo much sir. Thankyou for helping us build this amazing Dashboard
Glad you liked it
Great work thanks for shearing the knowledge
this is content really helpfull for me as beginner which who want learn Data Analyst process..
i hope u cant keep update about simillar things coz i will follow ur update for further
👍🙏
I will try my best, thank you
Wow, thank you so much for this incredible Power BI tutorial! 🙌 Your explanations are clear, and your step-by-step approach made it so easy for someone like me, who's relatively new to Power BI, to follow along.
I've been struggling with some aspects of data visualization, and your video not only clarified those concepts but also gave me the confidence to dive deeper into Power BI. Your dedication to helping others learn is truly admirable.
I can see the effort and time you've put into creating this tutorial, and it's greatly appreciated. Please keep up the fantastic work! Looking forward to more of your tutorials. 💪
Many Thanks for such a detailed video
Glad it was helpful !
Thank you Data Tutorials it is really helpful and awesome
!!!
God bless you friend. Knowledge is Power
It is really an excellent tutorial in an easy way, which is very helpful for beginners
Thank you so much sir for this project❤
Thank You So much. Learning a lot from you
Glad to hear that!
Underated Channel. Thanks
I did learn SQL a few days ago but could not find any useful SQL project and luckily ur this project came in front of my eyes. The SQL queries u performed were a mix of beginner and intermediate difficulty and ur power BI skills are really phenomenal. I learnt a lot. Thank you and God Bless!
Which SQL software do you use for this application ? Which do u recommend to download?
Thank you for sharing your knowledge. I understand you have connected the SQL server to Power BI but you didn't use the queries that you created. I see you have used only DAX functions in your visual then what's the purpose of creating queries in SQL. I just wanted to learn! But very informative session
Great work. A slight mistake I noticed was how for the 2nd page, in the worst sellers section, its suppots to written that the Brie Carre Pizza contributes to the minimum Total Orders instead of the "maximum".
Finished! Thanks for your wonderful project. Keep it up.
Thank you for posting the video. This helped me to enhance my knowledge for data analysis
Clear explanation valuable video
Thanks so much. I have learned a lot from this project
"Fantastic content! Thanks for sharing this insightful video!"
Awesome ... Very Awesome.. Love from Pakistan .....
Excellent videos..Quality content.
Much appreciated!
did you do the project?
Wow, it's really good. It's very attractive and the AD is very interesting
Thanks a lot, it was my first project and learned lot from your video. thanks !
Thnks for all the projects video ..very well explained!!!!🙏
just incredible 👏👏
thank you so much God bless you amazing
Awesome video... thank you so much for sharing your knowledge
Thank you sharing
Thanks for watching!
RESPECT SIR.
I replicated this in addition to pandas and SQL project for a Data Analyst role.
I jet the job, I’ll dedicated it to you.
Did you get the job?🤗🤗🤗🎉🎉🎉🎉
I have no words to say after seeing this dashboard which gives me an accurate knowledge of how to use MySQL and PowerBI together. I watched your video from beginning and learn lot of things like what is MySQL server management studio and how to connect it with PowerBI. I also learn some new DAX Queries with the help of this dataset and I also created this dashboard through your guidance and lot of support. Thanks for this video and keep it up.
This was great, thank you!
One thing I did notice when adding an additional column for the day of the week (on Building the Monthly and Daily trends) is that the data on the excel sheet has a large amount of dates not formatted correctly, or different, and it shows as blank when transforming the data. When making a bar chart with this data, it shows around 29k blank spots for the day.
Hii I'm having this same problem
Did you manage to solve it?
same problem, did you solve it?
Thank you so much for your incredible work here. It was really amazing.
Thank you...
Excellent project