title
Business Analyst Full Course In 2 Hours | Business Analyst Training For Beginners | Simplilearn

description
🔥Business Analyst Masters Program (Discount Coupon - YTBE15):https://www.simplilearn.com/business-analyst-certification-training-course?utm_campaign=23AugustTubebuddyExpBA&utm_medium=DescriptionFF&utm_source=youtube 🔥Post Graduate Program In Business Analysis: https://www.simplilearn.com/pgp-business-analysis-certification-training-course?utm_campaign=BusinessAnalytics-UBVzucVpG7k&utm_medium=DescriptionFF&utm_source=youtube In this Simplilearn video on Business Analyst Full Course In 2 Hours, you will look at topics like the importance of business analysts, their skills and their duties, the business analysis process, demo on business analysis with excel, and business analyst interview questions. So, let's get started with this business analyst training for beginners! The topics covered in this business analyst full course are: Introduction 00:00:00 Need for a Business Analyst 00:01:18 Who Is a Business Analyst 00:05:33 Business Analyst Responsibilities 00:11:50 Business Analyst Skills 00:14:01 Business Analyst Certification 00:25:06 Business Analyst Roadmap 00:30:29 Business Analysis Knowledge Areas 00:31:37 Agile Methodology 00:33:22 Scrum Methodology 00:35:01 Business Analyst Career 00:37:55 Business Analyst Tools 00:38:40 Business Analysis With Excel 00:39:08 Business Analyst vs Data Analyst 01:19:04 Dataset Link - https://drive.google.com/drive/folders/1v4uqpSHmf5GsRL740lAVKeiM4AubkKQn ✅Subscribe to our Channel to learn more about the top Technologies: https://bit.ly/2VT4WtH ⏩ Check out the Business Analytics tutorial videos: https://bit.ly/3hQFfDP #BusinessAnalystFullCourse #BusinessAnalystTraining #BusinessAnalystTrainingForBeginners #BusinessAnalystCourse #BusinessAnalyst #BusinessAnalytics #Simplilearn Who Is A Business Analyst? A business analyst understands the business problems and identifies the solutions that will maximize the organization's value to its stakeholders. A business analyst is an individual who works closely with the technology team to improve the quality of the services being delivered. They ensure the customer needs are correctly interpreted and translated into application. They possess programming, SQL, and business intelligence skills to deliver data-driven solutions. ➡️ About Post Graduate Program In Business Analysis This Post Graduate Program in Business Analysis is for professionals looking to pursue a Business Analysis career, understand business analysis techniques, get hands-on experience, and for experienced analysts looking to learn the latest tools and frameworks used by Agile teams. ✅ Key Features - Certificate from Simplilearn in collaboration with Purdue University - Become eligible to be part of the Purdue University Alumni Association - Master Classes delivered by Purdue faculty - Earn 35 PDs/CDUs post completion of the CBAP® module - Harvard Business Publishing case studies of Pearson, CarMax, EvCard, etc. - Capstone from 3 domains and 14+ projects - Simplilearn Career Service helps you get noticed by top hiring companies - Get mentored and network with Business Analyst from Amazon, Microsoft, and Google ✅ Skills Covered - Business Analysis - Elicitation and Collaboration - BRD FRD and SRS Document Creation - Requirements Analysis - Planning and Monitoring - Requirements Life Cycle Management - Strategy Analysis - Wireframing - Solution Evaluation - Dashboarding - Data Visualization - Agile scrum methodology - Scrum Artifacts - Statistical Analysis using Excel - SQL Database - Python - Data analysis - Digital Transformation Learn more at: https://www.simplilearn.com/pgp-business-analysis-certification-training-course?utm_campaign=BusinessAnalytics-UBVzucVpG7k&utm_medium=DescriptionFF&utm_source=youtube 🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688 "

detail
{'title': 'Business Analyst Full Course In 2 Hours | Business Analyst Training For Beginners | Simplilearn', 'heatmap': [{'end': 1886.315, 'start': 1811.171, 'weight': 0.806}, {'end': 2297.52, 'start': 1953.26, 'weight': 0.759}, {'end': 2564.909, 'start': 2424.292, 'weight': 0.715}, {'end': 3239.031, 'start': 3161.142, 'weight': 0.887}], 'summary': 'The full course on business analysis covers the need, skills, and knowledge areas including hands-on demos and comparison with data analyst, showcasing pivotal role in reviving a cafe, essential skills, becoming a business analyst, agile/scrum methodologies, data analysis, visualization, comparing roles, and covering software, project lifecycle, risk management, analytical techniques, data import, and analysis techniques.', 'chapters': [{'end': 66.348, 'segs': [{'end': 66.348, 'src': 'embed', 'start': 24.949, 'weight': 0, 'content': [{'end': 30.693, 'text': 'We will begin this full course video by understanding the need for a business analyst in an organization.', 'start': 24.949, 'duration': 5.744}, {'end': 35.877, 'text': 'We will have a close look at the duties carried out by a business analyst through an interesting story.', 'start': 31.293, 'duration': 4.584}, {'end': 41.881, 'text': 'After this, we will have an in-depth understanding of the various skills required to become a business analyst.', 'start': 37.018, 'duration': 4.863}, {'end': 45.784, 'text': "Following which, we will look at the business analyst's knowledge areas.", 'start': 42.522, 'duration': 3.262}, {'end': 50.268, 'text': 'After this, we will look into a hands-on demo on business analysis with Excel.', 'start': 46.425, 'duration': 3.843}, {'end': 58.581, 'text': 'We will then conclude this video by drawing a brief comparison between the two most popular job roles today, business analyst and data analyst.', 'start': 51.414, 'duration': 7.167}, {'end': 64.166, 'text': 'For this training with me, I have Avijit and we will take you through the various topics in business analytics.', 'start': 59.281, 'duration': 4.885}, {'end': 66.348, 'text': 'All of this in under two hours.', 'start': 64.605, 'duration': 1.743}], 'summary': 'This video covers the need, duties, skills, and demo of business analysis, concluding with a comparison to data analysis, all in under two hours.', 'duration': 41.399, 'max_score': 24.949, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k24949.jpg'}], 'start': 5.563, 'title': 'Business analyst full course', 'summary': 'Covers the need for a business analyst, required skills, knowledge areas, includes hands-on demo on business analysis with excel, and a comparison with data analyst, all in under two hours.', 'chapters': [{'end': 66.348, 'start': 5.563, 'title': 'Business analyst full course', 'summary': 'Covers the need for a business analyst, the skills required, knowledge areas, and includes a hands-on demo on business analysis with excel, concluding with a comparison between business analyst and data analyst, all in under two hours.', 'duration': 60.785, 'highlights': ['The chapter covers the need for a business analyst, the skills required, knowledge areas, and includes a hands-on demo on business analysis with Excel, concluding with a comparison between business analyst and data analyst, all in under two hours.', 'The video provides a comprehensive understanding of the job role of a business analyst and the skills required, catering to aspiring business analysts.', 'Includes a hands-on demo on business analysis with Excel, offering practical insights and application of skills for business analysts.']}], 'duration': 60.785, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k5563.jpg', 'highlights': ['Covers the need for a business analyst, required skills, knowledge areas, hands-on demo on business analysis with Excel, and a comparison with data analyst, all in under two hours.', 'Provides a comprehensive understanding of the job role of a business analyst and the skills required, catering to aspiring business analysts.', 'Includes a hands-on demo on business analysis with Excel, offering practical insights and application of skills for business analysts.']}, {'end': 909.175, 'segs': [{'end': 217.289, 'src': 'embed', 'start': 189.949, 'weight': 1, 'content': [{'end': 195.113, 'text': 'This way, Ted knew that business will improve as customers prefer home delivery in the current scenario.', 'start': 189.949, 'duration': 5.164}, {'end': 200.838, 'text': 'Next, Ted suggested that Rob has work from home meal boxes added to his menu.', 'start': 195.774, 'duration': 5.064}, {'end': 204.633, 'text': 'Many professionals are working from home currently,', 'start': 202.29, 'duration': 2.343}, {'end': 209.94, 'text': 'and having work from home meal boxes would be a good pick for such professionals in the middle of a busy day.', 'start': 204.633, 'duration': 5.307}, {'end': 217.289, 'text': "Ted's third suggestion was to bring down the selling cost by providing discount coupons that can be utilized by customers.", 'start': 209.96, 'duration': 7.329}], 'summary': 'Ted suggests adding work from home meal boxes to the menu and offering discount coupons to boost business among professionals working from home.', 'duration': 27.34, 'max_score': 189.949, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k189949.jpg'}, {'end': 284.445, 'src': 'embed', 'start': 254.648, 'weight': 2, 'content': [{'end': 257.829, 'text': 'Ted became the intermediary between the IT team and Rob.', 'start': 254.648, 'duration': 3.181}, {'end': 264.571, 'text': 'He provided suggestions to the team, checked the app through user interface testing and made sure that the requirements met well.', 'start': 258.249, 'duration': 6.322}, {'end': 268.313, 'text': 'The same applied to the other business requirements and changes as well.', 'start': 265.372, 'duration': 2.941}, {'end': 274.875, 'text': 'Ted held regular meetings to gauge the progress and also kept Rob in the loop and updated him with the status of the project.', 'start': 268.733, 'duration': 6.142}, {'end': 280.961, 'text': 'Attending regular catch-ups helped Rob gain an insight into the progress and give his feedback from time to time.', 'start': 275.655, 'duration': 5.306}, {'end': 284.445, 'text': 'Ted made sure that the entire case was well documented.', 'start': 281.662, 'duration': 2.783}], 'summary': 'Ted facilitated communication between it team and rob, ensuring requirements were met. held regular meetings for progress updates and documentation.', 'duration': 29.797, 'max_score': 254.648, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k254648.jpg'}, {'end': 315.301, 'src': 'embed', 'start': 290.692, 'weight': 0, 'content': [{'end': 298.615, 'text': 'Ted made presentations that showed Rob the business growth after implementing the changes and Ted always supported his presentations with data.', 'start': 290.692, 'duration': 7.923}, {'end': 301.896, 'text': "Rob was very impressed with Ted's business approach.", 'start': 299.315, 'duration': 2.581}, {'end': 310.179, 'text': 'Such an approach not only helped Rob reopen his business amidst the COVID-19 but also helped him get 80% of his customer base back.', 'start': 302.656, 'duration': 7.523}, {'end': 315.301, 'text': "Ted successfully brought about a positive change in Rob's business which was highly beneficial.", 'start': 310.559, 'duration': 4.742}], 'summary': "Ted's approach helped rob reopen business post-covid, regained 80% customers, and brought positive change.", 'duration': 24.609, 'max_score': 290.692, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k290692.jpg'}, {'end': 645.136, 'src': 'embed', 'start': 619.798, 'weight': 3, 'content': [{'end': 624.682, 'text': "Now that she has completed all her duties and responsibilities with respect to Rob's project,", 'start': 619.798, 'duration': 4.884}, {'end': 628.185, 'text': 'she is ready to deliver the final e-commerce application to Rob for use.', 'start': 624.682, 'duration': 3.503}, {'end': 634.509, 'text': "Rob is rest assured that the application developed by Angela's firm is apt for his business and just what he wanted.", 'start': 628.665, 'duration': 5.844}, {'end': 640.534, 'text': "Angela's streamlined approach made it easier for the project to be delivered within the stipulated time period.", 'start': 635.35, 'duration': 5.184}, {'end': 645.136, 'text': "Rob is happy and I'm sure he will come back to Angela's firm for projects in the future.", 'start': 640.974, 'duration': 4.162}], 'summary': 'Angela successfully delivers e-commerce app, pleasing rob and ensuring future projects.', 'duration': 25.338, 'max_score': 619.798, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k619798.jpg'}, {'end': 684.317, 'src': 'embed', 'start': 658.243, 'weight': 4, 'content': [{'end': 664.586, 'text': 'If getting your learning started is half the battle, what if you could do that for free? Visit SkillUp by SimplyLearn.', 'start': 658.243, 'duration': 6.343}, {'end': 667.148, 'text': 'Click on the link in the description to know more.', 'start': 664.927, 'duration': 2.221}, {'end': 673.958, 'text': 'Business analyst is a professional who is responsible for bridging the gap between IT and business teams.', 'start': 668.413, 'duration': 5.545}, {'end': 684.317, 'text': 'They use analytics to evaluate processes, determine requirements, deliver data-driven solutions, and generate reports to executives and stakeholders.', 'start': 675.595, 'duration': 8.722}], 'summary': 'Learn business analysis for free with skillup by simplylearn.', 'duration': 26.074, 'max_score': 658.243, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k658243.jpg'}, {'end': 879.375, 'src': 'embed', 'start': 853.08, 'weight': 5, 'content': [{'end': 858.964, 'text': 'but through experience and combined with the ability to understand situations and the motive behind the problem.', 'start': 853.08, 'duration': 5.884}, {'end': 862.987, 'text': "So let's have a look at the top skills to become a successful business analyst.", 'start': 859.444, 'duration': 3.543}, {'end': 866.45, 'text': 'The first skill we have is understanding the business objective.', 'start': 863.668, 'duration': 2.782}, {'end': 873.391, 'text': 'For a business analyst it is important to know the goals and objectives of the business.', 'start': 869.468, 'duration': 3.923}, {'end': 879.375, 'text': 'It is advised that business analysts should have a good knowledge of the business operations in his or her organization.', 'start': 873.831, 'duration': 5.544}], 'summary': 'Top skills for a successful business analyst: understanding business objectives and operations.', 'duration': 26.295, 'max_score': 853.08, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k853080.jpg'}], 'start': 67.308, 'title': 'The role of a business analyst', 'summary': 'Discusses the pivotal role of a business analyst in reviving a cafe, showcasing a recovery of 80% of the customer base amidst the pandemic, and also outlines the typical roles and responsibilities of a business analyst through a successful e-commerce app project delivery.', 'chapters': [{'end': 328.626, 'start': 67.308, 'title': 'Role of business analyst in reviving a cafe', 'summary': 'Illustrates how ted, a business analyst, helped rob revive his cafe amidst the pandemic by implementing strategies that led to a sustainable business, resulting in a recovery of 80% of the customer base.', 'duration': 261.318, 'highlights': ["Ted's strategies led to a recovery of 80% of the customer base for Rob's cafe Ted's suggestions and approach resulted in a significant recovery as 80% of the customer base was regained by implementing the recommended strategies.", "Ted facilitated the development of an exclusive home delivery app and work from home meal boxes for Rob's cafe Ted recommended the development of a home delivery app and adding work from home meal boxes to the menu, catering to the current scenario of increased demand for home delivery and convenience for professionals working from home.", 'Ted acted as an intermediary between the IT team and Rob, ensuring the successful implementation of the suggested changes Ted played a crucial role in coordinating with the IT team, providing suggestions, monitoring the development progress, and ensuring that the requirements were met, thus facilitating the successful implementation of the suggested changes.']}, {'end': 909.175, 'start': 329.126, 'title': 'Roles of a business analyst', 'summary': "Highlights the typical roles and responsibilities of a business analyst, as exemplified through angela's approach in delivering rob's e-commerce app project, which involves understanding business objectives, gathering requirements, allocating resources, monitoring progress, collecting feedback, building reports, and maintaining transparency, ultimately leading to the successful delivery of the app within the stipulated time period.", 'duration': 580.049, 'highlights': ["Angela's approach in delivering Rob's e-commerce app project, involving understanding business objectives, gathering requirements, allocating resources, monitoring progress, collecting feedback, building reports, and maintaining transparency, ultimately leading to the successful delivery of the app within the stipulated time period. This encompasses the core responsibilities and activities of a business analyst, showcasing the practical application of these duties in a real-world scenario.", "The importance of a business analyst's role in bridging the gap between IT and business teams, using analytics to evaluate processes, determining requirements, delivering data-driven solutions, and generating reports to executives and stakeholders. This emphasizes the significance of a business analyst's contribution in facilitating effective communication and decision-making between IT and business functions, as well as their role in providing valuable insights through data-driven solutions.", 'The essential skills required for a successful business analyst, including understanding business objectives, problem-solving, collecting and documenting business requirements, engaging with stakeholders, performing user acceptance testing, and building visualizations and maintenance reports. This highlights the diverse skill set and competencies needed for a business analyst to effectively fulfill their responsibilities and contribute to the success of projects.']}], 'duration': 841.867, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k67308.jpg', 'highlights': ["Ted's strategies led to a recovery of 80% of the customer base for Rob's cafe", 'Ted recommended the development of a home delivery app and adding work from home meal boxes to the menu', 'Ted played a crucial role in coordinating with the IT team, providing suggestions, and ensuring successful implementation', "Angela's approach in delivering Rob's e-commerce app project showcased the practical application of business analyst duties", "The importance of a business analyst's role in bridging the gap between IT and business teams", 'The essential skills required for a successful business analyst include understanding business objectives and problem-solving']}, {'end': 1811.171, 'segs': [{'end': 997.923, 'src': 'embed', 'start': 971.878, 'weight': 9, 'content': [{'end': 979.242, 'text': 'Critical thinking allows the business analyst to distinguish between requirements that add value to the business and those that should be given a low priority.', 'start': 971.878, 'duration': 7.364}, {'end': 985.746, 'text': 'A business analyst must be creative in order to reach stated goals where resources are limited and the conditions are non-ideal.', 'start': 979.742, 'duration': 6.004}, {'end': 991.669, 'text': 'The third important skill for a business analyst is communication and interpersonal skills.', 'start': 987.507, 'duration': 4.162}, {'end': 997.923, 'text': 'Understanding and being properly understood is key to any profession.', 'start': 994.921, 'duration': 3.002}], 'summary': 'Critical thinking, creativity, and communication are vital for a business analyst to prioritize requirements and achieve goals in challenging conditions.', 'duration': 26.045, 'max_score': 971.878, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k971878.jpg'}, {'end': 1058.401, 'src': 'embed', 'start': 1034.079, 'weight': 0, 'content': [{'end': 1040.825, 'text': 'Business analysts use verbal and written communication to convey ideas, concepts, facts and opinions to a variety of stakeholders.', 'start': 1034.079, 'duration': 6.746}, {'end': 1050.834, 'text': 'Non-verbal communication skills enable the effective sending and receiving of messages, but not limited to body movement, posture, facial expressions,', 'start': 1041.705, 'duration': 9.129}, {'end': 1052.115, 'text': 'gestures and eye contact.', 'start': 1050.834, 'duration': 1.281}, {'end': 1058.401, 'text': 'Effective listening allows the business analyst to accurately understand information that is being communicated verbally.', 'start': 1053.136, 'duration': 5.265}], 'summary': 'Business analysts use verbal, written, and non-verbal communication to convey information effectively.', 'duration': 24.322, 'max_score': 1034.079, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k1034079.jpg'}, {'end': 1095.095, 'src': 'embed', 'start': 1072.974, 'weight': 1, 'content': [{'end': 1080.958, 'text': 'These people include clients, business leaders, project team members, project stakeholders, vendors, private sector representatives,', 'start': 1072.974, 'duration': 7.984}, {'end': 1082.318, 'text': 'industry leaders and so forth.', 'start': 1080.958, 'duration': 1.36}, {'end': 1086, 'text': 'Business analysts negotiate at every turn during the course of a project.', 'start': 1082.919, 'duration': 3.081}, {'end': 1092.914, 'text': 'At the initial stage of a project, negotiation skills are used to determine what should be included in the vision of the project.', 'start': 1087.051, 'duration': 5.863}, {'end': 1095.095, 'text': 'As details emerge,', 'start': 1093.654, 'duration': 1.441}], 'summary': 'Business analysts negotiate with various stakeholders to shape project vision and scope.', 'duration': 22.121, 'max_score': 1072.974, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k1072974.jpg'}, {'end': 1143.705, 'src': 'embed', 'start': 1114.105, 'weight': 2, 'content': [{'end': 1120.71, 'text': 'Business analysts also perform cost-benefit analysis to conduct an assessment of the benefits and costs anticipated in a project.', 'start': 1114.105, 'duration': 6.605}, {'end': 1123.451, 'text': 'When organizations undertake new projects,', 'start': 1121.03, 'duration': 2.421}, {'end': 1129.635, 'text': 'it is advisable for business analysts that they use cost-benefit analysis to establish whether such projects should be embarked or not.', 'start': 1123.451, 'duration': 6.184}, {'end': 1137.361, 'text': 'Business analysts should be able to achieve a profitable outcome for your company while finding a solution for the client that makes them happy.', 'start': 1130.696, 'duration': 6.665}, {'end': 1143.705, 'text': 'This balancing act demands the ability to influence a mutual solution and maintain professional relationship.', 'start': 1138.361, 'duration': 5.344}], 'summary': 'Business analysts use cost-benefit analysis to assess project viability and achieve profitable outcomes.', 'duration': 29.6, 'max_score': 1114.105, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k1114105.jpg'}, {'end': 1385.644, 'src': 'embed', 'start': 1342.178, 'weight': 3, 'content': [{'end': 1343.659, 'text': 'as well as NoSQL databases.', 'start': 1342.178, 'duration': 1.481}, {'end': 1352.188, 'text': 'Also, having hands-on experience with SQL is a must for a business analyst to access, retrieve, manipulate and analyze data.', 'start': 1345.023, 'duration': 7.165}, {'end': 1359.194, 'text': 'So they should be able to write data definition and data manipulation commands such as create, update, delete and insert.', 'start': 1352.769, 'duration': 6.425}, {'end': 1363.657, 'text': 'Microsoft Excel is the ninth skill in our list.', 'start': 1361.555, 'duration': 2.102}, {'end': 1372.664, 'text': 'Excel is one of the oldest and most popular and powerful analytics and reporting tool used in the industries for working with data.', 'start': 1365.939, 'duration': 6.725}, {'end': 1381.481, 'text': 'Business analysts use Excel to perform various calculations, budget analysis, and data analysis to derive meaningful insights and take decisions.', 'start': 1374.076, 'duration': 7.405}, {'end': 1385.644, 'text': 'They sort, filter, and create pivot tables to summarize the data.', 'start': 1382.442, 'duration': 3.202}], 'summary': 'Business analysts need sql and excel skills for data analysis and reporting.', 'duration': 43.466, 'max_score': 1342.178, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k1342178.jpg'}, {'end': 1608.222, 'src': 'embed', 'start': 1552.423, 'weight': 5, 'content': [{'end': 1558.966, 'text': "now, if you look on the right, we have the different courses that will be covered as part of this master's program.", 'start': 1552.423, 'duration': 6.543}, {'end': 1564.208, 'text': 'so there is introduction to business analysis, certified business analytics professional.', 'start': 1558.966, 'duration': 5.242}, {'end': 1567.449, 'text': "you'll also learn about agile and scrum.", 'start': 1564.208, 'duration': 3.241}, {'end': 1568.989, 'text': "there's business analytics with excel.", 'start': 1567.449, 'duration': 1.54}, {'end': 1571.49, 'text': "you'll also get training in sql.", 'start': 1568.989, 'duration': 2.501}, {'end': 1576.574, 'text': "there's tableau training and you'll also get to work on business analyst caption projects.", 'start': 1571.49, 'duration': 5.084}, {'end': 1583.919, 'text': 'If I scroll down, now here are the tools that will be covered as part of this course.', 'start': 1578.815, 'duration': 5.104}, {'end': 1594.745, 'text': "So there's Microsoft Excel, Zira, Tableau, Power BI, PostgreSQL, then there's Planbox, Target Process, and others.", 'start': 1584.299, 'duration': 10.446}, {'end': 1600.389, 'text': 'Here you can see the program advisors.', 'start': 1597.307, 'duration': 3.082}, {'end': 1608.222, 'text': 'and, if I scroll further, is the entire course content we have.', 'start': 1601.94, 'duration': 6.282}], 'summary': "Master's program covers courses in business analysis, agile, sql, and tableau, along with training in various tools like microsoft excel, zira, and power bi.", 'duration': 55.799, 'max_score': 1552.423, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k1552423.jpg'}, {'end': 1660.084, 'src': 'embed', 'start': 1636.7, 'weight': 7, 'content': [{'end': 1644.222, 'text': 'this is in partnership with purdue university and endorsed education provider is iipa.', 'start': 1636.7, 'duration': 7.522}, {'end': 1648.184, 'text': 'if i scroll down, you can see here the key features of this course.', 'start': 1644.222, 'duration': 3.962}, {'end': 1657.342, 'text': "you'll get purdue postgraduate program certification, alumni association membership, master classes from Purdue faculties,", 'start': 1648.184, 'duration': 9.158}, {'end': 1660.084, 'text': "enrollment in Simply Learn's job assist.", 'start': 1657.342, 'duration': 2.742}], 'summary': 'Partnership with purdue university offering postgraduate program certification, alumni membership, and job assist.', 'duration': 23.384, 'max_score': 1636.7, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k1636700.jpg'}, {'end': 1754.771, 'src': 'embed', 'start': 1729.565, 'weight': 8, 'content': [{'end': 1734.646, 'text': 'If I scroll down here, you can see the skills that will be covered as part of this program.', 'start': 1729.565, 'duration': 5.081}, {'end': 1742.128, 'text': "So there's business analysis, there's elicitation and collaboration, requirement analysis, planning and monitoring.", 'start': 1735.046, 'duration': 7.082}, {'end': 1744.409, 'text': 'Let me click on view more.', 'start': 1742.148, 'duration': 2.261}, {'end': 1754.771, 'text': "you have strategy analysis, dashboarding, wireframing, there's data visualization, statistical analysis using Excel, SQL database,", 'start': 1744.409, 'duration': 10.362}], 'summary': 'Program covers business analysis, elicitation, collaboration, wireframing, data visualization, and statistical analysis using excel and sql database.', 'duration': 25.206, 'max_score': 1729.565, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k1729565.jpg'}], 'start': 909.995, 'title': 'Essential business analyst skills', 'summary': "Emphasizes the critical skills required for business analysts, including analytical thinking, communication, negotiation, and cost benefit analysis, with an emphasis on the need for continuous learning and adaptability to industry changes. it also covers essential skills such as cost-benefit analysis, decision-making, programming languages, database and sql, microsoft excel, and documentation and presentation. additionally, it includes information on two business analytics programs offered by simplylearn: a business analyst master's program endorsed by iiba and a postgraduate program in business analysis in partnership with purdue university.", 'chapters': [{'end': 1113.265, 'start': 909.995, 'title': 'Essential skills for business analysts', 'summary': 'Emphasizes the critical skills required for business analysts, including analytical thinking, communication, negotiation, and cost benefit analysis, with an emphasis on the need for continuous learning and adaptability to industry changes.', 'duration': 203.27, 'highlights': ["Analytical and Critical Thinking Business analysts should have the ability to analyze and interpret client's requirements, apply critical thinking to distinguish between valuable and low priority requirements, and be creative in reaching goals with limited resources and non-ideal conditions.", 'Communication and Interpersonal Skills Business analysts need to effectively communicate and convey requirements to stakeholders using verbal, written, and non-verbal communication. They also require good listening, reading, and writing skills, and the ability to facilitate meetings.', 'Negotiation and Cost Benefit Analysis Successful business analysts need strong negotiation skills to work with various stakeholders and determine project vision, requirements, and functional design. They also play a crucial role in conducting cost benefit analysis for technical decisions.']}, {'end': 1497.579, 'start': 1114.105, 'title': 'Essential business analyst skills', 'summary': 'Covers the essential skills required for business analysts, including cost-benefit analysis, decision-making, programming languages, database and sql, microsoft excel, and documentation and presentation.', 'duration': 383.474, 'highlights': ['Cost-benefit analysis Business analysts perform cost-benefit analysis to assess the benefits and costs of new projects, ensuring profitable outcomes and client satisfaction.', 'Programming languages Business analysts benefit from hands-on knowledge of programming languages like R and Python, enabling efficient data analysis and machine learning model creation.', 'Database and SQL Knowledge of relational and NoSQL databases, as well as SQL, is essential for business analysts to store, retrieve, manipulate, and analyze structured data.', 'Microsoft Excel Excel is a powerful tool for business analysts to perform calculations, budget analysis, data analysis, and create dynamic reports, charts, and graphs.', 'Documentation and presentation Business analysts should be adept at documenting project learnings and presenting findings to stakeholders, enabling organized communication and informed decision-making.']}, {'end': 1811.171, 'start': 1498.319, 'title': 'Simplylearn business analytics programs', 'summary': "Covers two business analytics programs offered by simplylearn: a business analyst master's program endorsed by iiba, covering various courses and tools, and a postgraduate program in business analysis in partnership with purdue university, offering purdue postgraduate program certification, alumni association membership, and industry-related projects.", 'duration': 312.852, 'highlights': ["Business Analyst Master's Program endorsed by IIBA The program offers courses in introduction to business analysis, certified business analytics professional, agile and scrum, business analytics with excel, SQL training, tableau training, and industry-related projects like canteen ordering system for Unilever and library management system for Stanford University.", 'Tools covered in the program The program covers tools such as Microsoft Excel, Zira, Tableau, Power BI, PostgreSQL, Planbox, Target Process, and others.', "Postgraduate Program in Business Analysis in partnership with Purdue University The program offers Purdue postgraduate program certification, alumni association membership, master classes from Purdue faculties, enrollment in Simply Learn's job assist, 170+ hours of blended learning, 11+ hands-on projects, and industry-related projects like WhatsApp pay and hospital management system for Mayo clinic.", 'Skills covered in the program The program covers skills such as business analysis, elicitation and collaboration, requirement analysis, planning and monitoring, strategy analysis, dashboarding, wireframing, data visualization, statistical analysis using Excel, SQL database, and others.']}], 'duration': 901.176, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k909995.jpg', 'highlights': ['Business analysts need to effectively communicate and convey requirements to stakeholders using verbal, written, and non-verbal communication.', 'Successful business analysts need strong negotiation skills to work with various stakeholders and determine project vision, requirements, and functional design.', 'Business analysts perform cost-benefit analysis to assess the benefits and costs of new projects, ensuring profitable outcomes and client satisfaction.', 'Knowledge of relational and NoSQL databases, as well as SQL, is essential for business analysts to store, retrieve, manipulate, and analyze structured data.', 'Excel is a powerful tool for business analysts to perform calculations, budget analysis, data analysis, and create dynamic reports, charts, and graphs.', 'The program offers courses in introduction to business analysis, certified business analytics professional, agile and scrum, business analytics with excel, SQL training, tableau training, and industry-related projects like canteen ordering system for Unilever and library management system for Stanford University.', 'The program covers tools such as Microsoft Excel, Zira, Tableau, Power BI, PostgreSQL, Planbox, Target Process, and others.', "The program offers Purdue postgraduate program certification, alumni association membership, master classes from Purdue faculties, enrollment in Simply Learn's job assist, 170+ hours of blended learning, 11+ hands-on projects, and industry-related projects like WhatsApp pay and hospital management system for Mayo clinic.", 'The program covers skills such as business analysis, elicitation and collaboration, requirement analysis, planning and monitoring, strategy analysis, dashboarding, wireframing, data visualization, statistical analysis using Excel, SQL database, and others.', "Analytical and Critical Thinking Business analysts should have the ability to analyze and interpret client's requirements, apply critical thinking to distinguish between valuable and low priority requirements, and be creative in reaching goals with limited resources and non-ideal conditions."]}, {'end': 2263.908, 'segs': [{'end': 1886.315, 'src': 'heatmap', 'start': 1811.171, 'weight': 0.806, 'content': [{'end': 1820.956, 'text': "if you scroll further, there's the learner's profile and how the industry trend has been for business analysts.", 'start': 1811.171, 'duration': 9.785}, {'end': 1828.38, 'text': 'so please go ahead and enroll to this program if you really want to start your career or you want to grow your career as a business analyst.', 'start': 1820.956, 'duration': 7.424}, {'end': 1834.326, 'text': 'Now here is a quick roadmap that depicts what a fresher needs to possess to become a business analyst.', 'start': 1829.204, 'duration': 5.122}, {'end': 1838.288, 'text': 'First, they need to have a graduation degree in a related field.', 'start': 1835.067, 'duration': 3.221}, {'end': 1843.43, 'text': 'Then, knowledge of SQL and relational database is very important.', 'start': 1838.928, 'duration': 4.502}, {'end': 1849.973, 'text': "Thirdly, a fresher should have good hands-on experience with programming languages and that's a prerequisite.", 'start': 1844.491, 'duration': 5.482}, {'end': 1856.354, 'text': 'And finally, they need to have good communication skills to nail the role of a business analyst.', 'start': 1851.553, 'duration': 4.801}, {'end': 1863.056, 'text': 'Up next, we have the roadmap that depicts what an experienced professional needs to possess to become a business analyst.', 'start': 1857.134, 'duration': 5.922}, {'end': 1867.537, 'text': 'Firstly, they should have good knowledge of the domain they are currently working in.', 'start': 1863.896, 'duration': 3.641}, {'end': 1870.978, 'text': 'Next, they should know how to write SQL queries.', 'start': 1868.697, 'duration': 2.281}, {'end': 1875.119, 'text': 'An experienced professional should be good with programming languages.', 'start': 1871.938, 'duration': 3.181}, {'end': 1880.36, 'text': 'In addition to that, they need to have good communication and negotiation skills.', 'start': 1876.459, 'duration': 3.901}, {'end': 1886.315, 'text': 'Finally, they should be good at creating interactive reports using business intelligence tools.', 'start': 1881.75, 'duration': 4.565}], 'summary': 'Enroll in the program to start/grow as a business analyst. freshers need degree, sql, programming, and communication skills. experienced professionals need domain knowledge, sql, programming, communication, and bi tool skills.', 'duration': 75.144, 'max_score': 1811.171, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k1811171.jpg'}, {'end': 1886.315, 'src': 'embed', 'start': 1857.134, 'weight': 0, 'content': [{'end': 1863.056, 'text': 'Up next, we have the roadmap that depicts what an experienced professional needs to possess to become a business analyst.', 'start': 1857.134, 'duration': 5.922}, {'end': 1867.537, 'text': 'Firstly, they should have good knowledge of the domain they are currently working in.', 'start': 1863.896, 'duration': 3.641}, {'end': 1870.978, 'text': 'Next, they should know how to write SQL queries.', 'start': 1868.697, 'duration': 2.281}, {'end': 1875.119, 'text': 'An experienced professional should be good with programming languages.', 'start': 1871.938, 'duration': 3.181}, {'end': 1880.36, 'text': 'In addition to that, they need to have good communication and negotiation skills.', 'start': 1876.459, 'duration': 3.901}, {'end': 1886.315, 'text': 'Finally, they should be good at creating interactive reports using business intelligence tools.', 'start': 1881.75, 'duration': 4.565}], 'summary': 'Business analysts need domain knowledge, sql, programming, communication, and bi skills.', 'duration': 29.181, 'max_score': 1857.134, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k1857134.jpg'}, {'end': 1929.18, 'src': 'embed', 'start': 1897.268, 'weight': 1, 'content': [{'end': 1899.751, 'text': "Let's now learn the business analysis knowledge areas.", 'start': 1897.268, 'duration': 2.483}, {'end': 1905.29, 'text': 'First up, we have business analysis planning and monitoring.', 'start': 1901.687, 'duration': 3.603}, {'end': 1910.795, 'text': 'Now this knowledge area describes the tasks used to organize and coordinate business analysis efforts.', 'start': 1906.011, 'duration': 4.784}, {'end': 1918.882, 'text': 'It involves planning business analysis approach, stakeholder engagement, business analysis governance, as well as information management.', 'start': 1911.676, 'duration': 7.206}, {'end': 1922.125, 'text': 'Then we have elicitation and collaboration.', 'start': 1919.542, 'duration': 2.583}, {'end': 1929.18, 'text': 'Now this knowledge area describes the tasks used to prepare and conduct elicitation activities and confirm the results.', 'start': 1923.117, 'duration': 6.063}], 'summary': 'Business analysis includes planning, stakeholder engagement, and elicitation activities.', 'duration': 31.912, 'max_score': 1897.268, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k1897268.jpg'}, {'end': 2090.491, 'src': 'embed', 'start': 2063.309, 'weight': 2, 'content': [{'end': 2066.891, 'text': 'Next, we have testing the product in the next step of the lifecycle.', 'start': 2063.309, 'duration': 3.582}, {'end': 2070.694, 'text': "Deploying the developed product to check if it's working fine.", 'start': 2067.871, 'duration': 2.823}, {'end': 2076.358, 'text': 'And finally, we have reviewing the product and getting feedback from customers, clients, stakeholders, etc.', 'start': 2071.293, 'duration': 5.065}, {'end': 2080.782, 'text': 'Now, in agile methodology, the entire work is broken down into several sprints.', 'start': 2076.879, 'duration': 3.903}, {'end': 2087.268, 'text': 'After each sprint, we get a shippable product and that product is reviewed by the client or the stakeholder.', 'start': 2081.641, 'duration': 5.627}, {'end': 2090.491, 'text': 'The suggestions are incorporated in the next sprint.', 'start': 2088.168, 'duration': 2.323}], 'summary': 'Agile methodology involves breaking work into sprints, delivering shippable products for review and incorporating feedback.', 'duration': 27.182, 'max_score': 2063.309, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k2063309.jpg'}, {'end': 2155.577, 'src': 'embed', 'start': 2129.207, 'weight': 3, 'content': [{'end': 2136.97, 'text': 'This process enables organizations to adjust smoothly to rapidly changing requirements and produce a product that meets evolving business goals.', 'start': 2129.207, 'duration': 7.763}, {'end': 2141.833, 'text': 'Okay, so the concepts and practices in Scrum can be divided into three categories.', 'start': 2137.691, 'duration': 4.142}, {'end': 2144.254, 'text': 'First, we have three roles.', 'start': 2142.713, 'duration': 1.541}, {'end': 2150.395, 'text': 'A product owner owns the product backlog and writes user stories and acceptance criteria.', 'start': 2145.413, 'duration': 4.982}, {'end': 2155.577, 'text': 'They are responsible for prioritizing the product backlog and deciding the release date and the content.', 'start': 2151.075, 'duration': 4.502}], 'summary': 'Scrum helps organizations adapt to change and deliver products that meet evolving goals.', 'duration': 26.37, 'max_score': 2129.207, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k2129207.jpg'}, {'end': 2272.333, 'src': 'embed', 'start': 2243.982, 'weight': 4, 'content': [{'end': 2249.163, 'text': 'In sprint planning, the team meets and decides what they need to complete in the coming sprint.', 'start': 2243.982, 'duration': 5.181}, {'end': 2254.385, 'text': 'Sprint review is a type of meeting in which the team demonstrates what they shipped in the sprint.', 'start': 2249.884, 'duration': 4.501}, {'end': 2262.087, 'text': "In the sprint retrospective, the team reviews their work, identifying what they did well and what didn't go as planned,", 'start': 2255.165, 'duration': 6.922}, {'end': 2263.908, 'text': 'so that they can make the next sprint better.', 'start': 2262.087, 'duration': 1.821}, {'end': 2272.333, 'text': 'Daily Scrum is a stand-up meeting or a very short like 15 to 20 minutes meeting for the team to make sure that they are all on the same page.', 'start': 2264.708, 'duration': 7.625}], 'summary': 'Team uses sprint planning, review, retrospective, and daily scrum to improve productivity.', 'duration': 28.351, 'max_score': 2243.982, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k2243982.jpg'}], 'start': 1811.171, 'title': 'Becoming a business analyst and agile/scrum methodologies', 'summary': 'Provides a roadmap for professionals to become a business analyst, emphasizing essential skills and knowledge areas. it also discusses agile and scrum methodologies, highlighting their steps, roles, artifacts, and impacts on project management and software development.', 'chapters': [{'end': 1997.052, 'start': 1811.171, 'title': 'Becoming a business analyst', 'summary': 'Provides a roadmap for fresher and experienced professionals to become a business analyst, emphasizing the essential skills and knowledge areas required, with a focus on qualifications, technical skills, and certifications.', 'duration': 185.881, 'highlights': ['A roadmap is presented for both fresher and experienced professionals to become a business analyst, emphasizing the essential qualifications and skills required. Roadmap for fresher includes graduation degree, SQL knowledge, programming languages, and communication skills. Roadmap for experienced professionals includes domain knowledge, SQL proficiency, programming skills, communication, and business intelligence tool usage.', 'The knowledge areas of business analysis, including planning and monitoring, elicitation and collaboration, requirements lifecycle management, strategy analysis, requirements analysis and design definition, and solution evaluation, are outlined. The knowledge areas cover tasks related to organizing and coordinating business analysis efforts, preparing and conducting elicitation activities, managing requirements, identifying business needs, organizing requirements, and measuring solution performance.']}, {'end': 2263.908, 'start': 1997.052, 'title': 'Agile and scrum methodologies', 'summary': 'Discusses the agile and scrum methodologies, highlighting their steps, roles, artifacts, and ceremonies, and their impacts on project management and software development.', 'duration': 266.856, 'highlights': ['Agile methodology involves steps like planning, designing, developing, testing, deploying, and reviewing, and work is broken down into several sprints, leading to faster value delivery and continuous improvement. The Agile methodology involves breaking down work into stages like planning, designing, developing, testing, deploying, and reviewing, leading to faster value delivery and continuous improvement.', 'Scrum methodology empowers small development teams, with roles like the product owner, scrum master, and development team, and includes artifacts such as the product backlog, sprint backlog, and product increment, leading to increased productivity and adaptability to changing requirements. The Scrum methodology empowers small development teams, with roles like the product owner, scrum master, and development team, and includes artifacts such as the product backlog, sprint backlog, and product increment, leading to increased productivity and adaptability to changing requirements.', 'Scrum ceremonies include sprint planning, sprint review, and sprint retrospective, enabling the team to plan, demonstrate, and review their work for continuous improvement. Scrum ceremonies like sprint planning, sprint review, and sprint retrospective enable the team to plan, demonstrate, and review their work for continuous improvement.']}], 'duration': 452.737, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k1811171.jpg', 'highlights': ['A roadmap is presented for both fresher and experienced professionals to become a business analyst, emphasizing the essential qualifications and skills required.', 'The knowledge areas of business analysis, including planning and monitoring, elicitation and collaboration, requirements lifecycle management, strategy analysis, requirements analysis and design definition, and solution evaluation, are outlined.', 'Agile methodology involves steps like planning, designing, developing, testing, deploying, and reviewing, and work is broken down into several sprints, leading to faster value delivery and continuous improvement.', 'Scrum methodology empowers small development teams, with roles like the product owner, scrum master, and development team, and includes artifacts such as the product backlog, sprint backlog, and product increment, leading to increased productivity and adaptability to changing requirements.', 'Scrum ceremonies include sprint planning, sprint review, and sprint retrospective, enabling the team to plan, demonstrate, and review their work for continuous improvement.']}, {'end': 4101.557, 'segs': [{'end': 2333.152, 'src': 'embed', 'start': 2264.708, 'weight': 1, 'content': [{'end': 2272.333, 'text': 'Daily Scrum is a stand-up meeting or a very short like 15 to 20 minutes meeting for the team to make sure that they are all on the same page.', 'start': 2264.708, 'duration': 7.625}, {'end': 2277.394, 'text': "Now let's talk about the average annual salary of a business analyst.", 'start': 2273.513, 'duration': 3.881}, {'end': 2285.976, 'text': 'According to PayScale, the average annual salary of a business analyst in the United States is $68,973,,', 'start': 2278.094, 'duration': 7.882}, {'end': 2289.898, 'text': 'while in India a business analyst can earn nearly 6 lakh rupees per annum.', 'start': 2285.977, 'duration': 3.921}, {'end': 2297.52, 'text': 'Now talking about the companies hiring for business analysts, we have the Indian e-commerce payment system and financial technology company Paytm.', 'start': 2290.158, 'duration': 7.362}, {'end': 2303.161, 'text': 'American MNC Cognizant and British Dutch multinational oil and gas company Shell.', 'start': 2298.28, 'duration': 4.881}, {'end': 2307.222, 'text': 'We also have Cisco, the search engine giant Google and Dell.', 'start': 2303.921, 'duration': 3.301}, {'end': 2311.943, 'text': 'Finally, in our list of companies, we have Ernst & Young Global Limited,', 'start': 2307.842, 'duration': 4.101}, {'end': 2319.105, 'text': 'American multinational computer technology corporation Oracle and British multinational investment bank and financial services company Barclays.', 'start': 2311.943, 'duration': 7.162}, {'end': 2324.766, 'text': "With that, let's discuss the top business analysis tools and software used by business analysts.", 'start': 2319.865, 'duration': 4.901}, {'end': 2333.152, 'text': 'We have the widely used spreadsheet application Microsoft Excel, web-based Kanban-style list-making application Trello.', 'start': 2325.606, 'duration': 7.546}], 'summary': 'Daily scrum is a 15-20 minute team meeting. business analysts earn $68,973 in the us and 6 lakh rupees in india. companies hiring include paytm, cognizant, shell, cisco, google, dell, ernst & young, oracle, and barclays. top tools include microsoft excel and trello.', 'duration': 68.444, 'max_score': 2264.708, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k2264708.jpg'}, {'end': 2383.499, 'src': 'embed', 'start': 2357.503, 'weight': 0, 'content': [{'end': 2363.749, 'text': 'They do create pivot tables and pivot charts to summarize and analyze data, find trends and insights to make critical decisions.', 'start': 2357.503, 'duration': 6.246}, {'end': 2371.735, 'text': 'So in this demo we will work on a sales data set from the United States and analyze the total revenue, total profit,', 'start': 2364.912, 'duration': 6.823}, {'end': 2378.297, 'text': 'the quantity sold for different categories and subcategories of products across various regions, segments, cities, etc.', 'start': 2371.735, 'duration': 6.562}, {'end': 2380.858, 'text': 'Now let me show you the data set first.', 'start': 2379.217, 'duration': 1.641}, {'end': 2383.499, 'text': 'Okay, so here is my data set.', 'start': 2381.738, 'duration': 1.761}], 'summary': 'Demonstration of creating pivot tables and charts to analyze us sales data for revenue, profit, and quantity sold for different product categories and regions.', 'duration': 25.996, 'max_score': 2357.503, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k2357503.jpg'}, {'end': 2564.909, 'src': 'heatmap', 'start': 2424.292, 'weight': 0.715, 'content': [{'end': 2425.753, 'text': 'Next we have the product name.', 'start': 2424.292, 'duration': 1.461}, {'end': 2428.736, 'text': 'Then we have our sales value.', 'start': 2426.714, 'duration': 2.022}, {'end': 2431.359, 'text': 'Now you can assume this to be in dollars.', 'start': 2429.397, 'duration': 1.962}, {'end': 2435.603, 'text': 'Then we have the quantity that was sold for each product.', 'start': 2432.62, 'duration': 2.983}, {'end': 2439.707, 'text': 'Then we have the discount column and finally we have the profit column.', 'start': 2436.644, 'duration': 3.063}, {'end': 2445.259, 'text': "So, let's analyze this data set using different charts and graphs.", 'start': 2441.656, 'duration': 3.603}, {'end': 2450.304, 'text': "First, let's create a pivot table to see the sales by region and year.", 'start': 2446.34, 'duration': 3.964}, {'end': 2455.088, 'text': 'So, here we want to see the sales of all the years in different regions of the United States.', 'start': 2450.984, 'duration': 4.104}, {'end': 2464.956, 'text': "So, for that, I'll click on any cell inside this data set, go to the insert tab and here I have the option to create a pivot table.", 'start': 2456.349, 'duration': 8.607}, {'end': 2474.541, 'text': "I'll click on this create pivot table option and you can see it has selected my entire data and here I'll choose new worksheet.", 'start': 2465.837, 'duration': 8.704}, {'end': 2478.483, 'text': "that is the place where I want to place this pivot table and let's click on OK.", 'start': 2474.541, 'duration': 3.942}, {'end': 2492.674, 'text': "so you can see it has created a new sheet, which is sheet 2, and let's drag our columns onto the different sections in this pivot table fields.", 'start': 2480.069, 'duration': 12.605}, {'end': 2505.918, 'text': "so since I want to know the region and the year, so let's drag the order date first and let's delete the quarter column.", 'start': 2492.674, 'duration': 13.244}, {'end': 2507.419, 'text': "so I'll click on remove field.", 'start': 2505.918, 'duration': 1.501}, {'end': 2510.437, 'text': "I don't want this field.", 'start': 2509.076, 'duration': 1.361}, {'end': 2528.709, 'text': "so I have my years first and then let's drag region column under columns and we want to know the sales for all the years in different regions.", 'start': 2510.437, 'duration': 18.272}, {'end': 2535.093, 'text': "so I'll drag sales onto values.", 'start': 2528.709, 'duration': 6.384}, {'end': 2538.323, 'text': 'you can see here we have our Pivot table ready.', 'start': 2535.093, 'duration': 3.23}, {'end': 2542.764, 'text': 'If you want, you can go ahead and rename these row labels and column labels.', 'start': 2538.923, 'duration': 3.841}, {'end': 2547.985, 'text': "Now with this table ready, let's create a line chart.", 'start': 2543.904, 'duration': 4.081}, {'end': 2551.926, 'text': 'This will help you analyze your data better.', 'start': 2549.066, 'duration': 2.86}, {'end': 2561.468, 'text': 'So what you can do is go to the insert tab and here under recommended charts, you can go for line chart.', 'start': 2552.766, 'duration': 8.702}, {'end': 2564.909, 'text': 'You can see the line chart preview here and click on okay.', 'start': 2561.668, 'duration': 3.241}], 'summary': 'Analyzing sales data using pivot table and line chart.', 'duration': 140.617, 'max_score': 2424.292, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k2424292.jpg'}, {'end': 3239.031, 'src': 'heatmap', 'start': 3161.142, 'weight': 0.887, 'content': [{'end': 3167.686, 'text': 'so you can go to the design tab and under grand totals you can select the first option.', 'start': 3161.142, 'duration': 6.544}, {'end': 3176.492, 'text': 'you can see the grand total has gone And in order to create a map, we need to adjust this pivot table.', 'start': 3167.686, 'duration': 8.806}, {'end': 3178.172, 'text': "So I'll click on United States.", 'start': 3176.752, 'duration': 1.42}, {'end': 3183.394, 'text': "I'll right click and I'll go to field settings.", 'start': 3179.453, 'duration': 3.941}, {'end': 3191.176, 'text': "Here under layout and print, I'll click on show item labels in tabular format.", 'start': 3184.594, 'duration': 6.582}, {'end': 3195.178, 'text': "And I'll also click on repeat item labels.", 'start': 3191.997, 'duration': 3.181}, {'end': 3195.938, 'text': 'You can see.', 'start': 3195.418, 'duration': 0.52}, {'end': 3200.133, 'text': 'It will populate United States for all the rows.', 'start': 3197.89, 'duration': 2.243}, {'end': 3204.559, 'text': 'If I click on OK, you can see the United States have been populated for all the states.', 'start': 3200.413, 'duration': 4.146}, {'end': 3208.765, 'text': 'Now let me select this table.', 'start': 3205.841, 'duration': 2.924}, {'end': 3215.855, 'text': "Or before that, let's remove the subtotal from here.", 'start': 3208.785, 'duration': 7.07}, {'end': 3217.416, 'text': "I'll close this.", 'start': 3215.875, 'duration': 1.541}, {'end': 3219.197, 'text': 'Go to the design tab.', 'start': 3218.177, 'duration': 1.02}, {'end': 3223.56, 'text': "Under subtotals, I'll choose do not show subtotals.", 'start': 3219.938, 'duration': 3.622}, {'end': 3231.366, 'text': "Okay Now let's select the table and I'll actually paste it somewhere here.", 'start': 3223.741, 'duration': 7.625}, {'end': 3239.031, 'text': 'Now with this data, I can go to the insert tab and choose maps.', 'start': 3233.748, 'duration': 5.283}], 'summary': 'Adjust pivot table to show united states as item labels in tabular format and repeat item labels, then create a map using the data.', 'duration': 77.889, 'max_score': 3161.142, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k3161142.jpg'}, {'end': 3339.105, 'src': 'embed', 'start': 3312.903, 'weight': 4, 'content': [{'end': 3321.37, 'text': 'you can see it will show the sales values for each of the states and if you want, you can keep the legend as well.', 'start': 3312.903, 'duration': 8.467}, {'end': 3326.534, 'text': "i'll just remove these two all right now.", 'start': 3321.37, 'duration': 5.164}, {'end': 3331.839, 'text': 'similarly, you can also create a field map to see the profits by each state,', 'start': 3326.534, 'duration': 5.305}, {'end': 3338.264, 'text': 'so you can analyze which states made the highest amount of profit and the state that made the lowest amount of profit.', 'start': 3331.839, 'duration': 6.425}, {'end': 3339.105, 'text': "so let's do that.", 'start': 3338.264, 'duration': 0.841}], 'summary': 'Visualize sales and profits by state to analyze performance.', 'duration': 26.202, 'max_score': 3312.903, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k3312903.jpg'}], 'start': 2264.708, 'title': 'Data analysis and visualization', 'summary': 'Covers topics including daily scrum, average annual salary for business analysts, creating pivot tables and charts in excel, field maps for visualizing sales and profits, and building a sales dashboard, providing insights on sales and profit analysis using slicers and filters.', 'chapters': [{'end': 2623.902, 'start': 2264.708, 'title': 'Daily scrum and business analyst insights', 'summary': 'Discusses the concept of daily scrum and provides insights on the average annual salary, companies hiring for business analysts, top business analysis tools and software, and a demo on business analyst training.', 'duration': 359.194, 'highlights': ['The average annual salary of a business analyst in the United States is $68,973, while in India it is nearly 6 lakh rupees per annum, according to PayScale. This highlights the quantifiable data on average annual salaries for business analysts in the United States and India.', 'Companies hiring for business analysts include Indian e-commerce payment system and financial technology company Paytm, American MNC Cognizant, British Dutch multinational oil and gas company Shell, Cisco, Google, Dell, Ernst & Young Global Limited, Oracle, and Barclays. This highlights the key companies hiring for business analysts, providing a comprehensive list of potential employers.', 'The top business analysis tools and software used by business analysts include Microsoft Excel, Trello, MySQL, Microsoft SQL Server, PostgreSQL, Zira, and Tableau. This provides a list of essential business analysis tools and software, offering insights into the technological skills required in the field.', "The demo on business analyst training involves working on structured data using Excel to create pivot tables and pivot charts for data analysis and visualization. This highlights the practical application of business analyst training, focusing on data analysis and visualization using Excel's features."]}, {'end': 3242.534, 'start': 2626.038, 'title': 'Creating pivot tables and charts in excel', 'summary': 'Demonstrates creating pivot tables and charts in excel to analyze sales data, including creating bar, line, and pie charts and field maps, and provides insights on sales, profits, and quantity sold by segment, category, subcategory, and shipment mode.', 'duration': 616.496, 'highlights': ['Creating a pivot table to analyze the sales by category and segment, followed by generating a bar chart and a line chart to visualize the data. Demonstrates analyzing sales data by category and segment, creating bar and line charts to visualize the data.', 'Using pivot tables to identify the segments with the highest and lowest profits, and creating a pie chart to represent the profit distribution. Illustrates identifying segments with highest and lowest profits using pivot tables, and creating a pie chart to represent the profit distribution.', 'Utilizing pivot tables to analyze the total units sold for each subcategory and shipment mode, followed by creating a line chart to visualize the quantity sold. Shows analyzing total units sold for each subcategory and shipment mode using pivot tables, and creating a line chart to visualize the quantity sold.', 'Using pivot tables to identify states with the highest and lowest sales, and demonstrating the process of creating a field map to visualize the sales data geographically. Illustrates identifying states with highest and lowest sales using pivot tables, and creating a field map to visualize the sales data geographically.']}, {'end': 3490.353, 'start': 3244.554, 'title': 'Field maps for sales and profits', 'summary': 'Covers the creation of field maps to visualize sales and profits by state in the united states, demonstrating how california had the highest sales, and discussing the process of generating a map to analyze profits by state.', 'duration': 245.799, 'highlights': ['California had the highest amount of sales, represented by the dark blue color on the field map. California had the highest amount of sales, indicated by the dark blue color on the field map.', 'Demonstrating the process of generating a map to analyze profits by state, including the steps of creating a pivot table and designing the field map. The process of generating a map to analyze profits by state, including creating a pivot table and designing the field map, was demonstrated.']}, {'end': 3897.365, 'start': 3491.974, 'title': 'Building sales dashboard', 'summary': 'Details the process of building a sales dashboard by adding text, arranging pivot charts, and incorporating slicers and timelines to enable efficient data filtering and visualization.', 'duration': 405.391, 'highlights': ['The process of building a sales dashboard by adding text, arranging pivot charts, and incorporating slicers and timelines is detailed. The chapter covers the steps involved in creating a sales dashboard, including adding text, arranging pivot charts, and incorporating slicers and timelines for efficient data filtering and visualization.', 'The usage of slicers and timelines to filter tables and charts is explained, with a demonstration of manipulating the order year to reflect changes across all tables and charts. The usage of slicers and timelines to filter tables and charts is explained, with a demonstration of manipulating the order year to reflect changes across all tables and charts, ensuring synchronized data manipulation.', 'The addition of filters in the form of slicers for region and segment is demonstrated, emphasizing the advanced filtering options available. The addition of filters in the form of slicers for region and segment is demonstrated, emphasizing the advanced filtering options available for efficient data analysis and visualization.']}, {'end': 4101.557, 'start': 3898.405, 'title': 'Sales and profit analysis demo', 'summary': 'Demonstrates how to filter and analyze sales and profit data by year, region, and segment using slicers, showing variations in graphs and updating pivot tables based on the selected filters.', 'duration': 203.152, 'highlights': ['The demo illustrates how to filter sales and profit data by year, region, and segment using slicers, updating pivot tables and graphs accordingly. The speaker demonstrates filtering sales and profit data by year, region, and segment using slicers, updating pivot tables and graphs accordingly.', 'The tutorial explains the process of updating pivot tables by applying slicers for different regions and segments, showing variations in the graphs based on the selected filters. The tutorial explains how to update pivot tables by applying slicers for different regions and segments, showing variations in the graphs based on the selected filters.', 'The speaker demonstrates how to use slicers to filter sales and profit data for specific segments, showing variations in the graphs and updating pivot tables accordingly. The speaker demonstrates using slicers to filter sales and profit data for specific segments, showing variations in the graphs and updating pivot tables accordingly.']}], 'duration': 1836.849, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k2264708.jpg', 'highlights': ['The chapter covers the steps involved in creating a sales dashboard, including adding text, arranging pivot charts, and incorporating slicers and timelines for efficient data filtering and visualization.', 'Companies hiring for business analysts include Indian e-commerce payment system and financial technology company Paytm, American MNC Cognizant, British Dutch multinational oil and gas company Shell, Cisco, Google, Dell, Ernst & Young Global Limited, Oracle, and Barclays.', 'The top business analysis tools and software used by business analysts include Microsoft Excel, Trello, MySQL, Microsoft SQL Server, PostgreSQL, Zira, and Tableau.', 'The average annual salary of a business analyst in the United States is $68,973, while in India it is nearly 6 lakh rupees per annum, according to PayScale.', 'The process of generating a map to analyze profits by state, including creating a pivot table and designing the field map, was demonstrated.', 'The demo on business analyst training involves working on structured data using Excel to create pivot tables and pivot charts for data analysis and visualization.']}, {'end': 5146.768, 'segs': [{'end': 4150.153, 'src': 'embed', 'start': 4120.988, 'weight': 2, 'content': [{'end': 4126.953, 'text': 'Business analyst is a professional who bridges the gap between the IT and the business teams in an organization.', 'start': 4120.988, 'duration': 5.965}, {'end': 4133.477, 'text': 'They use data analytics and modern technologies to assess processes and deliver data-driven solutions.', 'start': 4127.433, 'duration': 6.044}, {'end': 4138.02, 'text': 'They understand and solve a business problem and validate business requirements.', 'start': 4134.218, 'duration': 3.802}, {'end': 4142.624, 'text': 'A business analyst generates reports for executives and stakeholders.', 'start': 4138.881, 'duration': 3.743}, {'end': 4150.153, 'text': 'They are part of the business operation and work closely with the technology team to improve the quality of the services being delivered.', 'start': 4143.544, 'duration': 6.609}], 'summary': 'Business analysts bridge it-business gap, use data to solve problems, and generate reports for stakeholders.', 'duration': 29.165, 'max_score': 4120.988, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k4120988.jpg'}, {'end': 4192.91, 'src': 'embed', 'start': 4164.444, 'weight': 1, 'content': [{'end': 4169.089, 'text': 'A data analyst collects, processes and performs analysis of large data sets.', 'start': 4164.444, 'duration': 4.645}, {'end': 4172.551, 'text': 'Every business generates data in several formats.', 'start': 4169.93, 'duration': 2.621}, {'end': 4180.72, 'text': 'This data can be in the form of customer information and feedback, log files, transaction data, marketing research and so on.', 'start': 4173.053, 'duration': 7.667}, {'end': 4186.163, 'text': 'It is the duty of a data analyst to transform these business data into valuable insights.', 'start': 4181.359, 'duration': 4.804}, {'end': 4192.91, 'text': 'Some of the problems that can be addressed are how to improve a business, how to provide good customer experience,', 'start': 4186.665, 'duration': 6.245}], 'summary': 'A data analyst processes and analyzes various business data to provide valuable insights for improving business and customer experience.', 'duration': 28.466, 'max_score': 4164.444, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k4164444.jpg'}, {'end': 4241.641, 'src': 'embed', 'start': 4208.76, 'weight': 0, 'content': [{'end': 4213.241, 'text': "let's now shift our focus towards the various responsibilities of a business analyst.", 'start': 4208.76, 'duration': 4.481}, {'end': 4216.542, 'text': 'A business analyst, identifies the business goals,', 'start': 4214.082, 'duration': 2.46}, {'end': 4222.064, 'text': 'understands the problems faced by an organization and comes up with a cost-effective solution to tackle the issues.', 'start': 4216.542, 'duration': 5.522}, {'end': 4227.225, 'text': 'They thoroughly understand the requirements from the clients and assign the right resources.', 'start': 4222.924, 'duration': 4.301}, {'end': 4233.198, 'text': 'BAs communicate and work closely with the development team to design the solution for a problem.', 'start': 4228.177, 'duration': 5.021}, {'end': 4241.641, 'text': "They ensure that the development team doesn't spend their time understanding the stakeholders' requirements and often give iterative feedback on the solution being developed.", 'start': 4233.718, 'duration': 7.923}], 'summary': 'Business analysts identify goals, understand problems, and provide cost-effective solutions, working closely with development teams to ensure efficient communication and resource allocation.', 'duration': 32.881, 'max_score': 4208.76, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k4208760.jpg'}, {'end': 4383.091, 'src': 'embed', 'start': 4353.679, 'weight': 12, 'content': [{'end': 4357.64, 'text': 'You can apply for entry-level business analyst positions or with professional experience.', 'start': 4353.679, 'duration': 3.961}, {'end': 4361.962, 'text': 'Excel is a powerful analytics and reporting tool for working with data.', 'start': 4358.38, 'duration': 3.582}, {'end': 4366.305, 'text': 'BAs use Excel to perform various calculations, data analysis,', 'start': 4362.583, 'duration': 3.722}, {'end': 4372.428, 'text': 'plan an editorial calendar and calculate customer discounts to derive meaningful insights and take decisions.', 'start': 4366.305, 'duration': 6.123}, {'end': 4378.472, 'text': 'BAs use SQL to retrieve, manipulate, and analyze data stored in relational databases.', 'start': 4373.329, 'duration': 5.143}, {'end': 4383.091, 'text': "Critical thinking skills are important to understand customers' business needs.", 'start': 4379.249, 'duration': 3.842}], 'summary': 'Entry-level business analysts use excel for data analysis and sql for database manipulation to understand and fulfill customer needs.', 'duration': 29.412, 'max_score': 4353.679, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k4353679.jpg'}, {'end': 4551.758, 'src': 'embed', 'start': 4519.477, 'weight': 3, 'content': [{'end': 4522.919, 'text': "Now let's discuss the salary structure for both of these job roles.", 'start': 4519.477, 'duration': 3.442}, {'end': 4530.343, 'text': 'According to PayScale, a business analyst in the United States earns an average salary of $69,000,', 'start': 4523.84, 'duration': 6.503}, {'end': 4533.326, 'text': 'while in India you can earn nearly 6 lakh rupees per annum.', 'start': 4530.344, 'duration': 2.982}, {'end': 4536.048, 'text': 'Now talking about the salary of a data analyst.', 'start': 4533.846, 'duration': 2.202}, {'end': 4540.29, 'text': 'according to PayScale, in the US a data analyst earns an average salary of $60,710 per annum,', 'start': 4536.048, 'duration': 4.242}, {'end': 4542.252, 'text': 'and in India you can earn around 4,24,000 rupees per annum.', 'start': 4540.29, 'duration': 1.962}, {'end': 4551.758, 'text': "Let's now move on and look at the different companies hiring for business analyst roles.", 'start': 4547.615, 'duration': 4.143}], 'summary': 'Us business analysts earn $69,000; indian analysts earn 6 lakh rupees. us data analysts earn $60,710; indian analysts earn 4,24,000 rupees.', 'duration': 32.281, 'max_score': 4519.477, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k4519477.jpg'}, {'end': 4613.476, 'src': 'embed', 'start': 4591.512, 'weight': 5, 'content': [{'end': 4599.684, 'text': 'The key points that you have to keep in mind before making a decision is First, review your background and see what qualifications you have.', 'start': 4591.512, 'duration': 8.172}, {'end': 4603.147, 'text': 'Check what skills you possess and the domain knowledge you have.', 'start': 4600.104, 'duration': 3.043}, {'end': 4606.69, 'text': 'Then, gauge your interests to see what suits you best.', 'start': 4603.988, 'duration': 2.702}, {'end': 4613.476, 'text': "And finally, consider your long-term goals and see the job roles that'll help you grow in your career in the long run.", 'start': 4607.691, 'duration': 5.785}], 'summary': 'Consider qualifications, skills, interests, and long-term goals for career decisions.', 'duration': 21.964, 'max_score': 4591.512, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k4591512.jpg'}, {'end': 4794.218, 'src': 'embed', 'start': 4768.024, 'weight': 6, 'content': [{'end': 4773.849, 'text': 'because in business they want to make money and we really want to understand where the split is on a lot of these things.', 'start': 4768.024, 'duration': 5.825}, {'end': 4778.093, 'text': 'So always ask yourself where is the bottom dollar on this, and what does this mean?', 'start': 4773.889, 'duration': 4.204}, {'end': 4783.377, 'text': "Risk is your potential and an issue is something that's actually happening.", 'start': 4779.033, 'duration': 4.344}, {'end': 4788.922, 'text': 'So risk is a potential problem that can be predicted, risk may or may not happen in the future.', 'start': 4784.258, 'duration': 4.664}, {'end': 4794.218, 'text': 'A proactive response plan is formulated and kept ready to mitigate risks.', 'start': 4789.457, 'duration': 4.761}], 'summary': 'In business, understanding the bottom dollar is crucial. risk is a potential problem that can be predicted and mitigated with a proactive response plan.', 'duration': 26.194, 'max_score': 4768.024, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k4768024.jpg'}, {'end': 4865.977, 'src': 'embed', 'start': 4837.394, 'weight': 7, 'content': [{'end': 4844.783, 'text': "Some of the more basic ones obviously an Excel spreadsheet, which isn't on this list, But your Python, your SQL.", 'start': 4837.394, 'duration': 7.389}, {'end': 4848.946, 'text': "you should really know your SQL, because it's going to come up in no matter what format you're in.", 'start': 4844.783, 'duration': 4.163}, {'end': 4854.57, 'text': 'Your Tableau, your Azure, your Balsamiq, all these are different platforms.', 'start': 4849.687, 'duration': 4.883}, {'end': 4859.913, 'text': "There's a lot more out there, but you should be aware on which platforms your proficiencies are on.", 'start': 4854.59, 'duration': 5.323}, {'end': 4865.977, 'text': 'And those also that you might not be proficient on, but you at least know what they do and what their performance is.', 'start': 4860.594, 'duration': 5.383}], 'summary': 'Proficiency in excel, python, sql, tableau, azure, and balsamiq is crucial for diverse platforms.', 'duration': 28.583, 'max_score': 4837.394, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k4837394.jpg'}, {'end': 4945.209, 'src': 'embed', 'start': 4878.113, 'weight': 8, 'content': [{'end': 4885.996, 'text': 'And we look at project initiation, project planning, project execution, project control and monitoring, project closure.', 'start': 4878.113, 'duration': 7.883}, {'end': 4892.478, 'text': "And it's really important to understand any one of these in a little bit more detail than just knowing the list.", 'start': 4886.016, 'duration': 6.462}, {'end': 4901.266, 'text': 'What is feasibility study? A feasibility study is a method of gauging the success rate of proposed business solution.', 'start': 4893.138, 'duration': 8.128}, {'end': 4905.51, 'text': 'It enables business analysts to discover new business opportunities.', 'start': 4901.686, 'duration': 3.824}, {'end': 4912.649, 'text': "And really, a lot of businesses, when they're looking for a business analyst, This is really what they want to know.", 'start': 4907.111, 'duration': 5.538}, {'end': 4918.512, 'text': "What's the feasibility? That is a very central question that comes up in most business plans.", 'start': 4912.689, 'duration': 5.823}, {'end': 4921.214, 'text': "What's the feasibility of doing something and getting it done?", 'start': 4918.633, 'duration': 2.581}, {'end': 4923.676, 'text': 'What is business model analysis??', 'start': 4921.895, 'duration': 1.781}, {'end': 4931.981, 'text': 'Business model analysis is a technique that helps you analyze if a business is financially, economically and socially viable or not.', 'start': 4924.136, 'duration': 7.845}, {'end': 4945.209, 'text': "I know a number of contractors that this is their sole career is to go in and analyze ski resorts in Colorado to find out whether it's going to make it this year or not and what they need to do to fix that.", 'start': 4933.544, 'duration': 11.665}], 'summary': 'The importance of project phases and business analysis techniques, including feasibility study and business model analysis, in evaluating success and viability.', 'duration': 67.096, 'max_score': 4878.113, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k4878113.jpg'}, {'end': 5003.394, 'src': 'embed', 'start': 4972.616, 'weight': 11, 'content': [{'end': 4977.319, 'text': 'Needs Needs are the high level representation of the terms and the result.', 'start': 4972.616, 'duration': 4.703}, {'end': 4984.724, 'text': "Business needs include identifying and comprehending the business's goals and articulating its strategic direction.", 'start': 4977.96, 'duration': 6.764}, {'end': 4991.542, 'text': 'And you can think of needs are, what do we need to succeed? Requirements are, well, these are the things we need to put into place.', 'start': 4985.455, 'duration': 6.087}, {'end': 4994.184, 'text': "This is what's required to achieve a business objective.", 'start': 4991.602, 'duration': 2.582}, {'end': 5003.394, 'text': 'Suppose you have been given a list of zip pin codes from different countries.', 'start': 4997.328, 'duration': 6.066}], 'summary': 'Identifying business needs and requirements for success and achievement of objectives.', 'duration': 30.778, 'max_score': 4972.616, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k4972616.jpg'}, {'end': 5121.535, 'src': 'embed', 'start': 5094.255, 'weight': 13, 'content': [{'end': 5101.143, 'text': "Now, not all companies use Tableau, but it is becoming a very highly used tool because it's so easy to use.", 'start': 5094.255, 'duration': 6.888}, {'end': 5103.984, 'text': 'You drag the region onto columns.', 'start': 5101.823, 'duration': 2.161}, {'end': 5107.386, 'text': 'Drag the sales channel and item type fields onto rows.', 'start': 5104.264, 'duration': 3.122}, {'end': 5112.549, 'text': 'Select the total revenue column and drag it onto color and label cards.', 'start': 5107.867, 'duration': 4.682}, {'end': 5115.351, 'text': 'Select square as the mark type.', 'start': 5112.77, 'duration': 2.581}, {'end': 5119.133, 'text': 'Drag the total revenue field onto columns.', 'start': 5116.952, 'duration': 2.181}, {'end': 5121.535, 'text': 'Drag the total profit column onto rows.', 'start': 5119.394, 'duration': 2.141}], 'summary': 'Tableau is increasingly popular due to its ease of use and is used by many companies.', 'duration': 27.28, 'max_score': 5094.255, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k5094255.jpg'}], 'start': 4101.957, 'title': 'Comparing business analyst and data analyst roles', 'summary': 'Compares the responsibilities, skills, and tasks of business analysts and data analysts, emphasizing data handling, analysis, and problem-solving. it also highlights skill sets, salary structures, job opportunities, and interview insights, including practical applications of tools like excel and tableau.', 'chapters': [{'end': 4332.039, 'start': 4101.957, 'title': 'Comparison: business analyst vs data analyst', 'summary': 'Compares the roles of business analyst and data analyst, highlighting their responsibilities, skills, and tasks, focusing on data handling, analysis, and problem-solving, with an emphasis on bridging it and business, and transforming business data into valuable insights.', 'duration': 230.082, 'highlights': ['Data analysts collect, process, and analyze large data sets from various sources, using analytical and statistical tools to spot trends and patterns, and prepare summary reports for the leadership team. Data analysts play a crucial role in collecting and analyzing data from heterogeneous sources, using analytical tools to spot trends and patterns, and preparing summary reports for the leadership team.', 'Business analysts bridge the gap between IT and business teams, using data analytics and modern technologies to assess processes, deliver data-driven solutions, and generate reports for executives and stakeholders. Business analysts act as a bridge between IT and business teams, utilizing data analytics to assess processes, deliver data-driven solutions, and generate reports for executives and stakeholders.', 'Business analysts identify business goals, understand organization problems, and come up with cost-effective solutions to tackle issues, communicating and working closely with the development team to design solutions. Business analysts identify business goals, understand organization problems, and work closely with the development team to design cost-effective solutions, ensuring alignment with business requirements.']}, {'end': 4746.595, 'start': 4332.959, 'title': 'Business analyst vs data analyst skills and job opportunities', 'summary': 'Compares the skill sets and job opportunities for business analysts and data analysts, highlighting key skills, salary structures, and companies hiring for these roles, along with guidance on choosing the right career path and information on postgraduate programs in business analysis and data analytics offered by simply learn.', 'duration': 413.636, 'highlights': ['Business analysts require skills in Excel, SQL, data visualization, programming languages like R and Python, and presentation abilities, with an average salary of $69,000 in the US and 6 lakh rupees in India. Business analysts need to be proficient in Excel, SQL, and data visualization tools like Tableau and Power BI, along with programming languages such as R and Python. The average salary for a business analyst is $69,000 in the US and 6 lakh rupees in India.', 'Data analysts should be skilled in Excel, SQL, programming languages like Python, R, SAS, and JavaScript, data visualization tools like Tableau and Power BI, and machine learning algorithms, with an average salary of $60,710 in the US and 4,24,000 rupees in India. Data analysts require expertise in Excel, SQL, programming languages including Python, R, SAS, and JavaScript, as well as data visualization tools like Tableau and Power BI. Additionally, they should have knowledge of machine learning algorithms. The average salary for a data analyst is $60,710 in the US and 4,24,000 rupees in India.', 'Key considerations for choosing the right career path include reviewing qualifications, assessing skills and domain knowledge, evaluating interests, and considering long-term career goals. Before deciding between a business analyst and a data analyst role, individuals should review their qualifications, skills, domain knowledge, interests, and long-term career goals to make an informed choice.', "Simply Learn offers postgraduate programs in business analysis and data analytics, providing comprehensive coverage of relevant skills and tools, along with certification and job assistance. Simply Learn's postgraduate programs in business analysis and data analytics, in collaboration with Purdue University and IBM, cover essential skills, tools, and certifications, offering job assistance and master classes from Purdue faculty."]}, {'end': 5146.768, 'start': 4747.955, 'title': 'Business analytics interview insights', 'summary': 'Covers key topics like risk vs. issue, essential tools for business analysts, stages of a business project, feasibility study, business model analysis, requirements vs. needs, and practical excel and tableau applications for data analysis.', 'duration': 398.813, 'highlights': ['Understanding the differentiation between risk and issue is crucial in business analytics, with risk being a potential problem that can be predicted, and an issue being something that is occurring or about to happen. Risk is a potential problem that can be predicted, and an issue is a risk that is occurring or about to happen.', 'Proficiency in tools like Python, SQL, Tableau, and Azure is essential for business analysts, as these are commonly used platforms in the field, and being aware of other platforms is also beneficial. Proficiency in tools like Python, SQL, Tableau, and Azure is essential for business analysts, and being aware of other platforms is also beneficial.', 'Understanding the various stages of a business project, such as initiation, planning, execution, control and monitoring, and closure, is crucial for a comprehensive grasp of project management. Understanding the various stages of a business project, such as initiation, planning, execution, control and monitoring, and closure, is crucial for a comprehensive grasp of project management.', 'Feasibility study is a central aspect in business planning, enabling the discovery of new business opportunities and gauging the success rate of proposed business solutions. Feasibility study is a central aspect in business planning, enabling the discovery of new business opportunities and gauging the success rate of proposed business solutions.', 'The technique of business model analysis is vital for assessing the financial, economic, and social viability of a business, particularly in niche areas such as analyzing ski resorts for sustainability. The technique of business model analysis is vital for assessing the financial, economic, and social viability of a business, particularly in niche areas such as analyzing ski resorts for sustainability.', 'Distinguishing between requirements and needs is essential, with requirements being the targeted solutions required to achieve business objectives, while needs represent the high-level representation of terms and results. Distinguishing between requirements and needs is essential, with requirements being the targeted solutions required to achieve business objectives, while needs represent the high-level representation of terms and results.', 'Practical applications of Excel for tasks like finding city and state names from zip codes and using functions like SUMIF and filters for data analysis provide valuable insights and skills for business analysts. Practical applications of Excel for tasks like finding city and state names from zip codes and using functions like SUMIF and filters for data analysis provide valuable insights and skills for business analysts.', 'Utilizing Tableau for creating highlight tables to visualize revenue generated from offline and online sales across regions demonstrates the practical use of data visualization tools in business analysis. Utilizing Tableau for creating highlight tables to visualize revenue generated from offline and online sales across regions demonstrates the practical use of data visualization tools in business analysis.']}], 'duration': 1044.811, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k4101957.jpg', 'highlights': ['Business analysts identify business goals, understand organization problems, and come up with cost-effective solutions to tackle issues, communicating and working closely with the development team to design solutions.', 'Data analysts collect, process, and analyze large data sets from various sources, using analytical and statistical tools to spot trends and patterns, and prepare summary reports for the leadership team.', 'Business analysts bridge the gap between IT and business teams, using data analytics and modern technologies to assess processes, deliver data-driven solutions, and generate reports for executives and stakeholders.', 'Business analysts require skills in Excel, SQL, data visualization, programming languages like R and Python, and presentation abilities, with an average salary of $69,000 in the US and 6 lakh rupees in India.', 'Data analysts should be skilled in Excel, SQL, programming languages like Python, R, SAS, and JavaScript, data visualization tools like Tableau and Power BI, and machine learning algorithms, with an average salary of $60,710 in the US and 4,24,000 rupees in India.', 'Key considerations for choosing the right career path include reviewing qualifications, assessing skills and domain knowledge, evaluating interests, and considering long-term career goals.', 'Understanding the differentiation between risk and issue is crucial in business analytics, with risk being a potential problem that can be predicted, and an issue being something that is occurring or about to happen.', 'Proficiency in tools like Python, SQL, Tableau, and Azure is essential for business analysts, as these are commonly used platforms in the field, and being aware of other platforms is also beneficial.', 'Understanding the various stages of a business project, such as initiation, planning, execution, control and monitoring, and closure, is crucial for a comprehensive grasp of project management.', 'Feasibility study is a central aspect in business planning, enabling the discovery of new business opportunities and gauging the success rate of proposed business solutions.', 'The technique of business model analysis is vital for assessing the financial, economic, and social viability of a business, particularly in niche areas such as analyzing ski resorts for sustainability.', 'Distinguishing between requirements and needs is essential, with requirements being the targeted solutions required to achieve business objectives, while needs represent the high-level representation of terms and results.', 'Practical applications of Excel for tasks like finding city and state names from zip codes and using functions like SUMIF and filters for data analysis provide valuable insights and skills for business analysts.', 'Utilizing Tableau for creating highlight tables to visualize revenue generated from offline and online sales across regions demonstrates the practical use of data visualization tools in business analysis.']}, {'end': 5636.345, 'segs': [{'end': 5198.627, 'src': 'embed', 'start': 5169.146, 'weight': 3, 'content': [{'end': 5176.308, 'text': 'Here phases include requirement gathering coding operations maintenance and documentation, where the project lifecycle.', 'start': 5169.146, 'duration': 7.162}, {'end': 5179.459, 'text': 'This enables you to develop a new product in the business.', 'start': 5176.758, 'duration': 2.701}, {'end': 5184.001, 'text': 'Project lifecycle consists of multiple software in one customer scenario.', 'start': 5179.699, 'duration': 4.302}, {'end': 5190.284, 'text': 'Phases here are idea generation, screening, development, testing, and analysis.', 'start': 5184.621, 'duration': 5.663}, {'end': 5198.627, 'text': "How do you perform risk management in your project? So again, we're dealing with intermediate, not just how to pull tables across.", 'start': 5191.084, 'duration': 7.543}], 'summary': 'Project lifecycle involves requirement gathering, coding, operations, maintenance, and documentation. it enables development of new products in the business.', 'duration': 29.481, 'max_score': 5169.146, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k5169146.jpg'}, {'end': 5230.6, 'src': 'embed', 'start': 5208.607, 'weight': 0, 'content': [{'end': 5217.531, 'text': "having the appropriate risk management plan decreases losses and optimizes decision making to enhance the organization's performance.", 'start': 5208.607, 'duration': 8.924}, {'end': 5220.312, 'text': 'how does risk mitigation differ from risk avoidance?', 'start': 5217.531, 'duration': 2.781}, {'end': 5222.554, 'text': 'Risk mitigation.', 'start': 5221.693, 'duration': 0.861}, {'end': 5225.976, 'text': 'Risk mitigation is a plan to be executed when a risk occurs.', 'start': 5222.614, 'duration': 3.362}, {'end': 5230.6, 'text': 'When a risk occurs, there might be a business impact and the cost incurred is high.', 'start': 5226.417, 'duration': 4.183}], 'summary': 'Effective risk management decreases losses, optimizes decision making, and enhances organizational performance.', 'duration': 21.993, 'max_score': 5208.607, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k5208607.jpg'}, {'end': 5305.158, 'src': 'embed', 'start': 5274.124, 'weight': 1, 'content': [{'end': 5277.266, 'text': "There's all kinds of areas where you want to mitigate and avoid risk.", 'start': 5274.124, 'duration': 3.142}, {'end': 5280.023, 'text': 'What are project deliverables?', 'start': 5278.462, 'duration': 1.561}, {'end': 5288.648, 'text': 'Project deliverables represent a collection of measurable services and goods that are to be delivered to the end user in the project completion stage.', 'start': 5280.543, 'duration': 8.105}, {'end': 5290.469, 'text': 'This is so important.', 'start': 5289.548, 'duration': 0.921}, {'end': 5297.893, 'text': 'We start talking about any of our, when you sign a contract, any of our online contracts, cloud computing, all of that.', 'start': 5290.489, 'duration': 7.404}, {'end': 5305.158, 'text': "Make sure you're very clear what the deliverables are, who owns it, who is the responsibility of the service, and the security around it.", 'start': 5298.334, 'duration': 6.824}], 'summary': 'Project deliverables are measurable services and goods to be delivered to end users, emphasizing the importance of clarity and security in contracts and cloud computing.', 'duration': 31.034, 'max_score': 5274.124, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k5274124.jpg'}, {'end': 5346.677, 'src': 'embed', 'start': 5321.487, 'weight': 2, 'content': [{'end': 5326.329, 'text': 'The Agile model is adaptable to requirement changes and has an incremental approach.', 'start': 5321.487, 'duration': 4.842}, {'end': 5331.432, 'text': 'In the Agile model, testing can be performed in every phase.', 'start': 5327.49, 'duration': 3.942}, {'end': 5338.515, 'text': 'With the Waterfall model, the Waterfall model is referred as a structured software development methodology.', 'start': 5332.812, 'duration': 5.703}, {'end': 5346.677, 'text': 'Changes and requirements are difficult to implement, meanwhile in the waterfall model testing is performed only in the final phase.', 'start': 5339.215, 'duration': 7.462}], 'summary': 'Agile is adaptable, incremental; testing in every phase. waterfall is structured, limited testing.', 'duration': 25.19, 'max_score': 5321.487, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k5321487.jpg'}, {'end': 5413.573, 'src': 'embed', 'start': 5369.264, 'weight': 4, 'content': [{'end': 5373.747, 'text': 'Describe the different analytical techniques like Moscow and SWOT.', 'start': 5369.264, 'duration': 4.483}, {'end': 5376.089, 'text': 'Moscow analysis.', 'start': 5374.948, 'duration': 1.141}, {'end': 5380.132, 'text': "It is a prioritization technique that highlights a requirement's significance.", 'start': 5376.229, 'duration': 3.903}, {'end': 5389.76, 'text': 'Question like, is it a must-have or a should-have? Could the demand be made better? Would a specific idea be useful in the future? Are asked here.', 'start': 5380.673, 'duration': 9.087}, {'end': 5398.744, 'text': 'In the SWOT analysis, it discovers the strengths and weaknesses of a firm and evaluates them as opportunities and threats.', 'start': 5391.26, 'duration': 7.484}, {'end': 5403.927, 'text': 'SWOT analysis consists of strengths, weaknesses, opportunities, and threats.', 'start': 5399.745, 'duration': 4.182}, {'end': 5410.931, 'text': "And you can kind of think of it as like the SWAT team coming in to, you know, you're worried about threats here.", 'start': 5404.648, 'duration': 6.283}, {'end': 5412.192, 'text': "So we're talking about policing.", 'start': 5410.951, 'duration': 1.241}, {'end': 5413.573, 'text': 'Or in Moscow.', 'start': 5412.732, 'duration': 0.841}], 'summary': "Analytical techniques like moscow and swot prioritize requirements and evaluate firm's strengths, weaknesses, opportunities, and threats.", 'duration': 44.309, 'max_score': 5369.264, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k5369264.jpg'}, {'end': 5469.791, 'src': 'embed', 'start': 5439.428, 'weight': 6, 'content': [{'end': 5440.749, 'text': 'What is benchmarking?', 'start': 5439.428, 'duration': 1.321}, {'end': 5448.113, 'text': "Benchmarking is a process of evaluating an organization's measures, like the quality of policies, programs, etc.", 'start': 5441.729, 'duration': 6.384}, {'end': 5450.615, 'text': 'against the standard criteria.', 'start': 5448.894, 'duration': 1.721}, {'end': 5455.58, 'text': "It's so important to have that baseline of what are you measuring against.", 'start': 5451.876, 'duration': 3.704}, {'end': 5460.684, 'text': "The baseline might not even be a very good one, but you can't measure something unless you have something to measure it against.", 'start': 5455.8, 'duration': 4.884}, {'end': 5463.626, 'text': 'It helps with the measuring the performance of the company.', 'start': 5461.464, 'duration': 2.162}, {'end': 5469.791, 'text': 'You can recognize the areas of improvement in a company and analyze how other companies achieve other objectives.', 'start': 5463.946, 'duration': 5.845}], 'summary': 'Benchmarking evaluates measures against standard criteria, aiding performance analysis and improvement.', 'duration': 30.363, 'max_score': 5439.428, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k5439428.jpg'}, {'end': 5530.127, 'src': 'embed', 'start': 5501.525, 'weight': 7, 'content': [{'end': 5505.506, 'text': 'The stakeholders had so much difficulty with some particular aspect going on.', 'start': 5501.525, 'duration': 3.981}, {'end': 5513.138, 'text': 'So difficulties are going to arise, hopefully not at that level, but things happen and of course you want to just assume work with anybody,', 'start': 5506.294, 'duration': 6.844}, {'end': 5515.559, 'text': 'but you want to listen patiently to the stakeholders point of view.', 'start': 5513.138, 'duration': 2.421}, {'end': 5519.561, 'text': 'respond to them politely and diplomatically.', 'start': 5516.6, 'duration': 2.961}, {'end': 5526.905, 'text': 'have a one on one discussion to make things more precise, comprehend their worries and be transparent.', 'start': 5519.561, 'duration': 7.344}, {'end': 5530.127, 'text': 'make sure to continuously engage such difficult stakeholders.', 'start': 5526.905, 'duration': 3.222}], 'summary': 'Address difficulties by listening, responding diplomatically, and engaging stakeholders continuously.', 'duration': 28.602, 'max_score': 5501.525, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k5501525.jpg'}, {'end': 5601.568, 'src': 'embed', 'start': 5572.214, 'weight': 8, 'content': [{'end': 5574.175, 'text': "Important thing to look into if you haven't.", 'start': 5572.214, 'duration': 1.961}, {'end': 5586.661, 'text': 'Learn Software Development and Extreme Programming, XP, Feature-Driven Development, FDD, Crystal, Kanban, Dynamic Systems Development Method, DSDM.', 'start': 5575.157, 'duration': 11.504}, {'end': 5593.663, 'text': 'If getting your learning started is half the battle, what if you could do that for free? Visit SkillUp by SimplyLearn.', 'start': 5587.321, 'duration': 6.342}, {'end': 5596.224, 'text': 'Click on the link in the description to know more.', 'start': 5593.983, 'duration': 2.241}, {'end': 5601.568, 'text': 'just a ton of different methodologies,', 'start': 5598.666, 'duration': 2.902}], 'summary': 'Learn various software development methodologies for free on skillup by simplylearn.', 'duration': 29.354, 'max_score': 5572.214, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k5572214.jpg'}, {'end': 5645.489, 'src': 'embed', 'start': 5614.677, 'weight': 9, 'content': [{'end': 5622.482, 'text': 'gap analysis refers to the analysis of differences between the existing systems functionalities and the targeted system.', 'start': 5614.677, 'duration': 7.805}, {'end': 5625.904, 'text': 'the gap indicates the amount of work required to get the intended result.', 'start': 5622.482, 'duration': 3.422}, {'end': 5630.863, 'text': 'Gap analysis is a comparison between the current and proposed functionalities.', 'start': 5626.601, 'duration': 4.262}, {'end': 5636.345, 'text': 'You can see here we put together an action plan to go from the current state to the desired state.', 'start': 5630.883, 'duration': 5.462}, {'end': 5645.489, 'text': 'How do you import text file data into MS Excel? And remember, Excel is one of those things that has been around forever.', 'start': 5637.446, 'duration': 8.043}], 'summary': 'Gap analysis measures work needed for system upgrade. excel data import is discussed.', 'duration': 30.812, 'max_score': 5614.677, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k5614677.jpg'}], 'start': 5147.908, 'title': 'Lifecycle, risk and analytical techniques', 'summary': 'Covers software and project lifecycle, risk management, analytical techniques such as moscow and swot, strategy analysis, agile and waterfall models, and working with stakeholders.', 'chapters': [{'end': 5366.663, 'start': 5147.908, 'title': 'Project lifecycle and risk management', 'summary': 'Discusses the difference between software development lifecycle and project lifecycle, risk management techniques, risk mitigation versus risk avoidance, project deliverables, and the differentiation between agile and waterfall models.', 'duration': 218.755, 'highlights': ['Project deliverables represent a collection of measurable services and goods that are to be delivered to the end user in the project completion stage. Understanding project deliverables is crucial for ensuring clear responsibilities and security around the services and goods delivered.', 'Risk mitigation is a plan to be executed when a risk occurs, while risk avoidance is carried out to avoid the risk from occurring. Distinguishing between risk mitigation and risk avoidance is essential for decision-making and cost management in dealing with potential risks.', 'The Agile model is adaptable to requirement changes and has an incremental approach, while the Waterfall model is referred to as a structured software development methodology. Understanding the differences between the Agile and Waterfall models is crucial, especially in the context of software development, as they impact adaptability and testing processes.', 'Software development lifecycle helps with the development of software products, consisting of multiple phases including requirement gathering, coding, operations, maintenance, and documentation. Understanding the phases of the software development lifecycle is essential for the development of software products and efficient project management.', 'Risk management is a technique wherein risks are identified, avoided, reduced, assessed, and mitigated, leading to decreased losses and optimized decision-making for enhanced organizational performance. Comprehending the risk management process and its impact on organizational performance is vital for effective risk assessment and decision-making.']}, {'end': 5636.345, 'start': 5369.264, 'title': 'Analytical techniques and strategy analysis', 'summary': 'Discusses the analytical techniques like moscow and swot, components of strategy analysis, benchmarking, working with difficult stakeholders, agile methodologies, and gap analysis.', 'duration': 267.081, 'highlights': ["Moscow analysis prioritizes requirements' significance by categorizing them as must-have or should-have, and evaluates their future usefulness. Moscow analysis categorizes requirements as must-have or should-have and evaluates their future usefulness, providing a clear prioritization technique.", "SWOT analysis evaluates a firm's strengths, weaknesses, opportunities, and threats, akin to a SWAT team identifying and addressing threats. SWOT analysis evaluates a firm's strengths, weaknesses, opportunities, and threats, similar to a SWAT team addressing threats, offering a comprehensive evaluation approach.", "Benchmarking involves evaluating an organization's measures against standard criteria to analyze performance and identify areas of improvement. Benchmarking involves evaluating an organization's measures against standard criteria to analyze performance and identify areas of improvement, providing a crucial process for enhancing company performance.", 'Approaches for working with difficult stakeholders include listening patiently, responding politely, having one-on-one discussions, and continuously engaging them. Approaches for working with difficult stakeholders include listening patiently, responding politely, having one-on-one discussions, and continuously engaging them, emphasizing the importance of not ignoring difficult stakeholders.', 'Different types of agile methodologies include Scrum, XP, FDD, Crystal, Kanban, and DSDM, and understanding them is crucial for professionals. Understanding different types of agile methodologies like Scrum, XP, FDD, Crystal, Kanban, and DSDM is crucial for professionals, highlighting the importance of comprehensive knowledge in this area.', 'Gap analysis involves analyzing the differences between existing and targeted systems, indicating the amount of work required to achieve the desired result. Gap analysis involves analyzing the differences between existing and targeted systems, indicating the amount of work required to achieve the desired result, offering a clear comparison between current and proposed functionalities.']}], 'duration': 488.437, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k5147908.jpg', 'highlights': ['Risk management involves identifying, avoiding, reducing, assessing, and mitigating risks, leading to decreased losses and optimized decision-making for enhanced organizational performance.', 'Understanding project deliverables is crucial for ensuring clear responsibilities and security around the services and goods delivered.', 'The Agile model is adaptable to requirement changes and has an incremental approach, while the Waterfall model is referred to as a structured software development methodology.', 'Software development lifecycle consists of multiple phases including requirement gathering, coding, operations, maintenance, and documentation, essential for efficient project management.', 'Moscow analysis categorizes requirements as must-have or should-have and evaluates their future usefulness, providing a clear prioritization technique.', "SWOT analysis evaluates a firm's strengths, weaknesses, opportunities, and threats, offering a comprehensive evaluation approach.", "Benchmarking involves evaluating an organization's measures against standard criteria to analyze performance and identify areas of improvement.", 'Approaches for working with difficult stakeholders include listening patiently, responding politely, having one-on-one discussions, and continuously engaging them.', 'Understanding different types of agile methodologies like Scrum, XP, FDD, Crystal, Kanban, and DSDM is crucial for professionals.', 'Gap analysis involves analyzing the differences between existing and targeted systems, indicating the amount of work required to achieve the desired result.']}, {'end': 6733.254, 'segs': [{'end': 5661.341, 'src': 'embed', 'start': 5637.446, 'weight': 0, 'content': [{'end': 5645.489, 'text': 'How do you import text file data into MS Excel? And remember, Excel is one of those things that has been around forever.', 'start': 5637.446, 'duration': 8.043}, {'end': 5651.113, 'text': "And, even though it's like the bottom barrel of a lot of analysis that we do,", 'start': 5645.729, 'duration': 5.384}, {'end': 5658.839, 'text': 'most of our data starts in an Excel spreadsheet or comma-separated variable file that you then end up with an Excel spreadsheet.', 'start': 5651.113, 'duration': 7.726}, {'end': 5661.341, 'text': 'Given below is the employee text file.', 'start': 5659.66, 'duration': 1.681}], 'summary': 'Import text file data into ms excel, a common tool for data analysis.', 'duration': 23.895, 'max_score': 5637.446, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k5637446.jpg'}, {'end': 6462.254, 'src': 'embed', 'start': 6435.586, 'weight': 1, 'content': [{'end': 6441.349, 'text': 'What is Pareto analysis? The Pareto analysis helps in crucial decision making.', 'start': 6435.586, 'duration': 5.763}, {'end': 6447.933, 'text': 'It helps in prioritizing decisions, identifying the most relevant and the least decision concerning the overall goal.', 'start': 6441.489, 'duration': 6.444}, {'end': 6450.034, 'text': 'It is also known as the 80-20 rule.', 'start': 6448.873, 'duration': 1.161}, {'end': 6456.671, 'text': "As per this rule, 82% of the project's benefit arises from 20% of the work.", 'start': 6451.528, 'duration': 5.143}, {'end': 6462.254, 'text': 'Vice versa, 80% of the case problem can be due to 20% of the causes.', 'start': 6457.431, 'duration': 4.823}], 'summary': 'Pareto analysis prioritizes decisions; 82% benefit from 20% work.', 'duration': 26.668, 'max_score': 6435.586, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k6435586.jpg'}, {'end': 6518.661, 'src': 'embed', 'start': 6486.139, 'weight': 2, 'content': [{'end': 6490.321, 'text': 'The fish model is similar to the V model, but with more multiple verification teams.', 'start': 6486.139, 'duration': 4.182}, {'end': 6495.904, 'text': 'Every stage is tested by another team for completeness and correctness.', 'start': 6491.942, 'duration': 3.962}, {'end': 6501.308, 'text': 'The fish model is comparatively very costly and time consuming, which makes sense,', 'start': 6496.525, 'duration': 4.783}, {'end': 6507.23, 'text': 'because if you have multiple tests on each stage for multiple teams, They have to all be spun up on it,', 'start': 6501.308, 'duration': 5.922}, {'end': 6510.794, 'text': "and so you're literally more than doubling the work, because you also have to track all that.", 'start': 6507.23, 'duration': 3.564}, {'end': 6518.661, 'text': "Given the sales data, create a chart to show each region's country that made the highest revenue.", 'start': 6513.456, 'duration': 5.205}], 'summary': 'Fish model involves multiple verification teams for comprehensive testing, but is costly and time-consuming.', 'duration': 32.522, 'max_score': 6486.139, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k6486139.jpg'}], 'start': 5637.446, 'title': 'Data import and analysis techniques', 'summary': 'Covers importing text file data into ms excel, creating pivot tables, analyzing data using percentage contributions, visualizing data in tableau, requirement prioritization techniques, critical agile metrics, bpmn, elicitation techniques, use case diagrams, v model and fish model comparison, and excel and tableau data visualization for analysis and insight.', 'chapters': [{'end': 5915.779, 'start': 5637.446, 'title': 'Importing text file data into ms excel', 'summary': 'Explains how to import text file data into ms excel, create pivot tables, analyze data using percentage contributions, create dual axis chart in tableau, and visualize data in tableau for analysis and insight.', 'duration': 278.333, 'highlights': ['The chapter explains how to import text file data into MS Excel, including steps such as clicking on the Data tab, selecting text CSV from files, and creating a pivot table to analyze profit, with a focus on the importance of pivot tables in summarizing extensive data. (Relevance score: 5)', 'Instructions on creating pivot tables to analyze the profit of items in each region, including steps such as selecting cells for data and finding the percentage contribution of cosmetics to the total revenue and profit, with specific contributions of 14.03% and 18.94% respectively. (Relevance score: 4)', 'Steps for creating a dual axis chart in Tableau, involving actions such as dragging order data onto columns, synchronizing right axes, and visualizing total units sold and profit generated from each item, with an emphasis on customization and exploration. (Relevance score: 3)', 'Guidance on using Tableau to create visualizations for analyzing total revenue and units sold for specific items across different regions, including steps to filter data and insights such as meat having the highest units sold and maximum profit. (Relevance score: 2)', 'Encouragement for hands-on experience with Tableau and other software, along with an acknowledgment of the variety of tools available for data analysis, emphasizing the importance of practical familiarity with the concepts discussed. (Relevance score: 1)']}, {'end': 6462.254, 'start': 5916.679, 'title': 'Requirement prioritization techniques and business analysis insights', 'summary': 'Explores requirement prioritization techniques, critical agile metrics, bpmn, elicitation techniques, key documents for business analysts, project approach, use case diagrams, analytical reporting, kanban methodology, and differences between brd and srs.', 'duration': 545.575, 'highlights': ["Pareto analysis helps in prioritizing decisions, with 82% of the project's benefit arising from 20% of the work. Pareto analysis prioritizes decisions, with 82% of the project's benefit arising from 20% of the work.", 'Sprint burndown is a critical agile metric used to track work completion and is popular in Scrum setups. Sprint burndown is a critical agile metric used to track work completion and is popular in Scrum setups.', 'The Moscow technique and the $100 method are used for requirement prioritization, enabling stakeholders to allocate values to requirements based on their importance. The Moscow technique and the $100 method are used for requirement prioritization, enabling stakeholders to allocate values to requirements based on their importance.', 'BPMN (Business Process Model and Notation) is a flow chart technique with essential elements including flow objects, events, activities, gateways, connecting objects, sequence, messages, associations, swim lanes, pool or lane artifacts, data, object group, and annotation. BPMN (Business Process Model and Notation) is a flow chart technique with essential elements including flow objects, events, activities, gateways, connecting objects, sequence, messages, associations, swim lanes, pool or lane artifacts, data, object group, and annotation.', 'Elicitation techniques include interviews, document analysis, focus group, prototyping, brainstorming, observations, workshops, interface analysis, and questionnaire and survey. Elicitation techniques include interviews, document analysis, focus group, prototyping, brainstorming, observations, workshops, interface analysis, and questionnaire and survey.', 'Key documents needed by a business analyst include initiation document, project vision document, use cases, system requirements, specifications document, business requirement document, requirements traceability matrix, functional requirement document, use case specifications document, and gap analysis document. Key documents needed by a business analyst include initiation document, project vision document, use cases, system requirements, specifications document, business requirement document, requirements traceability matrix, functional requirement document, use case specifications document, and gap analysis document.']}, {'end': 6733.254, 'start': 6463.235, 'title': 'Comparison of v model and fish model', 'summary': 'Explains the differences between the v model and the fish model, highlighting their sequential processes, multiple verification teams, time consumption, and costs. it also provides guidance on creating pivot tables, using advanced filters in excel, and generating visualizations in tableau.', 'duration': 270.019, 'highlights': ["The V model and FISH model are compared, emphasizing the V model's sequential processes and lower time and cost consumption, and the FISH model's multiple verification teams, higher time consumption, and costs.", 'Guidance is given on creating pivot tables in Excel by dragging regions and countries onto rows, placing revenue under values, and filtering the top 10 countries, as well as using advanced filter options to find countries with low fruit sales.', 'Instructions are provided on creating a pivot table to identify countries with the lowest profit, and generating a field map in Tableau to analyze revenue and profit from beverages in North America.', 'The process of displaying top and bottom items based on profit in Tableau is outlined, along with a note on the importance of proficiency in tools like Tableau for business analysts targeting companies using R or Python.']}], 'duration': 1095.808, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UBVzucVpG7k/pics/UBVzucVpG7k5637446.jpg', 'highlights': ['Import text file data into MS Excel, create pivot tables to analyze profit, and emphasize the importance of pivot tables in summarizing extensive data.', "Use Pareto analysis for prioritizing decisions, with 82% of the project's benefit arising from 20% of the work.", "Compare the V model's sequential processes and lower time and cost consumption with the FISH model's multiple verification teams, higher time consumption, and costs."]}], 'highlights': ["The program offers Purdue postgraduate program certification, alumni association membership, master classes from Purdue faculties, enrollment in Simply Learn's job assist, 170+ hours of blended learning, 11+ hands-on projects, and industry-related projects like WhatsApp pay and hospital management system for Mayo clinic.", 'The program covers skills such as business analysis, elicitation and collaboration, requirement analysis, planning and monitoring, strategy analysis, dashboarding, wireframing, data visualization, statistical analysis using Excel, SQL database, and others.', 'The essential skills required for a successful business analyst include understanding business objectives and problem-solving.', 'The knowledge areas of business analysis, including planning and monitoring, elicitation and collaboration, requirements lifecycle management, strategy analysis, requirements analysis and design definition, and solution evaluation, are outlined.', 'Agile methodology involves steps like planning, designing, developing, testing, deploying, and reviewing, and work is broken down into several sprints, leading to faster value delivery and continuous improvement.', 'Scrum methodology empowers small development teams, with roles like the product owner, scrum master, and development team, and includes artifacts such as the product backlog, sprint backlog, and product increment, leading to increased productivity and adaptability to changing requirements.', 'The chapter covers the steps involved in creating a sales dashboard, including adding text, arranging pivot charts, and incorporating slicers and timelines for efficient data filtering and visualization.', 'Companies hiring for business analysts include Indian e-commerce payment system and financial technology company Paytm, American MNC Cognizant, British Dutch multinational oil and gas company Shell, Cisco, Google, Dell, Ernst & Young Global Limited, Oracle, and Barclays.', 'The top business analysis tools and software used by business analysts include Microsoft Excel, Trello, MySQL, Microsoft SQL Server, PostgreSQL, Zira, and Tableau.', 'The average annual salary of a business analyst in the United States is $68,973, while in India it is nearly 6 lakh rupees per annum, according to PayScale.', 'Business analysts identify business goals, understand organization problems, and come up with cost-effective solutions to tackle issues, communicating and working closely with the development team to design solutions.', 'Understanding the differentiation between risk and issue is crucial in business analytics, with risk being a potential problem that can be predicted, and an issue being something that is occurring or about to happen.', 'Risk management involves identifying, avoiding, reducing, assessing, and mitigating risks, leading to decreased losses and optimized decision-making for enhanced organizational performance.', 'Understanding project deliverables is crucial for ensuring clear responsibilities and security around the services and goods delivered.', 'The Agile model is adaptable to requirement changes and has an incremental approach, while the Waterfall model is referred to as a structured software development methodology.', 'Software development lifecycle consists of multiple phases including requirement gathering, coding, operations, maintenance, and documentation, essential for efficient project management.', 'Moscow analysis categorizes requirements as must-have or should-have and evaluates their future usefulness, providing a clear prioritization technique.', "SWOT analysis evaluates a firm's strengths, weaknesses, opportunities, and threats, offering a comprehensive evaluation approach.", "Benchmarking involves evaluating an organization's measures against standard criteria to analyze performance and identify areas of improvement.", 'Approaches for working with difficult stakeholders include listening patiently, responding politely, having one-on-one discussions, and continuously engaging them.', 'Understanding different types of agile methodologies like Scrum, XP, FDD, Crystal, Kanban, and DSDM is crucial for professionals.', 'Gap analysis involves analyzing the differences between existing and targeted systems, indicating the amount of work required to achieve the desired result.', 'Import text file data into MS Excel, create pivot tables to analyze profit, and emphasize the importance of pivot tables in summarizing extensive data.', "Use Pareto analysis for prioritizing decisions, with 82% of the project's benefit arising from 20% of the work.", "Compare the V model's sequential processes and lower time and cost consumption with the FISH model's multiple verification teams, higher time consumption, and costs."]}