This is the first UA-cam comment that I commented today of this year, I rarely do comments on videos which means I'm so picky even though I like the video most, cause i have been learning and applying data science related topics from UA-cam since long time but honestly I find this channel is literally insane, so useful. Its too good Thank You So much Sir
if you have a problem with issue_date here is what I did i opened the format cell custom then type mmm/dd/yyyy then replace - with / then manually switch the 4 bad data cell day and month to month and day hit enter and it will fix it its not that bad because you only need to manually do 4 bad data cell but it there's a better solution tell me because its a pain if you need to do a lot more manual change Edit: the last_credit_pull_date column is worst I don't know the fix unless you do it manually Edit 2: Found a solution first replace the - and / with . then find the position of " . " also find the 2nd position of " . " use Left, Mid, and Right Function to get the day month and year finally use the =Date() Function then its now cleaned and format it as mmm/dd/yyyy if you like
Thank you very much for teaching a very useful data analytics project. Truly appreciate this. I have completed this project using MS Excel only. Hopefully, I will do it again along with SQL as well. For now, can I add the completed project to my LinkedIn profile? Looking forward to a positive response from your end.
According to the statement problem, In loan status grid view, it was also asked about the MTD funded and recieved amount. I think u missed out on adding it to the first dashboard
Sir I'm facing a problem , when I try to copy from pivot table and past all Bar charts in a dashboard but failed. Bar charts are not being pasted. Please any solution?
Hi When I am creating a MTD measure, adding issue_date to rows is giving me a list of date but I am getting the whole list how can it be turned to months format
U can make calendar table when using time intelligence functions like MTD , Calendar table will not have any duplication hence there will be no uncertainty in results. Put date in rows and set hierarchy to month if u want month format
QUICK FIX: Create 'issue_month' column before you start working on your pivot table. Then instead of adding 'issue_date' to the rows, you add 'issue_month'. (the data type of the 'issue_date' is not correct)
what i did is i opened the format cell custom then type mmm/dd/yyyy then replace - with / then manually switch the day and month to month and day hit enter and it will fix it its not that bad because you only need to manually do 4 bad data cell but it there's a better solution tell me because its a pain if you need to do a lot more manual change
hello sir i have faced date formating in row data when i create pivot table MTD also created but issue is when i drag the issu_date formate will be open in dd/mm/yyy like this not open month wise data i request to you sir please solve this problem in short video we are still waiting please solve sir thank you
Either extract month from the date column in data itself, using Text(Cell, “mmmm”). Cell means the cell in which date is present Then use that month in pivot tables
@ Data Tutorials, Hello Swapnajeet, Can i add this project to linked in or Novypro? also tell the steps to upload to novypro, there is no embedd option given in my Excel 2021.
Sir here in Dates Column some dates are in General format and some dates in Dates format at time of extract or some calculation its shown error for those dates which is are in general format,can please tell me how solve this issue
Sir, when creating an MTD measure, adding issue_date to rows gives me a list of dates but I am getting the whole list how can it be turned to month format, (the data file is already converted to Excel from CSV, and the issue_date column data type is set to date short and date long alternatively but no change in the result)
Book your slot for the Odin School’s Data Science Demo now! - hubs.la/Q02bbrxV0
It's been many months that I I have done this course from Odinschool and still didn't got even one opportunity
This is the first UA-cam comment that I commented today of this year, I rarely do comments on videos which means I'm so picky even though I like the video most, cause i have been learning and applying data science related topics from UA-cam since long time but honestly I find this channel is literally insane, so useful. Its too good Thank You So much Sir
Thank you so much 😊
You are doing god's work sir.
Really Appreciate it what you are doing here.
Helped me alot.
Thank you very much 🙇
Its an Human Magic 😯
Un believable excel dashboard
Sir, Your many tricks are much interesting👋👋👌
Love this video, I think I’ve watched it four times.
if you have a problem with issue_date here is what I did i opened the format cell custom then type mmm/dd/yyyy then replace - with / then manually switch the 4 bad data cell day and month to month and day hit enter and it will fix it its not that bad because you only need to manually do 4 bad data cell
but it there's a better solution tell me because its a pain if you need to do a lot more manual change
Edit: the last_credit_pull_date column is worst I don't know the fix unless you do it manually
Edit 2: Found a solution first replace the - and / with . then find the position of " . " also find the 2nd position of " . " use Left, Mid, and Right Function to get the day month and year finally use the =Date() Function then its now cleaned and format it as mmm/dd/yyyy if you like
Thank you very much for teaching a very useful data analytics project. Truly appreciate this. I have completed this project using MS Excel only. Hopefully, I will do it again along with SQL as well. For now, can I add the completed project to my LinkedIn profile? Looking forward to a positive response from your end.
According to the statement problem, In loan status grid view, it was also asked about the MTD funded and recieved amount. I think u missed out on adding it to the first dashboard
How to modify issue_date column?
magnifecent💯💯
Can anyone explain that employee title and employee length are related to customer or any sales representative?
Very helpful - thankyou.
Glad it was helpful!
The excel file in the description is not the same you are using.... Please upload the one you're using
Can I add this project in my resume?
Sir your excel.data giving different values
thanku so much
sir can u plz upload the same project using power bi ?? plzz
Do recruiters also want excel dashboard ?
the data you are using in the video is not the same as in the description, pls can you download the right one
Hi ,
I am also expecting Power BI Dashboard. Please upload it.
Thanks,
Amal
Will upload soon
@@datatutorials1 please upload the power bi part as well.
Thank you helped me so much ;)
Im.gonna try this project
Hi i can see there are some blank cells there in raw data, do we need to fill before we start building dashboards or we can ignore that ?
I thought you will create this dashboard on power bi but unfortunately not as expected
It's Excel Project soo made in Excel ,, he made same project in Power BI Also
Sir I'm facing a problem , when I try to copy from pivot table and past all Bar charts in a dashboard but failed. Bar charts are not being pasted. Please any solution?
Need more videos on full Excel Project
Please I'm a beginner. How did you get the dataset from SQL database. Is it readily available How can I do it on my own.
using Power BI in the thumbnail in part 1 and part 2 you turned to excel?
Hi
When I am creating a MTD measure, adding issue_date to rows is giving me a list of date but I am getting the whole list how can it be turned to months format
U can make calendar table when using time intelligence functions like MTD , Calendar table will not have any duplication hence there will be no uncertainty in results.
Put date in rows and set hierarchy to month if u want month format
facing same issue, any solution ?
QUICK FIX: Create 'issue_month' column before you start working on your pivot table. Then instead of adding 'issue_date' to the rows, you add 'issue_month'.
(the data type of the 'issue_date' is not correct)
what i did is i opened the format cell custom then type mmm/dd/yyyy then replace - with / then manually switch the day and month to month and day hit enter and it will fix it its not that bad because you only need to manually do 4 bad data cell
but it there's a better solution tell me because its a pain if you need to do a lot more manual change
Have you created insurance dashboard in Excel videos
hello sir i have faced date formating in row data when i create pivot table MTD also created but issue is when i drag the issu_date formate will be open in dd/mm/yyy like this not open month wise data i request to you sir please solve this problem in short video we are still waiting please solve sir thank you
Did you convert the csv file to excel file
@@datatutorials1 did in both ways but not working
Make sure dates are in the right date type before you create your pivot table.
mee too same problem.....i have tried many times...but no result.
Same problem
Whenever I tried to use issue date column in pivot table it comes in date format not in month format please help me how van i rectify this
Either extract month from the date column in data itself, using Text(Cell, “mmmm”).
Cell means the cell in which date is present
Then use that month in pivot tables
@
Data Tutorials, Hello Swapnajeet, Can i add this project to linked in or Novypro? also tell the steps to upload to novypro, there is no embedd option given in my Excel 2021.
Yes you can add. I too need to check out excel publishing to novy
Is part 2 available in PowerBi ?
02:20:20
sir how to explain this project without having domain knowledge to companies if i get interview call ?
Excel Project | Data Analyst Portfolio Project | Finance Domain
I am not getting the field map even though my system has internet connection can you please help me
Why do we write sql queries and not use it when doing the visualization?
After I finished the entire project, I worked hard on it all day, and it did not save
anyone can please help with the issue date column.
Sir the dasbboard will not be made in power bi ? Earlier you were making this dashboard in power bi
Will be and uploaded in next week
Excel project for insurance dataset
Please share the one with Power BI
Will be uploaded soon
sir plz upload soon
@@datatutorials1
Sir here in Dates Column some dates are in General format and some dates in Dates format at time of extract or some calculation its shown error for those dates which is are in general format,can please tell me how solve this issue
I have same question actually, were you able to understand ?
How to get data from mysql server online sir?
Is data analysis job decrease with AI
All KPIs title are same
Did you use 2 dataset and merge it?
Nooe
Sir, when creating an MTD measure, adding issue_date to rows gives me a list of dates but I am getting the whole list how can it be turned to month format, (the data file is already converted to Excel from CSV, and the issue_date column data type is set to date short and date long alternatively but no change in the result)
Same problem
Sir pls provide this excel project 😭😭😭i just made it and my forgot to save it 😭😭😭i am crying right now pls sirrrrrr
😂
Hi, I am unable to find the Excel data sheet for practice. Please check once and update it.Thank you.
It is available as csv file
am i the only one having problems with the issue date
Why in Excel when we have powerbi and tableau?
You will also be required to create some projects and data cleaning in excel
Please where's the link to the 1st part of the video?
Check playlist
Why didn't you clean the data first?
Cleaning is done
@@datatutorials1can you please upload the video of cleaning the data used in this project as well.
@kuch0nahin watch data cleaning video available on my channel
@@datatutorials1thanks. Will do!
@@kuch0nahin u can go for the power BI project to explain it clearly ( data cleaning).
Sir
.... Hindi ya urdu mai nai hai???
Hindi me video