title
How I Changed Careers to Become a Data Analyst | Alex The Analyst Show | Episode 2

description
Today I go in-depth about how I changed careers to become a Data Analyst. I definitely didn't start out my career thinking I would ever be a Data Analyst. In fact, I didn't really know what that was, but here I am a few years later with a completely different career and future. I hope this videos gives you some ideas on things you can do to change careers as well! ____________________________________________ SUPPORT MY CHANNEL - PATREON Patreon Page - https://www.patreon.com/AlexTheAnalyst Every dollar donated is put back into my channel to make my videos even better. Thank you all so much for your support! ____________________________________________ SUBSCRIBE! Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content! ____________________________________________ Introduction 0:00 First Job 2:40 First Data Job 3:45 First REAL Data Analyst Job 10:00 Starting at a Fortune 500 Company 23:00 Support the Channel and Max 31:48 First Promotion 33:20 Main Tips from Video 35:00 Question of the Week 37:15 ____________________________________________ RESOURCES: Coursera Courses: Google Data Analyst Certification: https://coursera.pxf.io/5bBd62 Data Analysis with Python - https://coursera.pxf.io/BXY3Wy IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR Tableau Data Visualization - https://coursera.pxf.io/MXYqaN Udemy Courses: Python for Data Analysis and Visualization- https://bit.ly/3hhX4LX Statistics for Data Science - https://bit.ly/37jqDbq SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij Tableau A-Z - http://bit.ly/385lYvN Favorite Books: Python for Data Analysis Book - https://amzn.to/3dDneGq SQL Beginner's Guide to Managing and Analyzing With SQL Book - https://amzn.to/2X5341B *Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!* ____________________________________________ Websites: GitHub: https://github.com/AlexTheAnalyst ____________________________________________ *All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*

detail
{'title': 'How I Changed Careers to Become a Data Analyst | Alex The Analyst Show | Episode 2', 'heatmap': [{'end': 281.233, 'start': 220.692, 'weight': 0.892}, {'end': 589.364, 'start': 563.952, 'weight': 0.779}, {'end': 908.766, 'start': 879.079, 'weight': 0.725}, {'end': 1277.775, 'start': 1249.403, 'weight': 0.81}, {'end': 1843.763, 'start': 1813.612, 'weight': 1}, {'end': 2166.351, 'start': 2110.658, 'weight': 0.778}], 'summary': 'Alex shares his journey from recreational therapy to becoming a data analyst, detailing ups and downs, including transitioning to a healthcare analytics role, self-learning python and sql, and automating database gap analysis, leading to a $100,000 salary offer and providing valuable advice for aspiring data analysts.', 'chapters': [{'end': 105.823, 'segs': [{'end': 39.044, 'src': 'embed', 'start': 14.093, 'weight': 1, 'content': [{'end': 21.915, 'text': "It's from people who are teachers or nurses or accountants who want to pivot their careers or completely change their careers to become a data analyst.", 'start': 14.093, 'duration': 7.822}, {'end': 26.336, 'text': 'And, you know, they ask me for tips and they ask me for advice on what they should do.', 'start': 22.575, 'duration': 3.761}, {'end': 34.641, 'text': 'And so I thought that you know this is a good time, a good place to really go in depth into how I was able to make that change, the things that I did,', 'start': 27.136, 'duration': 7.505}, {'end': 35.642, 'text': 'the timeframes.', 'start': 34.641, 'duration': 1.001}, {'end': 39.044, 'text': 'And so hopefully, along this, in this video,', 'start': 35.702, 'duration': 3.342}], 'summary': 'Professionals seeking career change to data analyst seek advice and tips from the speaker.', 'duration': 24.951, 'max_score': 14.093, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o14093.jpg'}, {'end': 86.228, 'src': 'embed', 'start': 63.781, 'weight': 0, 'content': [{'end': 71.566, 'text': 'useful video that you know people can actually learn something from and apply to their own journeys and end careers as well.', 'start': 63.781, 'duration': 7.785}, {'end': 79.212, 'text': "so let's start at the very beginning of my you know career, which was i have a degree in recreational therapy.", 'start': 71.566, 'duration': 7.646}, {'end': 81.624, 'text': "you don't know what that is.", 'start': 80.183, 'duration': 1.441}, {'end': 82.405, 'text': "don't be surprised.", 'start': 81.624, 'duration': 0.781}, {'end': 86.228, 'text': 'i had no idea what it was when i first got into college.', 'start': 82.405, 'duration': 3.823}], 'summary': 'Speaker discusses starting career with a degree in recreational therapy.', 'duration': 22.447, 'max_score': 63.781, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o63781.jpg'}], 'start': 0.269, 'title': 'Transitioning to data analyst', 'summary': 'Discusses the journey of transitioning from recreational therapy to becoming a data analyst, providing insights and advice for individuals looking to pivot their careers, covering the progression from the initial degree to the current job.', 'chapters': [{'end': 105.823, 'start': 0.269, 'title': 'Transitioning to data analyst', 'summary': 'Discusses the journey of transitioning from recreational therapy to becoming a data analyst, providing insights and advice for individuals looking to pivot their careers, covering the progression from the initial degree to the current job.', 'duration': 105.554, 'highlights': ['Transitioning from recreational therapy to data analyst The chapter delves into the transition from a degree in recreational therapy to becoming a data analyst, offering insights into the career shift.', 'Insights and advice for career pivot The discussion provides valuable insights and advice for individuals seeking to pivot their careers, particularly for those looking to shift to a data analyst role.', 'Progression from initial degree to current job The chapter covers the progression from the initial degree in recreational therapy to the current data analyst role, offering a detailed account of the journey.']}], 'duration': 105.554, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o269.jpg', 'highlights': ['Progression from initial degree to current job The chapter covers the progression from the initial degree in recreational therapy to the current data analyst role, offering a detailed account of the journey.', 'Insights and advice for career pivot The discussion provides valuable insights and advice for individuals seeking to pivot their careers, particularly for those looking to shift to a data analyst role.', 'Transitioning from recreational therapy to data analyst The chapter delves into the transition from a degree in recreational therapy to becoming a data analyst, offering insights into the career shift.']}, {'end': 506.617, 'segs': [{'end': 128.816, 'src': 'embed', 'start': 106.94, 'weight': 0, 'content': [{'end': 115.914, 'text': "So I moved to Dallas Texas right after college for an internship and then I had plans to work a little bit and then get into a master's program.", 'start': 106.94, 'duration': 8.974}, {'end': 119.08, 'text': "So just to set the stage, that's kind of where I was.", 'start': 116.195, 'duration': 2.885}, {'end': 128.816, 'text': "And so I get here, I'm doing my internship, and lo and behold, I decide to go out and I meet a girl.", 'start': 120.492, 'duration': 8.324}], 'summary': "Moved to dallas for internship, planned to work and pursue master's program. met a girl during internship.", 'duration': 21.876, 'max_score': 106.94, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o106940.jpg'}, {'end': 284.014, 'src': 'heatmap', 'start': 215.97, 'weight': 2, 'content': [{'end': 220.512, 'text': "you know, I'm making, I'm building relationships, even though I'm in basically the lowest position at the entire nonprofit.", 'start': 215.97, 'duration': 4.542}, {'end': 223.653, 'text': "And so, you know, I'm building relationships, I'm getting to know people.", 'start': 220.692, 'duration': 2.961}, {'end': 229.435, 'text': 'And a job comes up, which was a data collection specialist and analyst.', 'start': 224.393, 'duration': 5.042}, {'end': 233.896, 'text': 'Now, my girlfriend at the time, my now wife, said, hey, you should apply for that job.', 'start': 229.775, 'duration': 4.121}, {'end': 236.257, 'text': "And I was like, I don't know what that means at all.", 'start': 233.976, 'duration': 2.281}, {'end': 238.738, 'text': 'I have no idea what any of those words are.', 'start': 236.557, 'duration': 2.181}, {'end': 243.74, 'text': "I don't, I guess I kind of know what data is, have no idea what this job would entail.", 'start': 238.758, 'duration': 4.982}, {'end': 249.084, 'text': 'But I looked at the job description and it was basically just working in Excel.', 'start': 244.6, 'duration': 4.484}, {'end': 254.81, 'text': 'It was collecting numbers from different departments and putting them together and it seemed really easy.', 'start': 249.545, 'duration': 5.265}, {'end': 265.228, 'text': 'So I completely reformatted my resume, I applied, and lo and behold, I was the only applicant and I got the job.', 'start': 255.945, 'duration': 9.283}, {'end': 274.371, 'text': "And so this is where the whole story of how I became who I am today career-wise, that's how it all happened.", 'start': 265.708, 'duration': 8.663}, {'end': 281.233, 'text': 'It was me desperately needing more money because I wanted to marry this girl, and she kind of pushed me to just apply,', 'start': 274.611, 'duration': 6.622}, {'end': 284.014, 'text': 'even though I thought there was no way I was gonna get this job.', 'start': 281.233, 'duration': 2.781}], 'summary': 'Started as lowest position, applied for data job, only applicant, got hired, led to career success.', 'duration': 68.044, 'max_score': 215.97, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o215970.jpg'}, {'end': 281.233, 'src': 'embed', 'start': 255.945, 'weight': 3, 'content': [{'end': 265.228, 'text': 'So I completely reformatted my resume, I applied, and lo and behold, I was the only applicant and I got the job.', 'start': 255.945, 'duration': 9.283}, {'end': 274.371, 'text': "And so this is where the whole story of how I became who I am today career-wise, that's how it all happened.", 'start': 265.708, 'duration': 8.663}, {'end': 281.233, 'text': 'It was me desperately needing more money because I wanted to marry this girl, and she kind of pushed me to just apply,', 'start': 274.611, 'duration': 6.622}], 'summary': 'Reformatted resume, only applicant, got the job, needed money to marry.', 'duration': 25.288, 'max_score': 255.945, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o255945.jpg'}, {'end': 506.617, 'src': 'embed', 'start': 462.616, 'weight': 1, 'content': [{'end': 468.318, 'text': 'I went through a very, very big phase where I was almost obsessed with learning about data analytics.', 'start': 462.616, 'duration': 5.702}, {'end': 470.218, 'text': 'That was my future.', 'start': 469.298, 'duration': 0.92}, {'end': 474.12, 'text': 'I had kind of decided in that moment, I was like, I need to get a job as a data analyst.', 'start': 470.238, 'duration': 3.882}, {'end': 477.504, 'text': "so you know, i'm in that job for six months.", 'start': 475.143, 'duration': 2.361}, {'end': 478.785, 'text': 'i started learning about it.', 'start': 477.504, 'duration': 1.281}, {'end': 483.588, 'text': 'over the next two or three months, um, things start going downhill in that job.', 'start': 478.785, 'duration': 4.803}, {'end': 488.09, 'text': "uh, the people i'm working with start to change.", 'start': 483.588, 'duration': 4.502}, {'end': 489.831, 'text': 'um starts to get a little bit toxic.', 'start': 488.09, 'duration': 1.741}, {'end': 494.454, 'text': "i would even say and um, you know, i'm talking to my wife about this, and she's like.", 'start': 489.831, 'duration': 4.623}, {'end': 498.055, 'text': 'you know, we, you know, you should try to find another job.', 'start': 494.454, 'duration': 3.601}, {'end': 500.711, 'text': "to be honest, She's like you need to find another job.", 'start': 498.055, 'duration': 2.656}, {'end': 504.875, 'text': "And there wasn't many options out there for me.", 'start': 502.072, 'duration': 2.803}, {'end': 506.617, 'text': 'I had a degree in recreational therapy.', 'start': 505.035, 'duration': 1.582}], 'summary': 'Obsessed with data analytics, job as data analyst, faced toxic work environment, advised to find another job.', 'duration': 44.001, 'max_score': 462.616, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o462616.jpg'}], 'start': 106.94, 'title': "Life's unexpected turn and career transformation", 'summary': "Narrates how the speaker's life took an unexpected turn after meeting his now wife during an internship, leading to a career shift to a data collection specialist and analyst role at a non-profit. it also details the transformation from desperation to obsession in striving to become a data analyst triggered by the discovery of sql.", 'chapters': [{'end': 254.81, 'start': 106.94, 'title': "Life's unexpected turn", 'summary': "Narrates how the speaker's life took an unexpected turn after meeting his now wife during an internship in dallas, leading to a change in career plans and eventual transition to a data collection specialist and analyst role at a non-profit, marking a significant shift from his initial career aspirations.", 'duration': 147.87, 'highlights': ["Met his now wife during an internship in Dallas, leading to a change in career plans. The speaker's life took a significant turn after meeting his now wife during an internship in Dallas, altering his initial career plans.", 'Transitioned to a data collection specialist and analyst role at a non-profit. The speaker transitioned to a data collection specialist and analyst role at a non-profit, showcasing a shift from his previous job at the non-profit as a caretaker.', 'Initial struggle with finding employment after the internship, leading to taking up a caretaker role at a non-profit. The speaker initially struggled to find employment, leading to taking up a caretaker role at a non-profit shelter, demonstrating the challenges he faced in establishing his career after the internship.']}, {'end': 506.617, 'start': 255.945, 'title': 'Career transformation: from desperation to obsession', 'summary': "Details the transformation of the speaker's career from a place of desperation and lack of career aspirations to becoming obsessed with learning about data analytics and striving to become a data analyst, triggered by the discovery of sql in a job as a data collection specialist and analyst.", 'duration': 250.672, 'highlights': ['The speaker landed a job as the only applicant, which propelled the transformation of his career. The speaker was the sole applicant for a job that led to the transformation of his career aspirations.', "Discovering SQL in his job as a data collection specialist and analyst sparked the speaker's obsession with learning about data analytics and striving to become a data analyst. Learning about SQL in the job as a data collection specialist and analyst ignited the speaker's enthusiasm and dedication to pursuing a career in data analytics.", 'The toxic work environment and a push from his wife led the speaker to seek another job, ultimately pursuing a career in data analytics. The toxic work environment and encouragement from his wife prompted the speaker to look for a new job, solidifying his decision to pursue a career in data analytics.']}], 'duration': 399.677, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o106940.jpg', 'highlights': ['Met his now wife during an internship in Dallas, leading to a change in career plans.', "Discovering SQL in his job as a data collection specialist and analyst sparked the speaker's obsession with learning about data analytics and striving to become a data analyst.", 'The speaker transitioned to a data collection specialist and analyst role at a non-profit, showcasing a shift from his previous job at the non-profit as a caretaker.', 'The speaker was the sole applicant for a job that led to the transformation of his career aspirations.', 'The toxic work environment and a push from his wife led the speaker to seek another job, ultimately pursuing a career in data analytics.']}, {'end': 1129.115, 'segs': [{'end': 589.364, 'src': 'heatmap', 'start': 563.952, 'weight': 0.779, 'content': [{'end': 568.993, 'text': "i didn't have really any domain knowledge or understanding of how the process worked at all.", 'start': 563.952, 'duration': 5.041}, {'end': 573.657, 'text': 'And so I felt, looking back, I basically knew nothing.', 'start': 569.915, 'duration': 3.742}, {'end': 574.977, 'text': "I knew SQL and that's about it.", 'start': 573.937, 'duration': 1.04}, {'end': 577.579, 'text': "I didn't even know how to use it in a production environment.", 'start': 575.618, 'duration': 1.961}, {'end': 580.28, 'text': "I didn't understand how to use it in a team or work with it in a team.", 'start': 577.799, 'duration': 2.481}, {'end': 583.441, 'text': "I just knew the syntax, right? So that's kind of where I was.", 'start': 580.32, 'duration': 3.121}, {'end': 589.364, 'text': "And my job starts taking a really big downhill turn and I'm like, I need to find another job.", 'start': 584.122, 'duration': 5.242}], 'summary': 'Struggled due to lack of domain knowledge, mainly knew sql, job situation deteriorated.', 'duration': 25.412, 'max_score': 563.952, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o563952.jpg'}, {'end': 621.353, 'src': 'embed', 'start': 594.806, 'weight': 0, 'content': [{'end': 606.459, 'text': "I probably applied to hundreds I'm talking like probably two to 300 jobs on LinkedIn, Glassdoor, Indeed, anything that was like entry level.", 'start': 594.806, 'duration': 11.653}, {'end': 607.2, 'text': 'I was applying for it.', 'start': 606.459, 'duration': 0.741}, {'end': 610.003, 'text': 'And so, give me one sec.', 'start': 608.281, 'duration': 1.722}, {'end': 612.625, 'text': 'And so I was applying for it.', 'start': 611.384, 'duration': 1.241}, {'end': 618.711, 'text': 'And I finally got messaged from this guy on LinkedIn.', 'start': 613.306, 'duration': 5.405}, {'end': 621.353, 'text': "And he was like, hey, I'm a recruiter in the Dallas area.", 'start': 619.051, 'duration': 2.302}], 'summary': 'Applied to 200-300 entry-level jobs, finally contacted by a recruiter in dallas.', 'duration': 26.547, 'max_score': 594.806, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o594806.jpg'}, {'end': 692.767, 'src': 'embed', 'start': 665.769, 'weight': 1, 'content': [{'end': 670.552, 'text': 'But genuinely, I worked with about five or six recruiters and he was the first one who reached out to me.', 'start': 665.769, 'duration': 4.783}, {'end': 673.894, 'text': 'And he was the first one I accepted my next job with.', 'start': 671.193, 'duration': 2.701}, {'end': 683.221, 'text': "But I'm working with the recruiters and I'm basically telling them like, look, The data collection specialist is mostly Excel.", 'start': 675.115, 'duration': 8.106}, {'end': 685.142, 'text': 'I have some SQL experience.', 'start': 683.401, 'duration': 1.741}, {'end': 687.143, 'text': "I'm trying to get a job that's just SQL.", 'start': 685.582, 'duration': 1.561}, {'end': 692.767, 'text': "I express that to them very honestly, because I don't want to get into a job where I have to know Python or data visualization,", 'start': 688.144, 'duration': 4.623}], 'summary': 'The speaker worked with five or six recruiters, the first of whom helped them secure their next job. they are seeking a job focused solely on sql and expressed this requirement honestly to their recruiters.', 'duration': 26.998, 'max_score': 665.769, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o665769.jpg'}, {'end': 733.067, 'src': 'embed', 'start': 706.037, 'weight': 2, 'content': [{'end': 713.239, 'text': "They were offering like $80,000, $90,000, and they were expecting, like machine learning and things that I didn't even know existed basically.", 'start': 706.037, 'duration': 7.202}, {'end': 717.781, 'text': 'And so, you know, I kept turning them down because I was, you know, they..', 'start': 714.2, 'duration': 3.581}, {'end': 720.954, 'text': "They weren't jobs that I was gonna get, and if I got it,", 'start': 718.772, 'duration': 2.182}, {'end': 726.921, 'text': "I would just get fired right away because I was not intelligent enough or I didn't have enough experience to understand it.", 'start': 720.954, 'duration': 5.967}, {'end': 733.067, 'text': 'So I finally got in contact with a healthcare analytics company.', 'start': 727.802, 'duration': 5.265}], 'summary': 'Turned down offers of $80,000-$90,000 due to lack of knowledge, found role in healthcare analytics.', 'duration': 27.03, 'max_score': 706.037, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o706037.jpg'}, {'end': 771.336, 'src': 'embed', 'start': 741.49, 'weight': 3, 'content': [{'end': 746.014, 'text': 'And so I was really able to leverage that and say I actually used to use EHRs.', 'start': 741.49, 'duration': 4.524}, {'end': 749.297, 'text': 'I know how they work, I know SQL, I know Excel.', 'start': 746.014, 'duration': 3.283}, {'end': 750.178, 'text': 'this would be a good fit for me.', 'start': 749.297, 'duration': 0.881}, {'end': 757.665, 'text': "And so I got the phone interview, that went really well, got the in-person interview, that kind of didn't go so great to be honest.", 'start': 750.418, 'duration': 7.247}, {'end': 762.969, 'text': 'The boss that I ended up having, he was the hiring person in the interview.', 'start': 758.866, 'duration': 4.103}, {'end': 771.336, 'text': 'And I remember, you know, he asked me some really simple questions that now, looking back, I 100% should have known and been prepared for,', 'start': 763.67, 'duration': 7.666}], 'summary': "Candidate leveraged ehr experience, had successful phone interview, but struggled in-person with boss's questions.", 'duration': 29.846, 'max_score': 741.49, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o741490.jpg'}, {'end': 908.766, 'src': 'heatmap', 'start': 879.079, 'weight': 0.725, 'content': [{'end': 888.942, 'text': "And I had my boss who was, I think the director of, I can't remember his title, but he was a huge mentor to me.", 'start': 879.079, 'duration': 9.863}, {'end': 894.633, 'text': 'And he really took me under my wing, under his wing, and he taught me SQL.', 'start': 890.449, 'duration': 4.184}, {'end': 897.196, 'text': 'He taught me a lot of really advanced things in Excel.', 'start': 894.833, 'duration': 2.363}, {'end': 906.144, 'text': 'And these are things that inevitably, not inevitably, but eventually became huge for me to know, became extremely important.', 'start': 898.036, 'duration': 8.108}, {'end': 908.766, 'text': "And I didn't even know, I didn't know these things.", 'start': 906.324, 'duration': 2.442}], 'summary': 'Mentor taught sql and advanced excel, crucial for career growth.', 'duration': 29.687, 'max_score': 879.079, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o879079.jpg'}, {'end': 952.985, 'src': 'embed', 'start': 925.064, 'weight': 4, 'content': [{'end': 930.128, 'text': 'I was starting studying everything about SQL Server, like every single thing I could find.', 'start': 925.064, 'duration': 5.064}, {'end': 936.912, 'text': 'By the time in two weeks when I got my new job, I had already taken like four courses on SQL Server.', 'start': 931.329, 'duration': 5.583}, {'end': 943.097, 'text': 'And so once I got into it, I was a little bit comfortable, but I was still very novice, very much beginner level.', 'start': 937.012, 'duration': 6.085}, {'end': 946.643, 'text': 'And so I stayed at that job for a whole year.', 'start': 944.062, 'duration': 2.581}, {'end': 952.985, 'text': 'And I say a whole year because I had no intention of leaving that job.', 'start': 948.323, 'duration': 4.662}], 'summary': 'Studied extensively, completed 4 sql server courses in 2 weeks, stayed at the beginner level job for a year', 'duration': 27.921, 'max_score': 925.064, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o925064.jpg'}, {'end': 1001.405, 'src': 'embed', 'start': 973.63, 'weight': 5, 'content': [{'end': 976.832, 'text': 'But I had really high by that time.', 'start': 973.63, 'duration': 3.202}, {'end': 981.795, 'text': 'once I started really getting into that job, I started realizing kind of the job market.', 'start': 976.832, 'duration': 4.963}, {'end': 989.039, 'text': 'I started realizing how much I probably could be worth, which at that time I was making $63,000, right?', 'start': 981.795, 'duration': 7.244}, {'end': 993.722, 'text': 'At the nonprofit I was making $47,000 as the data collection specialist and analyst.', 'start': 989.88, 'duration': 3.842}, {'end': 1001.405, 'text': 'as making like 32 or something like that, maybe 36 as the caretaker.', 'start': 995.023, 'duration': 6.382}], 'summary': 'Realized potential worth in job market, increased from $47,000 to $63,000.', 'duration': 27.775, 'max_score': 973.63, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o973630.jpg'}], 'start': 506.657, 'title': 'Career transition and upskilling', 'summary': 'Details the transition to a data analyst role, including self-learning sql, job application experiences, and working with recruiters. it also highlights the journey of transitioning into a healthcare analytics role, showcasing rapid upskilling and an increased salary from $47,000 to $76,000 amidst personal milestones.', 'chapters': [{'end': 720.954, 'start': 506.657, 'title': 'Transition to data analyst role', 'summary': 'Details the journey of transitioning to a data analyst role, including self-learning sql, job application experiences, and working with recruiters, ultimately aiming to secure a job primarily focused on sql with honest self-assessment and encountering high-paying job offers requiring advanced skills.', 'duration': 214.297, 'highlights': ['Applied to hundreds of entry-level jobs on various platforms like LinkedIn, Glassdoor, Indeed, and received a message from a recruiter in the Dallas area. Applied to 200-300 jobs on different platforms in pursuit of an entry-level position.', 'Engaged with multiple recruiters, with the first one playing a crucial role in securing the next job. Worked with around 5-6 recruiters, with the first recruiter being instrumental in landing the subsequent job.', 'Encountered phone interviews offering high salaries of $80,000-$90,000 but requiring skills beyond current capabilities, leading to turning down the opportunities. Received phone interview offers with high salaries but requiring advanced skills like machine learning, resulting in declining the offers.']}, {'end': 1129.115, 'start': 720.954, 'title': 'Navigating career transitions and upskilling', 'summary': "Highlights the journey of transitioning into a healthcare analytics role, showcasing the candidate's dedication, rapid upskilling, and increased salary from $47,000 to $76,000 amidst personal milestones such as marriage and impending parenthood.", 'duration': 408.161, 'highlights': ['The candidate transitioned into a healthcare analytics role, leveraging their healthcare background and skills in EHRs, SQL, and Excel, despite initial doubts about their technical knowledge. Transitioned into healthcare analytics role leveraging healthcare background and skills in EHRs, SQL, and Excel despite initial doubts about technical knowledge.', 'The candidate rapidly upskilled, taking four courses on SQL Server within two weeks of securing the job and receiving mentorship to advance their skills in SQL and Excel. Rapidly upskilled, taking four courses on SQL Server within two weeks of securing the job and receiving mentorship to advance skills in SQL and Excel.', "The candidate's salary increased from $47,000 to $63,000 in the nonprofit sector, then further to $76,000 in a junior data analyst position at a Fortune 500 company, emphasizing the financial progression during a transformative life stage involving marriage and impending parenthood. Salary increase from $47,000 to $63,000 in nonprofit sector, then to $76,000 in junior data analyst position at a Fortune 500 company during a transformative life stage involving marriage and impending parenthood."]}], 'duration': 622.458, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o506657.jpg', 'highlights': ['Applied to 200-300 jobs on different platforms in pursuit of an entry-level position.', 'Worked with around 5-6 recruiters, with the first recruiter being instrumental in landing the subsequent job.', 'Received phone interview offers with high salaries but requiring advanced skills like machine learning, resulting in declining the offers.', 'Transitioned into healthcare analytics role leveraging healthcare background and skills in EHRs, SQL, and Excel despite initial doubts about technical knowledge.', 'Rapidly upskilled, taking four courses on SQL Server within two weeks of securing the job and receiving mentorship to advance skills in SQL and Excel.', 'Salary increase from $47,000 to $63,000 in nonprofit sector, then to $76,000 in junior data analyst position at a Fortune 500 company during a transformative life stage involving marriage and impending parenthood.']}, {'end': 1636.079, 'segs': [{'end': 1173.039, 'src': 'embed', 'start': 1129.135, 'weight': 2, 'content': [{'end': 1136.12, 'text': 'To back it up just real quick before I tell you what I did there to back that up.', 'start': 1129.135, 'duration': 6.985}, {'end': 1142.045, 'text': 'while I was at this healthcare analytics company, I was also learning a ton in my spare time.', 'start': 1136.12, 'duration': 5.925}, {'end': 1146.388, 'text': 'I was learning Python, Tableau, Power BI, and we..', 'start': 1142.605, 'duration': 3.783}, {'end': 1154.052, 'text': 'We used Tableau at the job, and so I finally, near maybe like the six month mark at that job, I started to use it.', 'start': 1147.549, 'duration': 6.503}, {'end': 1157.493, 'text': "But we didn't use any Python, at least from my position.", 'start': 1154.772, 'duration': 2.721}, {'end': 1159.074, 'text': "We didn't use any Power BI.", 'start': 1157.933, 'duration': 1.141}, {'end': 1165.916, 'text': 'And so I was just learning those things 100% on my own, figuring out how to automate things, data visualization in Python, those kinds of things.', 'start': 1159.494, 'duration': 6.422}, {'end': 1167.677, 'text': 'And I did that for months.', 'start': 1166.436, 'duration': 1.241}, {'end': 1169.398, 'text': 'I mean, probably like six months.', 'start': 1168.057, 'duration': 1.341}, {'end': 1173.039, 'text': 'And Python to me was just another language.', 'start': 1170.318, 'duration': 2.721}], 'summary': 'Learned python, tableau, and power bi in spare time, used tableau at job after six months, self-taught for six months, became proficient in python.', 'duration': 43.904, 'max_score': 1129.135, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o1129135.jpg'}, {'end': 1253.204, 'src': 'embed', 'start': 1219.446, 'weight': 3, 'content': [{'end': 1221.347, 'text': "i didn't get my first job and just stopped learning.", 'start': 1219.446, 'duration': 1.901}, {'end': 1222.929, 'text': 'Try to learn on the job.', 'start': 1222.088, 'duration': 0.841}, {'end': 1226.892, 'text': 'As I was learning on the job, I was always taking tons of courses.', 'start': 1223.489, 'duration': 3.403}, {'end': 1234.737, 'text': 'And again semi obsessively, just continuing to grow my skill set, because I knew the more skills that I knew.', 'start': 1227.212, 'duration': 7.525}, {'end': 1238.56, 'text': 'if I knew Python, I knew it would increase my value in the market.', 'start': 1234.737, 'duration': 3.823}, {'end': 1239.461, 'text': 'I just knew that.', 'start': 1238.821, 'duration': 0.64}, {'end': 1245.065, 'text': "And that's how I thought of these things is the more I'm studying, the more I'm increasing my value and the more money I can make.", 'start': 1239.501, 'duration': 5.564}, {'end': 1246.606, 'text': 'That is 100% where my head was at.', 'start': 1245.425, 'duration': 1.181}, {'end': 1253.204, 'text': 'And so back to the, to the actual job is I got the interview.', 'start': 1249.403, 'duration': 3.801}], 'summary': 'Continuously learning on the job and taking courses increased skills and market value, leading to job interview success.', 'duration': 33.758, 'max_score': 1219.446, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o1219446.jpg'}, {'end': 1277.775, 'src': 'heatmap', 'start': 1249.403, 'weight': 0.81, 'content': [{'end': 1253.204, 'text': 'And so back to the, to the actual job is I got the interview.', 'start': 1249.403, 'duration': 3.801}, {'end': 1255.165, 'text': 'I went through three levels of interviews.', 'start': 1253.224, 'duration': 1.941}, {'end': 1257.906, 'text': 'Um, and you know they.', 'start': 1255.805, 'duration': 2.101}, {'end': 1270.79, 'text': 'they extended an offer and I had to choose do I want to be a junior data analyst at a very large company or do I want to be a data analyst right now but most likely get promoted to senior level data analyst?', 'start': 1257.906, 'duration': 12.884}, {'end': 1275.392, 'text': 'And, you know, they were, they, I remember them when I was one second.', 'start': 1271.01, 'duration': 4.382}, {'end': 1277.775, 'text': 'Sorry, I thought I heard something.', 'start': 1277.014, 'duration': 0.761}], 'summary': 'Interviewed for junior data analyst, offered promotion to senior level data analyst.', 'duration': 28.372, 'max_score': 1249.403, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o1249403.jpg'}, {'end': 1436.854, 'src': 'embed', 'start': 1388.126, 'weight': 0, 'content': [{'end': 1394.169, 'text': "And I was like, I get it, but I don't see how that is going to be beneficial to me in the long run of my career.", 'start': 1388.126, 'duration': 6.043}, {'end': 1405.294, 'text': 'And so I made a very difficult decision to take $76,000 hourly with the opportunity to get promoted, or the opportunity to go full-time.', 'start': 1395.049, 'duration': 10.245}, {'end': 1409.736, 'text': "That was the fear that I would get the part-time work and I wouldn't get the full-time work,", 'start': 1405.494, 'duration': 4.242}, {'end': 1412.377, 'text': 'and I would have missed out on this huge opportunity to make $100,000 right away.', 'start': 1409.736, 'duration': 2.641}, {'end': 1416.721, 'text': 'But I took the other job because I wanted the stability.', 'start': 1414.378, 'duration': 2.343}, {'end': 1422.427, 'text': 'I wanted to be a very large company, to grow at that company, to have that brand name.', 'start': 1416.741, 'duration': 5.686}, {'end': 1425.931, 'text': 'And I made the right decision.', 'start': 1423.228, 'duration': 2.703}, {'end': 1427.052, 'text': 'I really did.', 'start': 1426.491, 'duration': 0.561}, {'end': 1430.516, 'text': 'I really think in retrospect, looking back, I made the right decision.', 'start': 1427.072, 'duration': 3.444}, {'end': 1434.81, 'text': 'So I start the job.', 'start': 1431.966, 'duration': 2.844}, {'end': 1436.854, 'text': 'I am a junior data analyst.', 'start': 1434.83, 'duration': 2.024}], 'summary': 'Chose stability over immediate higher pay, took $76,000 hourly job to grow in a large company, and feels it was the right decision.', 'duration': 48.728, 'max_score': 1388.126, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o1388126.jpg'}, {'end': 1545.938, 'src': 'embed', 'start': 1513.208, 'weight': 5, 'content': [{'end': 1520.154, 'text': "That is my one thing that if anything fails, if anyone asks me, what's the best thing you're at? SQL Server.", 'start': 1513.208, 'duration': 6.946}, {'end': 1521.314, 'text': 'That is my thing.', 'start': 1520.714, 'duration': 0.6}, {'end': 1522.634, 'text': 'I love it.', 'start': 1522.114, 'duration': 0.52}, {'end': 1523.595, 'text': "I think it's amazing.", 'start': 1522.754, 'duration': 0.841}, {'end': 1527.315, 'text': 'I still stand by it to this day that it is fantastic and you should learn it.', 'start': 1523.995, 'duration': 3.32}, {'end': 1533.196, 'text': 'And I had been learning Python, so I knew quite a bit of Python as well.', 'start': 1528.755, 'duration': 4.441}, {'end': 1545.938, 'text': 'So I get into my role and I think I had a little bit of anxiety that I was going to, after I think it was a six month contract to hire.', 'start': 1533.656, 'duration': 12.282}], 'summary': 'Passionate about sql server, proficient in python, and transitioning to a new role after a six-month contract.', 'duration': 32.73, 'max_score': 1513.208, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o1513208.jpg'}], 'start': 1129.135, 'title': 'Data analytics career journey', 'summary': "Details the speaker's journey of self-learning python, tableau, and power bi, transitioning from a beginner to a junior data analyst, and making a career decision between a large company and a smaller one offering a director-level role, including a $100,000 salary offer. it also discusses the importance of stability and long-term career growth, leading to a successful career transition and a significant increase in income.", 'chapters': [{'end': 1323.141, 'start': 1129.135, 'title': 'Learning data analytics and career choices', 'summary': "Details the speaker's journey of self-learning python, tableau, and power bi, progressing from a beginner to a junior data analyst, and making a career decision between a large company and a smaller one offering a director-level role, including a $100,000 salary offer.", 'duration': 194.006, 'highlights': ['The speaker self-learned Python, Tableau, and Power BI, spending six months to gain proficiency, emphasizing the value of continuously learning and increasing skill set for market value and career growth.', 'The speaker chose between a junior data analyst position at a large company and a smaller company offering a potential director-level role, with the latter making a $100,000 salary offer to retain the speaker.', 'The speaker progressed from a beginner to a junior data analyst, demonstrating the impact of self-study and continuous learning on career advancement and market value.', "The speaker's journey involved learning Python, Tableau, and Power BI, showcasing the dedication to self-improvement and skill enhancement for career growth and increased market value."]}, {'end': 1636.079, 'start': 1323.742, 'title': 'Choosing stability over title', 'summary': 'Discusses the decision-making process of choosing a large company over a small one, emphasizing the importance of stability and long-term career growth, leading to a successful career transition and significant increase in income.', 'duration': 312.337, 'highlights': ['Opted for a junior data analyst role at a large company over a higher role at a small company to prioritize stability and long-term career growth. The speaker chose to take on a junior data analyst role at a large company over a higher role at a small company to prioritize stability and long-term career growth, considering potential future job prospects and opportunities.', 'Accepted a $76,000 hourly position with opportunities for promotion and full-time employment, leading to a successful career transition and increased income. The decision to accept a $76,000 hourly position with opportunities for promotion and full-time employment led to a successful career transition and a significant increase in income.', 'Focused on excelling in the role, mastering SQL Server and learning Python to optimize value and ensure full-time employment, resulting in significant contributions to the team and the company. The speaker focused on excelling in the role, mastering SQL Server, and learning Python to optimize value and ensure full-time employment, resulting in significant contributions to the team and the company, leading to career stability and growth.']}], 'duration': 506.944, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o1129135.jpg', 'highlights': ['The speaker chose between a junior data analyst position at a large company and a smaller company offering a potential director-level role, with the latter making a $100,000 salary offer to retain the speaker.', 'The decision to accept a $76,000 hourly position with opportunities for promotion and full-time employment led to a successful career transition and a significant increase in income.', 'The speaker self-learned Python, Tableau, and Power BI, spending six months to gain proficiency, emphasizing the value of continuously learning and increasing skill set for market value and career growth.', 'The speaker progressed from a beginner to a junior data analyst, demonstrating the impact of self-study and continuous learning on career advancement and market value.', "The speaker's journey involved learning Python, Tableau, and Power BI, showcasing the dedication to self-improvement and skill enhancement for career growth and increased market value.", 'Focused on excelling in the role, mastering SQL Server, and learning Python to optimize value and ensure full-time employment, resulting in significant contributions to the team and the company, leading to career stability and growth.', 'Opted for a junior data analyst role at a large company over a higher role at a small company to prioritize stability and long-term career growth.']}, {'end': 1995.493, 'segs': [{'end': 1717.953, 'src': 'embed', 'start': 1655.447, 'weight': 0, 'content': [{'end': 1661.769, 'text': "something my team was doing was doing gap analysis on different databases, because we would take a database, we'd get some new data.", 'start': 1655.447, 'duration': 6.322}, {'end': 1666.531, 'text': 'we would wanna do another a comparison to the new database, the new data.', 'start': 1661.769, 'duration': 4.762}, {'end': 1667.291, 'text': "see what's changed.", 'start': 1666.531, 'duration': 0.76}, {'end': 1674.294, 'text': "And my team, they didn't have any tools or anything that was doing that, so people were doing this manually.", 'start': 1668.071, 'duration': 6.223}, {'end': 1676.815, 'text': 'And when I first got there, I had to do it manually.', 'start': 1675.134, 'duration': 1.681}, {'end': 1678.717, 'text': 'And it took forever.', 'start': 1677.136, 'duration': 1.581}, {'end': 1680.358, 'text': 'It was taking hours.', 'start': 1679.097, 'duration': 1.261}, {'end': 1684.721, 'text': "I'm like a whole day worth just to do one gap analysis on a database.", 'start': 1680.378, 'duration': 4.343}, {'end': 1687.323, 'text': 'I was like, there has got to be a better way.', 'start': 1685.422, 'duration': 1.901}, {'end': 1693.227, 'text': 'And so, without even asking my boss, I took the time out of my time at home.', 'start': 1687.944, 'duration': 5.283}, {'end': 1696.797, 'text': 'So I said how can I make this quicker?', 'start': 1694.335, 'duration': 2.462}, {'end': 1703.242, 'text': 'So I did tons of research, played around with tons of different scripts, and I wrote a script that would take a whole database.', 'start': 1697.277, 'duration': 5.965}, {'end': 1704.323, 'text': 'compare it to another database.', 'start': 1703.242, 'duration': 1.081}, {'end': 1709.246, 'text': 'It would compare every view, every table, every column, the counts of the columns, everything.', 'start': 1704.443, 'duration': 4.803}, {'end': 1713.089, 'text': 'And it would give us the output, and it would take like five minutes to run.', 'start': 1710.147, 'duration': 2.942}, {'end': 1717.953, 'text': 'And I said, hey, boss, I made this thing.', 'start': 1713.93, 'duration': 4.023}], 'summary': 'Developed a script to automate database gap analysis, reducing the time from hours to 5 minutes.', 'duration': 62.506, 'max_score': 1655.447, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o1655447.jpg'}, {'end': 1774.569, 'src': 'embed', 'start': 1743.655, 'weight': 2, 'content': [{'end': 1745.115, 'text': "She's extremely smart.", 'start': 1743.655, 'duration': 1.46}, {'end': 1749.977, 'text': "But when it came to the technical stuff, she just didn't have, she wasn't a technical person.", 'start': 1745.755, 'duration': 4.222}, {'end': 1755.059, 'text': "And that's why she was in a manager's role and she had me underneath as the data analyst.", 'start': 1750.577, 'duration': 4.482}, {'end': 1758.26, 'text': 'And before that, she had another data analyst who had to leave.', 'start': 1755.759, 'duration': 2.501}, {'end': 1761.861, 'text': 'And so she really needed somebody who had technical skills.', 'start': 1759, 'duration': 2.861}, {'end': 1764.122, 'text': 'And she was just floored.', 'start': 1762.481, 'duration': 1.641}, {'end': 1766.524, 'text': 'She thought it was the best thing that has ever happened.', 'start': 1764.162, 'duration': 2.362}, {'end': 1768.385, 'text': 'And she made me feel that way.', 'start': 1767.184, 'duration': 1.201}, {'end': 1770.687, 'text': 'She made me feel like it was the best thing ever.', 'start': 1768.425, 'duration': 2.262}, {'end': 1774.569, 'text': 'So I really, you know, she is a really good boss.', 'start': 1771.167, 'duration': 3.402}], 'summary': "Manager was impressed by data analyst's technical skills and made them feel valued.", 'duration': 30.914, 'max_score': 1743.655, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o1743655.jpg'}, {'end': 1843.763, 'src': 'heatmap', 'start': 1813.612, 'weight': 1, 'content': [{'end': 1819.916, 'text': 'and so i started to gain a lot of confidence and then eventually i built a python script.', 'start': 1813.612, 'duration': 6.304}, {'end': 1822.418, 'text': 'that Another thing that we were.', 'start': 1819.916, 'duration': 2.502}, {'end': 1827.84, 'text': 'you know, I was trying to solve business issues, things that were taking us a lot of manual time.', 'start': 1822.418, 'duration': 5.422}, {'end': 1834.681, 'text': 'And something that we were doing was we were getting flat files from customers where we needed to look into it, kind of analyze it a little bit,', 'start': 1828.32, 'duration': 6.361}, {'end': 1835.941, 'text': 'get some basic information.', 'start': 1834.681, 'duration': 1.26}, {'end': 1843.763, 'text': 'And what my team was originally doing was taking it, converting it to an Excel, running counts on the columns and all these things,', 'start': 1836.542, 'duration': 7.221}], 'summary': 'Built python script to automate manual data analysis, saving time and effort.', 'duration': 30.151, 'max_score': 1813.612, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o1813612.jpg'}, {'end': 1881.718, 'src': 'embed', 'start': 1846.664, 'weight': 1, 'content': [{'end': 1851.366, 'text': "I was like, this is a perfect opportunity to use my Python skills that I've been working on for the past four months.", 'start': 1846.664, 'duration': 4.702}, {'end': 1861.87, 'text': 'So I build a script that when the file was put into this folder, it would ingest it, spit out all of the things that we were looking for.', 'start': 1852.286, 'duration': 9.584}, {'end': 1865.352, 'text': 'So it would spit out counts, nulls, all these things.', 'start': 1862.451, 'duration': 2.901}, {'end': 1869.874, 'text': "And then it would create a file He would send us an email and say it's done.", 'start': 1865.912, 'duration': 3.962}, {'end': 1881.718, 'text': "And again, I think that one was probably one of the most challenging things that I had basically ever done or projects that I've ever done to date.", 'start': 1870.674, 'duration': 11.044}], 'summary': 'Used python skills to build a script to process files, producing counts, nulls, and sending completion email.', 'duration': 35.054, 'max_score': 1846.664, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o1846664.jpg'}], 'start': 1636.7, 'title': 'Automating database gap analysis', 'summary': 'Discusses automating manual gap analysis in sql server, reducing processing time from a day to five minutes, leading to increased efficiency. it also showcases impressing the boss with technical skills, resulting in validation, confidence, and potential job offer.', 'chapters': [{'end': 1717.953, 'start': 1636.7, 'title': 'Automating gap analysis in sql server', 'summary': 'Describes how the speaker automated the manual process of gap analysis on databases at work, reducing the time taken from a whole day to just five minutes, resulting in increased efficiency and productivity for the team.', 'duration': 81.253, 'highlights': ['The speaker automated the manual process of gap analysis on databases, reducing the time taken from a whole day to just five minutes, resulting in increased efficiency and productivity for the team.', 'The team previously had no tools for doing gap analysis and were doing it manually, taking hours for one analysis.', 'The script written by the speaker compared every view, table, column, and counts of the columns in a database, providing the output in just five minutes.']}, {'end': 1995.493, 'start': 1717.973, 'title': 'Boss impressed by technical skills', 'summary': "Highlights the narrator's success in impressing their boss with technical skills, leading to increased confidence, validation, and potential job offer, exemplified by developing a python script for automating data analysis and processing, and their boss's enthusiastic response to the solution.", 'duration': 277.52, 'highlights': ["The narrator's boss was impressed by the technical skills displayed, leading to increased confidence and validation, and potentially a job offer.", 'The narrator developed a Python script to automate data analysis and processing, significantly reducing manual time and effort.', 'The boss enthusiastically responded to the Python script, considering it as one of the most challenging and impactful projects to date.', "The chapter concludes with a playful interruption about the narrator's new puppy and a sponsorship mention for Patreon."]}], 'duration': 358.793, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o1636700.jpg', 'highlights': ['Automated manual gap analysis in SQL Server, reducing processing time from a day to five minutes, increasing efficiency.', 'Developed Python script to automate data analysis, reducing manual time and effort, impressing the boss.', 'Boss was impressed by technical skills, leading to validation, confidence, and potential job offer.', 'Script compared every view, table, column, and counts of the columns in a database, providing output in just five minutes.', 'Team previously had no tools for gap analysis, taking hours for one analysis.']}, {'end': 2452.816, 'segs': [{'end': 2047.608, 'src': 'embed', 'start': 2018.546, 'weight': 0, 'content': [{'end': 2024.35, 'text': 'I talked to our internal team, who does the hiring, and we wanna offer you a data analyst two position,', 'start': 2018.546, 'duration': 5.804}, {'end': 2028.353, 'text': 'which was two pay positions higher than I was already at.', 'start': 2024.35, 'duration': 4.003}, {'end': 2033.257, 'text': 'And so I just remember being absolutely floored.', 'start': 2029.614, 'duration': 3.643}, {'end': 2039.402, 'text': 'Like I was absolutely just floored that they were gonna do that.', 'start': 2033.557, 'duration': 5.845}, {'end': 2047.608, 'text': 'Because they could have easily just offered me the junior data analyst position for like 75,000 full-time or mid 70s full-time,', 'start': 2039.422, 'duration': 8.186}], 'summary': 'Offered data analyst position with two pay levels higher, exceeding expectations.', 'duration': 29.062, 'max_score': 2018.546, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o2018546.jpg'}, {'end': 2090.483, 'src': 'embed', 'start': 2062.06, 'weight': 3, 'content': [{'end': 2068.125, 'text': 'basically, and um to say the least, i was it just it made me feel,', 'start': 2062.06, 'duration': 6.065}, {'end': 2075.751, 'text': 'um so validated that my decision was correct to not take the other job but to take this one,', 'start': 2068.125, 'duration': 7.626}, {'end': 2079.214, 'text': 'because eventually the the pay was comparable to what they were offering me at the other job.', 'start': 2075.751, 'duration': 3.463}, {'end': 2090.483, 'text': 'but now i have um, this really good company, brand name, giant company, on my resume and that will do me wonders down the road.', 'start': 2079.214, 'duration': 11.269}], 'summary': 'Chose current job over another for better pay, validated by comparable offer, now has prestigious company on resume.', 'duration': 28.423, 'max_score': 2062.06, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o2062060.jpg'}, {'end': 2132.036, 'src': 'embed', 'start': 2110.658, 'weight': 1, 'content': [{'end': 2121.948, 'text': 'But all that to say is you know, I think that for everyone out there who is trying to change careers, there are a few main tips that I will give you,', 'start': 2110.658, 'duration': 11.29}, {'end': 2125.711, 'text': 'which is make sure that you know the skills really well, the ones that you really need to know.', 'start': 2121.948, 'duration': 3.763}, {'end': 2132.036, 'text': 'SQL, Python, Tableau, Power BI, Excel, the basics, make sure you know those really well.', 'start': 2126.352, 'duration': 5.684}], 'summary': 'Tips for changing careers: master sql, python, tableau, power bi, and excel.', 'duration': 21.378, 'max_score': 2110.658, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o2110658.jpg'}, {'end': 2180.699, 'src': 'heatmap', 'start': 2110.658, 'weight': 2, 'content': [{'end': 2121.948, 'text': 'But all that to say is you know, I think that for everyone out there who is trying to change careers, there are a few main tips that I will give you,', 'start': 2110.658, 'duration': 11.29}, {'end': 2125.711, 'text': 'which is make sure that you know the skills really well, the ones that you really need to know.', 'start': 2121.948, 'duration': 3.763}, {'end': 2132.036, 'text': 'SQL, Python, Tableau, Power BI, Excel, the basics, make sure you know those really well.', 'start': 2126.352, 'duration': 5.684}, {'end': 2139.211, 'text': 'make sure that you have a really good resume and you can speak to your skills very well in an interview.', 'start': 2133.149, 'duration': 6.062}, {'end': 2141.391, 'text': 'Work with a recruiter.', 'start': 2139.851, 'duration': 1.54}, {'end': 2145.052, 'text': "make sure that the recruiter knows what you're looking for,", 'start': 2141.391, 'duration': 3.661}, {'end': 2156.465, 'text': "that you're working with many recruiters and that when you get into that interview that you sell yourself hard, you sell yourself.", 'start': 2145.052, 'duration': 11.413}, {'end': 2158.867, 'text': 'you make sure you get that job because you need that experience.', 'start': 2156.465, 'duration': 2.402}, {'end': 2161.408, 'text': 'you need an experience underneath your belt.', 'start': 2158.867, 'duration': 2.541}, {'end': 2166.351, 'text': 'uh, to to progress and and go higher and make more money, you, you have to have it.', 'start': 2161.408, 'duration': 4.943}, {'end': 2172.174, 'text': 'and so that is in a nutshell, in a very quick nutshell, that is, you know, that is the.', 'start': 2166.351, 'duration': 5.823}, {'end': 2174.396, 'text': 'that is the takeaway from all of this.', 'start': 2172.174, 'duration': 2.222}, {'end': 2176.357, 'text': 'it is possible to change careers.', 'start': 2174.396, 'duration': 1.961}, {'end': 2180.699, 'text': 'it is difficult, and i had a very tough time getting that first job.', 'start': 2176.357, 'duration': 4.342}], 'summary': 'Key tips for career change: master skills like sql, python, tableau, power bi, excel; work with recruiters; sell yourself in interviews; gaining experience is crucial.', 'duration': 21.832, 'max_score': 2110.658, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o2110658.jpg'}, {'end': 2232.159, 'src': 'embed', 'start': 2203.091, 'weight': 4, 'content': [{'end': 2208.914, 'text': 'And so for all of you who are in that spot where I was just a few years ago, there is hope.', 'start': 2203.091, 'duration': 5.823}, {'end': 2214.955, 'text': 'It may be a little bit more difficult now that there is COVID, but I promise you there are jobs out there.', 'start': 2209.914, 'duration': 5.041}, {'end': 2222.237, 'text': 'You just have to keep focused, know what you need to do, and just do it consistently all the time.', 'start': 2215.715, 'duration': 6.522}, {'end': 2225.917, 'text': "So if you're studying, consistently study.", 'start': 2223.397, 'duration': 2.52}, {'end': 2232.159, 'text': "You don't have to study it all in one month, right? Make sure you're just doing it consistently, and it will pay off.", 'start': 2226.417, 'duration': 5.742}], 'summary': 'Despite covid, there are jobs available. stay focused and consistent in your efforts.', 'duration': 29.068, 'max_score': 2203.091, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o2203091.jpg'}, {'end': 2356.189, 'src': 'embed', 'start': 2327.018, 'weight': 5, 'content': [{'end': 2328.179, 'text': "And that's why I'm making this channel.", 'start': 2327.018, 'duration': 1.161}, {'end': 2330.121, 'text': "I'm sure a lot of you know that is like.", 'start': 2328.459, 'duration': 1.662}, {'end': 2336.185, 'text': "that's why I started this channel is because I didn't want other people who were trying to get into this field to go through what I went through,", 'start': 2330.121, 'duration': 6.064}, {'end': 2338.127, 'text': 'which was I felt like I did it all by myself.', 'start': 2336.185, 'duration': 1.942}, {'end': 2341.953, 'text': 'I created this channel so that I could help you guys.', 'start': 2338.587, 'duration': 3.366}, {'end': 2343.916, 'text': 'So I could give advice.', 'start': 2342.373, 'duration': 1.543}, {'end': 2346.9, 'text': 'share my story, help you, you know.', 'start': 2343.916, 'duration': 2.984}, {'end': 2355.308, 'text': 'however, you want to say that create your dream, make your dreams come true, help you become a data analyst.', 'start': 2349.025, 'duration': 6.283}, {'end': 2356.189, 'text': "That's what this is all about.", 'start': 2355.348, 'duration': 0.841}], 'summary': 'Created channel to help others become data analysts and avoid struggles faced, offering advice and support.', 'duration': 29.171, 'max_score': 2327.018, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o2327018.jpg'}, {'end': 2425.958, 'src': 'embed', 'start': 2397.73, 'weight': 6, 'content': [{'end': 2403.653, 'text': 'You guys are my real fans or the real dedicated people.', 'start': 2397.73, 'duration': 5.923}, {'end': 2409.755, 'text': 'You guys, the people who are sticking around right now listening to my rant at the very end of my show.', 'start': 2403.673, 'duration': 6.082}, {'end': 2412.617, 'text': 'you guys are the people who are going to be successful data analysts.', 'start': 2409.755, 'duration': 2.862}, {'end': 2418.659, 'text': "Everyone who dropped off 10, 15 minutes ago, they don't got it.", 'start': 2412.937, 'duration': 5.722}, {'end': 2420.26, 'text': "They don't got it like you got it.", 'start': 2419.36, 'duration': 0.9}, {'end': 2425.958, 'text': 'And so if you made it this far, put a comment below that you made it this far.', 'start': 2421.516, 'duration': 4.442}], 'summary': 'Dedicated listeners will succeed as data analysts. drop-offs lack dedication.', 'duration': 28.228, 'max_score': 2397.73, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o2397730.jpg'}], 'start': 1997.233, 'title': 'Career change success and advice for aspiring data analysts', 'summary': 'Narrates a successful career change, securing a higher position with a significant pay raise and provides tips for career changers. it also emphasizes the importance of consistency in studying and reflects on the journey to success as a data analyst.', 'chapters': [{'end': 2202.51, 'start': 1997.233, 'title': 'Career change success story', 'summary': 'Narrates a successful career change, securing a higher position with a significant pay raise and provides tips for career changers including the importance of skills like sql, python, tableau, power bi, excel, working with recruiters, and selling oneself in interviews.', 'duration': 205.277, 'highlights': ['Securing a data analyst two position with a two pay grade higher offer due to exceeding expectations in technical and people skills. The offer of a data analyst two position, two pay positions higher than the current role, was a pleasant surprise after being deemed to have exceeded expectations in technical and people skills.', 'Emotional validation and satisfaction in making the right career decision reflected in receiving a comparable pay to the previous offer and gaining valuable experience at a reputed company. The emotional validation and satisfaction in making the right career decision were due to receiving a comparable pay to the previous offer and gaining valuable experience at a reputed company, which will enhance future prospects.', 'Importance of mastering essential skills like SQL, Python, Tableau, Power BI, and Excel, and the significance of working with recruiters to secure desired roles. The chapter emphasizes the importance of mastering essential skills like SQL, Python, Tableau, Power BI, and Excel, and highlights the significance of working with recruiters to secure desired roles, along with excelling in interviews to sell oneself effectively.', 'The invaluable nature of gaining real experience with skills in a job role, facilitating easier job acquisition and career progression. The invaluable nature of gaining real experience with skills in a job role is highlighted, as it facilitates easier job acquisition and career progression, significantly impacting future opportunities.']}, {'end': 2452.816, 'start': 2203.091, 'title': 'Advice for aspiring data analysts', 'summary': 'Emphasizes the importance of consistency in studying, acknowledges the impact of covid on job searching, and expresses gratitude towards the audience while reflecting on the journey to success as a data analyst.', 'duration': 249.725, 'highlights': ['The importance of consistency in studying and job searching despite the challenges posed by COVID is emphasized, providing hope for aspiring data analysts.', 'The speaker reflects on the lack of guidance and mentorship they faced when starting out and expresses gratitude towards the audience for their support, emphasizing the purpose of the channel to help others in the field.', 'The speaker acknowledges the combination of luck and hard work in their journey, expressing appreciation for the dedicated audience and their potential for success as data analysts.']}], 'duration': 455.583, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Z2AachB309o/pics/Z2AachB309o1997233.jpg', 'highlights': ['Securing a data analyst two position with a two pay grade higher offer due to exceeding expectations in technical and people skills.', 'Importance of mastering essential skills like SQL, Python, Tableau, Power BI, and Excel, and the significance of working with recruiters to secure desired roles.', 'The invaluable nature of gaining real experience with skills in a job role, facilitating easier job acquisition and career progression.', 'The emotional validation and satisfaction in making the right career decision reflected in receiving a comparable pay to the previous offer and gaining valuable experience at a reputed company.', 'The importance of consistency in studying and job searching despite the challenges posed by COVID is emphasized, providing hope for aspiring data analysts.', 'The speaker reflects on the lack of guidance and mentorship they faced when starting out and expresses gratitude towards the audience for their support, emphasizing the purpose of the channel to help others in the field.', 'The speaker acknowledges the combination of luck and hard work in their journey, expressing appreciation for the dedicated audience and their potential for success as data analysts.']}], 'highlights': ['Automated manual gap analysis in SQL Server, reducing processing time from a day to five minutes, increasing efficiency.', 'Developed Python script to automate data analysis, reducing manual time and effort, impressing the boss.', 'The speaker chose between a junior data analyst position at a large company and a smaller company offering a potential director-level role, with the latter making a $100,000 salary offer to retain the speaker.', 'The decision to accept a $76,000 hourly position with opportunities for promotion and full-time employment led to a successful career transition and a significant increase in income.', 'The speaker self-learned Python, Tableau, and Power BI, spending six months to gain proficiency, emphasizing the value of continuously learning and increasing skill set for market value and career growth.', 'Securing a data analyst two position with a two pay grade higher offer due to exceeding expectations in technical and people skills.', 'Importance of mastering essential skills like SQL, Python, Tableau, Power BI, and Excel, and the significance of working with recruiters to secure desired roles.', 'The invaluable nature of gaining real experience with skills in a job role, facilitating easier job acquisition and career progression.', 'The emotional validation and satisfaction in making the right career decision reflected in receiving a comparable pay to the previous offer and gaining valuable experience at a reputed company.', 'The importance of consistency in studying and job searching despite the challenges posed by COVID is emphasized, providing hope for aspiring data analysts.']}