84 Data Analyst courses delivered Live Online

This practitioner-level 4 award encourages individuals in IT and technical roles to explore the many teams, ideas, and functions within an organisation and maximise their contribution. You will achieve this by learning the key concepts and considering behaviour and response in different scenarios.

This award introduces the critical concepts associated with AI and explores its relationship with the systems and processes that make up the digital ecosystem. It explores how AI can empower organisations to utilise Big Data through the use of Business Analysis and Machine Learning, and encourages candidates to consider a future vision of the world that is powered by AI.

This Level 4 practitioner award encourages individuals in or working towards a leadership role (this could be an IT or technical based-role), and you want to demonstrate modern leadership behaviours to nurture a high-performing team, especially during a time of organisational change.

This Level 4 course encourages individuals in digital and technical roles to enhance their skills by exploring different techniques, formats, and tools to communicate and understand the impact of their communication choices.

Excel 2016 Formulas and Functions Course Overview: This course is designed to provide learners with a comprehensive understanding of Excel 2016 formulas and functions. By covering essential tools and techniques, the course enables learners to confidently navigate the Excel environment and utilise formulas for data analysis, calculations, and reporting. With a focus on both fundamental and advanced functions, learners will gain the skills needed to streamline their tasks and improve efficiency in the workplace. The course’s practical value lies in its application across various industries, allowing professionals to enhance their data handling and reporting capabilities, making it an invaluable addition to any skill set. Course Description: The "Excel 2016 Formulas and Functions" course covers the core concepts of using Excel formulas and functions to manage and analyse data. It starts with the basics, such as SUM, AVERAGE, and IF functions, before advancing to more complex tools like VLOOKUP and conditional formatting.Through each module, learners will explore how to use these features to automate calculations, create dynamic reports, and manipulate datasets. The course offers a structured approach to mastering Excel, with clear guidance on how to use each function effectively in a business context. Learners will come away with the knowledge to work more efficiently in Excel, enabling them to make informed data-driven decisions and enhance productivity. Excel 2016 Formulas and Functions Curriculum: Module 01: Getting Started with Microsoft Excel 2016 Module 02: Basic Formulas and Functions Module 03: Formulas and Functions Activities (See full curriculum) Who is this course for? Individuals seeking to improve their Excel skills Professionals aiming to enhance their data analysis capabilities Beginners with an interest in data management and analysis Any other individuals looking to gain proficiency in Excel Career Path: Data Analyst Administrative Assistant Financial Analyst Business Analyst Project Coordinator

Javascript for Data Structures Course Overview This course, JavaScript for Data Structures, offers a comprehensive introduction to fundamental data structures using JavaScript. Learners will explore core concepts such as lists, stacks, queues, and sets, gaining a solid understanding of how data is organised and managed in programming. The course emphasises clear, logical thinking and problem-solving skills applicable to software development, data analysis, and computer science. By the end, participants will be able to implement key data structures effectively, enhancing their coding proficiency and preparing them for more advanced programming challenges or career opportunities in technology-related fields. Course Description This course delves into essential data structures within JavaScript, providing detailed coverage of lists, stacks, queues, and sets. Learners will study how these structures operate, their use cases, and how to manipulate them efficiently in code. The curriculum is designed to develop both theoretical understanding and coding ability through structured explanations and examples. Throughout the course, students will develop skills in data organisation, algorithmic thinking, and memory management principles. This knowledge is critical for writing optimised code and tackling complex computational problems in software development and data science domains. Javascript for Data Structures Curriculum Module 01: Introduction Module 02: Essential Concepts Module 03: List Data Structure Module 04: Stack Data Structure Module 05: Queue Data Structure Module 06: Set Data Structure Module 07: Final Thought (See full curriculum) Who Is This Course For? Individuals seeking to build strong foundations in data structures using JavaScript. Professionals aiming to enhance their software development skills. Beginners with an interest in programming and computer science. Students preparing for technical roles in coding or data analysis. Career Path Software Developer Front-End Developer Data Analyst Junior Programmer Computer Science Student

Course Overview Delve into the dynamic world of weather and atmospheric sciences with this comprehensive Meteorology course. Whether you’re fascinated by weather patterns, climate systems, or the forces that shape our environment, this course offers a structured pathway to understanding the core principles of meteorology. Learners will explore atmospheric structures, cloud formation, precipitation processes, and major environmental challenges such as global warming and natural hazards. Designed to build both foundational knowledge and contextual awareness, the course helps learners appreciate the scientific mechanisms behind weather forecasts and climate behaviour. Upon completion, students will be well-prepared to engage in further academic studies or pursue roles that require a strong understanding of environmental and climatic phenomena. Course Description This Meteorology course introduces the scientific study of the atmosphere and its processes. Through a series of engaging modules, students will examine topics ranging from the composition of the atmosphere and cloud dynamics to rainfall systems, weather disturbances, and broader planetary influences. Emphasis is placed on understanding the environmental impact of climate change and how global weather systems interconnect. The course also includes a focus on natural hazards, such as storms and droughts, providing insights into how meteorological science is used to monitor and assess these events. Learners will gain theoretical knowledge supported by real-world examples and case studies, enabling them to interpret weather data and explore long-term climate patterns with confidence. Ideal for aspiring meteorologists or environmental enthusiasts, the course encourages critical thinking and scientific curiosity throughout. Course Modules: Module 01: Introduction to Meteorology Module 02: The Atmosphere Module 03: Clouds and their Development Module 04: Precipitation Module 05: Natural Hazards Module 06: The Solar System Module 07: Climate Change and Global Warming (See full curriculum) Who is this course for? Individuals seeking to understand how weather systems and climate change operate. Professionals aiming to expand their knowledge in environmental science or geography. Beginners with an interest in meteorology, climate studies, or Earth sciences. Educators, researchers, and those working in related academic fields. Career Path Meteorological Assistant Environmental Data Analyst Weather Forecaster Support Staff Academic Research Assistant in Climate Studies Climate Policy Advisor Public Sector Environmental Analyst

Course Overview This comprehensive course on "Data Analysis and Forecasting in Excel" provides learners with essential skills to manage, analyse, and visualise data effectively using Excel. Whether you are analysing historical data or forecasting future trends, this course covers key tools such as PivotTables, charts, and lookup functions to make your data work for you. Learners will also gain proficiency in automating tasks and creating dynamic reports, which are invaluable for decision-making processes in various professional settings. By the end of the course, you will have the capability to work with complex data sets, produce insightful reports, and apply forecasting techniques to guide future strategies. Course Description In this course, learners will delve into the full spectrum of data analysis capabilities offered by Excel. Topics include modifying worksheets, working with lists, and using advanced tools such as PivotTables, PivotCharts, and lookup functions. Learners will explore the process of visualising data through charts and sparklines, allowing them to convey complex information in an accessible manner. The course also covers automating workbook functionality and creating mapping data for better analysis. Additionally, learners will gain expertise in forecasting data trends to support strategic planning. By the end of the course, participants will have developed a comprehensive understanding of Excel’s analytical tools, enabling them to manage data with efficiency and precision in various business contexts. Course Modules Module 01: Modifying a Worksheet Module 02: Working with Lists Module 03: Analyzing Data Module 04: Visualizing Data with Charts Module 05: Using PivotTables and PivotCharts Module 06: Working with Multiple Worksheets and Workbooks Module 07: Using Lookup Functions and Formula Auditing Module 08: Automating Workbook Functionality Module 09: Creating Sparklines and Mapping Data Module 10: Forecasting Data (See full curriculum) Who is this course for? Individuals seeking to enhance their Excel data analysis skills. Professionals aiming to improve their forecasting and reporting capabilities. Beginners with an interest in data management and analysis. Those seeking to enhance their proficiency in Excel for career advancement. Career Path Data Analyst Business Analyst Financial Analyst Marketing Analyst Operations Manager Project Manager Excel Specialist in various industries such as finance, marketing, and logistics

Course Overview This comprehensive Data Analytics course provides an in-depth exploration of data analysis, covering the essential principles and techniques used to extract valuable insights from data. Learners will engage with core concepts, such as data mining, statistical analysis, and visualisation, enabling them to make informed decisions and drive business outcomes. By the end of the course, participants will have the skills to analyse and interpret data, apply analytical tools effectively, and present their findings clearly. This course equips learners with the necessary tools to understand and leverage data in various professional settings, adding significant value to their career prospects. Course Description The Data Analytics course covers a wide range of topics, including the fundamentals of data analysis, statistical methods, and various data visualisation techniques. Learners will explore essential tools such as Excel and specialised software, while gaining a deep understanding of how to collect, store, and process data effectively. Emphasis is placed on developing the analytical mindset required to interpret data accurately and draw actionable insights. This course is designed to ensure learners can confidently navigate the world of data analytics and apply their knowledge in diverse industries, enhancing their problem-solving and decision-making abilities. Course Modules Module 01: Introduction to the World of Data Module 02: Basics of Data Analytics Module 03: Statistics for Data Analytics Module 04: Actions Taken in the Data Analysis Process Module 05: Gathering the Right Information Module 06: Storing Data Module 07: Data Mining Module 08: Excel for Data Analytics Module 09: Tools for Data Analytics Module 10: Data-Analytic Thinking Module 11: Data Visualisation That Clearly Describes Insights Module 12: Data Visualisation Tools (See full curriculum) Who is this course for? Individuals seeking to enhance their analytical skills for data-driven decision-making. Professionals aiming to transition into data analytics or enhance their data-related roles. Beginners with an interest in understanding data and its applications across industries. Business professionals seeking to leverage data for strategic growth. Career Path Data Analyst Business Intelligence Analyst Data Scientist Market Research Analyst Operations Analyst Financial Analyst Business Analyst Data Visualisation Specialist

Course Overview The "Microsoft Excel Complete Course" is designed to equip learners with the essential skills to master Microsoft Excel, one of the most widely used tools in data analysis and business operations. This course covers a comprehensive range of topics, including Excel's new features, formula creation, data visualisation, and workbook management. It offers practical knowledge that will help learners work more efficiently, whether they are managing large datasets, analysing trends, or presenting information. By the end of this course, learners will be confident in using Excel for various business tasks, gaining a strong foundation for further professional development. Course Description This course covers all key aspects of Microsoft Excel, from the basics to advanced techniques. Learners will explore Excel’s new features in the 2019 version, as well as how to perform calculations, modify worksheets, and apply formatting. The course delves into functions, lists, and data analysis tools, including PivotTables and charts. Learners will also learn how to work with multiple worksheets and workbooks, use lookup functions, and automate workbook functionality. With a focus on essential Excel tools and techniques, learners will gain the ability to efficiently manage and analyse data for business or personal use. Course Modules Module 01: Microsoft Excel 2019 New Features Module 02: Getting Started with Microsoft Office Excel Module 03: Performing Calculations Module 04: Modifying a Worksheet Module 05: Formatting a Worksheet Module 06: Printing Workbooks Module 07: Managing Workbooks Module 08: Working with Functions Module 09: Working with Lists Module 10: Analyzing Data Module 11: Visualizing Data with Charts Module 12: Using PivotTables and PivotCharts Module 13: Working with Multiple Worksheets and Workbooks Module 14: Using Lookup Functions and Formula Auditing Module 15: Sharing and Protecting Workbooks Module 16: Automating Workbook Functionality Module 17: Creating Sparklines and Mapping Data Module 18: Forecasting Data (See full curriculum) Who is this course for? Individuals seeking to improve their data management and analysis skills. Professionals aiming to enhance their productivity in Excel for business applications. Beginners with an interest in data analysis or office administration. Anyone looking to build a strong foundation in Excel for career advancement. Career Path Data Analyst Financial Analyst Office Administrator Project Manager Business Analyst Operations Manager Administrative Assistant HR Specialist