Accenture Task 3 Data Visualization ruclips.net/video/xnBmA5DRk0c/видео.htmlsi=b7Ev40mI9IXUr1lY Excel File github.com/Skillspiress/Accenture-Data-Sampling-and-modelling "Categories and Score", Please Correct it, Messed up in arranging Largest to Smallest, though the sum and every other thing is right. Sorry for the Mistake, didn't checked it that time.
you can also download the excel file, i provided in my Github account for better understanding if you are doing something wrong. github.com/Skillspiress/Accenture-Data-Sampling-and-modelling
Did you check the column, wether it contains any other value than studying? Before using duplicate. Download the excel file provided in the GitHub account (check description) . Hope it will help.
@@jensternahak Did you check the column, wether it contains any other value other than studying? Before using duplicate. Download the excel file provided in the GitHub account (check description) . Hope it will help.
After clicking remove duplicate data then we can see unique data but on clicking the ok in pop up then all unique values are changed to studying, how to solve it?
Did you check whether the column contains any other value than studying? Possibilities 1. Column only contains studying as a value, reason may be you didn't import correctly using the vlookup function and only imported studying as a value. Please correct the formula. 2. Maybe the data is filtered to show only studying. Please unfilter your data. For more please download the file from my GitHub account. You can get the link in the description. Hope it helps.
Getting NA because you are missing something in the syntax that's why it's not showing correct value, maybe you didn't select the appropriate table for vlookup or returning something with incorrect value
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.
Check the pin comment for the formula used in the vlookup function. You are getting n/a because of there is no value to return. Correct the formula and you will get the result.
If you completed a cell for both content type and category, when you click on the cell, you will find a dot in the right most corner, just double click it and it will fill all the remaining values till the previous filled cell of the previous column.
While copying VLOOKUP to all cell only 2-3 cells are generating the answer remaining are giving #NA this error can someone please tell me how to resolve this.
if you are copying the same formula in different cells (Same formula with exact characters), its not going to work as each cell reference is different. just type the formula in first cell and drag it to fill all the cells or in the cell where you put your vlookup formula, you can see a small dot in the right most corner, just double click it and it will fill all the cells automatically till the previous column last cell.
Please use this $B$1:$D$1001 =VLOOKUP($B2,Sheet1!$B$1:$D$1001,2,0) please correct the returning value if in case it's showing other value. (In above it's returning value in the 2nd column)
Please follow the task 3, so that you can understand how to separate the datetime column and how to extract months from it. Sorry for earlier comment, thought talking about PowerBI videos.
Task 3 Uploaded ruclips.net/video/xnBmA5DRk0c/видео.html Task 4 is a video recording, just record a video of your insights and conclusion and upload it.
Accenture Task 3 Data Visualization
ruclips.net/video/xnBmA5DRk0c/видео.htmlsi=b7Ev40mI9IXUr1lY
Excel File
github.com/Skillspiress/Accenture-Data-Sampling-and-modelling
"Categories and Score", Please Correct it, Messed up in arranging Largest to Smallest, though the sum and every other thing is right. Sorry for the Mistake, didn't checked it that time.
Where is the mistake?
@@richaahuja944 there is no calculation error, just rearrange top categories and score, by going to sort- arrange through score-largest to smallest.
Thankyou so much sir for the guidance
Really helpful video to learn
sir i cant download this Excel File can you provide the link again ?
@@TechWiz42 go to the GitHub account. It is uploaded there. Download it from there. Check it in the description.
Thankyou. As someone who hasnt used these functions before, watching this has really helped me understand. It was a fantastic breakdown.
Glad it helped!
Thankyou
Glad to help!
Why am getting studying only as a unique values? Please help
Check whether the data which is selected has other values other than studying?
is your problem solved can you tell me how i am also getting same problem
@@rahityapothuri7673 While pasting Category category use paste it as values
Iam also facing the same issue
@@AbhishekKumar-wv2sz please copy and paste category as value only.
Why i am getting same values.. even i checked calculation option and it was checked to automatic... please help
You are talking about which part? Which Calculation?
you can also download the excel file, i provided in my Github account for better understanding if you are doing something wrong.
github.com/Skillspiress/Accenture-Data-Sampling-and-modelling
@@SkillSpireS Thank you much! :)
Hey.. Can I have your mail id or number or insta acc id
Can I have ur number or mail id or insta id
how is your data arranged like that cos when i special paste the data it doesnt look organised
Paste as values/text only and then organise the data.
it was great though You should have explained what keys are pressing for better understanding ......keep it up
I don't have a mic, that's why I tried to put everything in an easy to read text box.
I got 27 categorys after filtering the duplicates....in that 27 there are some duplicate values...pls help me with it
Did you copy the categories in the other cell as text value only? Apply a duplicate tool after it.
Iam facing trouble with task 2 bro. Couldn't get the data in proper way and calculation going wrong. Could you please share the Excel link
Download it from my GitHub account, check the description.
I can find only task 3
Could you please share link i couldn't find task 2
@@preethitanakala7150 Updated, Please Download from GitHub account.
github.com/Skillspiress/Accenture-Data-Sampling-and-modelling
Thank you for your help
When removing duplicate value when ok mssg comes when touch to ok mssg duplicate value which are removed all becomes studying how to solve it then
Did you check the column, wether it contains any other value than studying? Before using duplicate.
Download the excel file provided in the GitHub account (check description) .
Hope it will help.
@@SkillSpireS i have this same problem can you explain it?
@@jensternahak Did you check the column, wether it contains any other value other than studying? Before using duplicate.
Download the excel file provided in the GitHub account (check description) .
Hope it will help.
sir can you please provide the excel file download link in the description ?
It's already in the description. . Check GitHub account.
After clicking remove duplicate data then we can see unique data but on clicking the ok in pop up then all unique values are changed to studying, how to solve it?
Did you check whether the column contains any other value than studying?
Possibilities
1. Column only contains studying as a value, reason may be you didn't import correctly using the vlookup function and only imported studying as a value. Please correct the formula.
2. Maybe the data is filtered to show only studying. Please unfilter your data.
For more please download the file from my GitHub account. You can get the link in the description. Hope it helps.
When u r pasting use option " Paste as value "
Forgot this one. Please paste as value. Thank you for reminding.
after first column ,im getting NA error while using vlookup
Getting NA because you are missing something in the syntax that's why it's not showing correct value, maybe you didn't select the appropriate table for vlookup or returning something with incorrect value
Hello, I’m getting N/A for sum of score I’m giving correct formula
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.
in the sorting part , higest to lowest , after animals science should come according to value ?
I filtered it alphabetically, just sort it by value high to low.
Please share 1st task of accenture
Task 1 is just MCQs, even if you get it wrong, click on the next option, eventually you will get it right. It doesn't hinder your completion rate.
Life saving video ! 👍🏼
in the end you sorted the category alphabetically not in the top 5 based on the sum of score please rectify it
Yes I know, already explained it in the description.
GREAT WORK
Thank you! Cheers!
Iam using Excel in Google web so the vlookup function is it same? Or vlookupinclude the url of the other pages?
The syntax of vlookup will be the same. Whether it contains url or not , you will get to know when you use it.
how to upload created power bi task ?
Upload the .pbix file. . Save the power bi file.. and directly upload it.
I don't think that you need to upload the power bi file. . You need to upload an excel file.
On adding reaction type in a single sheet I’m grtting n/a values.can u pls help me
Check the pin comment for the formula used in the vlookup function. You are getting n/a because of there is no value to return. Correct the formula and you will get the result.
Thank you!
I've applied vlookup on content type and category. But how do we fill remaining values of it for remaining table
Like I'm getting same values in Content type and Category.
If you completed a cell for both content type and category, when you click on the cell, you will find a dot in the right most corner, just double click it and it will fill all the remaining values till the previous filled cell of the previous column.
Check the formula, if you are getting the same value for different cells.
Yes sir I got it, but I had fixed the lookup value cell no, that's why it was showing same value all over, problem solved, thank you for the help
Ok
how to do autofill after first row .
ruclips.net/user/shorts8v4aWTQZLg4?feature=share
@@SkillSpireS thks bro✨
Sir, how you deleted all blanks in 1 go?
Use the filter option, select blank in it. Select all the blanks and remove it directly. Then remove the filter or select all in the filter.
While copying VLOOKUP to all cell only 2-3 cells are generating the answer remaining are giving #NA this error can someone please tell me how to resolve this.
if you are copying the same formula in different cells (Same formula with exact characters), its not going to work as each cell reference is different. just type the formula in first cell and drag it to fill all the cells or in the cell where you put your vlookup formula, you can see a small dot in the right most corner, just double click it and it will fill all the cells automatically till the previous column last cell.
By double clicking also it’s not working
@@MadgulkarAdityaManoj can you share the formula, you are using
For 1st cell =VLOOKUP($B2,sheet1!B1:$D1001,2,FALSE)
Please use this $B$1:$D$1001
=VLOOKUP($B2,Sheet1!$B$1:$D$1001,2,0)
please correct the returning value if in case it's showing other value. (In above it's returning value in the 2nd column)
after writing formulae how to drag till bottom
On the right side corner of a cell you will find a plus sign, just double click it and it will automatically fill till the previous column cell.
Im getting the sum formula as error pls help me with it sir
ruclips.net/user/shorts8Yt_q-Xzchg?feature=share
Please go through this, hope this helps.
Date and time ..how about that column..plzcould you tell me ?
Please follow the task 3, so that you can understand how to separate the datetime column and how to extract months from it. Sorry for earlier comment, thought talking about PowerBI videos.
Can u pls help i m getting 0 as my score result in reaction type
Check formula.
I do but not getting the answer
@@chirag5379 download the file from my GitHub account. Check description. Hope.it helps
Bhai task 4 ka record video kaise complete karna hain
Just record the video showcasing your insights (insights are already provided in the intership) and recommendations.
Task 4
ruclips.net/video/WH0h6DUzR28/видео.html
Pls post the task 2answer document in gitub and give me the gitublink
Sure will update as soon as possible
Bro give me ur Spotify playlist please 🥺😂
🤣
Task 3,4 pls??
Will upload soon
Task 3 Uploaded
ruclips.net/video/xnBmA5DRk0c/видео.html
Task 4 is a video recording, just record a video of your insights and conclusion and upload it.
Thank you for this video because I was trying to enter it manually using the tool bar but it wasn't working for me.
Glad I could help
Linkkkkk of the data set plz
Google forage Accenture virtual internship, you will get data from there.
github.com/Skillspiress/Accenture-Data-Sampling-and-modelling
❤❤❤❤
Hello bro will you please send ppt
Download from GitHub account. Check description.
@@SkillSpireS I need ppt with all details as you mentioned in video
THANK YOU
😄
You're welcome 😊
Sir app bolke video banaya kriye
Gunge h kya app
Ye samjh lo.. koi fancy setup nahi.. mic bahut noise record karte hai.. samjh main kuch ni ayega