title
Learn data analytics skills in 3 months, step by step | Complete data analyst roadmap in 2022

description
Do you want to learn data analyst skills and not sure where to start? In this video I will provide a 3 months step by step roadmap to acquire data analyst skills using online free resources. Complete data analyst roadmap: https://github.com/codebasics/py/blob/master/TechTopics/DataAnalystRoadMap2020/data_analyst_learning_path_2020.md 0:00 Introduction 0:41 Excel and Statistics 6:25 BI tools 9:12 Python 10:52 Numpy, Pandas, Data Visualization Libraries 12:56 SQL & MongoDB 13:59 Soft Skills 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. Video in Hindi: https://www.youtube.com/watch?v=aBHhBwcDwN0 Need help building software or data analytics and AI solutions? My company https://www.atliq.com/ can help. Click on the Contact button on that website. #️⃣ Social Medias #️⃣ 🔗 Discord: https://discord.gg/r42Kbuk 📸 Dhaval's Personal Instagram: https://www.instagram.com/dhavalsays/ 📸 Instagram: https://www.instagram.com/codebasicshub/ 🌎 Website: https://codebasics.io/ 🔊 Facebook: https://www.facebook.com/codebasicshub 📱 Twitter: https://twitter.com/codebasicshub 📝 Linkedin: https://www.linkedin.com/company/codebasics/ ❗❗ DISCLAIMER: All opinions expressed in this video are of my own and not that of my employers'.

detail
{'title': 'Learn data analytics skills in 3 months, step by step | Complete data analyst roadmap in 2022', 'heatmap': [{'end': 95.717, 'start': 77.15, 'weight': 0.751}, {'end': 313.401, 'start': 283.391, 'weight': 0.763}, {'end': 407.049, 'start': 359.489, 'weight': 0.744}], 'summary': 'Learn data analytics skills in a 3-month roadmap, dedicating 4 hours daily to microsoft excel, power bi, tableau, and qlik sense, with practical project ideas, suitable for non-technical beginners.', 'chapters': [{'end': 82.532, 'segs': [{'end': 27.146, 'src': 'embed', 'start': 0.953, 'weight': 0, 'content': [{'end': 5.135, 'text': 'Do you want to learn data analyst skills and you are not sure where to start?', 'start': 0.953, 'duration': 4.182}, {'end': 12.298, 'text': "In this video, I'm going to provide three months step by step roadmap to learn data analyst skills,", 'start': 5.655, 'duration': 6.643}, {'end': 17.4, 'text': 'assuming you do four hours of dedicated study every single day.', 'start': 12.298, 'duration': 5.102}, {'end': 20.041, 'text': "Now, you don't need to have any prior background.", 'start': 17.88, 'duration': 2.161}, {'end': 21.962, 'text': 'You could be a mechanical engineer.', 'start': 20.341, 'duration': 1.621}, {'end': 27.146, 'text': 'or even a person working in totally different non-technical field.', 'start': 22.922, 'duration': 4.224}], 'summary': '3-month roadmap to learn data analyst skills, 4 hours/day, for beginners from any background.', 'duration': 26.193, 'max_score': 0.953, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/_eAl7vuVu3U/pics/_eAl7vuVu3U953.jpg'}, {'end': 82.532, 'src': 'embed', 'start': 55.577, 'weight': 2, 'content': [{'end': 63.421, 'text': 'most of the time, data analyst and data scientist will be doing some type of data analysis in Microsoft Excel.', 'start': 55.577, 'duration': 7.844}, {'end': 72.895, 'text': 'now you need to know certain features, such as basic data filter functionality functions, VBA macros, pivot table,', 'start': 63.421, 'duration': 9.474}, {'end': 76.077, 'text': 'doing basic charts and plots and things like that.', 'start': 72.895, 'duration': 3.182}, {'end': 82.532, 'text': 'Your first Excel data science project could be managing your own personal finances.', 'start': 77.15, 'duration': 5.382}], 'summary': 'Data analysts and scientists use excel for data analysis, including basic features like data filters, vba macros, pivot tables, and charts. a first project could involve managing personal finances.', 'duration': 26.955, 'max_score': 55.577, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/_eAl7vuVu3U/pics/_eAl7vuVu3U55577.jpg'}], 'start': 0.953, 'title': 'A data analyst skills roadmap', 'summary': 'Outlines a three-month roadmap for learning data analyst skills through four hours of daily study, focusing on microsoft excel and offering a practical project idea, suitable for beginners from non-technical backgrounds.', 'chapters': [{'end': 82.532, 'start': 0.953, 'title': 'Data analyst skills roadmap', 'summary': 'Outlines a three-month roadmap for learning data analyst skills by dedicating four hours of study daily, emphasizing the importance of microsoft excel and providing a practical project idea, suitable for beginners from non-technical backgrounds.', 'duration': 81.579, 'highlights': ['Microsoft Excel is the most popular data crunching tool in the industry, emphasizing the importance of learning essential skills like basic data filter functionality, VBA macros, pivot tables, and basic charts and plots, to manage personal finances as a first data science project.', 'A three-month step-by-step roadmap for learning data analyst skills is provided, assuming four hours of dedicated study every single day, encouraging beginners from non-technical backgrounds to use online free resources.', 'Emphasizing the accessibility of the roadmap to beginners from non-technical backgrounds, including mechanical engineers or individuals working in non-technical fields, to effectively acquire data analyst skills through dedicated daily study.', 'Highlighting the significance of Microsoft Excel as the most popular data crunching tool in the industry, underlining its relevance for data analysis and data science, especially with smaller data sets, and the need to learn specific features for effective data manipulation.']}], 'duration': 81.579, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/_eAl7vuVu3U/pics/_eAl7vuVu3U953.jpg', 'highlights': ['A three-month step-by-step roadmap for learning data analyst skills is provided, assuming four hours of dedicated study every single day, encouraging beginners from non-technical backgrounds to use online free resources.', 'Emphasizing the accessibility of the roadmap to beginners from non-technical backgrounds, including mechanical engineers or individuals working in non-technical fields, to effectively acquire data analyst skills through dedicated daily study.', 'Microsoft Excel is the most popular data crunching tool in the industry, emphasizing the importance of learning essential skills like basic data filter functionality, VBA macros, pivot tables, and basic charts and plots, to manage personal finances as a first data science project.', 'Highlighting the significance of Microsoft Excel as the most popular data crunching tool in the industry, underlining its relevance for data analysis and data science, especially with smaller data sets, and the need to learn specific features for effective data manipulation.']}, {'end': 423.9, 'segs': [{'end': 109.745, 'src': 'embed', 'start': 83.372, 'weight': 0, 'content': [{'end': 87.554, 'text': 'On Google Docs, there is a template gallery for personal finances.', 'start': 83.372, 'duration': 4.182}, {'end': 95.717, 'text': 'So if you click on this link, you will find these templates where you can track your monthly incomes and expenses.', 'start': 87.594, 'duration': 8.123}, {'end': 98.678, 'text': "So if you click on, let's say, monthly budget,", 'start': 95.917, 'duration': 2.761}, {'end': 109.745, 'text': 'you will find this Excel file where you can enter your monthly expenses and then it will tell you how much money is left after doing all these expenses.', 'start': 98.678, 'duration': 11.067}], 'summary': 'Google docs offers a template gallery for personal finances, including a monthly budget excel file for tracking expenses and calculating remaining money.', 'duration': 26.373, 'max_score': 83.372, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/_eAl7vuVu3U/pics/_eAl7vuVu3U83372.jpg'}, {'end': 215.127, 'src': 'embed', 'start': 159.445, 'weight': 2, 'content': [{'end': 164.528, 'text': 'so if you look at these charts right, see they have these formulas.', 'start': 159.445, 'duration': 5.083}, {'end': 166.43, 'text': 'so these are the formulas you want to learn.', 'start': 164.528, 'duration': 1.902}, {'end': 179.215, 'text': 'if you look at, like different cells, you will see how they come up with these kind of interactive visualizations in excel,', 'start': 167.87, 'duration': 11.345}, {'end': 189.7, 'text': 'and what you want to do is you want to create your own excel file that can maintain your monthly expenses and income and, in the end,', 'start': 179.215, 'duration': 10.485}, {'end': 194.581, 'text': 'you can plot the trends in which month you are having the maximum expense?', 'start': 189.7, 'duration': 4.881}, {'end': 198.082, 'text': 'what is your trend of income overall, month to month?', 'start': 194.581, 'duration': 3.501}, {'end': 199.923, 'text': 'is it increasing or not?', 'start': 198.082, 'duration': 1.841}, {'end': 208.225, 'text': 'so all of this you will be able to do in Excel and, in the end, you are producing a tool which is helping you.', 'start': 199.923, 'duration': 8.302}, {'end': 215.127, 'text': 'so this gives you a mental reward and you can continue on your learning journey with passion.', 'start': 208.225, 'duration': 6.902}], 'summary': 'Learn to create interactive visualizations in excel to track monthly expenses and income, analyze trends, and produce a useful tool for financial management.', 'duration': 55.682, 'max_score': 159.445, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/_eAl7vuVu3U/pics/_eAl7vuVu3U159445.jpg'}, {'end': 270.66, 'src': 'embed', 'start': 239.565, 'weight': 5, 'content': [{'end': 244.527, 'text': 'so if you fill all these numbers here, you will see these charts being updated.', 'start': 239.565, 'duration': 4.962}, {'end': 252.232, 'text': 'so your goal is to Take inspiration from these files and you create your own budget tracker.', 'start': 244.527, 'duration': 7.705}, {'end': 257.175, 'text': 'that will be the best beginner Excel project that you can work on.', 'start': 252.232, 'duration': 4.943}, {'end': 266.295, 'text': 'There is a YouTube channel called Chandu and I suggest that you learn Excel things from here.', 'start': 259.708, 'duration': 6.587}, {'end': 267.597, 'text': 'This guy is great.', 'start': 266.596, 'duration': 1.001}, {'end': 270.66, 'text': 'He explains Excel really well.', 'start': 267.717, 'duration': 2.943}], 'summary': "Create a budget tracker in excel using inspiration from provided charts. recommended source for learning: chandu's youtube channel.", 'duration': 31.095, 'max_score': 239.565, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/_eAl7vuVu3U/pics/_eAl7vuVu3U239565.jpg'}, {'end': 330.256, 'src': 'heatmap', 'start': 283.391, 'weight': 6, 'content': [{'end': 290.573, 'text': "while you're learning excel, you also want to tackle statistics, because statistics is used everywhere.", 'start': 283.391, 'duration': 7.182}, {'end': 294.993, 'text': "so the first uh resource i suggest is khan academy's basic course.", 'start': 290.573, 'duration': 4.42}, {'end': 301.735, 'text': 'so if you look at this course, it has a very nice explanation using visualization.', 'start': 294.993, 'duration': 6.742}, {'end': 303.775, 'text': 'it also has exercises.', 'start': 301.735, 'duration': 2.04}, {'end': 313.401, 'text': 'so make sure you complete this course and you will learn basic things about what is normal distribution, the inferential statistics,', 'start': 303.775, 'duration': 9.626}, {'end': 322.569, 'text': 'the descriptive statistics, probability, the sample distribution, summarizing, quantitative data and so on.', 'start': 313.401, 'duration': 9.168}, {'end': 330.256, 'text': 'these are the concepts you want to start with and as you do more projects, you can learn advanced topics.', 'start': 322.569, 'duration': 7.687}], 'summary': "Learn basic statistics with khan academy's course to understand normal distribution, inferential and descriptive statistics, probability, and quantitative data.", 'duration': 28.521, 'max_score': 283.391, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/_eAl7vuVu3U/pics/_eAl7vuVu3U283391.jpg'}, {'end': 426.302, 'src': 'heatmap', 'start': 359.489, 'weight': 7, 'content': [{'end': 363.33, 'text': 'box plot is used for outlier removal.', 'start': 359.489, 'duration': 3.841}, {'end': 366.431, 'text': 'So you want to learn all these basic things.', 'start': 363.87, 'duration': 2.561}, {'end': 371.493, 'text': 'The other channel that I suggest is StatQuest with Joe Strammer.', 'start': 367.231, 'duration': 4.262}, {'end': 377.974, 'text': 'This person explains complex concepts in a very simple manner using visualizations.', 'start': 372.073, 'duration': 5.901}, {'end': 384.436, 'text': "So if you have any doubt on statistics, any topic you're not sure about, please refer to this channel.", 'start': 378.434, 'duration': 6.002}, {'end': 393.821, 'text': 'after spending first two weeks in learning excel and statistics, you should spend next three weeks, which is week number three, four and five,', 'start': 384.756, 'duration': 9.065}, {'end': 398.964, 'text': 'in learning bi tools such as power, bi tableau and click sense.', 'start': 393.821, 'duration': 5.143}, {'end': 405.008, 'text': 'these are the three most popular tools in the industry, but you can learn just one or two tools.', 'start': 398.964, 'duration': 6.044}, {'end': 407.049, 'text': 'even if you learn one tool, that should be good enough.', 'start': 405.008, 'duration': 2.041}, {'end': 411.552, 'text': 'Now, these tools allow you to connect to different data sources.', 'start': 407.529, 'duration': 4.023}, {'end': 414.274, 'text': 'It could be Excel, MySQL, or MongoDB.', 'start': 411.632, 'duration': 2.642}, {'end': 420.578, 'text': 'And you can pull the data and build dashboards and different analytics.', 'start': 414.854, 'duration': 5.724}, {'end': 423.9, 'text': 'So for BI tools, as I said, three weeks.', 'start': 420.938, 'duration': 2.962}, {'end': 426.302, 'text': 'If you want to learn Power BI.', 'start': 424.581, 'duration': 1.721}], 'summary': 'Learn basic statistics, then spend 3 weeks on bi tools like power bi, tableau, and qlik sense, which can connect to various data sources to build dashboards and analytics.', 'duration': 66.813, 'max_score': 359.489, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/_eAl7vuVu3U/pics/_eAl7vuVu3U359489.jpg'}], 'start': 83.372, 'title': 'Personal finance tracking and excel learning path', 'summary': 'Discusses using google docs templates for personal finance tracking, including monthly and annual budgeting, and advocates for learning excel, statistics, and spending time on bi tools like power bi, tableau, and qlik sense.', 'chapters': [{'end': 239.565, 'start': 83.372, 'title': 'Personal finance tracking on google docs', 'summary': 'Discusses using google docs templates for personal finance tracking, including monthly budgeting and annual budget tracking, with the aim of creating visualizations and producing a tool to monitor expenses and income trends in excel.', 'duration': 156.193, 'highlights': ['Google Docs offers templates for personal finance tracking including monthly budgeting and annual budget tracking. Google Docs provides a template gallery for personal finances, offering templates for tracking monthly incomes and expenses as well as annual budget tracking.', 'The Excel file allows tracking of monthly expenses and provides a summary of the remaining money. The Excel file enables users to enter monthly expenses and calculates the remaining money after deducting these expenses, providing a summary of the financial status.', 'Learning the formulas in Excel can help in creating visualizations and charts for personal finances. Learning the formulas in Excel is essential for creating visualizations and charts for personal finances, which is beneficial for data scientists or analysts.', 'Creating an Excel file for tracking monthly expenses and income helps in analyzing expense trends and overall income trends. Creating an Excel file to track monthly expenses and income enables analysis of expense and income trends, aiding in assessing the variation in monthly expenses and overall income.', 'Using formulas in Excel aids in creating visualizations such as bar charts for personal finance tracking. Formulas in Excel are utilized to create visualizations, including bar charts, for personal finance tracking, providing a visual representation of financial data.']}, {'end': 423.9, 'start': 239.565, 'title': 'Excel and statistics learning path', 'summary': "Advocates for learning excel and statistics, emphasizing the importance of a budget tracker project, khan academy's basic course for statistics, and spending three weeks on bi tools such as power bi, tableau, and qlik sense.", 'duration': 184.335, 'highlights': ['Emphasizes the importance of a budget tracker project as the best beginner Excel project to work on. Creating a budget tracker is recommended as the best beginner Excel project to work on.', "Recommends Khan Academy's basic statistics course for learning fundamental statistical concepts such as normal distribution, inferential statistics, descriptive statistics, and probability, with exercises for practice. Suggests completing Khan Academy's basic statistics course which covers fundamental statistical concepts and provides exercises for practice.", 'Advises spending three weeks on BI tools such as Power BI, Tableau, and Qlik Sense, which allow connecting to different data sources, building dashboards, and performing analytics. Suggests devoting three weeks to learning BI tools like Power BI, Tableau, and Qlik Sense, emphasizing their capability to connect to various data sources and create analytics dashboards.']}], 'duration': 340.528, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/_eAl7vuVu3U/pics/_eAl7vuVu3U83372.jpg', 'highlights': ['Google Docs offers templates for personal finance tracking including monthly budgeting and annual budget tracking.', 'The Excel file enables users to enter monthly expenses and calculates the remaining money after deducting these expenses, providing a summary of the financial status.', 'Creating an Excel file for tracking monthly expenses and income helps in analyzing expense trends and overall income trends.', 'Learning the formulas in Excel is essential for creating visualizations and charts for personal finances, which is beneficial for data scientists or analysts.', 'Formulas in Excel are utilized to create visualizations, including bar charts, for personal finance tracking, providing a visual representation of financial data.', 'Creating a budget tracker is recommended as the best beginner Excel project to work on.', "Suggests completing Khan Academy's basic statistics course which covers fundamental statistical concepts and provides exercises for practice.", 'Suggests devoting three weeks to learning BI tools like Power BI, Tableau, and Qlik Sense, emphasizing their capability to connect to various data sources and create analytics dashboards.']}, {'end': 1126.336, 'segs': [{'end': 477.508, 'src': 'embed', 'start': 424.581, 'weight': 0, 'content': [{'end': 426.302, 'text': 'If you want to learn Power BI.', 'start': 424.581, 'duration': 1.721}, {'end': 441.892, 'text': 'I have a complete Power BI sales insights project series where I took a real-life scenario And I work with my friend who is working for a data analyst company in UK.', 'start': 426.302, 'duration': 15.59}, {'end': 444.553, 'text': 'And we together did this project.', 'start': 442.612, 'duration': 1.941}, {'end': 449.016, 'text': 'So this project is solving a real life problem using Power BI.', 'start': 444.573, 'duration': 4.443}, {'end': 457.22, 'text': 'And this project, it covers how projects are executed in corporate environment in a professional manner.', 'start': 449.636, 'duration': 7.584}, {'end': 467.304, 'text': 'So doing this project series will not only teach you the technical skills, but it will give you a glimpse of what happens in the corporate life.', 'start': 457.68, 'duration': 9.624}, {'end': 472.566, 'text': 'So you build some soft skills as well, such as project management, for example.', 'start': 467.624, 'duration': 4.942}, {'end': 477.508, 'text': 'We talked about aims grid in one of the initial videos.', 'start': 473.306, 'duration': 4.202}], 'summary': 'Complete power bi sales insights project series solving a real-life problem, covering corporate project execution and building technical and soft skills.', 'duration': 52.927, 'max_score': 424.581, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/_eAl7vuVu3U/pics/_eAl7vuVu3U424581.jpg'}, {'end': 570.488, 'src': 'embed', 'start': 544.626, 'weight': 6, 'content': [{'end': 552.513, 'text': 'but these three months base learning will set a solid base for you so that you can continue your journey smoothly.', 'start': 544.626, 'duration': 7.887}, {'end': 556.216, 'text': 'The next important thing is Python programming language.', 'start': 552.953, 'duration': 3.263}, {'end': 560.199, 'text': "Sometimes people prefer R as well, but if you're confused, you always go with Python.", 'start': 556.316, 'duration': 3.883}, {'end': 564.363, 'text': 'You want to spend week number six and seven in Python.', 'start': 560.76, 'duration': 3.603}, {'end': 570.488, 'text': 'Now, these two weeks, you will learn just the basics of the programming language.', 'start': 564.983, 'duration': 5.505}], 'summary': '3 months of learning will set a solid base. focus on python programming for weeks 6-7.', 'duration': 25.862, 'max_score': 544.626, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/_eAl7vuVu3U/pics/_eAl7vuVu3U544626.jpg'}, {'end': 798.465, 'src': 'embed', 'start': 765.305, 'weight': 5, 'content': [{'end': 766.926, 'text': 'So you see UX selection data sets.', 'start': 765.305, 'duration': 1.621}, {'end': 775.351, 'text': 'So take these data sets and try to do analysis in Pandas, NumPy and Matplotlib.', 'start': 766.946, 'duration': 8.405}, {'end': 784.515, 'text': 'After you spent two weeks on this, The remaining weeks should be spent in learning SQL.', 'start': 776.371, 'duration': 8.144}, {'end': 789.158, 'text': "I mentioned MongoDB here, but it's okay if you don't even learn MongoDB.", 'start': 785.416, 'duration': 3.742}, {'end': 792.961, 'text': 'Now let me close all of the tabs.', 'start': 790.119, 'duration': 2.842}, {'end': 798.465, 'text': "Now for SQL, Khan Academy's SQL course is highly recommended.", 'start': 793.201, 'duration': 5.264}], 'summary': 'Analyze ux data sets using pandas, numpy, and matplotlib for two weeks, then focus on learning sql with a recommended course from khan academy.', 'duration': 33.16, 'max_score': 765.305, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/_eAl7vuVu3U/pics/_eAl7vuVu3U765305.jpg'}, {'end': 1071.516, 'src': 'embed', 'start': 1047.79, 'weight': 4, 'content': [{'end': 1058.994, 'text': 'I have done couple of sessions on resume review with some experienced data analyst and I have some data analyst resume templates as well.', 'start': 1047.79, 'duration': 11.204}, {'end': 1067.194, 'text': 'all the links are in video description below and you can use those resources to build a solid resume.', 'start': 1058.994, 'duration': 8.2}, {'end': 1071.516, 'text': 'and then there are some tips on how to build connections on LinkedIn etc.', 'start': 1067.194, 'duration': 4.322}], 'summary': 'Offered resume review sessions with data analysts, providing templates and tips for building connections on linkedin.', 'duration': 23.726, 'max_score': 1047.79, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/_eAl7vuVu3U/pics/_eAl7vuVu3U1047790.jpg'}, {'end': 1126.336, 'src': 'embed', 'start': 1095.029, 'weight': 3, 'content': [{'end': 1099.05, 'text': "But the interesting thing is you don't have to spend much money.", 'start': 1095.029, 'duration': 4.021}, {'end': 1101.931, 'text': 'You just can learn these things on your own.', 'start': 1099.13, 'duration': 2.801}, {'end': 1106.832, 'text': 'All you need is a willpower and internet connection and a laptop.', 'start': 1102.491, 'duration': 4.341}, {'end': 1108.452, 'text': 'So I hope you like this video.', 'start': 1107.212, 'duration': 1.24}, {'end': 1110.673, 'text': 'If you did, please give it a thumbs up.', 'start': 1108.893, 'duration': 1.78}, {'end': 1114.794, 'text': 'If you have any question, please leave a comment.', 'start': 1111.013, 'duration': 3.781}, {'end': 1126.336, 'text': 'try to respond to the comments which I get in first two days okay so if your question please post a comment I will try my best to respond thank you.', 'start': 1115.675, 'duration': 10.661}], 'summary': 'Learn skills inexpensively using willpower, internet, laptop. engage with viewers for feedback.', 'duration': 31.307, 'max_score': 1095.029, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/_eAl7vuVu3U/pics/_eAl7vuVu3U1095029.jpg'}], 'start': 424.581, 'title': 'Power bi sales insights project series and data analyst learning roadmap', 'summary': 'Discusses a power bi sales insights project series with a real-life scenario and a data analyst learning roadmap emphasizing various topics such as excel, python, numpy, pandas, data visualization, sql, soft skills, and networking, available on youtube and spanning a three-month period.', 'chapters': [{'end': 502.41, 'start': 424.581, 'title': 'Power bi sales insights project series', 'summary': 'Discusses a power bi sales insights project series with a real-life scenario, covering how projects are executed in a corporate environment and providing technical skills as well as soft skills like project management, available on youtube for self-learning.', 'duration': 77.829, 'highlights': ['The project series covers how projects are executed in a professional manner, offering technical skills and a glimpse of corporate life.', 'Soft skills such as project management are developed through the project series.', 'The project aims to solve a real-life problem using Power BI.', 'The series is available on YouTube for self-learning.']}, {'end': 1126.336, 'start': 502.41, 'title': 'Data analyst learning roadmap', 'summary': 'Outlines a three-month learning roadmap for becoming a data analyst, emphasizing the importance of covering various topics such as excel, python, numpy, pandas, data visualization, and sql, as well as the significance of projects, soft skills, and networking.', 'duration': 623.926, 'highlights': ['Projects are very important, and the learning will be a continuous process, setting a solid base for a smooth journey; Python programming language is essential, and learning its basics can be done in a matter of two weeks. Emphasizes the importance of projects and continuous learning to set a solid base for a smooth journey; highlights the essential nature of Python programming language, which can be learned in a matter of two weeks.', "Weeks eight and nine should be spent in learning NumPy, Pandas, and data visualization, with a recommendation to apply these skills to solve projects; The remaining weeks should be spent in learning SQL, and the Khan Academy's SQL course is highly recommended for understanding the basics. Recommends dedicating time to learning NumPy, Pandas, data visualization, and SQL, stressing the importance of applying these skills to projects and recommending the Khan Academy's SQL course for understanding the basics.", 'Group learning is emphasized for motivation and accountability, and recommendations for resources such as free PDF books on statistics and videos on transitioning to a data analyst from different backgrounds. Emphasizes the benefits of group learning for motivation and accountability, and recommends resources such as free PDF books on statistics and videos on transitioning to a data analyst from different backgrounds.']}], 'duration': 701.755, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/_eAl7vuVu3U/pics/_eAl7vuVu3U424581.jpg', 'highlights': ['The project series covers how projects are executed in a professional manner, offering technical skills and a glimpse of corporate life.', 'Soft skills such as project management are developed through the project series.', 'The project aims to solve a real-life problem using Power BI.', 'The series is available on YouTube for self-learning.', 'Emphasizes the benefits of group learning for motivation and accountability, and recommends resources such as free PDF books on statistics and videos on transitioning to a data analyst from different backgrounds.', "Recommends dedicating time to learning NumPy, Pandas, data visualization, and SQL, stressing the importance of applying these skills to projects and recommending the Khan Academy's SQL course for understanding the basics.", 'Emphasizes the importance of projects and continuous learning to set a solid base for a smooth journey; highlights the essential nature of Python programming language, which can be learned in a matter of two weeks.']}], 'highlights': ['A three-month step-by-step roadmap for learning data analyst skills is provided, assuming four hours of dedicated study every single day, encouraging beginners from non-technical backgrounds to use online free resources.', 'Emphasizing the accessibility of the roadmap to beginners from non-technical backgrounds, including mechanical engineers or individuals working in non-technical fields, to effectively acquire data analyst skills through dedicated daily study.', 'Microsoft Excel is the most popular data crunching tool in the industry, emphasizing the importance of learning essential skills like basic data filter functionality, VBA macros, pivot tables, and basic charts and plots, to manage personal finances as a first data science project.', 'Highlighting the significance of Microsoft Excel as the most popular data crunching tool in the industry, underlining its relevance for data analysis and data science, especially with smaller data sets, and the need to learn specific features for effective data manipulation.', 'Google Docs offers templates for personal finance tracking including monthly budgeting and annual budget tracking.', 'The Excel file enables users to enter monthly expenses and calculates the remaining money after deducting these expenses, providing a summary of the financial status.', 'Creating an Excel file for tracking monthly expenses and income helps in analyzing expense trends and overall income trends.', 'Learning the formulas in Excel is essential for creating visualizations and charts for personal finances, which is beneficial for data scientists or analysts.', 'Formulas in Excel are utilized to create visualizations, including bar charts, for personal finance tracking, providing a visual representation of financial data.', 'Creating a budget tracker is recommended as the best beginner Excel project to work on.', "Suggests completing Khan Academy's basic statistics course which covers fundamental statistical concepts and provides exercises for practice.", 'Suggests devoting three weeks to learning BI tools like Power BI, Tableau, and Qlik Sense, emphasizing their capability to connect to various data sources and create analytics dashboards.', 'The project series covers how projects are executed in a professional manner, offering technical skills and a glimpse of corporate life.', 'Soft skills such as project management are developed through the project series.', 'The project aims to solve a real-life problem using Power BI.', 'The series is available on YouTube for self-learning.', 'Emphasizes the benefits of group learning for motivation and accountability, and recommends resources such as free PDF books on statistics and videos on transitioning to a data analyst from different backgrounds.', "Recommends dedicating time to learning NumPy, Pandas, data visualization, and SQL, stressing the importance of applying these skills to projects and recommending the Khan Academy's SQL course for understanding the basics.", 'Emphasizes the importance of projects and continuous learning to set a solid base for a smooth journey; highlights the essential nature of Python programming language, which can be learned in a matter of two weeks.']}