● What is the role of the data analyst? ● What is the difference between data analyst, business analyst and data scientist? ● How does the data analyst serve the organization? ● Break down problems into bite-sized chunks ● What is data, types of data and why is it important ● The history of data. Data and the Internet ● How to create the right questions ● Structured thinking through case studies and problem statement worksheets ● Problem Solving Framework and Processes such as the HDEIP Framework ● Issue Trees, Hypotheses Trees, and Value Driver Trees

● Use Excel to create a default financial analysis module covering revenue and operational cost modelling ● Financial concepts including revenue, cost of goods sold, profit, balance sheets, cash flow statements, income statements and EBIT ● Statistical concepts including descriptive statistics (mean, mode, standard deviation, correlations etc.), correlations, simple and multivariate regression, confidence intervals

● SQL ● Writing queries ● Best practices in writing queries ● DA/BA tools ● Introduction to structured and unstructured Databases ● Introduction to set theory ● Case studies and hands-on exercises in writing SQL with real data

● Visualization tools: Tableau or/and PowerBi ● GIS ● Creating presentations with Powerpoint ● Using tools like Canva for simplicity ● Effective communication strategies, formats, and templates Presentations to technical and non-technical stakeholders ● Writing skills ● Presentation skills ● Design 101

● Owns personal goal setting ● Understands and uses metrics such as velocity and ticket completion to improve performance ● Business etiquette

● Documents rigorously and regularly ● Shares pertinent information with peers and team members ● Presentations/Public Speaking ● Translating data into stories and business cases ● Running meetings ● Doing presentations ● Managing time in meetings ● Professional discussion and handling conflict/difficult conversations

Focusing Lens(es) 1. Fundamentals 2. Vocabulary 3. Context Areas of Study 1. Fundamentals of data analysis 2. Data analysis process 3. Excel and SQL 4. Tableau Content Designed for apprentices with a variety of professional backgrounds and experience levels — including beginners — this course takes a deep dive into the data analytics process: collection, cleaning, analysis, and visualization. They will receive hands-on experience with Excel, SQL, and Tableau, and be able to transform raw data into a critical decision-making tool. Concepts What is data analysis, the data collection and analysis process, transforming unstructured data into tangible deliverables Unit/courses: Intro to Data Analytics Provider/Format: Udemy/Online Hours: 1.5 Location: https://www.udemy.com/course/learndata/ Unit/courses: Principles of Security Provider/Format: Udemy/Online Hours: 2 Location: https://www.udemy.com/course/information-security-concepts-and-secure-design-principles/ Unit/courses: Statistics for Data Science Provider/Format: Udemy/Online Hours: 11.5 Location: https://www.udemy.com/course/statistics-for-data-science-data-analytics/

Focusing Lens(es) 1. Day-to-day skills 2. Technical tools 3. Industry environment 4. Professional behavior 5. Collaboration and productivity 6. Goal setting, goal achieving Areas of Study 1. Data mining and wrangling 2. Python libraries, dashboards, data visualization 3. Data manipulation and analytical techniques 4. Data ethics and presentation skills Content The apprentice will power their data analyst career by learning the core principles of data analysis and gaining hands-on skills practice. They will work with a variety of data sources, project scenarios, and data analysis tools, including Excel, SQL, Python, Jupyter Notebooks, and Cognos Analytics, gaining practical experience with data manipulation, and applying analytical techniques. Through a mix of videos, assessments, and hands-on labs, the apprentice will be introduced to analysis tools and platforms and key analytical skills required for an entry-level job. Concepts Data manipulation, information management, working with different types of databases, the day-to-day work of data analysts Unit/courses: Tableau Comprehensive Provider/Format: Udemy/Online Hours: 24.5 Location: https://www.udemy.com/course/tableau-for-beginners/ Unit/courses: Excel Basic to advanced Provider/Format: Udemy/Online Hours: 18 Location: https://www.udemy.com/course/microsoft-excel-013-from-beginner-to-advanced-and-beyond/ Unit/courses: Excel Pivot Tables Provider/Format: Udemy/Online Hours: 6.5 Location: https://www.udemy.com/course/data-analysis-with-excel-pivot-tables/ Unit/courses: Data Visualization with Excel Provider/Format: Udemy/Online Hours: 4.5 Location: https://www.udemy.com/course/advanced-excel-charts-graphs/ Unit/courses: IBM Cognos Analytics Provider/Format: Udemy/Online Hours: 4.5 Location: https://www.udemy.com/course/complete-ibm-cognos-analytics-cloud-training/ Unit/courses: Python for Data Science and Machine Learning Provider/Format: Udemy/Online Hours: 25 Location: https://www.udemy.com/course/python-for-data-science-and-machine-learning-bootcamp/ Unit/courses: Introduction Microsoft Power BI Provider/Format: Udemy/Online Hours: 6.5 Location: https://www.udemy.com/course/powerful-reports-and-dashboards-with-microsoft-powerbi/ Unit/courses: Data ethics, data privacy, GDPR, CCPA Provider/Format: BuildWithin/Online Hours: 5 Location: In BuildWithin platform Unit/courses: SQL for Data Analytics Provider/Format: Udemy/Online Hours: 8 Location: https://www.udemy.com/course/the-complete-sql-masterclass-for-data-analytics/ Unit/courses: Data-Driven Decision Making Provider/Format: Udemy/Online Hours: 3 Location: https://www.udemy.com/course/data-driven-decision-making-and-leadership/ Unit/courses: Data Analysis with Pandas and Python Provider/Format: Udemy/Online Hours: 20 Location: https://www.udemy.com/course/data-analysis-with- pandas/ Assessments: Practice through OJL, completion of tickets, level of velocity, peer reviews.

Focusing Lens(es) 1. Professional behavior 2. Excellence in communications 3. Collaboration and productivity 4. Goalsetting, goal achieving Areas of Study 1. Communication tools used in the workplace. Slack, Jira, Github and others 2. Values. Mission, vision of the company and how that applies to the day-to-day work 3. Work estimation, completion of tickets, velocity, work quality Content Appearance and behavior. The apprentice will learn about professional Attire and Grooming, Business email writing, Business Etiquette, including Telephone and Mobile Etiquette, Meeting room etiquette and etiquette needed during presentations in the workplace. The apprentice will learn Agile methodology and how to implement it in the day to day. Will also learn to use the routines such as the standups and retrospective to communicate effectively with peers as well as common tools used like Trello, Asana and Jira. Concepts Meeting etiquette. Estimation. Ticketing. Retrospective. Standups. Ticket grooming. Speaking up/sharing. Unit/courses: Agile Fundamentals: Including Scrum and Kanban Provider/Format: Udemy/Online Hours: 4.5 Location: https://www.udemy.com/course/agile-fundamentals-scrum-kanban-scrumban/ Unit/courses: Meeting etiquette Provider/Format: Udemy/Online Hours: 5 Location: https://www.udemy.com/course/the-professional- edge-appearance-and-work-behaviour/Unit/courses: Estimation and completion Provider/Format: Udemy/Online Hours: 2.5 Location: https://www.udemy.com/course/effort-estimation-in-projects-how-to-estimate-and-get-better-every- day/ Unit/courses: Workplace communication and productivity tools(Slack, video conferencing, Jira, Asana, others) Provider/Format: BuildWithin/Online Hours: 7 Location: In BuildWithin platform Unit/courses: Presentation skills and public speaking Provider/Format: BuildWithin/Online Hours: 2 Location: In BuildWithin platform