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'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!
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.
Hey, can you please tell me if interviewer asked question that, what the actual use of SQL in this project, then what should be the expected answer can i give, please let me know, I`m confused in this?
@@Kishormurade02 SQL databases are more suited for handling large volumes of data with complex querying, transformation, and real-time access capabilities, while Excel sheets are useful for smaller datasets, manual analysis, and simpler reporting tasks. The choice between the two depends on the specific requirements of the BI project, including data volume, complexity, collaboration needs, and the desired level of automation and performance.
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!
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 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 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.
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.
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 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!
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 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.
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.
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!!
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 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 ❤👏
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.
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 👍🙏
Hi, thank you for the tutorials. This is my 2nd I am replicating from your channel as practice for interview. I am using mysql as I could not set up the server process for sql mgmt studio. In mysql many functions are either changed or not functioning so i got stuck at DATENAME query at 46:30. Solved this step today with DAYNAME, str_to_date and coalesce, as the order_date column was imported as text by default and the date data is formatted in 2 different ways: d/m/y and d-m-y. if someone is interested, this is the query: SELECT DAYNAME(coalesce( str_to_date(order_date, '%d-%m-%Y'), str_to_date(order_date, '%d/%m/%Y')) ) as Order_day, COUNT(DISTINCT order_id) AS Total_Orders from pizza_sales GROUP BY Order_day ORDER BY Total_Orders DESC
thank u so much for ur comment...i have literally been struggling to resolve this issue and tried every possible way to fix it but failed but the code u provided worked perfectly....can u help me with one more thing that if he is using dax functions whts the use of SQL queries.
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. 💪
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 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.
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.
Excellent Job, thank you very much for this clear Demo! It would be great if we could have same for Tableau and QLIK. Many thanks for your work sharing.
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🎉❤
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.
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".
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
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
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 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!
I am watching this "particular" video on 1.5x speed and most of the time i can listen is "particular" thing... 😅 Jokes apart.. video is structured well with good understanding
Hi Buddy. Better to create date master when dataset contain date field to achieve better response while playing with insights and slicing the data.. I appreciate your hard work toward sharing knowledge to audience . I have learn lot of new thing from this video and going forward expecting master piece tutorial from your channel buddy...
Sir,the videos are providing wonderful knowlegde. Can you please make more vidoes on Tableau dashbaoards as well.Thank you for providing the information.
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
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
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.
Hey, can you please tell me if interviewer asked question that, what the actual use of SQL in this project, then what should be the expected answer can i give, please let me know, I`m confused in this?
Absolutely right 😊
@@Kishormurade02 SQL databases are more suited for handling large volumes of data with complex querying, transformation, and real-time access capabilities, while Excel sheets are useful for smaller datasets, manual analysis, and simpler reporting tasks. The choice between the two depends on the specific requirements of the BI project, including data volume, complexity, collaboration needs, and the desired level of automation and performance.
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?.
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 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
One of the best RUclips channel for all Aspiring Data Analyst 😊
One of the best project for power bi available on youtube
Glad you think so!
Thanks, I have just completed your full tutorials. leaned a lot from your tutorials. Please give us more Power Bi and SQL Related Projects
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.
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
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.
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 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!
This project walkthrough has been very helpful. Thank you sir!
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 💐
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 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
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 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.
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!
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!!
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
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
in the comfortable way the lesson is prepared, really helpful.
Glad it helped you ✨
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 👍
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.
Thankyou for this video, learnt many new things from just 1 video.👍🏻
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
Just awesome Thank you so much 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
👍🙏
I will try my best, thank you
Wow what a video….You really cover most of my doubts….thank you so much for making this video
Wow, this video is fantastic, good presentation and very explicit. Thank you
Glad it was helpful!
Really your Dashboard is so impressive, always try to learn lots of things on Power BI dashboard creating.
Hi, thank you for the tutorials. This is my 2nd I am replicating from your channel as practice for interview. I am using mysql as I could not set up the server process for sql mgmt studio. In mysql many functions are either changed or not functioning so i got stuck at DATENAME query at 46:30. Solved this step today with DAYNAME, str_to_date and coalesce, as the order_date column was imported as text by default and the date data is formatted in 2 different ways: d/m/y and d-m-y.
if someone is interested, this is the query:
SELECT DAYNAME(coalesce(
str_to_date(order_date, '%d-%m-%Y'),
str_to_date(order_date, '%d/%m/%Y'))
) as Order_day,
COUNT(DISTINCT order_id) AS Total_Orders from pizza_sales
GROUP BY Order_day
ORDER BY Total_Orders DESC
thank u so much for ur comment...i have literally been struggling to resolve this issue and tried every possible way to fix it but failed but the code u provided worked perfectly....can u help me with one more thing that if he is using dax functions whts the use of SQL queries.
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, 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 wish i could like this a thousand times. great work.
Wow, thank you!
Thak you bro make this wonderful video please do this like video more 🙏🙏🙏
The best video i haev found to learn power BI and SQL , Thanks for the time and effort U have invested in this project
I want to express my heartfelt gratitude for your dedication to sharing knowledge..thanku somuch
Thank you so much for teaching us how to do this project. The dashboard is beautiful!
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!
Thanks for uploading this project. I learned a lot
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 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.
Thankyou soo much sir. Thankyou for helping us build this amazing Dashboard
Glad you liked it
Many thanks so much for you time🧑🏫🧑🏫🧑🏫🧑🏫🧑🏫
Very systematic explanation and easily understandable content. Thanks for such a knowledgable video.
thank you....best content ever i watched...waiting for SQL tutorial
Beautifully explained each and every concept
Wow, it's really good. It's very attractive and the AD is very interesting
I have learned many things from this video. Thank you for sharing.
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?
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.
Excellent Job, thank you very much for this clear Demo! It would be great if we could have same for Tableau and QLIK. Many thanks for your work sharing.
Glad it was helpful!
This is ground breaking, thanks for the dedication 🎉🎉
Always!
sir u r the greatest of all the teacher an step by step process.... Respect Respect and Respect
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
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.
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🎉❤
Ohh men Don't know how many times you use particular word 😂😂 but very well explained hats off to yoo
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.
Thank you so 'Data Tutorials' for this video. I have learnt a lot from this video and have subscribed. I am definitely adding this to my resume.
Glad it was helpful!
Thank you so much for your incredible work here. It was really amazing.
Thank you...
Thank you so much for very clean and easy way you explain all from beginning.
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?🤗🤗🤗🎉🎉🎉🎉
Thank you Data Tutorials it is really helpful and awesome
!!!
Thank you for posting the video. This helped me to enhance my knowledge for data analysis
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".
Very good explanation for beginners, thank you so much neat explanation 👏👏
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
Thank you bro for explening each and every single fun how to use in very simple method this session is very useful for me .
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
It is really an excellent tutorial in an easy way, which is very helpful for beginners
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
Many Thanks for such a detailed video
Glad it was helpful !
Thanks a lot, it was my first project and learned lot from your video. thanks !
you make it so simple ..... thankyou for making these kind of videos ..........to the point videos .....very systematic.😇
THANK YOU VERY MUCH for describing it so clearly
Best Video for PBI! Great work
I'm so grateful to you. You've given so much information and explained everything in such detail. I'm definitely subscribed. Much love from Pakistan.
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?
I am watching this "particular" video on 1.5x speed and most of the time i can listen is "particular" thing... 😅
Jokes apart.. video is structured well with good understanding
I will try to work on it, thanks for feedback
You are brilliant. Please let me know how good this field does it has a good future.
Thank you very much sir, it's really good and helpful
Glad to hear that
Boss genuinely acha content banate ho AAP ❤❤
Awesome video... thank you so much for sharing your knowledge
Thnks for all the projects video ..very well explained!!!!🙏
thank you so much for such good projects, really helpful for a fresher, please keep making such projects
Hi Buddy. Better to create date master when dataset contain date field to achieve better response while playing with insights and slicing the data.. I appreciate your hard work toward sharing knowledge to audience . I have learn lot of new thing from this video and going forward expecting master piece tutorial from your channel buddy...
We create if we have to work with time intelligence functions like YTD , MTD etc
@@datatutorials1 Got it . Thank you for wonderful session.
Man, you are awesome.
Excellent Information. Very well explained.
Thank you fro so much detailed work learnd alot of new things
Glad it was helpful!
You’re such a good teacher
Thank You So much. Learning a lot from you
Glad to hear that!
Sir,the videos are providing wonderful knowlegde. Can you please make more vidoes on Tableau dashbaoards as well.Thank you for providing the information.
Congratulations very well organized, clear language! Liked and subscribed!!!👏👏👏👏
Great work thanks for shearing the knowledge