title
How B com graduate became a data analyst | Data analyst career transition

description
Hitesh Talreja is senior data analyst in Accenture. He has b com (Bachelor of commerce) degree and with that he was able to make successful career in the field of data science. He will share many useful tips and step by step process on how a b com graduate can become a data analyst. Topics: 0:00 Introduction 1:12 What do you at present & What do you enjoy the most in your data analyst job 3:17 Your journey of becoming a data analyst with b com background and what inspired you to choose this career? 15:15 What job portals did you use to apply for a job? 16:30 What concepts or topics that you learnt in bcom that can help you when you move to data analysis field (you can talk about what math or statistics topic that you learnt that is helping you now) 18:46 People argue that it is hard to get interview calls if you are from b com background. What did you do to get interview calls? What projects did you show on your resume? 23:06 What challenges did you face when transitioning to data analyst career coming from bcom background 25:25 If someone wants to become data analyst with b com background what is the step by step process that you would recommend 25:43 How much time does it take to learn data analyst skills 28:17 How easy is it to enter a data analysis field with b com field? Is it very very hard? 29:34 How likely companies are to hire a person with b com background as a data analyst? 32:34 Is data science and data analysis a hype or a bubble that is going to burst soon? Hitesh's linked in profile: https://www.linkedin.com/in/hitesh-t/ Feel free to contact him if you have any questions. Do you want to learn technology from me? Check https://codebasics.io/ for my affordable video courses. Website: https://codebasics.io/ Facebook: https://www.facebook.com/codebasicshub Twitter: https://twitter.com/codebasicshub

detail
{'title': 'How B com graduate became a data analyst | Data analyst career transition', 'heatmap': [{'end': 1627.428, 'start': 1593.339, 'weight': 1}, {'end': 2311.889, 'start': 2284.365, 'weight': 0.724}], 'summary': "Hitesh talreja's journey from bcom to senior data analyst is detailed, emphasizing excel and power bi use, challenges faced, and the value of practical skills. the transition to data science, challenges of online learning, and advice for career transition are also discussed, highlighting the demand for data analysts and the importance of technical skills, patience, and business domain knowledge.", 'chapters': [{'end': 250.779, 'segs': [{'end': 30.846, 'src': 'embed', 'start': 1.36, 'weight': 0, 'content': [{'end': 2.461, 'text': 'hello everyone.', 'start': 1.36, 'duration': 1.101}, {'end': 5.563, 'text': 'we have Hitesh Talreja here for a conversation.', 'start': 2.461, 'duration': 3.102}, {'end': 9.465, 'text': "he's a senior data analyst working for accenture.", 'start': 5.563, 'duration': 3.902}, {'end': 12.947, 'text': 'he comes from a bachelor of commerce or a bcom background,', 'start': 9.465, 'duration': 3.482}, {'end': 19.812, 'text': 'so he is such an inspirational story for many of you who wants to move to data science field.', 'start': 12.947, 'duration': 6.865}, {'end': 22.013, 'text': 'coming from a bcom background.', 'start': 19.812, 'duration': 2.201}, {'end': 30.846, 'text': 'during our conversation, we will give be giving you a lot of tips on how you can transition from become to data analyst background and overall,', 'start': 22.013, 'duration': 8.833}], 'summary': 'Hitesh talreja, a senior data analyst at accenture, shares tips on transitioning from a bachelor of commerce to data analyst background.', 'duration': 29.486, 'max_score': 1.36, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/lqEzYDuTnvU/pics/lqEzYDuTnvU1360.jpg'}, {'end': 112.521, 'src': 'embed', 'start': 82.957, 'weight': 1, 'content': [{'end': 87.401, 'text': 'Well so, currently I am working with multiple projects.', 'start': 82.957, 'duration': 4.444}, {'end': 90.203, 'text': "One of the projects that I'm working on.", 'start': 87.861, 'duration': 2.342}, {'end': 104.435, 'text': 'that requires me to monitor the data that operation teams sends out to us and we prepare, say we clean it out using certain tools, majorly Excel,', 'start': 90.203, 'duration': 14.232}, {'end': 112.521, 'text': 'and then we put it into Power BI and we, you know, we represent it and in a visual.', 'start': 104.435, 'duration': 8.086}], 'summary': 'Managing multiple projects, using excel to clean data for power bi visualization.', 'duration': 29.564, 'max_score': 82.957, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/lqEzYDuTnvU/pics/lqEzYDuTnvU82957.jpg'}, {'end': 225.143, 'src': 'embed', 'start': 171.056, 'weight': 2, 'content': [{'end': 176.521, 'text': 'uh, putting out funds to just buy live, which was a startup for, uh, e-commerce.', 'start': 171.056, 'duration': 5.465}, {'end': 183.327, 'text': 'And, uh, yeah, I was working with that company for say quite a bit around eight, nine months.', 'start': 177.502, 'duration': 5.825}, {'end': 186.003, 'text': 'It was a startup and then last long.', 'start': 184.142, 'duration': 1.861}, {'end': 192.986, 'text': 'So I see there was not much of funding and they had to call off operations.', 'start': 186.623, 'duration': 6.363}, {'end': 193.747, 'text': 'Got it.', 'start': 193.367, 'duration': 0.38}, {'end': 194.187, 'text': 'Got it.', 'start': 193.787, 'duration': 0.4}, {'end': 198.569, 'text': "So let's begin with your journey.", 'start': 195.568, 'duration': 3.001}, {'end': 201.03, 'text': 'So you can come from become background.', 'start': 198.689, 'duration': 2.341}, {'end': 208.234, 'text': 'So can you tell us your journey, or a step by step process, of how you, after you graduated as a, become graduate?', 'start': 201.07, 'duration': 7.164}, {'end': 217.578, 'text': 'Where did you begin your job first? And what got you interested in data analyst job? And what steps did you take?', 'start': 210.874, 'duration': 6.704}, {'end': 225.143, 'text': 'Because on nowadays many people complain that when there is a data analyst job, they look for a computer science background.', 'start': 217.918, 'duration': 7.225}], 'summary': 'Worked with e-commerce startup for 8-9 months, which had to close due to lack of funding. also discussed journey after graduating and interest in data analyst job.', 'duration': 54.087, 'max_score': 171.056, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/lqEzYDuTnvU/pics/lqEzYDuTnvU171056.jpg'}], 'start': 1.36, 'title': 'Transitioning to data analyst role', 'summary': "Discusses hitesh talreja's transition from bcom to senior data analyst, emphasizing excel and power bi use. it also covers the challenges faced by a data analyst with experience in a startup.", 'chapters': [{'end': 139.1, 'start': 1.36, 'title': 'Transitioning from bcom to data analyst', 'summary': "Highlights hitesh talreja's journey from a bachelor of commerce background to becoming a senior data analyst at accenture, providing tips for transitioning and emphasizing the use of excel and power bi in data monitoring and visualization.", 'duration': 137.74, 'highlights': ['Hitesh Talreja, a senior data analyst at Accenture, shares insights on transitioning from a Bachelor of Commerce background to a data analyst role, providing valuable tips and inspiration for those aiming to make a similar career shift.', 'In his current role, Hitesh monitors and cleans data received from operation teams using tools like Excel and Power BI, emphasizing the importance of these tools in his day-to-day tasks.', "As a mediator between clients and operations teams, Hitesh's role involves cleaning and presenting data to clients, showcasing the practical application of his data analysis skills in a business context."]}, {'end': 250.779, 'start': 139.1, 'title': 'Data analyst journey and challenges', 'summary': 'Discusses the journey of a data analyst, facing challenges due to background, with experience in a startup that lacked funding and had to cease operations.', 'duration': 111.679, 'highlights': ['The interviewee worked with a startup, Just By Live, which was a sub-company for Herman and Cordon, and faced challenges due to lack of funding, leading to ceasing of operations.', 'The interviewee highlights the challenges faced by individuals from a non-computer science background in getting calls for data analyst job interviews, emphasizing that while difficult, it is not impossible.', 'The startup the interviewee worked for, Just By Live, had a short lifespan of around eight to nine months due to insufficient funding, resulting in ceasing of operations.', 'The interviewee discusses the difficulty faced by individuals from a commerce background in obtaining interview calls for data analyst positions, addressing the common complaint in the industry.', 'The chapter delves into the journey of the interviewee as a data analyst, starting from their background as a commerce graduate and the steps taken to enter the data analyst job sector.']}], 'duration': 249.419, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/lqEzYDuTnvU/pics/lqEzYDuTnvU1360.jpg', 'highlights': ['Hitesh Talreja shares insights on transitioning from a Bachelor of Commerce background to a data analyst role, providing valuable tips and inspiration for those aiming to make a similar career shift.', 'Hitesh monitors and cleans data received from operation teams using tools like Excel and Power BI, emphasizing the importance of these tools in his day-to-day tasks.', 'The interviewee discusses the difficulty faced by individuals from a commerce background in obtaining interview calls for data analyst positions, addressing the common complaint in the industry.', 'The interviewee worked with a startup, Just By Live, which was a sub-company for Herman and Cordon, and faced challenges due to lack of funding, leading to ceasing of operations.']}, {'end': 522.693, 'segs': [{'end': 389.845, 'src': 'embed', 'start': 289.021, 'weight': 0, 'content': [{'end': 294.362, 'text': 'So one of my engineer friend, he told me that, you know, this is the new buzzword.', 'start': 289.021, 'duration': 5.341}, {'end': 299.138, 'text': 'And people are just trying to get into this field.', 'start': 294.955, 'duration': 4.183}, {'end': 302.541, 'text': 'There are many institutes trying to teach this.', 'start': 299.278, 'duration': 3.263}, {'end': 310.167, 'text': 'They are asking about teaching the skills.', 'start': 302.921, 'duration': 7.246}, {'end': 314.81, 'text': 'So the type of person I am, I do a lot of research.', 'start': 310.187, 'duration': 4.623}, {'end': 322.656, 'text': 'And then I take a decision and move on to something that I have interest for.', 'start': 315.511, 'duration': 7.145}, {'end': 333.832, 'text': 'after some time I did some analysis and yeah, I thought, yeah, maybe you know, this is what the you know the world is going towards.', 'start': 325.007, 'duration': 8.825}, {'end': 336.393, 'text': "so let's possess this, these skills.", 'start': 333.832, 'duration': 2.561}, {'end': 345.358, 'text': 'so I joined some online you know, online classes.', 'start': 336.393, 'duration': 8.965}, {'end': 356.292, 'text': "yeah, of course, but it didn't quite work very well because I was not from a programming background and I didn't have much of a coding experience.", 'start': 345.358, 'duration': 10.934}, {'end': 359.816, 'text': "So that didn't work quite well for me.", 'start': 356.793, 'duration': 3.023}, {'end': 362.198, 'text': "So I thought, let's step back.", 'start': 360.316, 'duration': 1.882}, {'end': 365.06, 'text': "And I had KTs, I hadn't cleared that off.", 'start': 362.218, 'duration': 2.842}, {'end': 369.404, 'text': "So I thought, you know, let's focus on what I have left behind.", 'start': 365.1, 'duration': 4.304}, {'end': 373.207, 'text': 'So I cleared off those KTs first.', 'start': 370.345, 'duration': 2.862}, {'end': 381.763, 'text': 'Later by the time I had watched many videos in that online course and it had got my interest.', 'start': 373.928, 'duration': 7.835}, {'end': 383.584, 'text': 'but it was not.', 'start': 381.763, 'duration': 1.821}, {'end': 389.845, 'text': 'you know the assignments that they had that were to the next level.', 'start': 383.584, 'duration': 6.261}], 'summary': 'Struggled with online classes, cleared kts, gained interest in the field', 'duration': 100.824, 'max_score': 289.021, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/lqEzYDuTnvU/pics/lqEzYDuTnvU289021.jpg'}, {'end': 449.863, 'src': 'embed', 'start': 419.748, 'weight': 3, 'content': [{'end': 423.549, 'text': 'so I thought maybe this might not be the thing for me,', 'start': 419.748, 'duration': 3.801}, {'end': 435.333, 'text': 'because learning online in your own space plus there was support over the email whenever you try to call them.', 'start': 423.549, 'duration': 11.784}, {'end': 441.039, 'text': 'they would arrange a call back whenever the tutor was available, Even when they call back.', 'start': 435.333, 'duration': 5.706}, {'end': 444.74, 'text': 'whenever the tutor calls you back, even you should be available.', 'start': 441.039, 'duration': 3.701}, {'end': 449.863, 'text': "You should be free from your mind to understand what the concepts he's trying to make you understand.", 'start': 444.76, 'duration': 5.103}], 'summary': 'Online learning with email support and tutor call-backs for concept understanding.', 'duration': 30.115, 'max_score': 419.748, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/lqEzYDuTnvU/pics/lqEzYDuTnvU419748.jpg'}, {'end': 493.93, 'src': 'embed', 'start': 469.855, 'weight': 1, 'content': [{'end': 481.794, 'text': 'So if my tutor is making me learn a new concept, a new topic, he was more over to, you know, he was more on to that you practice this skill.', 'start': 469.855, 'duration': 11.939}, {'end': 485.066, 'text': "only then we'll move on to the next topic.", 'start': 482.765, 'duration': 2.301}, {'end': 489.568, 'text': "So just to summarize, you tried online courses first that didn't go well.", 'start': 485.686, 'duration': 3.882}, {'end': 493.93, 'text': "So now you join in person classes where you're going to classroom and teaching in person, right?", 'start': 489.608, 'duration': 4.322}], 'summary': 'Emphasizing practice before moving on to the next topic; transition from online to in-person classes.', 'duration': 24.075, 'max_score': 469.855, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/lqEzYDuTnvU/pics/lqEzYDuTnvU469855.jpg'}], 'start': 251.72, 'title': 'Transitioning to data science and challenges of online learning', 'summary': 'Details the journey of transitioning from a non-programming background to data science, including challenges faced in online classes, and the decision to focus on developing data science skills after clearing off kts. it also discusses the challenges of online learning, leading the individual to switch to in-person classes.', 'chapters': [{'end': 419.748, 'start': 251.72, 'title': 'Transition to data science', 'summary': 'Details the journey of transitioning from a non-programming background to data science, including the initial disinterest in commerce, the influence of an engineer friend, the challenges faced in online classes due to lack of coding experience, and the eventual decision to focus on developing skills in data science after clearing off kts.', 'duration': 168.028, 'highlights': ['The decision to transition to data science was influenced by the advice of an engineer friend and the recognition of the growing demand for skills in the field.', 'Initial challenges in online classes were faced due to a lack of programming background and coding experience.', 'The decision to focus on developing skills in data science was made after clearing off KTs, indicating a determination to pursue the field despite initial setbacks.']}, {'end': 522.693, 'start': 419.748, 'title': 'Challenges of online learning', 'summary': 'Discusses the challenges faced with online learning, leading the individual to switch to in-person classes, highlighting the lack of practical focus and support in online courses.', 'duration': 102.945, 'highlights': ['The lack of support and practical focus in online courses led to the decision to switch to in-person classes where the emphasis was on practicing new skills before moving on to the next topic.', 'Support over email and arranging call-backs from the tutor were available for online courses, but the focus of learning was not on practical application, leading to the decision to invest in in-person classes.', 'Initial attempt at online learning was hindered by the lack of practical learning and sufficient support, prompting the switch to classroom-based learning.']}], 'duration': 270.973, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/lqEzYDuTnvU/pics/lqEzYDuTnvU251720.jpg', 'highlights': ['The decision to transition to data science was influenced by the advice of an engineer friend and the recognition of the growing demand for skills in the field.', 'The lack of support and practical focus in online courses led to the decision to switch to in-person classes where the emphasis was on practicing new skills before moving on to the next topic.', 'Initial challenges in online classes were faced due to a lack of programming background and coding experience.', 'Support over email and arranging call-backs from the tutor were available for online courses, but the focus of learning was not on practical application, leading to the decision to invest in in-person classes.', 'The decision to focus on developing skills in data science was made after clearing off KTs, indicating a determination to pursue the field despite initial setbacks.', 'Initial attempt at online learning was hindered by the lack of practical learning and sufficient support, prompting the switch to classroom-based learning.']}, {'end': 893.343, 'segs': [{'end': 572.265, 'src': 'embed', 'start': 523.479, 'weight': 0, 'content': [{'end': 524.999, 'text': "you're not able to clear the exams.", 'start': 523.479, 'duration': 1.52}, {'end': 528.18, 'text': 'Oh, I see, I see, got it, got it.', 'start': 526.22, 'duration': 1.96}, {'end': 528.84, 'text': 'Another chance.', 'start': 528.22, 'duration': 0.62}, {'end': 530.901, 'text': 'Okay, okay, okay, got it.', 'start': 529.44, 'duration': 1.461}, {'end': 533.541, 'text': 'Well, this is very inspirational, actually.', 'start': 531.421, 'duration': 2.12}, {'end': 540.963, 'text': 'You had KDs in your college days in these courses, and you are now a successful data analyst.', 'start': 533.581, 'duration': 7.382}, {'end': 545.044, 'text': "So, for all those who don't do academically well,", 'start': 541.083, 'duration': 3.961}, {'end': 552.026, 'text': 'this is a nice example that getting marks is one thing and performing in real life is a different thing.', 'start': 545.044, 'duration': 6.982}, {'end': 553.731, 'text': "So that's very good.", 'start': 552.93, 'duration': 0.801}, {'end': 557.073, 'text': "So you did all this in-person class, let's say.", 'start': 553.891, 'duration': 3.182}, {'end': 566.06, 'text': 'And then after, did you start applying as a data analyst job directly or did you work in some other domain? No.', 'start': 557.433, 'duration': 8.627}, {'end': 572.265, 'text': 'So after my classroom class, I only had skills for R.', 'start': 566.1, 'duration': 6.165}], 'summary': 'Despite not excelling academically, the individual became a successful data analyst with kds in college, showcasing the distinction between academic performance and real-life success.', 'duration': 48.786, 'max_score': 523.479, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/lqEzYDuTnvU/pics/lqEzYDuTnvU523479.jpg'}, {'end': 710.151, 'src': 'embed', 'start': 659.265, 'weight': 2, 'content': [{'end': 661.086, 'text': "online course didn't go that well.", 'start': 659.265, 'duration': 1.821}, {'end': 672.19, 'text': 'tried classroom style course, uh, where you learned python r mainly and then you also started working in bpo, where you develop excel skills.', 'start': 661.086, 'duration': 11.104}, {'end': 674.611, 'text': 'So now your Excel and R skills.', 'start': 672.87, 'duration': 1.741}, {'end': 679.315, 'text': 'then you join another course where you build more visualization skills.', 'start': 674.611, 'duration': 4.704}, {'end': 690.484, 'text': 'So once you have those skills after that, how did you get your first data analyst job? So I was fed up working in the BPO.', 'start': 679.815, 'duration': 10.669}, {'end': 700.051, 'text': "I mean, I thought, you know, after having these skills and if I don't work towards these skills, I will lose those skills.", 'start': 690.704, 'duration': 9.347}, {'end': 709.17, 'text': 'right, I quit my job in the BPO and you know it was difficult for the time being.', 'start': 700.444, 'duration': 8.726}, {'end': 710.151, 'text': "I didn't have the job.", 'start': 709.17, 'duration': 0.981}], 'summary': 'Transitioned from bpo to data analyst role after acquiring excel, r, and visualization skills through various courses.', 'duration': 50.886, 'max_score': 659.265, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/lqEzYDuTnvU/pics/lqEzYDuTnvU659265.jpg'}, {'end': 790.844, 'src': 'embed', 'start': 761.327, 'weight': 5, 'content': [{'end': 766.909, 'text': 'So working in a startup, I think that was what made it easier for me.', 'start': 761.327, 'duration': 5.582}, {'end': 771.232, 'text': "And yeah, that's where I picked up more skills.", 'start': 767.55, 'duration': 3.682}, {'end': 781.877, 'text': 'Fortunately, that was also on R and Excel that they were functioning because it was e-commerce company and the data was not very structured.', 'start': 772.172, 'duration': 9.705}, {'end': 785.98, 'text': 'They had raw data in the form of excel.', 'start': 782.357, 'duration': 3.623}, {'end': 787.881, 'text': 'they were working on crms manually.', 'start': 785.98, 'duration': 1.901}, {'end': 790.844, 'text': 'data had to be extracted and it was in excel.', 'start': 787.881, 'duration': 2.963}], 'summary': 'Working in a startup helped me gain skills in r and excel, dealing with unstructured e-commerce data.', 'duration': 29.517, 'max_score': 761.327, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/lqEzYDuTnvU/pics/lqEzYDuTnvU761327.jpg'}], 'start': 523.479, 'title': 'Journey from college failures to successful data analyst', 'summary': 'Highlights the story of a data analyst who overcame academic struggles, emphasizing practical skills and continuous learning. it also outlines the journey to acquiring skills, obtaining a data analyst job after a five-month search, and succeeding in the interview process.', 'chapters': [{'end': 659.265, 'start': 523.479, 'title': 'Journey from college failures to successful data analyst', 'summary': 'Highlights a story of a successful data analyst who struggled academically in college, earning low grades, but went on to become successful in the field, emphasizing the importance of practical skills and the need for continuous learning in the real world.', 'duration': 135.786, 'highlights': ['The importance of practical skills and continuous learning in the real world is emphasized through the story of a successful data analyst who struggled academically in college, earning low grades, and later excelling in the field (relevance: 5)', 'The individual learned skills in Excel and R while working in a BPO, and later joined a full-fledged course to learn visualizations and Python, highlighting the value of acquiring diverse skills to meet the demands of the real world (relevance: 4)', "The individual's experience underscores the message that academic performance is not always indicative of real-life success, offering inspiration to those who may not perform well academically (relevance: 3)"]}, {'end': 893.343, 'start': 659.265, 'title': 'Path to data analyst job', 'summary': 'Outlines the journey of acquiring python, r, and excel skills, obtaining a data analyst job after five months of job search, and succeeding in the interview process, facilitated by project experience, in a startup using r and excel.', 'duration': 234.078, 'highlights': ['Acquiring Python, R, and Excel skills and joining a course to enhance visualization skills. The individual learned Python and R through a classroom-style course and developed Excel skills while working in a BPO. They also joined another course to build more visualization skills.', 'Job search and acquiring a data analyst role after five months, aided by project experience. After quitting the BPO job, it took around five months to secure a new job, during which time the individual worked on three to four projects, enhancing their resume and facilitating their entry into a startup as a data analyst.', "Success in the interview process at the startup due to prior skills and project experience. The individual's prior skills in R and Excel, along with a portfolio of projects, made it easier for them to secure an interview and ultimately a data analyst role at a startup. The interview process focused on general and technical questions related to Excel."]}], 'duration': 369.864, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/lqEzYDuTnvU/pics/lqEzYDuTnvU523479.jpg', 'highlights': ["The individual's experience underscores the message that academic performance is not always indicative of real-life success, offering inspiration to those who may not perform well academically (relevance: 3)", 'The importance of practical skills and continuous learning in the real world is emphasized through the story of a successful data analyst who struggled academically in college, earning low grades, and later excelling in the field (relevance: 5)', 'Acquiring Python, R, and Excel skills and joining a course to enhance visualization skills. The individual learned Python and R through a classroom-style course and developed Excel skills while working in a BPO. They also joined another course to build more visualization skills.', 'The individual learned skills in Excel and R while working in a BPO, and later joined a full-fledged course to learn visualizations and Python, highlighting the value of acquiring diverse skills to meet the demands of the real world (relevance: 4)', 'Job search and acquiring a data analyst role after five months, aided by project experience. After quitting the BPO job, it took around five months to secure a new job, during which time the individual worked on three to four projects, enhancing their resume and facilitating their entry into a startup as a data analyst.', "Success in the interview process at the startup due to prior skills and project experience. The individual's prior skills in R and Excel, along with a portfolio of projects, made it easier for them to secure an interview and ultimately a data analyst role at a startup. The interview process focused on general and technical questions related to Excel."]}, {'end': 1376.908, 'segs': [{'end': 1020.485, 'src': 'embed', 'start': 928.294, 'weight': 0, 'content': [{'end': 935.357, 'text': 'I would say there are no specific job portals, but the most effective or the most efficient one is LinkedIn.', 'start': 928.294, 'duration': 7.063}, {'end': 940.979, 'text': "It's not for jobs, but you can do your research, what market is hiring,", 'start': 936.137, 'duration': 4.842}, {'end': 951.709, 'text': 'what skills that the person who is searching for a job possess and how they can meet up the demands and then start applying say the jobs over LinkedIn,', 'start': 940.979, 'duration': 10.73}, {'end': 955.734, 'text': 'because many companies are now posting jobs over LinkedIn as well.', 'start': 951.709, 'duration': 4.025}, {'end': 966.045, 'text': "Another website is Naukri is quite helpful because my friends have got jobs from Naukri but personally I haven't.", 'start': 955.874, 'duration': 10.171}, {'end': 969.118, 'text': 'got a job from Naukri.', 'start': 967.037, 'duration': 2.081}, {'end': 971.858, 'text': 'Many of my friends have got jobs.', 'start': 969.298, 'duration': 2.56}, {'end': 978.06, 'text': 'Okay So for any international viewers, Naukri.com is a portal for jobs in India.', 'start': 972.278, 'duration': 5.782}, {'end': 981.581, 'text': "Hitesh is from India, so of course he's talking from the perspective of India.", 'start': 978.16, 'duration': 3.421}, {'end': 985.142, 'text': 'If you talk about US, there is indeed.com, there is Monster.', 'start': 982.061, 'duration': 3.081}, {'end': 989.943, 'text': 'There are a couple of job portals that you can use to find a job.', 'start': 985.182, 'duration': 4.761}, {'end': 998.307, 'text': "Now, sometimes people think that if you're coming from a Bachelor of Commerce background, your background really doesn't help with the job.", 'start': 990.343, 'duration': 7.964}, {'end': 1005.934, 'text': "And I think that's a big misconception, because when you're doing BCom, you are learning mathematics, you are learning statistics,", 'start': 998.347, 'duration': 7.587}, {'end': 1007.515, 'text': 'you are in banking and insurance.', 'start': 1005.934, 'duration': 1.581}, {'end': 1012.54, 'text': 'So you learn a lot of things about your domain, right? Like how banking and insurance works.', 'start': 1007.555, 'duration': 4.985}, {'end': 1020.485, 'text': "So my view is that your BCom studies are going to be actually very helpful if you're looking for a data analyst job.", 'start': 1013.18, 'duration': 7.305}], 'summary': 'Linkedin and naukri are effective job portals; naukri is popular in india, while linkedin is used by us companies. bcom studies are relevant for data analyst jobs.', 'duration': 92.191, 'max_score': 928.294, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/lqEzYDuTnvU/pics/lqEzYDuTnvU928294.jpg'}, {'end': 1106.824, 'src': 'embed', 'start': 1081.576, 'weight': 4, 'content': [{'end': 1089.641, 'text': 'But when I got into this field, I got to know that you know, I have learned this, and this is where they actually use it.', 'start': 1081.576, 'duration': 8.065}, {'end': 1092.763, 'text': "So that's where the value lies.", 'start': 1090.101, 'duration': 2.662}, {'end': 1094.799, 'text': 'I see, good.', 'start': 1093.959, 'duration': 0.84}, {'end': 1101.762, 'text': "So, if you're looking at all the normal distribution statistics, those are super helpful when you're doing data analysis right?", 'start': 1095.36, 'duration': 6.402}, {'end': 1106.824, 'text': "If you want to, let's say, remove outliers, you can use a technique of three standard deviation or more.", 'start': 1101.782, 'duration': 5.042}], 'summary': 'Understanding the value of statistics in data analysis, such as using normal distribution and three standard deviations for outlier removal.', 'duration': 25.248, 'max_score': 1081.576, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/lqEzYDuTnvU/pics/lqEzYDuTnvU1081576.jpg'}, {'end': 1359.298, 'src': 'embed', 'start': 1333.866, 'weight': 5, 'content': [{'end': 1339.953, 'text': "I'm not saying that's something you show it on your resume, but then it gives you confidence that you did your first project.", 'start': 1333.866, 'duration': 6.087}, {'end': 1342.434, 'text': 'then you start working on more projects.', 'start': 1340.473, 'duration': 1.961}, {'end': 1345.495, 'text': 'So more projects, you can find it from Google.', 'start': 1342.474, 'duration': 3.021}, {'end': 1349.817, 'text': "I'm also planning to start a data analysis project series.", 'start': 1345.615, 'duration': 4.202}, {'end': 1355, 'text': "I will have my first project coming up very soon where we'll be doing Power BI visualization.", 'start': 1349.877, 'duration': 5.123}, {'end': 1359.298, 'text': 'So you can follow these resources for doing projects.', 'start': 1356.156, 'duration': 3.142}], 'summary': 'Start with small projects, gain confidence, and progress to more using online resources.', 'duration': 25.432, 'max_score': 1333.866, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/lqEzYDuTnvU/pics/lqEzYDuTnvU1333866.jpg'}], 'start': 893.343, 'title': "Job search and bcom studies' impact", 'summary': 'Discusses the effectiveness of job portals like linkedin and naukri, emphasizing their usefulness for job search in india and the us. it also delves into the relevance of bcom studies for a data analyst job, highlighting the importance of mathematics, statistics, domain knowledge, probability, normal distribution, excel skills, patience, and project-based learning for transitioning into the field.', 'chapters': [{'end': 998.307, 'start': 893.343, 'title': 'Job search and portals', 'summary': 'Discusses the effectiveness of job portals for job search, with an emphasis on linkedin and naukri, highlighting their usefulness and the perspective from india, and also mentions job portals for the us.', 'duration': 104.964, 'highlights': ['LinkedIn is the most efficient job portal for research and job applications, with many companies posting jobs there. LinkedIn is highlighted as the most efficient job portal for research and job applications, with many companies posting jobs on the platform.', 'Naukri is a helpful job portal in India, with examples of friends who have successfully found jobs through it. Naukri is highlighted as a helpful job portal in India, with examples of friends who have successfully found jobs through it.', 'Indeed.com and Monster are mentioned as job portals for job search in the US. Indeed.com and Monster are mentioned as job portals for job search in the US, providing alternative options for job search in the US.']}, {'end': 1376.908, 'start': 998.347, 'title': 'Impact of bcom studies on data analyst job', 'summary': 'Discusses the relevance of bcom studies in preparing for a data analyst job, highlighting the importance of mathematics, statistics, and domain knowledge, with emphasis on skills like probability, normal distribution, and excel, as well as the need for patience and project-based learning for transitioning into the field.', 'duration': 378.561, 'highlights': ['The relevance of BCom studies in preparing for a data analyst job, emphasizing the importance of mathematics, statistics, and domain knowledge. The speaker highlights the value of BCom studies in providing essential skills such as mathematics, statistics, and domain knowledge, particularly in fields like banking and insurance.', 'The importance of skills like probability, normal distribution, and Excel in the context of a data analyst job. The speaker emphasizes the significance of skills like probability, normal distribution, and Excel in the context of a data analyst job, showcasing their practical application in data analysis tasks.', 'The need for patience and project-based learning when transitioning into the data analyst field from other backgrounds, with a focus on building confidence through project showcase. The speaker stresses the importance of patience and project-based learning when transitioning into the data analyst field from other backgrounds, highlighting the need to build confidence through project showcase and the time it takes to transition.']}], 'duration': 483.565, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/lqEzYDuTnvU/pics/lqEzYDuTnvU893343.jpg', 'highlights': ['LinkedIn is the most efficient job portal for research and job applications, with many companies posting jobs there.', 'Naukri is a helpful job portal in India, with examples of friends who have successfully found jobs through it.', 'Indeed.com and Monster are mentioned as job portals for job search in the US.', 'The relevance of BCom studies in preparing for a data analyst job, emphasizing the importance of mathematics, statistics, and domain knowledge.', 'The importance of skills like probability, normal distribution, and Excel in the context of a data analyst job.', 'The need for patience and project-based learning when transitioning into the data analyst field from other backgrounds, with a focus on building confidence through project showcase.']}, {'end': 1774.741, 'segs': [{'end': 1402.846, 'src': 'embed', 'start': 1377.408, 'weight': 0, 'content': [{'end': 1382.011, 'text': 'So building the project portfolio is not as hard as we think it is.', 'start': 1377.408, 'duration': 4.603}, {'end': 1383.472, 'text': 'Right All right.', 'start': 1382.751, 'duration': 0.721}, {'end': 1392.318, 'text': "So let's move on to the next topic, which is what challenges did you face when transitioning to data analyst career from become background?", 'start': 1383.492, 'duration': 8.826}, {'end': 1395.38, 'text': 'You mentioned one thing, which is you need to have a lot of patience.', 'start': 1392.418, 'duration': 2.962}, {'end': 1397.662, 'text': 'Right You waited for five months.', 'start': 1395.881, 'duration': 1.781}, {'end': 1402.846, 'text': 'But other than that, like, did you have any other challenges that you want to mention?', 'start': 1398.042, 'duration': 4.804}], 'summary': 'Transitioning to data analyst career requires patience and facing challenges.', 'duration': 25.438, 'max_score': 1377.408, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/lqEzYDuTnvU/pics/lqEzYDuTnvU1377408.jpg'}, {'end': 1491.024, 'src': 'embed', 'start': 1457.671, 'weight': 2, 'content': [{'end': 1460.512, 'text': 'So you had great connections who are already in this field.', 'start': 1457.671, 'duration': 2.841}, {'end': 1470.076, 'text': "Now, let's say if you are from a small town and if you don't have friends who are in data analyst field, what I suggest them is, okay, go to LinkedIn.", 'start': 1461.012, 'duration': 9.064}, {'end': 1475.454, 'text': 'try to build a relationship with people who are in data analysis field.', 'start': 1470.711, 'duration': 4.743}, {'end': 1481.818, 'text': 'And by building those relationships, you will gain a lot of knowledge actually.', 'start': 1475.934, 'duration': 5.884}, {'end': 1491.024, 'text': 'So that is probably one way that you can build connections and you can utilize those connections whenever you want to transition.', 'start': 1482.398, 'duration': 8.626}], 'summary': 'Leverage linkedin to build connections for transitioning into data analysis field.', 'duration': 33.353, 'max_score': 1457.671, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/lqEzYDuTnvU/pics/lqEzYDuTnvU1457671.jpg'}, {'end': 1602.463, 'src': 'embed', 'start': 1566.377, 'weight': 1, 'content': [{'end': 1567.898, 'text': 'You can hear me, right? Yep.', 'start': 1566.377, 'duration': 1.521}, {'end': 1570.44, 'text': 'Okay Yeah.', 'start': 1570.02, 'duration': 0.42}, {'end': 1575.984, 'text': 'So anyone who is looking for a transition, so from a BCom or say anything,', 'start': 1570.46, 'duration': 5.524}, {'end': 1583.549, 'text': "maybe if it's engineering from any field that they're looking for a transition into data analysis or data science field,", 'start': 1575.984, 'duration': 7.565}, {'end': 1592.639, 'text': 'The primary thing that they would focus on, as per my view, would be trying to gain more and more knowledge on the skills.', 'start': 1584.076, 'duration': 8.563}, {'end': 1602.463, 'text': 'So once they have the skills that they possess, primarily these would be the three things that they would try to gain.', 'start': 1593.339, 'duration': 9.124}], 'summary': 'Transition from bcom or engineering to data field: focus on gaining skills.', 'duration': 36.086, 'max_score': 1566.377, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/lqEzYDuTnvU/pics/lqEzYDuTnvU1566377.jpg'}, {'end': 1627.428, 'src': 'heatmap', 'start': 1593.339, 'weight': 1, 'content': [{'end': 1602.463, 'text': 'So once they have the skills that they possess, primarily these would be the three things that they would try to gain.', 'start': 1593.339, 'duration': 9.124}, {'end': 1611.026, 'text': 'First would be a language that could be any language, Python or any other language of their choice, majorly R and Python.', 'start': 1603.003, 'duration': 8.023}, {'end': 1624.066, 'text': 'Secondly, they can choose a visualization tool, maybe Power BI Tableau, Alteryx, any one of these and a database out of which the most common is SQL.', 'start': 1612.16, 'duration': 11.906}, {'end': 1627.428, 'text': "It's fairly simple to learn SQL.", 'start': 1625.107, 'duration': 2.321}], 'summary': 'Learn r and python, use power bi, tableau, or alteryx for visualization, and master sql for effective data analysis.', 'duration': 34.089, 'max_score': 1593.339, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/lqEzYDuTnvU/pics/lqEzYDuTnvU1593339.jpg'}, {'end': 1712.348, 'src': 'embed', 'start': 1657.114, 'weight': 3, 'content': [{'end': 1665.159, 'text': 'how much of the skill that you have tried to learn, how much have you actually grasped out of it?', 'start': 1657.114, 'duration': 8.045}, {'end': 1674.93, 'text': "So with time, you build more projects, you gain more knowledge, and that's how you showcase more and more projects.", 'start': 1666.305, 'duration': 8.625}, {'end': 1685.537, 'text': "Whenever there's a chance of getting an interview or getting a call from interview, at least whenever you'll have, say, minimum five projects,", 'start': 1676.571, 'duration': 8.966}, {'end': 1692.001, 'text': 'you can speak confidently that these are the skills that I have mentioned on my resume and I possess these.', 'start': 1685.537, 'duration': 6.464}, {'end': 1693.402, 'text': 'I see.', 'start': 1693.082, 'duration': 0.32}, {'end': 1694.383, 'text': 'Got it.', 'start': 1694.062, 'duration': 0.321}, {'end': 1694.723, 'text': 'Got it.', 'start': 1694.423, 'duration': 0.3}, {'end': 1706.323, 'text': 'So the next topic is how easy is it to enter data analysis field with a become background because many people think it is extremely difficult.', 'start': 1696.817, 'duration': 9.506}, {'end': 1709.646, 'text': 'Sometimes people think even is it even possible.', 'start': 1706.644, 'duration': 3.002}, {'end': 1712.348, 'text': 'So do you want to share some lights on that.', 'start': 1710.346, 'duration': 2.002}], 'summary': 'Building at least five projects can help showcase skills confidently in interviews for data analysis field.', 'duration': 55.234, 'max_score': 1657.114, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/lqEzYDuTnvU/pics/lqEzYDuTnvU1657114.jpg'}], 'start': 1377.408, 'title': 'Transitioning to data analyst career', 'summary': 'Discusses challenges, importance of connections, patience, skills, and utilizing linkedin for building relationships in transitioning to a data analyst career, emphasizing the value of practical skills and the feasibility of entering the field with a non-technical background.', 'chapters': [{'end': 1506.599, 'start': 1377.408, 'title': 'Transitioning to data analyst career', 'summary': 'Discusses the challenges faced and the importance of connections in transitioning to a data analyst career, emphasizing the value of patience, skills, and connections, with a specific mention of utilizing linkedin for building relationships.', 'duration': 129.191, 'highlights': ["Transitioning to data analyst career requires patience and skills, as illustrated by the speaker's five-month wait and the guidance received from friends in the field.", 'The speaker emphasizes the value of connections in the data analyst field, highlighting the use of LinkedIn for building relationships and gaining knowledge.', 'The chapter underlines the importance of utilizing LinkedIn for finding a job or building connections in the data analyst field.']}, {'end': 1774.741, 'start': 1506.599, 'title': 'Transitioning to data analysis field', 'summary': 'Discusses the steps and skills required for transitioning to the data analysis field, emphasizing the importance of learning specific languages, visualization tools, and databases, as well as the significance of practical application through project work. it also addresses the feasibility of entering the data analysis field with a non-technical background.', 'duration': 268.142, 'highlights': ['The primary focus for transitioning into data analysis or data science field should be on gaining knowledge on specific skills including programming languages such as Python and R, visualization tools like Power BI or Tableau, and databases mainly SQL. Emphasizes the importance of learning specific skills such as programming languages (Python, R), visualization tools (Power BI, Tableau), and databases (SQL) for transitioning into data analysis or data science field.', 'Practical application of learned skills through project work is essential to showcase proficiency and gain confidence during interviews, with a recommendation of having a minimum of five projects to demonstrate expertise. Stresses the significance of practical application through project work to showcase proficiency and gain confidence during interviews, suggesting a minimum of five projects to demonstrate expertise.', 'Entering the data analysis field with a non-technical background is feasible, but requires patience, ability to grasp new concepts, and the focus on learning and applying relevant skills. Addresses the feasibility of entering the data analysis field with a non-technical background, emphasizing the importance of patience, ability to grasp new concepts, and the focus on learning and applying relevant skills.']}], 'duration': 397.333, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/lqEzYDuTnvU/pics/lqEzYDuTnvU1377408.jpg', 'highlights': ["Transitioning to data analyst career requires patience and skills, as illustrated by the speaker's five-month wait and the guidance received from friends in the field.", 'The primary focus for transitioning into data analysis or data science field should be on gaining knowledge on specific skills including programming languages such as Python and R, visualization tools like Power BI or Tableau, and databases mainly SQL.', 'The speaker emphasizes the value of connections in the data analyst field, highlighting the use of LinkedIn for building relationships and gaining knowledge.', 'Practical application of learned skills through project work is essential to showcase proficiency and gain confidence during interviews, with a recommendation of having a minimum of five projects to demonstrate expertise.', 'Entering the data analysis field with a non-technical background is feasible, but requires patience, ability to grasp new concepts, and the focus on learning and applying relevant skills.', 'The chapter underlines the importance of utilizing LinkedIn for finding a job or building connections in the data analyst field.']}, {'end': 2355.527, 'segs': [{'end': 1828.176, 'src': 'embed', 'start': 1800.515, 'weight': 1, 'content': [{'end': 1811.079, 'text': 'but, uh, at the same time, you know we are at short of the skill as globally, when we look at the problems, the data,', 'start': 1800.515, 'duration': 10.564}, {'end': 1816.648, 'text': 'that at what rate that it is growing, We are definitely short of skilled people.', 'start': 1811.079, 'duration': 5.569}, {'end': 1822.852, 'text': 'So the companies are also becoming lenient while looking for the targeted roles.', 'start': 1817.068, 'duration': 5.784}, {'end': 1828.176, 'text': 'Previously, it was only the focus that they are specifically looking for engineers only.', 'start': 1823.292, 'duration': 4.884}], 'summary': 'Global skill shortage impacting companies, with leniency in targeted roles.', 'duration': 27.661, 'max_score': 1800.515, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/lqEzYDuTnvU/pics/lqEzYDuTnvU1800515.jpg'}, {'end': 2047.062, 'src': 'embed', 'start': 2018.027, 'weight': 0, 'content': [{'end': 2025.092, 'text': 'Companies are not having a lot of cash to hire data scientists, data analysts.', 'start': 2018.027, 'duration': 7.065}, {'end': 2032.717, 'text': "So the economy is in such a way that there's not a lot of liquidity at the moment.", 'start': 2025.593, 'duration': 7.124}, {'end': 2044.88, 'text': 'But as the situation would develop, I think the demand for data science, data analysis would still be at par or, as expected by the experts,', 'start': 2033.498, 'duration': 11.382}, {'end': 2047.062, 'text': 'it would reach that mark.', 'start': 2044.88, 'duration': 2.182}], 'summary': 'Limited cash hinders hiring data experts; demand expected to rise.', 'duration': 29.035, 'max_score': 2018.027, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/lqEzYDuTnvU/pics/lqEzYDuTnvU2018027.jpg'}, {'end': 2315.032, 'src': 'heatmap', 'start': 2267.853, 'weight': 3, 'content': [{'end': 2276.279, 'text': 'okay. so patience, skill, skill development and connection, these are the three keys that, uh hitesh would give and based on our current conversation,', 'start': 2267.853, 'duration': 8.426}, {'end': 2284.365, 'text': 'i can even summarize the specific technical skills which is as a data analyst, you always, uh, if you are targeting data analyst career,', 'start': 2276.279, 'duration': 8.086}, {'end': 2285.686, 'text': 'you always start with excel.', 'start': 2284.365, 'duration': 1.321}, {'end': 2292.011, 'text': 'you need to be good in excel, different graphing, vba, pivot table, all those skills you need to learn.', 'start': 2285.686, 'duration': 6.325}, {'end': 2293.912, 'text': 'then you can move to some visualization.', 'start': 2292.011, 'duration': 1.901}, {'end': 2303.081, 'text': 'power bi tableau are the most popular power bi being adopted even more in the organization who have Microsoft ecosystem.', 'start': 2293.912, 'duration': 9.169}, {'end': 2311.889, 'text': 'and then the third skill is SQL and of course, communication, good English communication, storytelling skills, business domain knowledge,', 'start': 2303.081, 'duration': 8.808}, {'end': 2315.032, 'text': 'if which you will have if you are coming from, become background right.', 'start': 2311.889, 'duration': 3.143}], 'summary': 'Hitesh emphasizes patience, skill development, and connection as key for data analysts. technical skills include excel, power bi/tableau, and sql, along with communication and business domain knowledge.', 'duration': 47.179, 'max_score': 2267.853, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/lqEzYDuTnvU/pics/lqEzYDuTnvU2267853.jpg'}], 'start': 1774.741, 'title': 'Data science and data analyst career advice', 'summary': "Covers the demand for data analysts, pandemic's impact on hiring, future prospects, shortage of skilled professionals, leniency in hiring for non-traditional backgrounds, and long-term potential. it also provides career advice, emphasizing patience, skill development, technical skills like excel, power bi, tableau, sql, communication, and business domain knowledge.", 'chapters': [{'end': 2165.203, 'start': 1774.741, 'title': 'Data science: demand and future', 'summary': 'Discusses the demand for data analysts, the impact of pandemic on hiring, and the future prospects for data science, highlighting the shortage of skilled professionals, the leniency in hiring for non-traditional backgrounds, and the long-term potential driven by data-driven decision making.', 'duration': 390.462, 'highlights': ['There is a shortage of skilled data professionals globally as the rate of data growth is outpacing the availability of skilled individuals. The speaker highlights the shortage of skilled data professionals globally due to the rapid growth of data, indicating a high demand for data analysts.', 'Companies are becoming lenient in hiring and considering candidates from non-traditional backgrounds such as BCOM and CA for data analyst roles due to high demand. The leniency in hiring for non-traditional backgrounds such as BCOM and CA is driven by the high demand for data analysts, indicating a shift in hiring norms.', 'The impact of the pandemic has caused a decline in hiring and liquidity, affecting the demand for data science and data analysis, but the long-term future for the field is bright due to the increasing importance of data-driven decision making in businesses. The pandemic has caused a decline in hiring and liquidity, impacting the demand for data science and data analysis in the short term, but the speaker emphasizes the bright long-term future driven by the increasing importance of data-driven decision making in businesses.']}, {'end': 2355.527, 'start': 2165.683, 'title': 'Career advice for data analysts', 'summary': 'Discusses the bright future of the data analyst field, emphasizing the importance of patience, skill development, and specific technical skills such as excel, power bi, tableau, and sql, as well as communication and business domain knowledge.', 'duration': 189.844, 'highlights': ['The future of the data analyst field is very bright, requiring patience, skill development, and specific technical skills like Excel, Power BI, Tableau, and SQL, as well as communication and business domain knowledge. The future of the data analyst field is emphasized as very bright, with an emphasis on the importance of patience, skill development, and specific technical skills like Excel, Power BI, Tableau, and SQL, as well as communication and business domain knowledge.', 'Emphasizing the importance of patience, skill development, and working on projects to gain hands-on training and knowledge, which is crucial for entering the data analyst field. The importance of patience, skill development, and working on projects to gain hands-on training and knowledge is emphasized as crucial for entering the data analyst field.', 'Specific technical skills required for a data analyst role include proficiency in Excel, Power BI, Tableau, and SQL, as well as good English communication, storytelling skills, and business domain knowledge. The specific technical skills required for a data analyst role are highlighted, including proficiency in Excel, Power BI, Tableau, and SQL, as well as good English communication, storytelling skills, and business domain knowledge.']}], 'duration': 580.786, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/lqEzYDuTnvU/pics/lqEzYDuTnvU1774741.jpg', 'highlights': ['High demand for data analysts due to shortage of skilled professionals globally.', 'Companies are becoming lenient in hiring for data analyst roles, considering candidates from non-traditional backgrounds.', 'Pandemic caused a decline in hiring and liquidity, but the long-term future for data analysis is bright due to the increasing importance of data-driven decision making in businesses.', 'The future of the data analyst field requires patience, skill development, and specific technical skills like Excel, Power BI, Tableau, and SQL, as well as communication and business domain knowledge.', 'Emphasizing the importance of patience, skill development, and working on projects to gain hands-on training and knowledge crucial for entering the data analyst field.', 'Specific technical skills required for a data analyst role include proficiency in Excel, Power BI, Tableau, and SQL, as well as good English communication, storytelling skills, and business domain knowledge.']}], 'highlights': ["Hitesh talreja's journey from bcom to senior data analyst is detailed, emphasizing excel and power bi use, challenges faced, and the value of practical skills.", 'The transition to data science, challenges of online learning, and advice for career transition are also discussed, highlighting the demand for data analysts and the importance of technical skills, patience, and business domain knowledge.', "The individual's experience underscores the message that academic performance is not always indicative of real-life success, offering inspiration to those who may not perform well academically.", 'The importance of practical skills and continuous learning in the real world is emphasized through the story of a successful data analyst who struggled academically in college, earning low grades, and later excelling in the field.', 'Acquiring Python, R, and Excel skills and joining a course to enhance visualization skills.', 'Job search and acquiring a data analyst role after five months, aided by project experience.', 'Success in the interview process at the startup due to prior skills and project experience.', 'LinkedIn is the most efficient job portal for research and job applications, with many companies posting jobs there.', 'The relevance of BCom studies in preparing for a data analyst job, emphasizing the importance of mathematics, statistics, and domain knowledge.', 'The need for patience and project-based learning when transitioning into the data analyst field from other backgrounds, with a focus on building confidence through project showcase.', "Transitioning to data analyst career requires patience and skills, as illustrated by the speaker's five-month wait and the guidance received from friends in the field.", 'The primary focus for transitioning into data analysis or data science field should be on gaining knowledge on specific skills including programming languages such as Python and R, visualization tools like Power BI or Tableau, and databases mainly SQL.', 'The speaker emphasizes the value of connections in the data analyst field, highlighting the use of LinkedIn for building relationships and gaining knowledge.', 'Practical application of learned skills through project work is essential to showcase proficiency and gain confidence during interviews, with a recommendation of having a minimum of five projects to demonstrate expertise.', 'Entering the data analysis field with a non-technical background is feasible, but requires patience, ability to grasp new concepts, and the focus on learning and applying relevant skills.', 'The chapter underlines the importance of utilizing LinkedIn for finding a job or building connections in the data analyst field.', 'High demand for data analysts due to shortage of skilled professionals globally.', 'Companies are becoming lenient in hiring for data analyst roles, considering candidates from non-traditional backgrounds.', 'Pandemic caused a decline in hiring and liquidity, but the long-term future for data analysis is bright due to the increasing importance of data-driven decision making in businesses.', 'The future of the data analyst field requires patience, skill development, and specific technical skills like Excel, Power BI, Tableau, and SQL, as well as communication and business domain knowledge.', 'Emphasizing the importance of patience, skill development, and working on projects to gain hands-on training and knowledge crucial for entering the data analyst field.', 'Specific technical skills required for a data analyst role include proficiency in Excel, Power BI, Tableau, and SQL, as well as good English communication, storytelling skills, and business domain knowledge.']}