Hi All, Just pinning this comment since lot of you have commented that you are facing issues while changing the data type of Archive_Date column. I have created a detailed video on how to solve this issue (Link Below). Hope this helps! Thanks for watching! ua-cam.com/video/quEN7orGuSA/v-deo.html
Thank You Soo much for sharing the additional video to solve this issue . I want date in MM-DD-YYY format so used below formula to solve this. Date.FromText(Text.Middle([Archive_Date],3,2) & "-" & Text.Start([Archive_Date],2) & "-" & Text.End([Archive_Date],4)))
Thank you very much. I am new to Power BI. This video helped me to build my first Power BI dashboard and I learned tremendous information in very short time. Thank you for your effort to create this wonderful video. I feel very productive, and my time is well spent.
This is great, you have given me a pathway to Power BI. It was a walk-through process, i will be pleased to join your class if available at any time, however be informed that am a newbie on this and ready to learn through
I would like to mention that I've gone through many videos demonstrating end to end projects creation in power bi but your content outshines them. The reason is simple, unlike others who simply load the data and create the visual, you have tried to give a realistic touch as what is mostly expected in real projects. Dynamic titles, placing measures in separate table, various transformations on the data and many other important concepts used in a subtle manner..all within a single hour tutorial ..and this is what I personally liked the most. I have used both the dashboards to put in my resume which you have shown in your channel. Keep adding more informative content for us. A heartfelt thanks to you from an aspiring data analyst.
amazing literally you are so good with your language tone explanation, i created whole project exactly side by side, great learning, please we want more videos
This is the best video on power bi video ever came across in UA-cam which is much more informative and under stable for beginners. Much appreciate work and kudos to pivotalstat👏
Excellent video! Opened my eyes to many new BI possibilities and provided a very valuable solution to a problem that I have been trying to solve for over a month. Thank you!
Thank you so much for the detailed Dashboard creation. I have followed the steps and created my first Power BI dashboard. Just a little bit I messed up with specialty names but rest is fine. Thanks a lot.
Thank you so much ❤ this is exactly what I'm looking for and I followed all the steps and created dashboard I'm proud to say that i have found excellent power bi dashboard on youtube. Your voice and the way you explained it's so clear and easy to understand for beginners. Thank you for doing these videos. 😍 btw this is my first comment on youtube ever till now . Hope to get response 😁
Thank you very much. Your way of teaching is very nice and also the way you have edited the video is quiet good. You gave some very important information through out the video. Subscribed.👍
Thanks so much for this content. I hope there more on to come. You have boosted my self-learning Data science journey . I really appreciate ❤️❤️. Please drop more and details ones as this.
A truly fantastic video presentation. Beautifully designed Dashboard. Excellent use of the DAX formulas to create the visuals. I really liked the way you used PowerPoint to create the background. Great tips on using Adobe. Simple, yet so effective. This is an extremely good presentation for anyone who wants to learn how to create a well-designed Power BI Dashboard. Thanks Sajit.
Great work !! I am new. you try to make understand by giving details multiple example, I liked that. its very much needed for people like me who are new and learning from zero (0). If you can , make it more easy to understand for new student like me please. Thank you so much. Much appreciated. God bless you !
Really great. Many new things I learned from this video. Completely different way of dashboard preparation and DAX functions I learned. Thank you so much for this video and your hard work!
Thank you so much for this informative video! .I really appreciate you taking the time to create this content. It's a great resource for anyone who wants to learn more about PowerBI.
you can show me how to connect share point using power BI and also make some video in power bi service like , datamart, schudle refresh , how to create a mobile app.
I finished it! Created my first power BI and it's amazing. Thank you so much for the step-by-stey process! Although, it needs a work email where I only have a personal email so I can't really my creation unless it's work email?
Glad that you liked it! Yes only work email can be used to publish the dashboard and you will need a paid license to share it with others. You can create a Microsoft Developer Account or Azure Active Directory to create a work email id. Below is a video on how to do the same. Hope this helps! ua-cam.com/video/zYKm8yBewQU/v-deo.html
Hello, I got an error while loading the data visual of PY Latest Month Wait List, from 28:00. The error reads "calculation error in measure "All_data PY Latest wait month list, DAX comparison operations doesnot support comparing values of type text with values of type date. Consider using the Value of Format Function to convert one of the values". Kindly help.
Thanks for the fantastic Power BI project! Your hard work and insights were invaluable. Could you share a Data Analyst project using a cloud platform? Your guidance is much appreciated.
Not sure if you are asking the same, but starting from 58:48 I have explained all steps involved in creating the tooltip. Let me know if you are asking about something else...
lots of things in a short vdo,, at least i watched 2 to 3 times,, especially some new formula, and Adobe colour code, new for me,,, i like this one ... cann't imagine within a hr there is lots of knowledge to collect.......
Really glad that u found it helpful. Check out the DAX masterclass video, which covers lot of essential dax: ua-cam.com/video/4rC9Ow76n0U/v-deo.htmlsi=HoWopwpUxISULtvF
I just loved the video. it is very useful... Your explanation is on point. Request you to create end to end project with a complex database which involves using simple as well as complex DAX queries. Also if you could create projects involving SQL queries as well. Thank you in advance. Waiting for more project videos.
This was one of the best videos I have watched. I followed all of your instructions and have completed my own replication. Thank you for helping me improve my portfolio. I can't wait to watch your next video.
Yes, please if you can use SQL Server(create dataflow) as a source, and more advance will certainly help. This is certainly good and delivered at a good pace. Thank you very much
Hello! I'm having a bit of an issue at 15:36. The append window on my PC is different from yours (probably due to a newer PowerBI version) and I must insert both first, second tables AND join type. Which would be the correct one (full outer join, left join, etc)? And which column should I choose in both inpatient and outpatient tables to realize the JOIN? I cannot proceed with the tutorial since my Data is not identical to yours after this step.
It seems you are selecting Merge instead of Append. Click Append Queries dropdown & then select "Append Queries as New" . This screen will only give you the option of selecting 2 tables. Hope this helps!
Thank you so much for this project.I am happy to announce that I have learnt a lot with this one project. I did have a little snag though,trying to format the tooltip was a bit cumbersome for me.The one in PowerPoint wasn’t aligning well with the one in power bi.Here is what I did…I selected only the tooltip coverage,pasted to ppt and when returning to powerbi bit doesn’t really align well. I wish you had shown us how you did it briefly but anyway,please let me know on how to solve it.Thank you so much!
Glad the content was helpful. I think I covered tooltip briefly in churn analysis project (link below). I will try to cover this in detail in a future video. ua-cam.com/video/QFDslca5AX8/v-deo.htmlsi=lg9j1v9x8cc3bLvg
Hey man, You have a nice content and thanks for the practice data, i have only one complaint that you don't explain the concepts in detail, so just work on it, otherwise it's good.
at 20:01 , cardinality is discussed. I am unable to differentiate the usage of one to many vs many to one, this is something i'm struggling for so long and chatGPT isn't helpful enough. can you point out how choosing either will have a difference in the result.
The way you taught is amazing good because you are explaining each and everything from the grounded level and explain all the basic requirements that we required and what are the outcomes about this projects? Can you Please make some videos of Powerbi projects? thanks you for you effort and time to make this video.👍👍👌👌
Good job. But you should have disable loading of the Inpatient and Outpatient tables from the Power Query editor before loading all_table to the data model.
Hello, I have an error message at your video at 27:36 which says MdxScript(Model) (3,57) - Calculation error: All_Data[Latest Month Wait List] SUM function can use at String values. What gone wrong? Thanks
Check the data type of your "total" column. It seems its stored as a text. You can change it to Number by going to transform data and then change data type option besides the column header.
Hi All,
Just pinning this comment since lot of you have commented that you are facing issues while changing the data type of Archive_Date column. I have created a detailed video on how to solve this issue (Link Below). Hope this helps! Thanks for watching!
ua-cam.com/video/quEN7orGuSA/v-deo.html
Thank you so much👍
Thank You Soo much for sharing the additional video to solve this issue . I want date in MM-DD-YYY format so used below formula to solve this. Date.FromText(Text.Middle([Archive_Date],3,2) & "-" & Text.Start([Archive_Date],2) & "-" & Text.End([Archive_Date],4)))
Sir data modeling ke opor video banaiyna
can i get the link
@@arjuntm9056 Thank you
One of the BEST Power BI Tutorial on internet!
Wow, thanks! 🙂
i confirm that
@@whyNeedAHandle1 indeed
Thank you very much. I am new to Power BI. This video helped me to build my first Power BI dashboard and I learned tremendous information in very short time. Thank you for your effort to create this wonderful video. I feel very productive, and my time is well spent.
Really glad that it was helpful. Check out other Power BI videos on my channel. That will give you a good starting point. All the best!
This is great, you have given me a pathway to Power BI. It was a walk-through process, i will be pleased to join your class if available at any time, however be informed that am a newbie on this and ready to learn through
Wonderful, Thanks for watching!
I would like to mention that I've gone through many videos demonstrating end to end projects creation in power bi but your content outshines them. The reason is simple, unlike others who simply load the data and create the visual, you have tried to give a realistic touch as what is mostly expected in real projects. Dynamic titles, placing measures in separate table, various transformations on the data and many other important concepts used in a subtle manner..all within a single hour tutorial ..and this is what I personally liked the most. I have used both the dashboards to put in my resume which you have shown in your channel. Keep adding more informative content for us. A heartfelt thanks to you from an aspiring data analyst.
Thanks buddy, all the best. cheers!
amazing literally you are so good with your language tone explanation, i created whole project exactly side by side, great learning, please we want more videos
Really glad it was helpful! Sure I will put out more content like this in future. Meanwhile if you want, checkout other Power BI videos on my channel.
Best PowerBI project on youtube. You dive deep into the functionnalities but you manage to explain every step of the way. Thanks a lot
Thanks, glad you liked the content 🙂
Really good job! You walked through that excellently and included a lot of interesting pieces of information. Well done!
Thank you very much!
Excellent!...Very detailed and totally complete for me as beginner.., Thank you very much
Glad it was helpful!
Great job teaching the nuances and not just covering the basics. I learned a lot and it was pretty insightful! earned my follow.
Awesome, thank you!
This is the best video on power bi video ever came across in UA-cam which is much more informative and under stable for beginners. Much appreciate work and kudos to pivotalstat👏
So nice of you, thanks for the appreciation. Cheers!
The video you created is informative and well-done. Thank you for sharing your knowledge and making such a great video.
Thank you so much. Really glad that it helped ! 🙂
Thankyou Sir I learned so much from this video, I watched it twice with many parts viewed multiple times. Your teaching is outstanding its so clear.
Thanks 🙂
I'm a lead data analyst and Just saw this video... It's amazing... Congratulations... And subscribed 😍
Thanks for the sub! :)
Such a well explained video with clear voice and attractive dashboard. Thanks. M gonna share with all my friends.
Thanks a ton
Excellent video! Opened my eyes to many new BI possibilities and provided a very valuable solution to a problem that I have been trying to solve for over a month. Thank you!
Glad it helped!
this is so smooth and informative ,could you please do like 2 more
sure, thanks for watching! :)
Thank you so much for the detailed Dashboard creation. I have followed the steps and created my first Power BI dashboard. Just a little bit I messed up with specialty names but rest is fine. Thanks a lot.
Great to hear!
Thank you so much ❤ this is exactly what I'm looking for and I followed all the steps and created dashboard I'm proud to say that i have found excellent power bi dashboard on youtube. Your voice and the way you explained it's so clear and easy to understand for beginners. Thank you for doing these videos. 😍 btw this is my first comment on youtube ever till now . Hope to get response 😁
Thank you so much for such a nice comment. Really glad that this helped! :)
Thank you very much. Your way of teaching is very nice and also the way you have edited the video is quiet good. You gave some very important information through out the video. Subscribed.👍
Thank you so much 🙂
Thanks so much for this content. I hope there more on to come. You have boosted my self-learning Data science journey . I really appreciate ❤️❤️. Please drop more and details ones as this.
Glad I was helpful. Thanks for watching!
Sure will definitely continue to upload quality content.
@@pivotalstats Thank you sir❤️❤️
brilliant video, I am an intermediate user and the explanations in this video are very clear - excellent teaching , thankyou very much
You're very welcome!
This is priceless. Thanks for sharing and bringing more clarity to Power BI
Glad it was helpful!
Following this tutorial i have learned so many new tricks and tips of power BI, thanks a lot sir
Glad to hear that !
A truly fantastic video presentation. Beautifully designed Dashboard.
Excellent use of the DAX formulas to create the visuals.
I really liked the way you used PowerPoint to create the background. Great tips on using Adobe. Simple, yet so effective.
This is an extremely good presentation for anyone who wants to learn how to create a well-designed Power BI Dashboard.
Thanks Sajit.
You're very welcome! Glad it was helpful :)
What a fantastic and informative video!
Every minute of the video was worth watching. Thank you so much for your efforts! Keep it up!!!
Thank you :)
Thanks!
Thanks for watching, cheers!
Thanks for this nicely explained power bi project. Being a newbie, it helped me a lot.
Glad it helped!
Great and very detailed video. This is supplemental to my current class in data science. Thanks and more power to your channel!
Awesome! Thank you!
Learnt a lot from this project
specially the dynamic use of DAX
thanks a lot
Most welcome!
What in the world! What a video! Thank you for this!!
Glad you enjoyed it!
Great work !! I am new. you try to make understand by giving details multiple example, I liked that. its very much needed for people like me who are new and learning from zero (0). If you can , make it more easy to understand for new student like me please. Thank you so much. Much appreciated. God bless you !
Glad it was helpful! Sure will do..
I usually dont comment on videos, but i couldnt do the same on this one, what a class jesus christ, you're the goat!!
Thank you so much for the appreciation! Made my day :)
Fully agree! Super Sajit
❤ new subscriber brother. Thank you for this free online tutorial. Will watching your other videos in the following days.
Welcome aboard! :)
Really great. Many new things I learned from this video. Completely different way of dashboard preparation and DAX functions I learned. Thank you so much for this video and your hard work!
Thank you so much, really glad it was helpful!
Thank you so much for this informative video! .I really appreciate you taking the time to create this content. It's a great resource for anyone who wants to learn more about PowerBI.
Glad it was helpful!
I wasn't expecting this at the beginning. The tutorial was amazing. Thank you ☺☺
Glad you liked it!
I just love you!! Classic music is life! I can work better, think better, and be grateful for life
Cheers!
Thank you for the detailed video. Keep up the good work.
Thanks, will do! :)
Well Done !!! nice tutorial and thanks for providing the dataset you have used, we can able to follow properly.
Glad it was helpful!
Great job! Really appreciate what you've done here!
Glad you enjoy it! Thanks for watching :)
I really appreciate your work! This tutorial was super helpful, thank you!
Happy to hear that! Thanks for watching:)
its was nice teaching about dashboard , thank you for good teaching.
eager to see more videos.
Glad you liked it
you can show me how to connect share point using power BI and also make some video in power bi service like , datamart, schudle refresh , how to create a mobile app.
This is awesome! Best PowerBI video I've seen!
Thank you so much!
That was amazing! I got a lot of tips for being a newbie. You've got a new sub here. Many thanks.
Welcome!
@@pivotalstatsCould you please Share Mapping_specialty file?
Thankyou for mentioning about changing the datatype/format of the Date.
👍
This video is fantastic. Very informative!
Glad you enjoyed it. Thanks for watching!
Merci!
Thanks for the support, cheers!
Really appreciates your effort and very informative. Thank You
Glad it was helpful!
Thanks! For this tutorial. I Requested to you pls bring more videos like this dashboard.
I will try my best. Meanwhile you can checkout the Churn Analysis project
ua-cam.com/video/QFDslca5AX8/v-deo.htmlsi=rp6CSGlCIG98jCIM
I finished it! Created my first power BI and it's amazing. Thank you so much for the step-by-stey process!
Although, it needs a work email where I only have a personal email so I can't really my creation unless it's work email?
Glad that you liked it!
Yes only work email can be used to publish the dashboard and you will need a paid license to share it with others. You can create a Microsoft Developer Account or Azure Active Directory to create a work email id. Below is a video on how to do the same. Hope this helps!
ua-cam.com/video/zYKm8yBewQU/v-deo.html
can you tell me how to apply archive_date
Hello,
I got an error while loading the data visual of PY Latest Month Wait List, from 28:00. The error reads "calculation error in measure "All_data PY Latest wait month list, DAX comparison operations doesnot support comparing values of type text with values of type date. Consider using the Value of Format Function to convert one of the values". Kindly help.
It seems your archive date column is not in a date format. Check out 10:40 , where I briefly touch this topic.
@@pivotalstats Thank you, i appreciate a lot.
It is very clear, thanks for this great video!
You are welcome!
Thank You So much for your hard work really appreciate you're work ... Thanks
Thanks buddy!
Thanks for the fantastic Power BI project! Your hard work and insights were invaluable. Could you share a Data Analyst project using a cloud platform? Your guidance is much appreciated.
Sure, ill create something soon. Meanwhile you can check out the GCP BigQuery SQL playlist.
1:00:56 where did you get the outpatient tool tip and what all parameters you have added kindly help
Not sure if you are asking the same, but starting from 58:48 I have explained all steps involved in creating the tooltip. Let me know if you are asking about something else...
Thank you so much. Learned a lot from your toturials.
Glad I could help!
Thank you very much for your support and help
Welcome :)
Hi Sir the power bi dashboard is fabulous.....having from scratch scenario in this video...
Thanks :)
Lots of love Big respect Sir , First time feeling time gone worth on Power bi Project
Thank you so much!! Really glad it was helpful :)
lots of things in a short vdo,, at least i watched 2 to 3 times,, especially some new formula, and Adobe colour code, new for me,,, i like this one ... cann't imagine within a hr there is lots of knowledge to collect.......
Really glad that u found it helpful. Check out the DAX masterclass video, which covers lot of essential dax:
ua-cam.com/video/4rC9Ow76n0U/v-deo.htmlsi=HoWopwpUxISULtvF
Thank you sir for your sharing and useful information
Welcome 👍
Wow, Im really impressed with all the intricate details you provided. Good job bro
Glad you enjoyed it. Thanks for watching!
I just loved the video. it is very useful... Your explanation is on point. Request you to create end to end project with a complex database which involves using simple as well as complex DAX queries. Also if you could create projects involving SQL queries as well. Thank you in advance. Waiting for more project videos.
Sure. Thanks for watching!
Thann you sonmuch i did the project and i have added to my portfolio on github and LinkedIn
👍
This was one of the best videos I have watched. I followed all of your instructions and have completed my own replication. Thank you for helping me improve my portfolio. I can't wait to watch your next video.
Glad it helped!
You can watch my latest portfolio project on Churn Analysis.
ua-cam.com/video/QFDslca5AX8/v-deo.html
You shares very useful information.thank you sir.i liked it
Thanks for watching!
Автору большое спасибо. Всё разбирается по шагам.
Glad you liked it 🙂
You literally taught me cool way to make dashboard more appealing.
Happy to help! 🙂
Its highly encouraging for a beginner !
Happy to help :)
Thank you so much sir for your effort and shared knowledge.
You're welcome. Thanks for watching!
Yes, please if you can use SQL Server(create dataflow) as a source, and more advance will certainly help. This is certainly good and delivered at a good pace.
Thank you very much
Sure 👍
Thanks for watching!
This is awesome! Thank you for teaching.
You are welcome. Thanks for watching! :)
Great Effort, Thank you!
You're welcome!
Hello! I'm having a bit of an issue at 15:36. The append window on my PC is different from yours (probably due to a newer PowerBI version) and I must insert both first, second tables AND join type. Which would be the correct one (full outer join, left join, etc)? And which column should I choose in both inpatient and outpatient tables to realize the JOIN? I cannot proceed with the tutorial since my Data is not identical to yours after this step.
It seems you are selecting Merge instead of Append. Click Append Queries dropdown & then select "Append Queries as New" . This screen will only give you the option of selecting 2 tables. Hope this helps!
Big thanks! Learned a lot
Cheers!
Very professional explanation sir, very high quality content available on internet ❤️❤️❤️❤️😍🙌🙏💯
Thanks a ton :)
Thank you so much for this project.I am happy to announce that I have learnt a lot with this one project.
I did have a little snag though,trying to format the tooltip was a bit cumbersome for me.The one in PowerPoint wasn’t aligning well with the one in power bi.Here is what I did…I selected only the tooltip coverage,pasted to ppt and when returning to powerbi bit doesn’t really align well.
I wish you had shown us how you did it briefly but anyway,please let me know on how to solve it.Thank you so much!
Glad the content was helpful. I think I covered tooltip briefly in churn analysis project (link below). I will try to cover this in detail in a future video.
ua-cam.com/video/QFDslca5AX8/v-deo.htmlsi=lg9j1v9x8cc3bLvg
Excellent video. Thank you much. Where have you been all along?
Thank you so much!
Really detailed and easy to follow video. Thank you so much. Please could you do another end to end with data sourced from SQL?
Sure 👍
Hey man, You have a nice content and thanks for the practice data, i have only one complaint that you don't explain the concepts in detail, so just work on it, otherwise it's good.
Thanks for the feedback buddy. noted !
Thank you. This was really helpful.
Glad it was helpful!
at 20:01 , cardinality is discussed. I am unable to differentiate the usage of one to many vs many to one, this is something i'm struggling for so long and chatGPT isn't helpful enough. can you point out how choosing either will have a difference in the result.
You can checkout below video on Data Model. Hope this will resolve your doubts
ua-cam.com/video/KmZipfYy3QQ/v-deo.html
Attractive and convenient way of presentation
Thanks!
thank you for your efforts, this is very helpful
You are welcome!
The way you taught is amazing good because you are explaining each and everything from the grounded level and explain all the basic requirements that we required and what are the outcomes about this projects?
Can you Please make some videos of Powerbi projects?
thanks you for you effort and time to make this video.👍👍👌👌
Really glad that the video was helpful!
Sure I will definitely try to make more Power BI projects in future. Thanks for watching!
you are amazing we need more project plz
thanks, sure :)
Good job. But you should have disable loading of the Inpatient and Outpatient tables from the Power Query editor before loading all_table to the data model.
Thanks!
Yes you are right. Good Suggestion!
Very organized and helpful
Glad you liked it. Thanks for watching!
Please add few more tutorials . it was very helpful
Sure, meanwhile you can check out the churn analysis project
ua-cam.com/video/QFDslca5AX8/v-deo.html
This was very helpful and clear. Can you please make more projects or on Videos explaining (blueprint visualization) ?
Hi, you can checkout the latest Churn Analysis project that I uploaded
ua-cam.com/video/QFDslca5AX8/v-deo.html
Thank you so much for the video. subscribed
Thanks for the sub!
Very informative. Thanks for the sharing 🤝
My pleasure!
This was very helpful...thank you..
You're welcome!
Thank you for sharing this, very informative!
Glad it was helpful!
Hello, I have an error message at your video at 27:36 which says MdxScript(Model) (3,57) - Calculation error: All_Data[Latest Month Wait List] SUM function can use at String values. What gone wrong? Thanks
Check the data type of your "total" column. It seems its stored as a text. You can change it to Number by going to transform data and then change data type option besides the column header.
@@pivotalstats thank you very much, that was the problem :)
Yes please do a SQL project!!! this video has been of great help sir thank you :)
👍
just amazing!! you got new subscriber today
Welcome aboard! :)
Nice.. Keep it up bro. Thank you. Next Subscriber Here.
Thanks for the sub! :)
Great Effort, Thank you!
You're welcome!