Пікірлер
@fazal5441 21 сағат бұрын
Well done and yeah audio quality is awesome thanks for fixing
@SkillSpireS 20 сағат бұрын
Good to hear
@fazal5441 Күн бұрын
Thank you 😊
@luvarora1921 Күн бұрын
5:55 my value is coming 0 even after putting the formula correctly
@SkillSpireS 20 сағат бұрын
Will post all the files in the GitHub account after completion of task 6, if the formula is correct, maybe it is not able to find the correct values. Please correct the values to look
@UnnathiSingh Күн бұрын
can you provide all 5 tasks files or github link ?
@SkillSpireS 20 сағат бұрын
Sure after completion of task 6
@rohitrouth4366 4 күн бұрын
Thora process ko break kar kae kijyae ga
@rohitrouth4366 4 күн бұрын
Sir sahi sae samaj nahi aee raha hai
@SkillSpireS 4 күн бұрын
In which part you are facing difficulty?
@viralworld6819 6 күн бұрын
voice bhut kam hai
@keengkh3578 6 күн бұрын
thank you so much
@SkillSpireS 6 күн бұрын
You're welcome!
@atharvavilankar3982 8 күн бұрын
audio issues makes the experience 👎
@SkillSpireS 7 күн бұрын
Sorry I don't have a good mic setup, that's why sound quality is poor. you can support me through Buy me a coffee buymeacoffee.c... Through Paypal paypal.me/Rams... Through KZbin Super Thanks, Super Chat, or Stickers: So that I can buy a new setup and the experience can go 👍
@SkillSpireS 7 күн бұрын
Links are in description if these are not opening from comments. Please check the description. Thank you
@AtharvaVilankar Күн бұрын
Why don’t you do it like the one did for JP Morgan investment banking forage video
@CalcuttaUniversityinfo Күн бұрын
Please provide the solutions link
@AtharvaVilankar 9 күн бұрын
Looking forward to more task from this simulation of hsbc. Thank you, it was helpful for me!
@SkillSpireS 9 күн бұрын
Glad it was helpful!
@vanshikamittal4652 11 күн бұрын
images from?
@SkillSpireS 10 күн бұрын
Download from flaticon
@siasingh3983 11 күн бұрын
HSBC Global Banking & marketing job simulation make video
@SkillSpireS 10 күн бұрын
Sure
@siasingh3983 11 күн бұрын
Please make video on HSBC Global Banking & Markets job simulation
@SkillSpireS 7 күн бұрын
I have some videos on similar topics, check out my channel!
@Atoofa-y4y 14 күн бұрын
Thankyou
@SkillSpireS 12 күн бұрын
Glad to help!
@TalesByVannn 19 күн бұрын
Thankyou so much❤
@SkillSpireS 18 күн бұрын
You're welcome! Happy to help! :)
@harikadigamarthi6535 28 күн бұрын
Is enough screensharing and record our audio or else we should on our camera and we should explain about and how many mins it should be?
@SkillSpireS 28 күн бұрын
Yes, screen sharing + audio is enough. Make it precise and insightful, don't be too lengthy or too short. Making it under 5 minutes should suffice and minimum 1 min.
@blackbot.1 Ай бұрын
How to get all 4 answers of task 3
@SkillSpireS 28 күн бұрын
Check the description, download the file from GitHub account.
@blackbot.1 28 күн бұрын
@@SkillSpireS thanks
@Het-r2e Ай бұрын
Sir pls give pdf of task 3
@AbdulrhmanHadad Ай бұрын
Thank you for your great work!
@SkillSpireS Ай бұрын
You're welcome, happy to help! :)
@melusinyoni1484 Ай бұрын
How did you clean your dataset?
@naman_624 Ай бұрын
How did you write the final investment recommendation? (330mm to 370 mm?)
@SkillSpireS Ай бұрын
Automatic calculation from dcf model
@AVISHEKROKKA Ай бұрын
data doesn't need to clean first in power bi
@SkillSpireS Ай бұрын
These tasks already come with near perfectly cleaned data, you can use filters to clean it more if needed.
@amma2255 Ай бұрын
@@SkillSpireS There were blanks and it wasnt cleaned
@SkillSpireS Ай бұрын
@@amma2255 use filter
@ayeshasultana9694 2 ай бұрын
Hi bro plz make a vedio on forage financial analyst tasks 1 and 2 complete
@SkillSpireS Ай бұрын
Any specific one?
@janethegod 2 ай бұрын
Pls do you have a video sample that you recorded of yourself doing this task that I can watch while doing mine
@SkillSpireS 2 ай бұрын
Sorry, I didn't record it. But complete the task as per your best, it's just an online internship. It helps you understand what is asked in the internship. But overall in an interview it doesn't hold much value.
@057gvaishnavi2 2 ай бұрын
Hi... for me No option for churn is not displaying. so that, customer risk analysis slide is not giving correct values...can you tell me whyy???
@SkillSpireS 2 ай бұрын
Maybe you're putting the wrong values in the value tab. Correct the values.
@reenamonteirosonar4607 2 ай бұрын
can u link the data to practice along pls
@SkillSpireS 2 ай бұрын
You can use the data to create it. uploaded in GitHub account github.com/Skillspiress/J-P-Morgan-Chase-and-co-excil-skill
@vishaltanna3042 2 ай бұрын
Hey, we've been asked to perform data cleanup in this task before starting with the visualization. Has it been covered by you anywhere?
@SkillSpireS 2 ай бұрын
Data is already cleaned, you can start working on it right away. If you want, you can have some minor changes. That's all
@jarinanan4275 2 ай бұрын
Sir how did you create page 4?
@SkillSpireS 2 ай бұрын
For home work, not necessary.
@GestySnr 2 ай бұрын
Very nice work How were you able to create the shape for the final arrangement and organization.
@SkillSpireS 2 ай бұрын
You can arrange it in any way you want, the arrangement is up to you!
@oneclipgaming2366 2 ай бұрын
Hiw did you got Tax Amt in DCF INPUT negative in I 39
@SkillSpireS 2 ай бұрын
Just put minus after =, it will change the value to negative
@abidurrahmanabir7745 3 ай бұрын
Awesome Brother.. Love From BANGLADESH.. Already finshed the project thank you so much brother..❤️❤️❤️....
@SkillSpireS 3 ай бұрын
Glad to help, :)
@sunnychauhan5053 3 ай бұрын
Mera pending mai chl rha hai. How to re access.please brother solve
@SkillSpireS 3 ай бұрын
If it's showing in your dashboard, forage, you can complete it. If not, they removed it. Last date to complete was 30 sept.
@sunnychauhan5053 3 ай бұрын
@@SkillSpireS similar course suggest me plz brother
@SkillSpireS 3 ай бұрын
Accenture, tata, pwc
@sunnychauhan5053 3 ай бұрын
@@SkillSpireSlink share karo do brother please
@benzz9239 3 ай бұрын
Task 4 video too please
@SkillSpireS 3 ай бұрын
The task four video is already in the channel page.
@SkillSpireS 3 ай бұрын
kzbin.info/www/bejne/jXmTmWl6it-FaJo
@asuka5366 3 ай бұрын
how is your data arranged like that cos when i special paste the data it doesnt look organised
@SkillSpireS 3 ай бұрын
Paste as values/text only and then organise the data.
@517Chamu 3 ай бұрын
I got 27 categorys after filtering the duplicates....in that 27 there are some duplicate values...pls help me with it
@SkillSpireS 3 ай бұрын
Did you copy the categories in the other cell as text value only? Apply a duplicate tool after it.
@EzPz-u6n 3 ай бұрын
hey bro , just a question why we making customer risk analysis tab if we have covered the requirements in churn dashboard
@SkillSpireS 3 ай бұрын
Covered overall in churn dashboard, details in risk analysis.
@Adarsh-c7y 3 ай бұрын
Have they removed the forage ? i'm not able to access it
@SkillSpireS 3 ай бұрын
Yes, they removed it. 30 September was the last date
@M_Priya_ 3 ай бұрын
It is not available now
@SkillSpireS 3 ай бұрын
Accenture and tata internships are available, you can do them.
@neerajag4789 3 ай бұрын
Hello, I’m getting N/A for sum of score I’m giving correct formula
@SkillSpireS 3 ай бұрын
If you are getting n/a , possibly your formula is not correct. Please correct it. You can download the file from the GitHub account about the task for reference. Link in description.
@MadhuShukla17 3 ай бұрын
I am not able to do the 5 yr CAGR sorting after doing the sorting it is showing #Name error in the entire column. Plz help
@SkillSpireS 3 ай бұрын
Maybe you did something wrong, please start fresh. Delete the file, download it again from forage and repeat the steps. I hope this will solve your problem. Record macro rather than writing vba .
@SkillSpireS 3 ай бұрын
Try changing the column format. Maybe you accidentally changed it to a name or string. Change the format of the column to percentage.
@Jaysaraf-b3v 3 ай бұрын
Same
@Jaysaraf-b3v 3 ай бұрын
Plz help bro
@MadhuShukla17 3 ай бұрын
@@SkillSpireS thanks the issue is resolved.
@theinnovationworld7 3 ай бұрын
13:30 Step is cut 😣
@SkillSpireS 3 ай бұрын
Which part is cut???
@pavidobbie_007 27 күн бұрын
Sir you told to add but while doing you have subtracted, which one should we follow??
@_m_h_z1432 3 ай бұрын
Question 4 am not getting map bro
@saisantosh7140 3 ай бұрын
save it -> close it-> reopen the file.
@SkillSpireS 2 ай бұрын
Sorry for late reply, you need to change the settings for map to display, search on google, it's simple setting.
@bhumikanautiyal2004 3 ай бұрын
Hi I am unable to hear your voice.
@ninjaff3604 3 ай бұрын
1st task ?
@JWPartridge 3 ай бұрын
Thankyou. As someone who hasnt used these functions before, watching this has really helped me understand. It was a fantastic breakdown.
@SkillSpireS 3 ай бұрын
Glad it helped!
@prsdsrinivasa390 3 ай бұрын
how to upload created power bi task ?
@SkillSpireS 3 ай бұрын
Upload the .pbix file. . Save the power bi file.. and directly upload it.
@SkillSpireS 3 ай бұрын
I don't think that you need to upload the power bi file. . You need to upload an excel file.
@shiven6920 3 ай бұрын
i Can't see sales in PivotTable Fields
@RK-ct8hi 3 ай бұрын
why is there no sound, I am new to pivot tables, finding it very difficult to track what is happening on screen without audio.
@SkillSpireS 3 ай бұрын
Sorry don't have mic
@RK-ct8hi 3 ай бұрын
@@SkillSpireS Thanks alot brother. I am new to excel, was finding it really difficult to complete the task, ur videos really helped.
@SkillSpireS 3 ай бұрын
@@RK-ct8hi Glad it helped, you can also check dashboard creation on power bi, for the same data. relatively easy creating dashboard in power bi.
@tanyarana1131 3 ай бұрын
It was top 10 *percent* right? I feel like you forgot to check the % box?
@SkillSpireS 3 ай бұрын
Yes, it was. Check the box.
@cosmicx7975 3 ай бұрын
how did you link the number of accounts in pivot table chart
@SkillSpireS 3 ай бұрын
You can't directly link it in a text box. You need to link a cell first. I linked a cell to the pivot table and then linked the cell in the dashboard text box.