Certified Ekasi Data Analysis Specialist

Certified Ekasi Data Analysis Specialist
Technology and Data Intermediate

Certified Ekasi Data Analysis Specialist

This course provides hands-on skills in data manipulation, visualization, and interpretation using popular tools. Learn to clean data, perform statistical analysis, and create dashboards that tell a compelling story.

Course Description

This course provides hands-on skills in data manipulation, visualization, and interpretation using popular tools. Learn to clean data, perform statistical analysis, and create dashboards that tell a compelling story.

Learning Outcomes

Ability to import, clean, and transform datasets|Skills to create insightful data visualizations and dashboards|Competence in performing descriptive statistical analysis|Proficiency in using tools like Excel, SQL, and/or Python for analysis

Target Audience

Business analysts|Marketing analysts|Aspiring data scientists|Anyone who works with data

8 Modules
0 Lessons
19h 30m

The data analysis process, types of analytics (descriptive, diagnostic, predictive, prescriptive), data sources, and the role of a data analyst.

No lessons in this module yet.

Methods of data collection, understanding data types (structured, semi-structured, unstructured), data quality dimensions, and data cleaning fundamentals.

No lessons in this module yet.

Advanced Excel functions (VLOOKUP, INDEX/MATCH, SUMIFS), pivot tables, data validation, Power Query for data transformation, and building dynamic dashboards.

No lessons in this module yet.

Querying databases with SQL (SELECT, WHERE, GROUP BY, JOIN, subqueries), filtering and aggregating data, and using SQL to answer business questions.

No lessons in this module yet.

Choosing the right chart type, principles of visual design for data, colour and typography in charts, and storytelling with data.

No lessons in this module yet.

Connecting to data sources, building interactive dashboards, creating calculated fields and measures, and sharing reports with stakeholders.

No lessons in this module yet.

Python basics, pandas for data manipulation, matplotlib/seaborn for visualisation, and completing an end-to-end data analysis project in a Jupyter Notebook.

No lessons in this module yet.

Descriptive statistics, distributions, hypothesis testing, correlation, and regression analysis. Interpreting statistical results for business decisions.

No lessons in this module yet.

Vocational Training Course
Certificate included
50 hours content
Downloadable resources
Mobile access
Practical skills guarantee

Course Details

Duration 50 hours
Skill Level Intermediate
Learning Method Self Study
Category Technology and Data
Modules 8
Total Lessons 0
Last Updated August 2025
Ekasi Assistant
Online
Hi there! 👋 I'm the Ekasi Courses assistant. How can I help you with our courses today?