title
Data Analyst Roadmap 2023 | Learn data analytics skills in 3 months

description
The only roadmap you need to learn data analyst skills in 3 months. No clickbait, no BS. Only real advice. This roadmap has already helped many folks prepare for data analyst skills and get a job. I will discuss all the FREE learning resources, exact week-by-week study plans, assignments, and milestones. We will also discuss resume and interview preparation for the data analyst job profile. To download Roadmap PDF, 1) Go to https://codebasics.io/resources?utm_source=description&utm_medium=yt&utm_campaign=description&utm_id=description 2) Click on the download button below the data analyst roadmap thumbnail 3) You need to create a login (takes 20 seconds) and then you will be able to download the roadmap PDF file Direct link: https://codebasics.io/resources/data-analyst-3-months-roadmap Video in Hindi: https://youtu.be/-j_HnYgIjQw 🔖Hashtags🔖 #dataanalystroadmap #dataanalystskills #howtobecomeadataanalyst #howtobecomedataanalyst #dataanalystforbeginners #howtolearndataanalyst #learndataanalyst #dataanalystroadmap #dataanalystguide #dataanalyst #dataanalystcourse #dataanalystfullcourse #learndataanalytics #dataanalystbeginner #dataanalystroadmap #howtobeadataanalyst #dataanalystroadmap2023 Do you want to learn technology from me? Check https://codebasics.io/?utm_source=description&utm_medium=yt&utm_campaign=description&utm_id=description for my affordable video courses. Need help building software or data analytics/AI solutions? My company https://www.atliq.com/ can help. Click on the Contact button on that website. 🎥 Codebasics Hindi channel: https://www.youtube.com/channel/UCTmFBhuhMibVoSfYom1uXEg #️⃣ Social Media #️⃣ 🔗 Discord: https://discord.gg/r42Kbuk 📸 Dhaval's Personal Instagram: https://www.instagram.com/dhavalsays/ 📸 Codebasics Instagram: https://www.instagram.com/codebasicshub/ 🔊 Facebook: https://www.facebook.com/codebasicshub 📱 Twitter: https://twitter.com/codebasicshub 📝 Linkedin (Personal): https://www.linkedin.com/in/dhavalsays/ 📝 Linkedin (Codebasics): https://www.linkedin.com/company/codebasics/ 🔗 Patreon: https://www.patreon.com/codebasics?fan_landing=true

detail
{'title': 'Data Analyst Roadmap 2023 | Learn data analytics skills in 3 months', 'heatmap': [{'end': 95.318, 'start': 77.242, 'weight': 0.943}, {'end': 174.749, 'start': 155.42, 'weight': 0.831}, {'end': 790.804, 'start': 754.131, 'weight': 0.848}, {'end': 981.703, 'start': 957.31, 'weight': 0.797}], 'summary': 'A comprehensive three-month roadmap for aspiring data analysts covering technical and soft skills, with daily study hours and interview preparation, based on a successful roadmap with 1.5 million views. it emphasizes learning microsoft excel, power bi, tableau, and business fundamentals, and provides guidance on personal finance, linkedin projects, and networking strategies.', 'chapters': [{'end': 42.8, 'segs': [{'end': 42.8, 'src': 'embed', 'start': 0.249, 'weight': 0, 'content': [{'end': 5.21, 'text': "Data analysis is one career role that doesn't require computer science degree or coding background.", 'start': 0.249, 'duration': 4.961}, {'end': 11.211, 'text': "In this video, I'm going to show you three months roadmap to prepare yourself for data analyst career,", 'start': 5.55, 'duration': 5.661}, {'end': 14.031, 'text': 'where we will include both technical and score skills.', 'start': 11.211, 'duration': 2.82}, {'end': 21.093, 'text': 'You will spend four hours every day where three hours will be spent in technical skills and one hour in learning soft skills.', 'start': 14.211, 'duration': 6.882}, {'end': 27.974, 'text': 'I have included all the free learning resources along with week by week study plan and exercises.', 'start': 21.573, 'duration': 6.401}, {'end': 36.637, 'text': 'We will spend last weeks of this 3 month time period in preparing you for the interviews this way at the end of 3 months you are truly job ready.', 'start': 28.214, 'duration': 8.423}, {'end': 41.159, 'text': '3 years back I created similar roadmap which received 1.5 million views.', 'start': 36.657, 'duration': 4.502}, {'end': 42.8, 'text': 'Many people found it to be useful.', 'start': 41.219, 'duration': 1.581}], 'summary': 'Prepare for data analyst career in 3 months with 3:1 ratio of technical to soft skills, free resources, and interview prep, based on a roadmap with 1.5m views.', 'duration': 42.551, 'max_score': 0.249, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/b_n-hhtMbXA/pics/b_n-hhtMbXA249.jpg'}], 'start': 0.249, 'title': 'Data analyst career roadmap', 'summary': 'Outlines a three-month roadmap to prepare for a data analyst career, covering technical and soft skills, with daily study hours and interview preparation, based on a previously successful roadmap that received 1.5 million views.', 'chapters': [{'end': 42.8, 'start': 0.249, 'title': 'Data analyst career roadmap', 'summary': 'Outlines a three-month roadmap to prepare for a data analyst career, covering technical and soft skills, with daily study hours and interview preparation, based on a previously successful roadmap that received 1.5 million views.', 'duration': 42.551, 'highlights': ['The roadmap outlines a three-month plan for preparing for a data analyst career, with a focus on technical and soft skills, involving four hours of daily study, where three hours are dedicated to technical skills and one hour to soft skills.', 'The plan includes free learning resources, a week-by-week study plan, and exercises for effective learning and skill-building.', 'The roadmap emphasizes interview preparation in the last weeks of the three-month period, aiming to make the candidate job-ready by the end of the timeline, based on the success of a similar roadmap receiving 1.5 million views three years ago.']}], 'duration': 42.551, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/b_n-hhtMbXA/pics/b_n-hhtMbXA249.jpg', 'highlights': ['The roadmap outlines a three-month plan for preparing for a data analyst career, with a focus on technical and soft skills, involving four hours of daily study, where three hours are dedicated to technical skills and one hour to soft skills.', 'The plan includes free learning resources, a week-by-week study plan, and exercises for effective learning and skill-building.', 'The roadmap emphasizes interview preparation in the last weeks of the three-month period, aiming to make the candidate job-ready by the end of the timeline, based on the success of a similar roadmap receiving 1.5 million views three years ago.']}, {'end': 278.103, 'segs': [{'end': 71.578, 'src': 'embed', 'start': 43.34, 'weight': 0, 'content': [{'end': 46.982, 'text': 'This video is 5 times better version of that particular roadmap.', 'start': 43.34, 'duration': 3.642}, {'end': 51.945, 'text': 'In first two weeks, you should learn Microsoft Excel as well as business math and statistics.', 'start': 47.282, 'duration': 4.663}, {'end': 56.568, 'text': 'Believe it or not, Excel is still heavily used in data analytics industry.', 'start': 52.325, 'duration': 4.243}, {'end': 62.032, 'text': 'When it comes to small scale data set or simple analytics, Excel is the perfect tool.', 'start': 56.648, 'duration': 5.384}, {'end': 67.295, 'text': 'You will find Excel as a necessary skill in any data analyst job profile.', 'start': 62.312, 'duration': 4.983}, {'end': 71.578, 'text': 'You need to learn some basic formulas like this, whatever I have listed.', 'start': 67.596, 'duration': 3.982}], 'summary': 'Learn microsoft excel and business math in first two weeks to excel in data analytics.', 'duration': 28.238, 'max_score': 43.34, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/b_n-hhtMbXA/pics/b_n-hhtMbXA43340.jpg'}, {'end': 117.556, 'src': 'heatmap', 'start': 77.242, 'weight': 3, 'content': [{'end': 79.964, 'text': 'pivot tables, basic charting filters, etc.', 'start': 77.242, 'duration': 2.722}, {'end': 83.167, 'text': "You don't need to learn VBAs and macros, folks.", 'start': 80.545, 'duration': 2.622}, {'end': 83.868, 'text': "They're dying.", 'start': 83.227, 'duration': 0.641}, {'end': 85.129, 'text': "So don't waste your time.", 'start': 83.928, 'duration': 1.201}, {'end': 95.318, 'text': 'Now you can make it a project based learning by opening this Google template gallery for personal finance where you will find a variety of templates.', 'start': 85.689, 'duration': 9.629}, {'end': 99.261, 'text': 'So if you open this, for example, let me just open it here.', 'start': 95.378, 'duration': 3.883}, {'end': 103.244, 'text': 'You will find annual budget, monthly budget and so on.', 'start': 99.802, 'duration': 3.442}, {'end': 109.93, 'text': 'Now, in monthly budget, you can start maintaining your own transaction for expenses and income,', 'start': 103.565, 'duration': 6.365}, {'end': 117.556, 'text': 'and in the summary here you see that it is using some excel formulas to come up with those aggregate numbers.', 'start': 109.93, 'duration': 7.626}], 'summary': 'Learn pivot tables and basic charting, not vba or macros. use google template gallery for personal finance.', 'duration': 40.314, 'max_score': 77.242, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/b_n-hhtMbXA/pics/b_n-hhtMbXA77242.jpg'}, {'end': 185.234, 'src': 'heatmap', 'start': 155.42, 'weight': 4, 'content': [{'end': 160.542, 'text': 'Here, this person has put a lot of amazing material on Excel.', 'start': 155.42, 'duration': 5.122}, {'end': 163.143, 'text': "So let's say you want to learn about pivot table.", 'start': 160.582, 'duration': 2.561}, {'end': 169.166, 'text': 'You can just search for that particular video on this channel and learn these things on your own.', 'start': 163.163, 'duration': 6.003}, {'end': 174.749, 'text': 'Talking about business math, you need to know basic concepts such as arithmetic percentages.', 'start': 169.326, 'duration': 5.423}, {'end': 181.532, 'text': "Let's say, someone asks you if April's revenue grew from 50 to 60 million, what was the percentage growth?", 'start': 174.829, 'duration': 6.703}, {'end': 185.234, 'text': 'You need to know how to calculate that formula.', 'start': 181.852, 'duration': 3.382}], 'summary': 'Excel tutorials cover pivot tables and business math concepts, including percentage growth calculation.', 'duration': 47.384, 'max_score': 155.42, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/b_n-hhtMbXA/pics/b_n-hhtMbXA155420.jpg'}, {'end': 251.381, 'src': 'embed', 'start': 227.483, 'weight': 6, 'content': [{'end': 234.848, 'text': 'In terms of statistics, you need to know once again basic like mean, median, standard deviation, all these concepts.', 'start': 227.483, 'duration': 7.365}, {'end': 238.771, 'text': "You don't have to go crazy and study all those advanced concepts.", 'start': 234.889, 'duration': 3.882}, {'end': 243.895, 'text': 'In terms of learning resources, I suggest Khan Academy and Mathisfun.', 'start': 239.352, 'duration': 4.543}, {'end': 246.037, 'text': 'These are the two very good websites.', 'start': 243.935, 'duration': 2.102}, {'end': 251.381, 'text': 'In the future, we are going to publish a playlist on our YouTube channel for this.', 'start': 246.157, 'duration': 5.224}], 'summary': 'Focus on basic statistics like mean, median, and standard deviation. recommended learning resources are khan academy and mathisfun. a playlist will be published on the youtube channel in the future.', 'duration': 23.898, 'max_score': 227.483, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/b_n-hhtMbXA/pics/b_n-hhtMbXA227483.jpg'}], 'start': 43.34, 'title': 'Data analytics roadmap essentials and personal finance learning resources', 'summary': "Emphasizes the importance of learning microsoft excel and business math and statistics in the first two weeks, underlining excel's continued relevance in the data analytics industry. it also discusses using google templates for personal finance and recommends resources like chandoo's youtube channel, khan academy, and mathisfun for learning statistics and percentages.", 'chapters': [{'end': 85.129, 'start': 43.34, 'title': 'Data analytics roadmap essentials', 'summary': "Highlights the importance of learning microsoft excel and business math and statistics in the first two weeks, emphasizing excel's continued relevance in the data analytics industry and the necessity of basic excel skills for any data analyst job profile.", 'duration': 41.789, 'highlights': ['Excel is heavily used in the data analytics industry, making it a necessary skill in any data analyst job profile.', 'In the first two weeks, learning Microsoft Excel, business math, and statistics is crucial for beginners in data analytics.', 'Basic Excel skills, such as pivot tables, basic charting, and filters, are emphasized for small scale data sets and simple analytics.']}, {'end': 278.103, 'start': 85.689, 'title': 'Personal finance learning resources', 'summary': "Discusses using google templates for personal finance, learning excel formulas and business math, and recommends resources like chandoo's youtube channel, khan academy, and mathisfun for learning statistics and percentages.", 'duration': 192.414, 'highlights': ['Using Google templates for personal finance, including annual and monthly budget templates, to learn Excel formulas and maintain detailed expenses and income. Google template gallery for personal finance offers various templates such as annual budget and monthly budget, allowing users to maintain their own transaction for expenses and income and learn Excel formulas.', "Recommendation of Chandoo's YouTube channel for learning Excel, including pivot tables and formulas. Chandoo's YouTube channel provides material on Excel, including pivot tables and formulas, for self-learning purposes.", 'Explaining basic business math concepts such as calculating percentage growth and market share, essential for becoming a data analyst. Basic business math concepts like calculating percentage growth and market share are crucial skills for aspiring data analysts.', 'Suggesting Khan Academy and Mathisfun as learning resources for statistics and percentages. Khan Academy and Mathisfun are recommended as learning resources for statistics and percentages.']}], 'duration': 234.763, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/b_n-hhtMbXA/pics/b_n-hhtMbXA43340.jpg', 'highlights': ['Excel is heavily used in the data analytics industry, making it a necessary skill in any data analyst job profile.', 'In the first two weeks, learning Microsoft Excel, business math, and statistics is crucial for beginners in data analytics.', 'Basic Excel skills, such as pivot tables, basic charting, and filters, are emphasized for small scale data sets and simple analytics.', 'Using Google templates for personal finance, including annual and monthly budget templates, to learn Excel formulas and maintain detailed expenses and income.', "Recommendation of Chandoo's YouTube channel for learning Excel, including pivot tables and formulas.", 'Explaining basic business math concepts such as calculating percentage growth and market share, essential for becoming a data analyst.', 'Suggesting Khan Academy and Mathisfun as learning resources for statistics and percentages.']}, {'end': 570.356, 'segs': [{'end': 303.955, 'src': 'embed', 'start': 278.103, 'weight': 0, 'content': [{'end': 283.306, 'text': 'you have to create your own budget spreadsheet and hopefully make some changes in that.', 'start': 278.103, 'duration': 5.203}, {'end': 284.326, 'text': 'all right.', 'start': 283.306, 'duration': 1.02}, {'end': 289.168, 'text': 'the second assignment is creating a professional looking linkedin profile.', 'start': 284.326, 'duration': 4.842}, {'end': 291.349, 'text': 'so we are learning technical skills.', 'start': 289.168, 'duration': 2.181}, {'end': 301.034, 'text': 'but in terms of soft skills, you need to spend time in creating a very excellent linkedin profile where you put a very clear headshot.', 'start': 291.349, 'duration': 9.685}, {'end': 303.955, 'text': "Don't take a selfie or put a blurred picture.", 'start': 301.514, 'duration': 2.441}], 'summary': 'Create budget spreadsheet, improve linkedin profile for soft skills.', 'duration': 25.852, 'max_score': 278.103, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/b_n-hhtMbXA/pics/b_n-hhtMbXA278103.jpg'}, {'end': 377.902, 'src': 'embed', 'start': 349.626, 'weight': 2, 'content': [{'end': 354.208, 'text': 'Track A requires you to work on three projects.', 'start': 349.626, 'duration': 4.582}, {'end': 362.611, 'text': 'So I have these three free projects on my YouTube channel where I cover data analytics project lifecycle end-to-end along with Power BI skills.', 'start': 354.248, 'duration': 8.363}, {'end': 365.213, 'text': 'So the first one is sales insight.', 'start': 363.331, 'duration': 1.882}, {'end': 367.594, 'text': 'The second one is HR data analytics.', 'start': 365.253, 'duration': 2.341}, {'end': 371.017, 'text': 'And the third one is personal finance projects.', 'start': 368.315, 'duration': 2.702}, {'end': 374.079, 'text': 'Now these projects uses a real life data set.', 'start': 371.097, 'duration': 2.982}, {'end': 377.902, 'text': "So you're getting some serious learning through these free projects.", 'start': 374.139, 'duration': 3.763}], 'summary': 'Track a involves three projects covering sales insight, hr analytics, and personal finance, with real-life datasets for serious learning.', 'duration': 28.276, 'max_score': 349.626, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/b_n-hhtMbXA/pics/b_n-hhtMbXA349626.jpg'}, {'end': 462.603, 'src': 'embed', 'start': 437.469, 'weight': 1, 'content': [{'end': 444.793, 'text': 'Many companies have been using Microsoft tools such as Microsoft Office, SharePoint, Azure, etc.', 'start': 437.469, 'duration': 7.324}, {'end': 449.416, 'text': "And it's really easy for those companies to use Power BI rather than Tableau.", 'start': 444.913, 'duration': 4.503}, {'end': 457.12, 'text': "And Kogartner's magic quadrant also shows that Microsoft is leading the chart when it comes to BI tools.", 'start': 449.956, 'duration': 7.164}, {'end': 462.603, 'text': 'Next few years, the Power BI jobs are going to only grow, whereas Tableau is kind of stagnant.', 'start': 457.78, 'duration': 4.823}], 'summary': 'Microsoft tools are popular, with power bi growing while tableau is stagnant.', 'duration': 25.134, 'max_score': 437.469, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/b_n-hhtMbXA/pics/b_n-hhtMbXA437469.jpg'}], 'start': 278.103, 'title': 'Building skills for budgeting and data analytics', 'summary': 'Highlights the creation of a budget spreadsheet, a professional linkedin profile, and the roadmap for acquiring data analytics skills, including learning power bi and tableau, and improving business fundamentals through practical projects and real-life experience.', 'chapters': [{'end': 327.484, 'start': 278.103, 'title': 'Budget spreadsheet and linkedin profile', 'summary': 'Emphasizes creating a budget spreadsheet and a professional linkedin profile as part of learning technical and soft skills, including using a clear headshot and banner image, and providing advice for a good looking linkedin profile.', 'duration': 49.381, 'highlights': ['Creating a professional LinkedIn profile with a clear headshot and banner image, and providing appropriate text can enhance soft skills and improve job prospects.', 'Building a good looking LinkedIn profile can involve using a clear headshot, an engaging banner image, and appropriate text to attract potential employers.', 'The importance of creating a professional LinkedIn profile with a clear headshot and engaging banner image is highlighted as a way to demonstrate soft skills and improve employability.']}, {'end': 570.356, 'start': 327.524, 'title': 'Data analytics roadmap and skills', 'summary': 'Outlines a roadmap for acquiring data analytics skills, including learning power bi and tableau, following influential figures on linkedin, and improving business fundamentals through resources like youtube channels, with a focus on practical projects and real-life experience.', 'duration': 242.832, 'highlights': ['The chapter outlines a roadmap for acquiring data analytics skills, including learning Power BI and Tableau, following influential figures on LinkedIn, and improving business fundamentals through resources like YouTube channels. The chapter provides a structured plan for acquiring essential data analytics skills, emphasizing the significance of learning Power BI and Tableau, following influential LinkedIn figures, and improving business fundamentals through resources like YouTube channels.', 'The roadmap includes practical projects and real-life experience, such as the sales insight, HR data analytics, and personal finance projects that utilize real-life datasets. The roadmap emphasizes practical projects and real-life experience, offering projects like sales insight, HR data analytics, and personal finance projects that utilize real-life datasets, contributing to serious learning.', 'It highlights the growing demand for Power BI skills, with most data analyst jobs requiring BI knowledge and Power BI being favored over Tableau due to its ease of use and future job growth potential. The chapter emphasizes the growing demand for Power BI skills, with most data analyst jobs requiring BI knowledge, and Power BI being favored over Tableau due to its ease of use and future job growth potential.']}], 'duration': 292.253, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/b_n-hhtMbXA/pics/b_n-hhtMbXA278103.jpg', 'highlights': ['The importance of creating a professional LinkedIn profile with a clear headshot and engaging banner image is highlighted as a way to demonstrate soft skills and improve employability.', 'The chapter emphasizes the growing demand for Power BI skills, with most data analyst jobs requiring BI knowledge, and Power BI being favored over Tableau due to its ease of use and future job growth potential.', 'The roadmap includes practical projects and real-life experience, offering projects like sales insight, HR data analytics, and personal finance projects that utilize real-life datasets, contributing to serious learning.']}, {'end': 1137.528, 'segs': [{'end': 639.799, 'src': 'embed', 'start': 597.423, 'weight': 0, 'content': [{'end': 604.871, 'text': 'The Power BI course that I talked about earlier covers all the P&L fundamentals in very easy to understand language.', 'start': 597.423, 'duration': 7.448}, {'end': 606.472, 'text': 'during this time period.', 'start': 605.171, 'duration': 1.301}, {'end': 612.957, 'text': 'you will also join my discord server the link is in video description below and start asking your question.', 'start': 606.472, 'duration': 6.485}, {'end': 617.54, 'text': 'and when you ask your question, you need to learn the art of asking question.', 'start': 612.957, 'duration': 4.583}, {'end': 621.643, 'text': 'i published this linkedin post some time back, where you know.', 'start': 617.54, 'duration': 4.103}, {'end': 623.304, 'text': 'i explained how do you ask question?', 'start': 621.643, 'duration': 1.661}, {'end': 626.467, 'text': "you don't just say I'm getting error XYZ.", 'start': 623.304, 'duration': 3.163}, {'end': 627.267, 'text': 'please help me.', 'start': 626.467, 'duration': 0.8}, {'end': 632.652, 'text': 'Because there you are portraying yourself as, you know, a poor guy who needs help.', 'start': 627.568, 'duration': 5.084}, {'end': 639.799, 'text': "But if you just say I'm stuck here despite trying XYZ, can someone give me troubleshooting?", 'start': 633.033, 'duration': 6.766}], 'summary': 'Power bi course covers p&l fundamentals in easy language. join discord server for support and learn how to ask questions effectively.', 'duration': 42.376, 'max_score': 597.423, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/b_n-hhtMbXA/pics/b_n-hhtMbXA597423.jpg'}, {'end': 700.123, 'src': 'embed', 'start': 660.859, 'weight': 2, 'content': [{'end': 666.763, 'text': 'here is one example where this person posted his learning from that sales inside youtube playlist.', 'start': 660.859, 'duration': 5.904}, {'end': 669.445, 'text': 'so you are summarizing all these things.', 'start': 666.763, 'duration': 2.682}, {'end': 675.068, 'text': 'you are also posting your dashboard that you have built and then people will comment.', 'start': 669.445, 'duration': 5.623}, {'end': 675.909, 'text': 'they will engage.', 'start': 675.068, 'duration': 0.841}, {'end': 678.57, 'text': "let's say, if i comment, i have 100 000 followers.", 'start': 675.909, 'duration': 2.661}, {'end': 687.116, 'text': 'some of them might be hr managers, data analytics managers, and you can, uh, you know, get highlighted in front of such a big audience,', 'start': 678.57, 'duration': 8.546}, {'end': 690.818, 'text': 'and that helps you in terms of learning, in terms of hiring as well.', 'start': 687.116, 'duration': 3.702}, {'end': 693.519, 'text': 'In week six and seven, you will learn SQL.', 'start': 691.078, 'duration': 2.441}, {'end': 700.123, 'text': 'As a data analyst, you are dealing with a variety of data sources and relational databases is one prominent data source.', 'start': 693.619, 'duration': 6.504}], 'summary': 'Posting learning on youtube, engaging with 100,000 followers, highlighting skills, learning sql in week six and seven.', 'duration': 39.264, 'max_score': 660.859, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/b_n-hhtMbXA/pics/b_n-hhtMbXA660859.jpg'}, {'end': 795.046, 'src': 'heatmap', 'start': 747.747, 'weight': 5, 'content': [{'end': 749.988, 'text': 'track B requires some payment.', 'start': 747.747, 'duration': 2.241}, {'end': 754.131, 'text': 'so in track A you have a Khan Academy course for SQL.', 'start': 749.988, 'duration': 4.143}, {'end': 764.221, 'text': 'you also have a nice SQL tutorial on W3 schools where you can just practice your sql skills as well as you can learn new skills.', 'start': 754.131, 'duration': 10.09}, {'end': 767.046, 'text': 'and then there is another website called sql bold.', 'start': 764.221, 'duration': 2.825}, {'end': 768.988, 'text': 'this website is amazing.', 'start': 767.046, 'duration': 1.942}, {'end': 774.316, 'text': 'you can practice as well as learn these skills in a very, very short time duration.', 'start': 768.988, 'duration': 5.328}, {'end': 776.558, 'text': 'now, once again, Track B.', 'start': 774.316, 'duration': 2.242}, {'end': 780.82, 'text': 'I have my own SQL course, which has received amazing reviews.', 'start': 776.558, 'duration': 4.262}, {'end': 783.081, 'text': 'All these reviews are real, by the way, nothing made up.', 'start': 780.9, 'duration': 2.181}, {'end': 786.722, 'text': "And if you are doing this course, then you don't need to follow any other resource.", 'start': 783.421, 'duration': 3.301}, {'end': 790.804, 'text': 'This is like one stop solution for your data analytics career.', 'start': 786.742, 'duration': 4.062}, {'end': 795.046, 'text': 'This course has all the exercises, training material, everything included.', 'start': 790.864, 'duration': 4.182}], 'summary': 'Track a offers multiple sql resources including khan academy, w3schools, and sql bold for quick learning and practice, while track b provides a comprehensive sql course with excellent reviews and all-inclusive material.', 'duration': 47.299, 'max_score': 747.747, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/b_n-hhtMbXA/pics/b_n-hhtMbXA747747.jpg'}, {'end': 819.541, 'src': 'embed', 'start': 795.826, 'weight': 3, 'content': [{'end': 804.672, 'text': 'In terms of soft skills, you need to participate in one resume project challenge on my portal codebasics.io.', 'start': 795.826, 'duration': 8.846}, {'end': 806.833, 'text': 'So if you go to codebasics.io,', 'start': 804.692, 'duration': 2.141}, {'end': 814.778, 'text': 'you will see this resume project challenge page where every month we conduct a challenge where we give a unique data set and a problem statement.', 'start': 806.833, 'duration': 7.945}, {'end': 819.541, 'text': 'We also give all the training material where we include business knowledge.', 'start': 815.119, 'duration': 4.422}], 'summary': 'Participate in a monthly resume project challenge on codebasics.io for soft skill development.', 'duration': 23.715, 'max_score': 795.826, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/b_n-hhtMbXA/pics/b_n-hhtMbXA795826.jpg'}, {'end': 961.772, 'src': 'embed', 'start': 934.862, 'weight': 1, 'content': [{'end': 938.623, 'text': "I'm also making separate posts where I'm highlighting all these entries.", 'start': 934.862, 'duration': 3.761}, {'end': 944.105, 'text': 'For example, in our first two challenges, these are the 10 people who did pretty well.', 'start': 938.663, 'duration': 5.442}, {'end': 952.248, 'text': 'And see, when many people are engaging, they come to know about your talent and they may reach out to you directly for a job.', 'start': 944.205, 'duration': 8.043}, {'end': 957.09, 'text': 'You will spend week 8, 9 and 10 learning Python and Pandas.', 'start': 952.609, 'duration': 4.481}, {'end': 961.772, 'text': 'Now in Python, once again, you need to know these basic concepts.', 'start': 957.31, 'duration': 4.462}], 'summary': 'Highlighting top 10 performers brings attention to talent, attracting job opportunities. week 8-10 will focus on learning python and pandas.', 'duration': 26.91, 'max_score': 934.862, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/b_n-hhtMbXA/pics/b_n-hhtMbXA934862.jpg'}, {'end': 990.126, 'src': 'heatmap', 'start': 957.31, 'weight': 0.797, 'content': [{'end': 961.772, 'text': 'Now in Python, once again, you need to know these basic concepts.', 'start': 957.31, 'duration': 4.462}, {'end': 963.713, 'text': "You don't need to go crazy about it.", 'start': 961.812, 'duration': 1.901}, {'end': 965.614, 'text': 'for learning resources.', 'start': 963.933, 'duration': 1.681}, {'end': 970.617, 'text': 'track a is free track where you can go to youtube and follow my playlist.', 'start': 965.614, 'duration': 5.003}, {'end': 975.159, 'text': 'in this playlist, you need to follow the first 16 videos only now.', 'start': 970.617, 'duration': 4.542}, {'end': 981.703, 'text': "these videos have exercises as well, so you're learning concepts, then you're learning coding and the exercises.", 'start': 975.159, 'duration': 6.544}, {'end': 990.126, 'text': 'so i have given the exercise list as well, so you can click on this particular github link and you will get those exercises track.', 'start': 981.703, 'duration': 8.423}], 'summary': 'Learn python basics through 16 free videos with exercises on youtube and github.', 'duration': 32.816, 'max_score': 957.31, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/b_n-hhtMbXA/pics/b_n-hhtMbXA957310.jpg'}], 'start': 570.456, 'title': 'Power bi fundamentals and data analysis career guidance', 'summary': 'Covers p&l fundamentals in power bi, emphasizes skills for finance data analysts, and offers learning opportunities. it also discusses the importance of soft skills, project management, and learning resources for sql, python, and pandas.', 'chapters': [{'end': 678.57, 'start': 570.456, 'title': 'P&l fundamentals in power bi course', 'summary': 'Covers the fundamental skills of p&l, emphasizing its importance for data analysts in finance divisions and offering the opportunity to learn through a power bi course, with a focus on asking effective questions and sharing learning through linkedin posts.', 'duration': 108.114, 'highlights': ['The Power BI course covers P&L fundamentals in an easy-to-understand language, making it an essential skill for data analysts in finance divisions.', 'Emphasizing the importance of asking questions effectively, by providing an example of an effective question and its impact on seeking help from others.', 'Encouraging learners to share their learning through LinkedIn posts, with an example of summarizing learning from a YouTube playlist and engaging with others.', 'Highlighting the opportunity to join the Discord server to ask questions and seek help, creating a supportive learning environment for participants.']}, {'end': 1137.528, 'start': 678.57, 'title': 'Data analytics career guidance', 'summary': 'Covers learning sql, python, and pandas for data analysis, emphasizing the importance of soft skills and project management in career advancement, and the learning resources available for each topic.', 'duration': 458.958, 'highlights': ['You will spend week 8, 9 and 10 learning Python and Pandas. Week 8, 9, and 10 are dedicated to learning Python and Pandas for data analysis.', 'In week six and seven, you will learn SQL, including basic and advanced queries, stored procedures, and functions. Week 6 and 7 focus on learning SQL, covering basic and advanced queries, stored procedures, and functions.', 'The importance of participating in a resume project challenge on codebasics.io and making a LinkedIn post to showcase technical and soft skills. Encourages participation in a resume project challenge and making a LinkedIn post to highlight technical and soft skills, aiding in career advancement.', 'Emphasizes the significance of soft skills and project management in career advancement, recommending resources for learning Agile project management methodologies such as Scrum and Kanban. Stresses the importance of soft skills and project management in career advancement, with a focus on learning Agile project management methodologies and providing recommended resources.', 'Provides learning resources for SQL, Python, and Pandas, including free and paid tracks, courses, and tutorials. Offers various learning resources for SQL, Python, and Pandas, including free and paid tracks, courses, and tutorials.']}], 'duration': 567.072, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/b_n-hhtMbXA/pics/b_n-hhtMbXA570456.jpg', 'highlights': ['The Power BI course covers P&L fundamentals in an easy-to-understand language, making it an essential skill for data analysts in finance divisions.', 'Week 8, 9, and 10 are dedicated to learning Python and Pandas for data analysis.', 'Week 6 and 7 focus on learning SQL, covering basic and advanced queries, stored procedures, and functions.', 'Encourages participation in a resume project challenge and making a LinkedIn post to highlight technical and soft skills, aiding in career advancement.', 'Stresses the importance of soft skills and project management in career advancement, with a focus on learning Agile project management methodologies and providing recommended resources.', 'Offers various learning resources for SQL, Python, and Pandas, including free and paid tracks, courses, and tutorials.', 'Emphasizing the importance of asking questions effectively, by providing an example of an effective question and its impact on seeking help from others.', 'Encouraging learners to share their learning through LinkedIn posts, with an example of summarizing learning from a YouTube playlist and engaging with others.', 'Highlighting the opportunity to join the Discord server to ask questions and seek help, creating a supportive learning environment for participants.', 'Provides learning resources for SQL, Python, and Pandas, including free and paid tracks, courses, and tutorials.']}, {'end': 1571.402, 'segs': [{'end': 1165.678, 'src': 'embed', 'start': 1137.848, 'weight': 0, 'content': [{'end': 1140.049, 'text': 'There are a lot of other tools as well.', 'start': 1137.848, 'duration': 2.201}, {'end': 1141.629, 'text': 'You need to know just one tool.', 'start': 1140.369, 'duration': 1.26}, {'end': 1147.891, 'text': 'In terms of your assignment, you need to participate in one more resume project challenge on my website.', 'start': 1141.829, 'duration': 6.062}, {'end': 1151.512, 'text': 'Then make a LinkedIn post but this time with audio.', 'start': 1148.371, 'duration': 3.141}, {'end': 1154.053, 'text': 'For the first challenge, you made a post but it was all text.', 'start': 1151.612, 'duration': 2.441}, {'end': 1161.975, 'text': "Second time, you prepare a presentation as if you're presenting to business stakeholders and you record your audio.", 'start': 1154.273, 'duration': 7.702}, {'end': 1165.678, 'text': 'and you put that audio along with your linkedin post.', 'start': 1162.535, 'duration': 3.143}], 'summary': 'Participate in one more resume project challenge on the website, make a linkedin post with audio, following specific guidelines.', 'duration': 27.83, 'max_score': 1137.848, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/b_n-hhtMbXA/pics/b_n-hhtMbXA1137848.jpg'}, {'end': 1240.775, 'src': 'embed', 'start': 1213.474, 'weight': 2, 'content': [{'end': 1217.638, 'text': 'last two weeks are going to be about resume and interview preparations.', 'start': 1213.474, 'duration': 4.164}, {'end': 1223.863, 'text': "resumes are dying as such and you should focus more on online skills, but they're not dead yet.", 'start': 1217.638, 'duration': 6.225}, {'end': 1225.764, 'text': 'so you need to have one resume.', 'start': 1223.863, 'duration': 1.901}, {'end': 1230.988, 'text': 'we did this one video where we have given two very good resume templates.', 'start': 1225.764, 'duration': 5.224}, {'end': 1235.632, 'text': 'so you can just go to video description, download the template and fill in your details all right,', 'start': 1230.988, 'duration': 4.644}, {'end': 1240.775, 'text': 'and we have mentioned in this video what makes an effective resume.', 'start': 1235.632, 'duration': 5.143}], 'summary': 'Focus on online skills, get one effective resume, and use provided templates.', 'duration': 27.301, 'max_score': 1213.474, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/b_n-hhtMbXA/pics/b_n-hhtMbXA1213474.jpg'}, {'end': 1352.045, 'src': 'embed', 'start': 1323.773, 'weight': 3, 'content': [{'end': 1329.157, 'text': 'He has provided the exact emails that he wrote in terms of cold emailing.', 'start': 1323.773, 'duration': 5.384}, {'end': 1333.859, 'text': 'You can also use the network that you have built on LinkedIn.', 'start': 1330.138, 'duration': 3.721}, {'end': 1334.42, 'text': 'All right.', 'start': 1334.119, 'duration': 0.301}, {'end': 1338.321, 'text': 'So you have made some friends, hopefully by this time on LinkedIn.', 'start': 1334.44, 'duration': 3.881}, {'end': 1346.444, 'text': 'And also you have gained some traction on your profile through the post you are making for those resume project challenges.', 'start': 1338.401, 'duration': 8.043}, {'end': 1352.045, 'text': 'And now you can use that network for job applications.', 'start': 1346.824, 'duration': 5.221}], 'summary': 'Leverage linkedin network and resume project challenges to enhance job applications.', 'duration': 28.272, 'max_score': 1323.773, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/b_n-hhtMbXA/pics/b_n-hhtMbXA1323773.jpg'}, {'end': 1420.742, 'src': 'embed', 'start': 1396.104, 'weight': 4, 'content': [{'end': 1403.568, 'text': 'You want to make sure you spend less time in consuming and more time in digesting, implementing and sharing.', 'start': 1396.104, 'duration': 7.464}, {'end': 1406.61, 'text': 'This is the formula for effective learning.', 'start': 1403.768, 'duration': 2.842}, {'end': 1411.774, 'text': 'Most of the people, they consume a lot of videos, but they practice very less.', 'start': 1407.27, 'duration': 4.504}, {'end': 1415.878, 'text': "So you can't do effective learning by following that particular approach.", 'start': 1412.114, 'duration': 3.764}, {'end': 1420.742, 'text': "The way it works is let's say you watch a video on Python or Power BI.", 'start': 1416.098, 'duration': 4.644}], 'summary': 'Effective learning involves spending less time consuming and more time digesting, implementing, and sharing. people often consume a lot of videos but practice very little, hindering effective learning.', 'duration': 24.638, 'max_score': 1396.104, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/b_n-hhtMbXA/pics/b_n-hhtMbXA1396104.jpg'}, {'end': 1470.304, 'src': 'embed', 'start': 1444.041, 'weight': 1, 'content': [{'end': 1451.626, 'text': 'so when you share the knowledge that you have gained, that knowledge becomes very solid in your brain so you can share it with your friends.', 'start': 1444.041, 'duration': 7.585}, {'end': 1455.249, 'text': 'you can share by helping others on the discord server.', 'start': 1451.626, 'duration': 3.623}, {'end': 1456.87, 'text': 'The next tip is group learning.', 'start': 1455.469, 'duration': 1.401}, {'end': 1458.772, 'text': "Let's say you go to gym and you're going alone.", 'start': 1456.91, 'duration': 1.862}, {'end': 1464.518, 'text': "It is not fun, but let's say if you go to gym with two of your friends, it is much better experience.", 'start': 1458.852, 'duration': 5.666}, {'end': 1470.304, 'text': 'Similarly, you can use group learning concept to prepare for your three month data analyst roadmap.', 'start': 1464.558, 'duration': 5.746}], 'summary': 'Sharing knowledge solidifies learning; group learning enhances experience and preparation.', 'duration': 26.263, 'max_score': 1444.041, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/b_n-hhtMbXA/pics/b_n-hhtMbXA1444041.jpg'}, {'end': 1541.082, 'src': 'embed', 'start': 1512.032, 'weight': 5, 'content': [{'end': 1514.953, 'text': 'In the end, I have shared some inspirational stories.', 'start': 1512.032, 'duration': 2.921}, {'end': 1519.795, 'text': 'For example, this particular video is how a BCom graduate become data analyst.', 'start': 1515.053, 'duration': 4.742}, {'end': 1521.775, 'text': 'I keep on interviewing these people.', 'start': 1520.135, 'duration': 1.64}, {'end': 1525.177, 'text': 'You will find so many of these videos on my YouTube channel.', 'start': 1521.835, 'duration': 3.342}, {'end': 1529.918, 'text': 'If you go to YouTube and search for Code Basics Career Transition, you will find an entire playlist.', 'start': 1525.257, 'duration': 4.661}, {'end': 1535.42, 'text': 'Check this, right? BCom graduate becoming data analyst, mechanical engineer becoming data analyst.', 'start': 1530.058, 'duration': 5.362}, {'end': 1541.082, 'text': 'And when you listen to these people, you will get a lot of tips for your own journey too.', 'start': 1535.48, 'duration': 5.602}], 'summary': 'Youtube channel features inspiring stories of career transitions, including bcom and mechanical engineering graduates becoming data analysts.', 'duration': 29.05, 'max_score': 1512.032, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/b_n-hhtMbXA/pics/b_n-hhtMbXA1512032.jpg'}], 'start': 1137.848, 'title': 'Linkedin project and networking strategy', 'summary': 'Outlines a linkedin project challenge involving audio posts, emphasizing the benefits of helping others on platforms like discord, highlighting potential skill acquisition and networking opportunities. it also provides tips for resume and interview preparation, including resources for sql and power bi, techniques for job applications, effective learning strategies, and inspirational stories for career transition.', 'chapters': [{'end': 1213.474, 'start': 1137.848, 'title': 'Linkedin project and networking strategy', 'summary': 'Outlines a linkedin project challenge involving audio posts and emphasizes the benefits of helping others on platforms like discord, highlighting the potential skill acquisition and networking opportunities.', 'duration': 75.626, 'highlights': ['By participating in a LinkedIn project challenge involving audio posts, individuals can practice verbal communication skills and enhance their professional online presence.', 'Helping others on platforms like Discord not only allows individuals to acquire new skills by answering questions but also helps in building a network, potentially leading to job referrals.']}, {'end': 1571.402, 'start': 1213.474, 'title': 'Resume and interview preparation tips', 'summary': 'Provides tips for resume and interview preparation, including resources for sql and power bi, techniques for job applications, effective learning strategies, and inspirational stories for career transition.', 'duration': 357.928, 'highlights': ['The chapter provides tips for resume and interview preparation, including resources for SQL and Power BI. The chapter discusses the importance of resume and interview preparation, emphasizing the relevance of online skills and providing resources for SQL and Power BI.', 'Techniques for job applications, including cold emailing and leveraging LinkedIn network, are explained. The chapter outlines techniques for job applications, such as cold emailing and utilizing the LinkedIn network to seek job referrals.', 'Effective learning strategies are shared, emphasizing the importance of digesting, implementing, and sharing knowledge. The chapter emphasizes effective learning strategies, focusing on digesting, implementing, and sharing knowledge to solidify learning.', 'Inspirational stories for career transition are provided, offering insights and motivation for those aspiring to enter the data analysis industry. The chapter shares inspirational stories of career transition, providing motivation and insights for individuals aspiring to enter the data analysis industry.']}], 'duration': 433.554, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/b_n-hhtMbXA/pics/b_n-hhtMbXA1137848.jpg', 'highlights': ['By participating in a LinkedIn project challenge involving audio posts, individuals can practice verbal communication skills and enhance their professional online presence.', 'Helping others on platforms like Discord not only allows individuals to acquire new skills by answering questions but also helps in building a network, potentially leading to job referrals.', 'The chapter provides tips for resume and interview preparation, including resources for SQL and Power BI, emphasizing the relevance of online skills.', 'Techniques for job applications, such as cold emailing and utilizing the LinkedIn network to seek job referrals, are explained.', 'Effective learning strategies are shared, emphasizing the importance of digesting, implementing, and sharing knowledge to solidify learning.', 'Inspirational stories for career transition are provided, offering insights and motivation for those aspiring to enter the data analysis industry.']}], 'highlights': ['The roadmap outlines a three-month plan for preparing for a data analyst career, with a focus on technical and soft skills, involving four hours of daily study, where three hours are dedicated to technical skills and one hour to soft skills.', 'The plan includes free learning resources, a week-by-week study plan, and exercises for effective learning and skill-building.', 'The roadmap emphasizes interview preparation in the last weeks of the three-month period, aiming to make the candidate job-ready by the end of the timeline, based on the success of a similar roadmap receiving 1.5 million views three years ago.', 'Excel is heavily used in the data analytics industry, making it a necessary skill in any data analyst job profile.', 'In the first two weeks, learning Microsoft Excel, business math, and statistics is crucial for beginners in data analytics.', 'The importance of creating a professional LinkedIn profile with a clear headshot and engaging banner image is highlighted as a way to demonstrate soft skills and improve employability.', 'The chapter emphasizes the growing demand for Power BI skills, with most data analyst jobs requiring BI knowledge, and Power BI being favored over Tableau due to its ease of use and future job growth potential.', 'The Power BI course covers P&L fundamentals in an easy-to-understand language, making it an essential skill for data analysts in finance divisions.', 'Week 8, 9, and 10 are dedicated to learning Python and Pandas for data analysis.', 'Week 6 and 7 focus on learning SQL, covering basic and advanced queries, stored procedures, and functions.', 'Encourages participation in a resume project challenge and making a LinkedIn post to highlight technical and soft skills, aiding in career advancement.', 'Stresses the importance of soft skills and project management in career advancement, with a focus on learning Agile project management methodologies and providing recommended resources.', 'By participating in a LinkedIn project challenge involving audio posts, individuals can practice verbal communication skills and enhance their professional online presence.', 'Helping others on platforms like Discord not only allows individuals to acquire new skills by answering questions but also helps in building a network, potentially leading to job referrals.', 'The chapter provides tips for resume and interview preparation, including resources for SQL and Power BI, emphasizing the relevance of online skills.', 'Techniques for job applications, such as cold emailing and utilizing the LinkedIn network to seek job referrals, are explained.']}