Use Coupon Code "FLAT50" for a discount on the new Power BI Specialization course 🎉 🔻🔻🔻🔻🔻🔻🔻🔻🔻🔻🔻🔻🔻🔻🔻🔻🔻🔻 learn.pavanlalwani.com/courses/Power-BI-2023-63a05686e4b0a7b1ab4dfc8d Download Project Files:shorturl.at/nCKMU
Hai Sir im a big fan of ur work...please guide us in a special video how to handle errors ,blanks , nulls , in date errors and all the three types of relationships of power pivot in different real time senarios we are expecting such more type of videos from u sir thank u 😊
Website course you get certificate, MCQs, assignment, projects, interview questions. A proper learning path majorly. It's new version 2023. RUclips course is 2020 version. Both are good based on choice
Thank you so much sir again for refreshing powerbi concepts in simple language BEFORE your videos: i was scared of powerbi , AFTER watching: its piece of cake.
Sir, you told that the files does not need to have same number of columns. Then if a file1 has 21 columns and file2 has 19 columns then the data would be inconsistent, right?? Pls explain...
Hi sir I need suggestions from your side please tell me what the company's hiring freshers that person only has power bi skills kindly reply back we need ur help
Thank You so much sir for a great explaination . You are a really good teacher . I hope we can see many more videos like this in future also . I have just one query : In powerbi service, when we uplaod map is not showing , I have tick to all the features in powerbi desktop but still it is not showing in powerbi query .. Any suggestions?
Hi sir i have watched this video of end to end project sir can data which is added in excel or another file after loaded in power bi ut can update autmatic when i was trying that i was facing error please help me
No !!! Just watching you will be aware of things Power BI Developer does. You will need to practice those topics, additional projects and case studies.
Hi Pavan Sir, Will it be possible if you list end to end capstone project separately at different rate in your website. bcz rest of the contents we have already done multiple times. one more thing , why there is only one year of access😊
Ajit This is good Idea for seperate project course 1 year access we have done it so that people finish it within time. If time limit not given people don't learn it. I want people to learn and not just pay and be relaxed. We should be on toes. Amount invested should be returned back in 6 months in form of skills and job. We have chat support which can be available for a year.
Hello @PavanLalwani..Your videos are really helpful to me. I just start learning and you are very motivational. Actually I have one question regarding same project. I am trying to replicate but I can't find expand one level down option. So if you get time then please respond .I am using latest version. Thank you .
Having doubt sir..When i combine and transform data and change order date from text data type to date data type the content is getting changed...some dates are changed with years 2028,20131 and so on..How to deal with it? Please help Sir
Hi Sir, Thank you so much for the Video. I've created a dashboard and published it to the Microsoft Power Bi service, when I wanted to schedule it to my colleague, I get the following message Free users or groups can only be subscribed to reports or dashboards backed by Premium capacity. Kindly Advice.
"It's amazing! As rightly said, practice is required to achieve perfection and understand the nuances of creating a dashboard. I absolutely love it. I followed along and spent 3-4 hours creating a beautiful end-to-end sales project."
Hi Pawan Sir, Thanks for your time. Lot of learning. Is there any plan to make videos on SAP BW/BPC as data source and create some Cost center Spending reports and Financial Reports.
is this correct way to remove duplicate as I see duplicate customer name with same order id??? removing duplicate from order id ,isn't it correct?? please correct me 16:24
When we automated the data suppose in new file we are getting duplicates . can we remove duplicates automatically ? Every time we are getting new files
Thankyou for this video it was awsome . Sir I have a question that lastly you have copy pasted one file means there are duplicate data in the report then sir how to automate that thing that if there is any duplicate data then it should get remove
Compared to all your videos, the sound is not as clear in this video. See if you could fix it. I closely pay attention to what you say, as you always make very useful and knowledge based videos.
Hello Sir, which one external tool are you using to quick access data level etc from charts directly, I think this feature is not available in Power BI, It was in Excel only.
anyone can guide me please, 1: can we use the personal mail id for power bi . 2: if yes then can we publish on like novy pro? 3: If i used trial version of professional account and publish the report that i wanna show in my cv but if trail free version of Microsoft account expire than that published project can't show?
Hi, Please do more and more practice, complete some projects, solve Power BI assignments, and then update your profile. side by side attain interview. Thanks,
Hi Pavan, First of all really appreciate your hard efforts which u r putting to share knowledge with all of us..I have a question while combine file with folder... Can we do combine all the files if we have seperate files like csv, xls, pdf & so on in single folder only with this way...pls guide
In reality this is a end to end project in youtube...... ❤❤❤ Really great work..... Can you make 10 min video about searching job or other way of freelance work..... All skills like sql, python topic... Can learn power apps.
Hi Sir, Great job👏 Can you help us to how can we prepared current month same day sales number compare to previous month same day and last year same day number. I prepared this report in excel it take more time every day.
Thank you sir for making a great end to end project video with easy explanation. I am now Fan of your teaching, you made me feel that Power BI is not hard. I got it that gandhi ji too😂😂
Thanks a lot sir I learn lots of thing. Sir can you explain why SQL is mandatory with Power BI ? Most of videos I seen you explain Power BI with excel. I want to learn also with SQL.
Having doubt sir..When i combine and transform data and change order date from text data type to date data type the content is getting changed...some dates are changed with years 2028,20131 and so on..How to deal with it? Please help Sir
If we have different file formation I.e. excel, csv, pdf etc. in a single folder like , can we combine all fomat in power bi or we need to create separate folder for that?
Sir, in your previous power bi project, we automated using power bi. But I have a doubt, sir. The Excel data which we receive via email is clean data or uncleaned data ?? If the data is cleaned, then it's OK, but what if the data is uncleaned ? Will power Bi automatically clean the data or data which we receive via email is already data ?
100% Yes It can clean data and combine files coming from email 100% Possible I didn't take it purposely else audience would be finding the project difficult
Hello Sir, Just had a look at the end-to-end project demo, I have a doubt about the subscription part, in the start date and end date sections we have to put the dates between which we want to know the updates, it's like if we want updates from say Jan 2023 to June 2023, so in between these dates we can schedule updates on the report? Am I right?
Sir, We had used ' remove duplicates feature' in the power query. Now, when you added a copy of that Excel life...the power query added some rows which shouldn't be done coz they will be duplicates right ? Kindly solve my query
I am huge fan of you... I completed your 8 hours power bi course... You explained very easy .. Sir in this project 2 audio quality not good ..its like double voice come .. I hope sir next coming you improve audio... Your are my ideal sir .... Thank you ✨✨
@Pavan Lalwani Hello Pavan sir .. Sir humble request to you kindly make a video of adventure work dashboard only you can teach better way.Thank you ...
@@PavanLalwani first of thanks for this efforts. sorry I don't have dataset however, Apart from sales there are domains like insurance, customer care, banking etc. If you can provide some dashboard on this then wil be good for beginners how we can work on other domain metrics. I will provide once I found any dataset. Thanks again.
Use Coupon Code "FLAT50" for a discount on the new Power BI Specialization course 🎉
🔻🔻🔻🔻🔻🔻🔻🔻🔻🔻🔻🔻🔻🔻🔻🔻🔻🔻
learn.pavanlalwani.com/courses/Power-BI-2023-63a05686e4b0a7b1ab4dfc8d
Download Project Files:shorturl.at/nCKMU
Hai Sir im a big fan of ur work...please guide us in a special video how to handle errors ,blanks , nulls , in date errors and all the three types of relationships of power pivot in different real time senarios we are expecting such more type of videos from u sir thank u 😊
Hi Sir,
Actually I have created a stacked bar chart but horizontal gridlines are not off when I have disable the button so what can I do
Pls uploaded microstrategy videos sir
Can you please tell me what is the difference between your free youtube power BI course and paid course?
Website course you get certificate, MCQs, assignment, projects, interview questions. A proper learning path majorly.
It's new version 2023.
RUclips course is 2020 version.
Both are good based on choice
@@PavanLalwani in your paid course, did you provide advanced level end to end dashboard developmnt?
Thank u Sir for providing this Video, I have seen this video and made the same Dashboard in Power BI and posted it on Linkedin. 😇
Thank you so much sir again for refreshing powerbi concepts in simple language
BEFORE your videos: i was scared of powerbi ,
AFTER watching: its piece of cake.
Sir, you told that the files does not need to have same number of columns. Then if a file1 has 21 columns and file2 has 19 columns then the data would be inconsistent, right?? Pls explain...
Hi sir I need suggestions from your side please tell me what the company's hiring freshers that person only has power bi skills kindly reply back we need ur help
Excel
Word
PowerPoint
Power BI
Basics of SQL
Mandatory
Communication skills
Problem solving attitude
If you have this you are ahead of many people
Sound quality is bad, it is echoing.
Dear Sir, A great Video and highly informative about Powerbi Report or Dash board. Thank you Very much for this video
Thank you Pawan Sir I created the Sales Report inspired from you....
That really helped me in boosting my Confidence.
Great !!
sir please can you get a new microphone. cause your voice in ecoing
Noted.
I tried to update my Power bi version. I want a version like you, How to get this. Please guide me
So, Rahul Gandhi was indeed right, but only if he knows how to use Power BI.
Let me know how to update power bi from May 24 to July 24 versions
Thank You so much sir for a great explaination . You are a really good teacher . I hope we can see many more videos like this in future also . I have just one query : In powerbi service, when we uplaod map is not showing , I have tick to all the features in powerbi desktop but still it is not showing in powerbi query .. Any suggestions?
High quality content! Thanks Pawan Sir. ❤
rahul Gandhi Meme "Yaha se Aloo Dalo waha se Sona Nikalo " most funniest things
pawan what about datamodelling and relationship in this date shall we publish this report in to service without relationship?
Hi sir i have watched this video of end to end project sir can data which is added in excel or another file after loaded in power bi ut can update autmatic when i was trying that i was facing error please help me
sir i done this project by seeing your explanation but i am not getting what description exactly need to add in my resume. Please help me sir.
When I click on Combine & Load, it's giving same tab again and again
Sir voice is irritating to listen please improve it in anyway if possible
Thankyou thankyou thankyou thankyou thankyou thankyou so much sir.....your video is very helpfull...
Welcome Anusha
Wish you all the best
Sir If I will watch your all power bi videos then I become power bi developer?
No !!!
Just watching you will be aware of things Power BI Developer does.
You will need to practice those topics, additional projects and case studies.
@@PavanLalwani can you make a video on this topic like case studies practices etc
@@PavanLalwani by the way is efficient your video to learn power bi?
You have to search it's already there on pavanlalwani.com
Where did you get all those data sir. Please tell
Please improve audio quality
amazing session sir, this free resourse goona help a lot sir, once angain thank you so much
Hi Pavan Sir, Will it be possible if you list end to end capstone project separately at different rate in your website. bcz rest of the contents we have already done multiple times. one more thing , why there is only one year of access😊
Ajit
This is good Idea for seperate project course
1 year access we have done it so that people finish it within time. If time limit not given people don't learn it.
I want people to learn and not just pay and be relaxed. We should be on toes.
Amount invested should be returned back in 6 months in form of skills and job.
We have chat support which can be available for a year.
Hello @PavanLalwani..Your videos are really helpful to me. I just start learning and you are very motivational. Actually I have one question regarding same project. I am trying to replicate but I can't find expand one level down option. So if you get time then please respond .I am using latest version.
Thank you .
Thankyou thankyou thankyou thankyou thankyou thankyou so much sir.....your video is very helpfull...
Sound quality is very poor
Having doubt sir..When i combine and transform data and change order date from text data type to date data type the content is getting changed...some dates are changed with years 2028,20131 and so on..How to deal with it? Please help Sir
Thanks a lot for making Power BI easy, sir!
You are welcome !!
Hi Sir, Thank you so much for the Video. I've created a dashboard and published it to the Microsoft Power Bi service, when I wanted to schedule it to my colleague, I get the following message Free users or groups can only be subscribed to reports or dashboards backed by Premium capacity. Kindly Advice.
thank you soooo much for wonderful experience
Hey, Pawan I've imported your Theme but I'm unable to get the actual one as shown in your videos.
Thank you for this video.
A friendly suggestion- Please look into the audio quality of this video, it's humming.
sir iam getting error values in date columns while loading data which has values like 16-08-19
"It's amazing! As rightly said, practice is required to achieve perfection and understand the nuances of creating a dashboard. I absolutely love it. I followed along and spent 3-4 hours creating a beautiful end-to-end sales project."
Hi Pawan Sir, Thanks for your time. Lot of learning. Is there any plan to make videos on SAP BW/BPC as data source and create some Cost center Spending reports and Financial Reports.
is this correct way to remove duplicate as I see duplicate customer name with same order id???
removing duplicate from order id ,isn't it correct??
please correct me
16:24
When we automated the data suppose in new file we are getting duplicates . can we remove duplicates automatically ? Every time we are getting new files
sir your voice is not clear
@PawanLalwani, sir the audio quality could have been better.
Sir is there any difference in both project end to end in this Playlist that video lengths is 44 mints only
Thankyou for this video it was awsome .
Sir I have a question that lastly you have copy pasted one file means there are duplicate data in the report then sir how to automate that thing that if there is any duplicate data then it should get remove
Compared to all your videos, the sound is not as clear in this video. See if you could fix it. I closely pay attention to what you say, as you always make very useful and knowledge based videos.
Hello Sir, which one external tool are you using to quick access data level etc from charts directly, I think this feature is not available in Power BI, It was in Excel only.
he clearly says that the dashboard design doesn't matter, the work that you did in the backend matters!
It was good explanation and now it will be easy for me. thankyou sir
anyone can guide me please, 1: can we use the personal mail id for power bi .
2: if yes then can we publish on like novy pro?
3: If i used trial version of professional account and publish the report that i wanna show in my cv but if trail free version of Microsoft account expire than that published project can't show?
I can arrange for you the college email id for permanent but it will be paid single time only for life time
@@ArvindSingh-wp8hw price?
What is the PBIX file average size in real time project ?
Hi I need to know how can I put district wise map of India in power bi .?
Sir if Mai apki sari power Bi videos dekh leta hu toh ma power bi developer ban jauga?
Hi,
Please do more and more practice, complete some projects, solve Power BI assignments, and then update your profile. side by side attain interview.
Thanks,
The data is missing and any data related issues how can we debug sir
Hi Pavan, First of all really appreciate your hard efforts which u r putting to share knowledge with all of us..I have a question while combine file with folder...
Can we do combine all the files if we have seperate files like csv, xls, pdf & so on in single folder only with this way...pls guide
Please can you make project on adventure work data
sir, project file link is not opening ,pls share the appropriate link
In reality this is a end to end project in youtube...... ❤❤❤ Really great work.....
Can you make 10 min video about searching job or other way of freelance work..... All skills like sql, python topic...
Can learn power apps.
Thank you Pradeep
Sure more good content on the way .
SQL by July End
It's in recording phase
Dataset link?
Thank you Sir ❤ you helped me to become a PowerBi specialist
Nice video
Sir, can you make a video on data cleaning in power bi
sir please use a better mike so that your voice will be clear
Hi Sir, Great job👏
Can you help us to how can we prepared current month same day sales number compare to previous month same day and last year same day number.
I prepared this report in excel it take more time every day.
GOOD ONE
Pavan Sir, Thank you for the video. Is it possible to share data for practice
super Mr Pavan good job🥰🥰🥰🥰🥰🥰🥰😘😘😘😘
Sir plz make separate Playlist so it's easy to find project
For a fresher power bi is enough to get job?
Thank you sir for making a great end to end project video with easy explanation. I am now Fan of your teaching, you made me feel that Power BI is not hard.
I got it that gandhi ji too😂😂
Welcome to the Power BI club
All the best
Thanks a lot sir I learn lots of thing. Sir can you explain why SQL is mandatory with Power BI ? Most of videos I seen you explain Power BI with excel. I want to learn also with SQL.
Hi Sir please suggest me can you review power bi resume
Hi Sir..Can we learn and use this project to put on resume?
Yes
Having doubt sir..When i combine and transform data and change order date from text data type to date data type the content is getting changed...some dates are changed with years 2028,20131 and so on..How to deal with it? Please help Sir
If we have different file formation I.e. excel, csv, pdf etc. in a single folder like , can we combine all fomat in power bi or we need to create separate folder for that?
yes you can but make sure all datasets including column names must be same
Thank u for providing such information for free of cost 👏👏👏
Sir, in your previous power bi project, we automated using power bi. But I have a doubt, sir. The Excel data which we receive via email is clean data or uncleaned data ??
If the data is cleaned, then it's OK, but what if the data is uncleaned ? Will power Bi automatically clean the data or data which we receive via email is already data ?
100% Yes
It can clean data and combine files coming from email
100% Possible
I didn't take it purposely else audience would be finding the project difficult
Good job sir and you may add some slicer
Hello Sir, Just had a look at the end-to-end project demo, I have a doubt about the subscription part, in the start date and end date sections we have to put the dates between which we want to know the updates, it's like if we want updates from say Jan 2023 to June 2023, so in between these dates we can schedule updates on the report? Am I right?
Not really
Sir, We had used ' remove duplicates feature' in the power query. Now, when you added a copy of that Excel life...the power query added some rows which shouldn't be done coz they will be duplicates right ? Kindly solve my query
I did not select all the columns to remove duplicate
So technically duplicate rows is not applicable here
@@PavanLalwani Got it sir, Thanks a lot!
I am huge fan of you...
I completed your 8 hours power bi course...
You explained very easy ..
Sir in this project 2 audio quality not good ..its like double voice come ..
I hope sir next coming you improve audio...
Your are my ideal sir ....
Thank you ✨✨
Kindly share link
@@iqrakanwal2679 ruclips.net/video/UXhGRVTndQA/видео.html
Can i do this project later on?
Thanks a lot for making Power BI easy, sir.
Thank you so much sir for leaveraging our knowledge
You are welcome !!
@Pavan Lalwani Hello Pavan sir ..
Sir humble request to you kindly make a video of adventure work dashboard only you can teach better way.Thank you ...
Ok Sure !!
@@PavanLalwani Thank a lot sir
@@PavanLalwani Good morning sir ....Still I'm waiting
Thank you so much, sir!
@PavanLalwani
Sir, can you please share the link or source of the data so that we can practice it on our own too.
Sure in sometime
You are very good teacher
Waoo sir its really great work 💯👌
Thank you soo much for explaining each step
You are welcome !!
I want to learn power bi ,
And how it's possible because I am non IT background
ruclips.net/video/SFZx2eru4ew/видео.html
Just have faith, brick by brick
Sir request you to please don't come up with sales dashboards again..
This is a very common power bi dashboard on RUclips..
Perfectionist
Suggest some names which are not common
Share me the dataset as well
@@PavanLalwani first of thanks for this efforts.
sorry I don't have dataset however,
Apart from sales there are domains like insurance, customer care, banking etc.
If you can provide some dashboard on this then wil be good for beginners how we can work on other domain metrics.
I will provide once I found any dataset.
Thanks again.
No problem
Will try for it
@@PavanLalwani Thank you for consideration
For a fresher power bi is enough to get job
Excel and SQL knowledge is required
@@PavanLalwani nhi sir SQL mt btao please python keh do please 🙏😅
Bina python chal raha hai kaam corporates mai filaal .. good to have skills
Very Nice. you taught me lot. Thank you
You are welcome !!
Please share the data sir.
Kindly take super messy data to clean
Share me your messy data link in Google drive
Next Project will come on that
@@PavanLalwani phat a head shot 😂
sir voice is not clear please resolve this issues
Manage karlo isbaar. 2 more videos with similar voice
..karpaoge ?
Next video will have a good voice
Awesome sir
thank you sir so much for all your support
You are welcome !!