Learn applied data analysis from scratch including descriptive statistics and using the powerful tools in Power BI and Excel, from the experts at Cloudswyft.

3-5 hrs per week

Approx 14 weeks

Certificates

Find out more

100% online

How it works

Cost

Find out more

Level

See requirements

  • Course 1

    Microsoft Excel: Advanced Data Analysis and Visualisation

    Develop your data science skills as you learn how to import, manipulate, analyse, and visualise data in Excel.

    3 weeks

    5 hours per week

    • Week 1

      Course Introduction
      • About the Course
      • Data Analysis in Excel
      • CloudSwyft Hands-On Labs
      • Data Models and DAX in Excel
      • CloudSwyft Hands-On Labs
      • Wrapping up the Week

    • Week 2

      Importing Data into the Excel Data Model
      • Importing Data: CSV Files
      • CloudSwyft Hands-On Labs
      • Importing Data: Databases and Multiple Files
      • Importing Data: Excel Reports
      • CloudSwyft Hands-On Lab
      • Wrapping Up the Week

    • Week 3

      Data Analysis and Visualisation with Excel and Power BI
      • The DAX Language
      • CloudSwyft Hands-On Labs
      • Visualising Data in Excel
      • CloudSwyft Hands-On Labs
      • Power BI
      • Wrapping Up the Course

  • Course 2

    Statistics and Data Analysis in Excel

    Learn the essential concepts of statistics and basic probability using Excel to discover the powerful tools at your disposal.

    4 tests

    5 weeks

    3 hours per week

    • Week 1

      Descriptive Statistics
      • About the Course
      • Defining Data
      • Histogram and Skewness
      • Descriptive Statistics with Analysis ToolPak
      • What is a Boxplot?
      • Categorical Data, PivotTables, and PivotCharts
      • Summarizing Heirarchal Data
      • 80-20 Rule and Pareto Charts
      • Week 1 Test

    • Week 2

      Basic Probability
      • Introduction to Probability
      • Law of Complements
      • Mutually Exclusive Events and Finding Prob (A or B)
      • Conditional Probability
      • Law of Total Probability and Bayes Rule
      • Basic Probability Review
      • Week 2 Test

    • Week 3

      Random Variables
      • Random Variable Definitions
      • Mean, Variance, and Standard Deviation of a Random Variable
      • Mean, Variance, and Standard Deviation for Sum of Random Variables
      • Binomial Random Variable
      • Poisson Random Variable
      • Normal Random Variable
      • Central Limit Theorem
      • Z Scores
      • Week 3 Test

    • Week 4

      Sampling and Confidence Intervals
      • Populations and Samples
      • Point Estimation of a Population Mean and Proportion
      • The Standard Normal
      • Confidence Interval Estimation
      • Sample Size Determination
      • The Finite Correction Factor
      • Additional Reading
      • Week 4 Quiz

    • Week 5

      Hypothesis Testing
      • Defining Hypotheses
      • Type I and Type II Error
      • One Sample Z-Test
      • One Sample T-Test
      • Single Sample Test for Population Proportion
      • Testing Equality of Variances
      • Testing the Difference Between Two Population Means
      • Chi-Squared Test for Independence
      • Additional Reading
      • Week 5 Quiz
      • Wrapping Up the Course

  • Course 3

    Microsoft Power BI: Advanced Data Analysis and Visualisation

    Master the fundamentals of Power BI and learn how to gather, transform, and visualise data with ease.

    1 test

    4 weeks

    5 hours per week

    • Week 1

      Course Introduction
      • About this Course
      • Power BI Desktop Transformations
      • Further Transformation
      • CloudSwyft Hands-On Labs: Data Transformation
      • Wrapping Up Data Transformation

    • Week 2

      Data Modelling & Dax in Power BI
      • Data Modelling
      • Dax in Power BI

    • Week 3

      Power BI Desktop Visualisations
      • Connecting and Collaborating With Excel
      • Work With Power BI visuals
      • Data-driven story with Power BI reports

    • Week 4

      Power BI Service
      • Work With Key Performance Indicators
      • Mobile App
      • Final Assessments & Wrapping Up the Course

  • Course 4

    Successful Data Analysis for Modern Industries

    Learn the data analysis skills you need to succeed in different and advancing industries, both today and tomorrow.

    2 tests

    2 weeks

    5 hours per week

    • Week 1

      Welcome to the Course
      • About this Course
      • Data Economics and Ecosystems
      • Data Analysis for Business
      • Data Analysis for Education
      • Wrapping Up the Week

    • Week 2

      Data Analysis for Social Good and Careers in Data Analysis
      • Data Analysis in Healthcare
      • Data Analysis for Social Good
      • Careers in Data Analysis
      • Final Assessments & Wrapping Up the Course

More courses you might like

Learners who joined this course have also enjoyed these courses.

©2025  onlincourse.com. All rights reserved