83 Data Analyst courses delivered Live Online

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

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

Learn with Case Study - Market Research Course Overview: This course, "Learn with Case Study - Market Research," provides an in-depth understanding of the principles and techniques used in market research. It is designed to equip learners with the knowledge necessary to assess market trends, consumer behaviour, and competitive landscapes effectively. Through the use of real-world case studies, participants will gain valuable insights into the application of market research methodologies in various industries. By the end of the course, learners will be able to conduct research, analyse data, and make informed decisions that drive business strategies and growth. This course is ideal for those seeking to enhance their market research skills and apply them to professional practice. Course Description: In this course, learners will explore the core concepts of market research, including data collection, analysis techniques, and the interpretation of findings. The course integrates case studies to demonstrate how these methods are applied in real-life scenarios across different sectors. Key topics covered include survey design, focus groups, consumer behaviour analysis, and competitor research. Learners will develop the ability to evaluate and synthesise market data to inform strategic business decisions. The course encourages critical thinking, data interpretation, and strategic application, ensuring that learners can effectively utilise market research to support business objectives. By the end of the course, participants will have the skills to execute comprehensive market research projects. Learn with Case Study - Market Research Curriculum: Module 01: Introduction to Market Research Module 02: Data Collection Techniques Module 03: Case Study: Market Research in Action Module 04: Data Analysis and Interpretation Module 05: Consumer Behaviour and Market Segmentation Module 06: Reporting and Presenting Research Findings (See full curriculum) Who is this course for? Individuals seeking to improve their market research skills. Professionals aiming to enhance their strategic decision-making abilities. Beginners with an interest in understanding market dynamics. Those working in marketing, sales, or business strategy roles. Career Path: Market Research Analyst Marketing Manager Business Development Specialist Consumer Insights Analyst Data Analyst

Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course Overview "Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!" is designed for learners who want to enhance their Excel skills in a short period. This course covers the essential formulas that are frequently used in both everyday tasks and professional settings. It provides quick, easy-to-follow insights on the most common Excel functions, enabling you to work more efficiently with data, improve productivity, and gain confidence in using Excel’s powerful features. By the end of this course, you will have a comprehensive understanding of 50 key Excel formulas and be able to apply them confidently across various tasks and scenarios. Course Description In this course, learners will be introduced to 50 of the most widely used Microsoft Excel formulas, including basic functions like SUM and AVERAGE, as well as more advanced formulas such as VLOOKUP, IF statements, and pivot table formulas. Each formula is explained with clear examples, offering learners a straightforward approach to improving their Excel proficiency. Whether you are managing data, performing financial analysis, or generating reports, these formulas will significantly enhance your ability to complete tasks faster and more effectively. With a focus on learning key formulas, this course provides an excellent foundation for anyone looking to optimise their Excel skills in a time-efficient way. Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Curriculum Module 01: Introduction to Excel Formulas Module 02: Basic Mathematical Formulas Module 03: Logical Functions and Conditions Module 04: Lookup and Reference Functions Module 05: Text and Date Functions Module 06: Statistical Functions and Analysis Module 07: Advanced Excel Formulas Module 08: Using Formulas for Data Validation and Error Checking Module 09: Formulas for Financial Modelling Module 10: Troubleshooting and Optimising Formulas (See full curriculum) Who is this course for? Individuals seeking to enhance their Excel capabilities. Professionals aiming to improve data management and analysis skills. Beginners with an interest in improving their productivity with Excel. Anyone wanting to quickly learn the key Excel formulas used in daily tasks. Career Path Data Analyst Financial Analyst Project Manager Business Analyst Office Administrator Operations Manager IT Support Specialist

Microsoft Power BI Training Course Overview: The Microsoft Power BI Training course is designed to equip learners with the knowledge and skills to use Power BI effectively for data analysis and reporting. This course covers the core features of Power BI, from data import and transformation to the creation of reports and visualizations. Learners will explore how to analyse data, generate insights, and create dynamic dashboards for reporting purposes. Whether you are looking to improve your analytical skills or advance your career, this course provides the foundation needed to become proficient in using Power BI for various data analysis tasks. By the end of the course, learners will be able to handle large data sets, create compelling visual reports, and make data-driven decisions. Course Description: This comprehensive Microsoft Power BI course delves into the essential components of the Power BI platform. Learners will start by exploring how to import and work with data, before progressing to designing reports and visualizations. The course includes an in-depth look at the various types of visualizations available, enabling learners to display data in an intuitive, easy-to-understand format. Additionally, learners will explore the Power BI Web App to access and share their reports online. As they move through the course, participants will gain valuable skills in data transformation, reporting, and visualization, all of which are applicable to industries requiring data-driven decision-making. By completing this course, learners will have a solid understanding of Power BI and the ability to create impactful reports and dashboards for business or personal use. Microsoft Power BI Training Curriculum: Module 01: Getting Started Module 02: Working with Data Module 03: Working with Reports and Visualizations Module 04: A Closer Look at Visualizations Module 05: Introduction to the Power BI Web App (See full curriculum) Who is this course for? Individuals seeking to understand Power BI and data analysis. Professionals aiming to enhance their data reporting skills. Beginners with an interest in business intelligence and data analytics. Anyone looking to improve their ability to visualise data for better decision-making. Career Path: Data Analyst Business Intelligence Analyst Reporting Specialist Data Visualisation Specialist Business Analyst

Develop Big Data Pipelines with R, Sparklyr & Power BI Course Overview: This course offers a comprehensive exploration of building and managing big data pipelines using R, Sparklyr, and Power BI. Learners will gain valuable insight into the entire process, from setting up and installing the necessary tools to creating effective ETL pipelines, implementing machine learning techniques, and visualising data with Power BI. The course is designed to provide a strong foundation in data engineering, enabling learners to handle large datasets, optimise data workflows, and communicate insights clearly using visual tools. By the end of this course, learners will have the expertise to work with big data, manage ETL pipelines, and use Sparklyr and Power BI to drive data-driven decisions in various professional settings. Course Description: This course delves into the core concepts and techniques for managing big data using R, Sparklyr, and Power BI. It covers a range of topics including the setup and installation of necessary tools, building ETL pipelines with Sparklyr, applying machine learning models to big data, and using Power BI for creating powerful visualisations. Learners will explore how to extract, transform, and load large datasets, and will develop a strong understanding of big data architecture. They will also gain proficiency in visualising complex data and presenting findings effectively. The course is structured to enhance learners' problem-solving abilities and their competence in big data environments, equipping them with the skills needed to manage and interpret vast amounts of information. Develop Big Data Pipelines with R, Sparklyr & Power BI Curriculum: Module 01: Introduction Module 02: Setup and Installations Module 03: Building the Big Data ETL Pipeline with Sparklyr Module 04: Big Data Machine Learning with Sparklyr Module 05: Data Visualisation with Power BI (See full curriculum) Who is this course for? Individuals seeking to understand big data pipelines. Professionals aiming to expand their data engineering skills. Beginners with an interest in data analytics and big data tools. Anyone looking to enhance their ability to analyse and visualise data. Career Path: Data Engineer Data Analyst Data Scientist Business Intelligence Analyst Machine Learning Engineer Big Data Consultant

Create Animations Using Flourish Studio Course Overview "Create Animations Using Flourish Studio" is designed to teach learners how to create dynamic, engaging animations using Flourish Studio, a powerful visualisation tool. This course covers everything from understanding the interface to building complex, interactive visualisations that can bring data to life. Through step-by-step instructions, learners will develop the skills necessary to enhance presentations, reports, and projects with professional-quality animations. By the end of the course, participants will be able to confidently use Flourish Studio to create visually compelling animations that are tailored to their specific data and narrative needs. This course is suitable for those looking to boost their visual communication skills and make an impact in data presentation. Course Description This course delves into the various capabilities of Flourish Studio, focusing on both its basic and advanced features. Learners will start by exploring the interface and learning how to work with different templates. The course then covers key areas such as importing and managing data, creating animations, and customising visualisations from scratch. In addition to mastering specific templates, participants will also learn how to craft a compelling data story and explore Flourish's other unique features. By the end of the course, learners will have the knowledge and skills to create engaging animations that effectively communicate data insights. Resources and tips for continued development will also be provided, ensuring that learners can keep building on their newfound expertise. Create Animations Using Flourish Studio Curriculum Module 01: Introduction to Flourish Studio Module 02: Getting Started with Flourish Module 03: Adding and Managing Data in Flourish Templates Module 04: Creating Visualisations in Flourish Studio from Scratch Module 05: More Visualisation Templates in Flourish Studio Module 06: Creating a Story and Other Options Module 07: Other Exciting and Important Features Module 08: Data Visualisation Tips & Resources Module 09: Congratulations (See full curriculum) Who is this course for? Individuals seeking to enhance their data presentation skills. Professionals aiming to improve their visual communication abilities. Beginners with an interest in data visualisation or animation. Anyone involved in creating impactful presentations or reports. Career Path Data Visualisation Specialist Marketing Analyst Data Storyteller Presentation Designer Business Intelligence Analyst Marketing Manager Data Analyst

Course Overview The Financial Engineering Courses – 8 Courses Bundle is a comprehensive training package designed to equip learners with a robust understanding of the mathematical, statistical, and analytical foundations of modern finance. This bundle merges core financial theories with quantitative models to support strategic financial decision-making. Learners will explore concepts ranging from derivatives pricing and risk modelling to portfolio optimisation and stochastic processes, gaining a solid foundation in the methodologies used in financial institutions and investment firms. By the end of the course, participants will be able to interpret financial models, assess risk frameworks, and contribute effectively to quantitative analysis roles. This course is particularly valuable for those aiming to strengthen their understanding of finance through an analytical lens, aligning with roles in investment banking, financial consultancy, or quantitative research. Course Description This course bundle offers eight interconnected modules covering a wide array of financial engineering topics. Learners will be introduced to financial mathematics, stochastic calculus, fixed income securities, options pricing, quantitative risk management, and algorithmic trading strategies. The programme provides an in-depth look into the mechanics of financial markets and the computational tools that underpin asset valuation and portfolio structuring. Through clear instruction and structured content, learners will build confidence in applying quantitative techniques and economic theory to real-world financial challenges. Emphasis is placed on theoretical rigour, analytical accuracy, and strategic application. Ideal for learners with a background or interest in finance, mathematics, or economics, this course supports a deeper understanding of financial markets and prepares participants for roles that require data-driven financial modelling and risk assessment skills. Course Modules Module 01: Introduction to Financial Engineering Module 02: Financial Mathematics and Modelling Techniques Module 03: Fixed Income Securities and Yield Curves Module 04: Derivatives and Options Pricing Theory Module 05: Quantitative Risk Management Fundamentals Module 06: Stochastic Processes in Finance Module 07: Portfolio Theory and Investment Analysis Module 08: Algorithmic and Computational Finance (See full curriculum) Bundle Instructions Access all eight courses through a single enrolment. Courses are self-paced and available online 24/7. Learners receive a certificate for each completed module. Support is available throughout the learning journey. Who is this course for? Individuals seeking to build a strong foundation in quantitative finance. Professionals aiming to advance their knowledge in financial modelling and analysis. Beginners with an interest in finance, mathematics, or data-driven investment theory. Graduates or career changers targeting roles in banking, analytics, or asset management. Career Path Quantitative Analyst Financial Risk Manager Investment Banking Analyst Asset or Portfolio Manager Financial Modelling Consultant Data Analyst in Financial Services Derivatives Pricing Specialist Economic Research Associate

ChatGPT Masterclass: A Complete ChatGPT Zero to Hero! Course Overview The ChatGPT Masterclass: A Complete ChatGPT Zero to Hero! course is designed to guide learners from basic understanding to advanced proficiency in using ChatGPT. This course covers a wide range of topics, from the fundamentals of ChatGPT to its integration for business scaling and its applications in specific industries like Excel professionals and students. By the end of the course, learners will have a comprehensive understanding of ChatGPT’s capabilities, how to leverage its potential for various tasks, and how to improve productivity and creativity using this powerful tool. Whether you are looking to enhance your business, excel in academic pursuits, or integrate AI into your work, this course provides the knowledge and skills necessary to succeed. Course Description This course offers an in-depth exploration of ChatGPT, covering its fundamental features and uses across different sectors. Learners will be introduced to ChatGPT’s functionalities, followed by more specialised modules, including its applications for developers, students, and professionals working with Excel. Participants will gain valuable insights into how ChatGPT can be used to automate tasks, enhance business operations, and create innovative content. They will also explore the integration of Dall-E 2 for generating graphic art and the best tools and extensions to improve ChatGPT's functionality. The course is structured to ensure learners gain a clear understanding of how to effectively use ChatGPT for various personal and professional goals. ChatGPT Masterclass: A Complete ChatGPT Zero to Hero! Curriculum Module 01: Getting Started Module 02: ChatGPT – Basic Module 03: ChatGPT for Developers Module 04: Build, and Scale your Business Using ChatGPT Module 05: ChatGPT for Students Module 06: The Power of ChatGPT Module 07: ChatGPT for Excel professionals Module 08: Generate Incredible Graphic Art with Dall-E 2 Module 09: The Best Tools and Extensions using ChatGPT (See full curriculum) Who is this course for? Individuals seeking to improve productivity through AI. Professionals aiming to leverage ChatGPT for business growth. Beginners with an interest in learning AI technologies. Developers looking to integrate ChatGPT into applications. Students seeking to optimise learning and research tasks. Career Path AI Integration Specialist Business Automation Expert Developer specialising in AI tools Digital Content Creator Data Analyst using AI tools Academic Support Professional Graphic Designer using AI for art generation

Python Programming: Beginner To Expert Course Overview The "Python Programming: Beginner to Expert" course provides a comprehensive learning journey from the basics of Python to advanced programming techniques. Designed to equip learners with the skills necessary to become proficient Python developers, this course covers a broad range of essential topics, including data types, operators, functions, error handling, and object-oriented programming (OOP). By the end of the course, learners will gain the expertise needed to develop complex applications and tackle real-world problems using Python. The course is ideal for those looking to deepen their understanding of programming and advance their careers in software development, data science, or automation. Course Description This course delves deeply into Python programming, beginning with the fundamentals and progressing to advanced concepts. Learners will explore core programming techniques, including control flow, functions, and error handling, as well as specialized topics such as object-oriented programming (OOP) and libraries like NumPy and Pandas. The course also covers career development topics, such as how to start a career in Python programming. Students will gain a solid understanding of Python’s capabilities and how to apply them across a variety of programming contexts, from scripting to data analysis and more. With its structured modules and clear guidance, learners will finish the course ready to take on more advanced programming projects and pursue roles in the field. Python Programming: Beginner To Expert Curriculum Module 01: Introduction to Python Programming from A-Z Module 02: Getting Familiar with Python Module 03: Basic Data Types Module 04: Python Operators Module 05: Advanced Data Types Module 06: Control Flow Part 1 Module 07: Control Flow Part 2 Module 08: Python Functions Module 09: User Input and Error Handling Module 10: Python Advanced Functions Module 11: Python Scripting and Libraries Module 12: NumPy Module 13: Pandas Module 14: Introduction to OOP Module 15: Advanced OOP Module 16: Starting a Career in Python (See full curriculum) Who is this course for? Individuals seeking to start a career in Python programming. Professionals aiming to enhance their programming skills for career development. Beginners with an interest in software development, data science, or automation. Those looking to expand their programming knowledge in a structured and progressive way. Career Path Python Developer Software Engineer Data Analyst Data Scientist Automation Specialist Web Developer Backend Developer