Beginner

Certificate in Data Analysis

About This Course

Transform raw data into actionable business insights with comprehensive data analysis training. Master the complete data analytics workflow: collection, cleaning, analysis, visualization, and reporting. Learn Excel for data manipulation and pivot tables, SQL for database querying, and Python with Pandas for advanced analysis. Create compelling data visualizations using Tableau-style dashboards, statistical analysis techniques, and predictive modeling basics. Understand key performance indicators (KPIs), A/B testing, and data-driven decision making. Work with real-world datasets from business, healthcare, and finance sectors. This practical course prepares you for data analyst, business intelligence, or market research roles. No advanced math required - just curiosity and attention to detail.

Course Content

Module 1: Why Data Matters and Excel Fundamentals

1.1 Why Data Analysis Matters (Preview)

1.2 Excel Fundamentals and Clean Data Entry

1.3 Organising and Cleaning Your First Dataset

Module 1 Quiz: Data and Excel Basics

Module 2: Formulas for Everyday Analysis

2.1 SUM, AVERAGE and COUNT Functions

2.2 IF and COUNTIF Functions

2.3 Finding Records with VLOOKUP

Module 2 Quiz: Excel Formulas

Module 3: Sorting, Filtering and Pivot Tables

3.1 Sorting and Filtering Data

3.2 Introduction to Pivot Tables

3.3 Practical Data Exploration

Module 3 Quiz: Sorting, Filtering and Pivot Tables

Module 4: Charts and Basic Statistics

4.1 Charts That Tell the Truth

4.2 Mean, Median and Percentages

4.3 Statistics with Maize Yield and Sales Examples

Module 4 Quiz: Charts and Statistics

Module 5: Google Sheets, Power BI and Dashboards

5.1 Google Sheets for Shared Work

5.2 Introduction to Power BI Free Version

5.3 Building a Simple Dashboard

5.4 Presenting Your Findings

Module 5 Quiz: Shared Work and Dashboards

Student Reviews

No reviews yet. Be the first to review!

ZMW 1,500.00

Instructor TBA

Duration 8 weeks

Students 2

Language English