MMAAR LEARNCourse details
Technology · all levels

Complete Data Analysis: Beginner to Job-Ready

Master Excel, data cleaning, statistics, SQL, Power BI, Python and business analysis through guided lessons, exercises and portfolio projects.

0.0 ★0 reviews3 learners72.0 hoursEnglish
Created by KARL

About this course

Become a job-ready data analyst through a structured, practical programme designed for beginners. You will learn how to define business questions, collect and clean data, analyse information with Excel, SQL and Python, create interactive Power BI dashboards, apply essential statistics, communicate insights and build a professional portfolio. The course uses realistic African and Cameroonian examples, guided demonstrations, knowledge checks, exercises and capstone projects. Recommended pace: 12 weeks at approximately 6 hours per week. Learners may study more slowly and resume from their saved progress.

Course lessons

1What Is Data Analysis?video · 45 minutes · Preview
2The Role of a Data Analystvideo · 45 minutes · Preview
3Understanding Types of Datavideo · 45 minutes · Preview
4The Data Analysis Processlive · 45 minutes · Preview
5Careers and Opportunities in Data Analysislive · 45 minutes · Preview
6Introduction to Microsoft Excellive · 75 minutes
7Entering and Formatting Data in Excellive · 75 minutes
8Essential Excel Formulas and Functionslive · 75 minutes
9Sorting and Filtering Data in Excellive · 75 minutes
10Data Validation and Conditional Formattinglive · 75 minutes
11Creating Tables and Charts in Excellive · 75 minutes
12PivotTables and PivotCharts in Excellive · 75 minutes
13Practical Excel Data Analysis Projectlive · 180 minutes
14Understanding Data Sourcestext · 60 minutes
15Importing CSV and Excel Fileslive · 60 minutes
16Identifying and Handling Missing Valueslive · 60 minutes
17Removing Duplicate Recordslive · 60 minutes
18Correcting Data Types and Errorslive · 60 minutes
19Handling Outlierslive · 60 minutes
20Preparing Clean Data for Analysislive · 60 minutes
21Data Cleaning Practical Exerciselive · 150 minutes
22Introduction to Descriptive Statisticslive · 60 minutes
23Mean, Median and Modelive · 60 minutes
24Range, Variance and Standard Deviationvideo · 75 minutes
25Percentiles, Quartiles and the Interquartile Rangevideo · 75 minutes
26Understanding Data Distributionsvideo · 75 minutes
27Correlation, Causation and Analytical Cautionvideo · 75 minutes
28Statistics Practical Exercisefile · 180 minutes
29Introduction to Databases and SQLvideo · 60 minutes
30SELECT, FROM, DISTINCT and Aliasesvideo · 75 minutes
31Filtering with WHEREvideo · 75 minutes
32Sorting and Limiting Query Resultsvideo · 60 minutes
33Aggregate Functions and GROUP BYvideo · 90 minutes
34Joining Related Tablesvideo · 105 minutes
35CASE Expressions and Data Cleaning in SQLvideo · 90 minutes
36Subqueries and Common Table Expressionsvideo · 90 minutes
37SQL Business Analysis Projectfile · 240 minutes
38Principles of Effective Data Visualisationvideo · 75 minutes
39Getting Started with Power BI Desktopvideo · 75 minutes
40Power Query for Importing and Cleaningvideo · 105 minutes
41Building a Reliable Data Modelvideo · 105 minutes
42Introduction to DAX Measuresvideo · 120 minutes
43Creating Interactive Reportsvideo · 105 minutes
44Dashboard Design, Storytelling and Accessibilityvideo · 90 minutes
45Power BI Sales Dashboard Projectfile · 300 minutes
46Python and Jupyter Fundamentalsvideo · 105 minutes
47Introduction to NumPyvideo · 90 minutes
48Loading and Inspecting Data with pandasvideo · 105 minutes
49Cleaning Data with pandasvideo · 135 minutes
50Filtering, Sorting and Transforming Datavideo · 105 minutes
51Grouping, Aggregating and Combining DataFramesvideo · 135 minutes
52Visualisation with Matplotlib and Seabornvideo · 120 minutes
53Exploratory Data Analysis Workflowvideo · 150 minutes
54Python Data Analysis Projectfile · 300 minutes
55Translating Business Problems into Analytical Questionsvideo · 90 minutes
56KPIs, Metrics and Target Settingvideo · 90 minutes
57Data Ethics, Privacy and Responsible Analysisvideo · 90 minutes
58Data Quality Assurance and Reconciliationvideo · 90 minutes
59Writing an Analytical Reportvideo · 105 minutes
60Presenting Insights to Stakeholdersvideo · 90 minutes
61Building a Data Analyst Portfoliovideo · 90 minutes
62Preparing for Data Analyst Interviewsvideo · 90 minutes
63Final Capstone: Cameroon Business Performance Analysisfile · 420 minutes
64Final Assessment and Career Action Plantext · 150 minutes

Student reviews

No reviews yet.