Skip to main content

Data Analyst

Power Your Future with Our Professional Courses

Creating a transformative educational journey to unlock potential, foster growth, and create a brighter future.
Lessons Preview
Instructors












Data Analyst

Power Your Future with Our Professional Courses

Creating a transformative educational journey to unlock potential, foster growth, and create a brighter future.
Lessons Preview
Instructors








Why This Course.?

At AReL, we offer an enriching Data Analytics course designed to equip our students with the essential skills and knowledge to thrive in today's data-driven world. Through Google comprehensive curriculum, students will delve into the intricacies of data analysis, learning how to collect, process, analyze, and interpret data effectively.Whether you're a beginner looking to kickstart your career in data analytics or a experienced professional seeking to enhance your skills, our course offers something for everyone.Students will gain hands-on experience using industry-standard tools and techniques, allowing them to tackle real-world data challenges with confidence.

Courses Powered With
Google Curriculum

July Intake Ongoing

  • Start Date :

    29th - July - 2025

  • Course Duration:

    6 Months

  • Mode of Learning :

    In Person

  • Physical Address :

    Kakuma 1, Hong Kong ,Next Youth Center 2

  • Registration Fee :

    1000 KSHS 

  • Tuition Fee :

    Free

Apply Now

Why This Course.?

At AReL, we offer an enriching Data Analytics course designed to equip our students with the essential skills and knowledge to thrive in today's data-driven world. Through Google's comprehensive curriculum, students will delve into the intricacies of data analysis, learning how to collect, process, analyze, and interpret data effectively. Whether you're a beginner looking to kickstart your career in data analytics or an experienced professional seeking to enhance your skills, our course offers something for everyone. Students will gain hands-on experience using industry-standard tools and techniques, allowing them to tackle real-world data challenges with confidence.

Courses Powered With
Google Curriculum

Modules To be Covered

Duration

Module 1: Explore

Content & Lessons
  • Orientation & Environment
    Setup
  • Course Overview &
    Expectations
  • Setting Up Work
    Environment (Excel, SQL,
    Python, BI Tools)
  • Data Analytics Lifecycle:
    Collection, Cleaning, Analysis,
    Visualization, Decision-Making
  • Ethical Considerations in
    Data Analytics
  • Soft Skills: Communication,
    Teamwork, Storytelling,
    Problem-Solving

Week 1

Module 2: Excel for Data Analysis

Content & Lessons
  • Understanding Excel’s Interface & Key Features
  • Entering, Editing, and Formatting Data
  • Writing Basic Formulas (SUM, AVERAGE, COUNT, TEXTFunctions)
  • Data Cleaning & Wrangling in Excel
  • Advanced Lookup Functions (VLOOKUP, HLOOKUP, INDEX-MATCH)
  • Introduction to Pivot Tables & Pivot Charts
  • Fundamentals of Data Visualization: Creating Charts & Graphs
  • Introduction to Power Query

Weeks 2-3

Module 3: Querying Data with SQL

Content & Lessons
  • Introduction to Databases & SQL
  • Writing Basic SQL Queries (SELECT, WHERE, ORDER BY)
  • Data Cleaning & Transformation with SQL
  • Data Aggregation (SUM, AVG, COUNT, MIN, MAX)
  • Joins (INNER, LEFT, RIGHT, FULL) & Subqueries
  • Window Functions & Common Table Expressions
    (CTEs)
  • Data Export & Integration
    with Other Tools

Weeks 5-8

Module 4: Data Visualization with Power BI & Tableau

Content & Lessons
  • Introduction to Data Visualization Principles
  • Connecting to Data Sources & Data Cleaning
  • Creating Interactive Dashboards & Reports
  • Power BI DAX Basics
  • Building Interactive Reports in Tableau
  • Advanced Tableau Features (Parameters, Calculated Fields)

Weeks 9-12

Module 5: Python for Data Analysis

Content & Lessons
  • Introduction to Python for Data Analytics
  • Working with Jupyter Notebooks
  • Data Cleaning & Manipulation with Pandas
  • Exploratory Data Analysis (EDA) & Visualization using Matplotlib & Seaborn

Weeks 13-17

Module 6: Introduction to Machine Learning

Content & Lessons
  • Introduction to Machine Learning Concepts
  • Types of Machine Learning: Supervised, Unsupervised
  • ML Tools (Scikit-Learn, AutoML, Power BI AI Insights)

Week 18

Module 7: AI in Data Analysis

Content & Lessons
  • AI in Data Analytics
  • Automating Data Cleaning with AI
  • AI-Powered Data Exploration & Insights
  • AI-Powered Visualization & Reporting

Week 19

Module 8: End-to-End Data Projects & Career Preparation

Content & Lessons
  • Data Collection & Cleaning
  • Exploratory Analysis & Insights
  • Communicating Insights with Stakeholders
  • Version Control & GitHub for Data Analysts
  • Resume & LinkedIn Optimization
  • Mock Interviews & Industry Expert Feedback

Weeks 20-23

Meet The Instructor

World-Class Education from a Dedicated Instructor, Bringing Local Insight and Global Expertise to Your Learning Journey.

Samuel Mati

Instructor

Samuel Mati is an experienced Data Analytics Instructor with a strong background in data analysis, business intelligence, data science, machine learning, and data mining. Passionate about empowering individuals with data-driven skills, he has guided numerous students in mastering tools like Excel, SQL, Python, Power BI, and Tableau to analyze, visualize, and extract insights from data effectively. With extensive expertise in predictive modeling, AI-driven automation, and advanced analytics, As an instructor at Action for Refugee Life (AReL), Samuel is committed to equipping students with the knowledge, tools, and confidence to excel in the evolving data industry.

All Courses >>>
Apply Now