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!
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
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!
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.
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.
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 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.
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.
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.
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.
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.
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 ❤👏
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
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 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.
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".
Thanks But my request is instead of one table use 10 more table so that it is useful. my request is to show dashboard using more table with join option
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.
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!
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.
for those who are using mysql will have problem with datename coz video is on sql server which supports datename but mysql wont so here is the solution SET SQL_SAFE_UPDATES = 0; update pizza_sales set order_date=str_to_date(order_date,"%d-%m-%Y"); alter table pizza_sales modify order_date date select dayname(order_date) as order_day, COUNT(DISTINCT order_id) AS total_orders from pizza_sales GROUP BY dayname(order_date) order by count(distinct order_id)desc
sir wonderful explaination...hand off for your patience and clear explanation of complete report. even a person how is using power BI for the first time can also understand and practice .....I was expecting dynamic text box in the project....like if we select category showing text box with highlights for the selected tenure or category. If possible can you please help us with dynamic text box.
![Visual Calculations in Power BI - DAX Made Easy! [Full Course]](http://i.ytimg.com/vi/JITM2iW2uLQ/mqdefault.jpg)
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 😊
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?.
Incredibly insightful video on TH-cam of end to end project of Data analysis.
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
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
Best project available on TH-cam thank you so much sir
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.
Thanks, I have just completed your full tutorials. leaned a lot from your tutorials. Please give us more Power Bi and SQL Related Projects
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
Beautifully explained each and every concept
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.
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.
Very good explanations and thanks you man for share your knowledge to us without any expectations ❤❤❤❤❤
This project walkthrough has been very helpful. Thank you 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
in the comfortable way the lesson is prepared, really helpful.
Glad it helped you ✨
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 💐
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 wish i could like this a thousand times. great work.
Wow, thank you!
sir u r the greatest of all the teacher an step by step process.... Respect Respect and Respect
THE BEST YT CHANNEL FOR PROJECTS
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
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.
Thank you so much for teaching us how to do this project. The dashboard is beautiful!
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 👍
You’re such a good teacher
I want to express my heartfelt gratitude for your dedication to sharing knowledge..thanku somuch
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
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!
Really your Dashboard is so impressive, always try to learn lots of things on Power BI dashboard creating.
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....best content ever i watched...waiting for SQL tutorial
Very systematic explanation and easily understandable content. Thanks for such a knowledgable video.
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
Thankyou for this video, learnt many new things from just 1 video.👍🏻
The best video i haev found to learn power BI and SQL , Thanks for the time and effort U have invested in this project
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!
This is ground breaking, thanks for the dedication 🎉🎉
Always!
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!
I have learned many things from this video. Thank you for sharing.
Amazing Video, your explanation is amazing. Thanks for making this project.
Wow what a video….You really cover most of my doubts….thank you so much for making this video
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
Wow, this video is fantastic, good presentation and very explicit. Thank you
Glad it was helpful!
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
Clear explanation valuable video
Thank you so much for very clean and easy way you explain all from beginning.
Excellent explanation,bole toh maaza aagya ❤❤❤❤
Thak you bro make this wonderful video please do this like video more 🙏🙏🙏
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
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.
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".
Thanks But my request is instead of one table use 10 more table so that it is useful. my request is to show dashboard using more table with join option
Noted! Will try
you make it so simple ..... thankyou for making these kind of videos ..........to the point videos .....very systematic.😇
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.
Sir pls one project on python so many videos on utube but your explanation is very simple and easy to adopt...
As soon as possible, thanks
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
Very good explanation for beginners, thank you so much neat explanation 👏👏
Excellent Information. Very well explained.
Thank you sharing
Thanks for watching!
Underated Channel. Thanks
Great work thanks for shearing the knowledge
Thanks for uploading this project. I learned a lot
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?
Excellent project
Thankyou soo much sir. Thankyou for helping us build this amazing Dashboard
Glad you liked it
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 VERY MUCH for describing it so clearly
Just awesome Thank you so much sir.
"Fantastic content! Thanks for sharing this insightful video!"
Many thanks so much for you time🧑🏫🧑🏫🧑🏫🧑🏫🧑🏫
It is really an excellent tutorial in an easy way, which is very helpful for beginners
Wow, it's really good. It's very attractive and the AD is very interesting
Many Thanks for such a detailed video
Glad it was helpful !
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!
Very good explanation.
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.
Thnks for all the projects video ..very well explained!!!!🙏
Thanks so much. I have learned a lot from this project
Thank you Data Tutorials it is really helpful and awesome
!!!
just incredible 👏👏
Boss genuinely acha content banate ho AAP ❤❤
Thank you for posting the video. This helped me to enhance my knowledge for data analysis
You are the Best ever!!!
God bless you friend. Knowledge is Power
Thank you so much sir for this project❤
Awesome ... Very Awesome.. Love from Pakistan .....
Finished! Thanks for your wonderful project. Keep it up.
Excellent videos..Quality content.
Much appreciated!
did you do the project?
Thanks a lot, it was my first project and learned lot from your video. thanks !
Thank You So much. Learning a lot from you
Glad to hear that!
for those who are using mysql will have problem with datename coz video is on sql server which supports datename but mysql wont so here is the solution
SET SQL_SAFE_UPDATES = 0;
update pizza_sales
set order_date=str_to_date(order_date,"%d-%m-%Y");
alter table pizza_sales
modify order_date date
select dayname(order_date) as order_day, COUNT(DISTINCT order_id) AS total_orders from pizza_sales
GROUP BY dayname(order_date) order by count(distinct order_id)desc
Awesome video... thank you so much for sharing your knowledge
sir wonderful explaination...hand off for your patience and clear explanation of complete report. even a person how is using power BI for the first time can also understand and practice .....I was expecting dynamic text box in the project....like if we select category showing text box with highlights for the selected tenure or category. If possible can you please help us with dynamic text box.
I will do it in next project
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?🤗🤗🤗🎉🎉🎉🎉