Python for Data Analytics, Engineering & AI
Offered by
Benaadir Research, Consultancy & Evaluation Center (BRCE)
-
LevelAll Levels
-
Duration8 hours
-
Last Updated09/01/2026
-
CertificateCertificate of completion
Course Description
The Python For Data Analytics,Engineering and AI course is a beginner-friendly, practical program designed to build essential Python skills for Data Analytics, Data Science, and Data Engineering. The course progresses from Python fundamentals, file handling, and data manipulation with pandas to exploratory data analysis, data visualization, APIs, SQL integration, ETL processes, feature engineering, machine learning, and AI automation. Participants will develop practical skills through live coding, guided exercises, real-world datasets, weekly assignments, and portfolio projects. By the end of the course, learners will be able to clean and analyse data, create visual reports, build basic data pipelines and machine-learning models, automate selected tasks, and present their work through a professional portfolio and final capstone project.
Why you should take this Course?
This course helps you learn Python from the beginner level and develop practical skills in data cleaning, analysis, visualisation, and automation.
You will gain hands-on experience working with real-world datasets, Excel, CSV, APIs, SQL, ETL processes, machine learning, and AI-powered applications.
By completing practical assignments, portfolio projects, and a final capstone project, you will be better prepared for entry-level careers in Data Analytics, Data Science, and Data Engineering.
Who Is This Course For?
- Beginners with no previous programming experience.
- University students and recent graduates interested in data careers.
- Business analysts who want to automate data analysis using Python.
- Junior data analysts who want to strengthen their Python skills.
- Professionals working with Excel who want to move to advanced data analysis.
- Individuals preparing for careers in Data Analytics, Data Science, or Data Engineering.
Course Curriculum
Module 1: Python Environment and Foundations
-
Lesson 1.1 Google Colab, Jupyter Notebook, and Visual Studio Code
13:34 -
Lesson 1.2 Variables and Data Types
08:08 -
Lesson 1.3 Python Operators
08:56 -
Lesson 1.4 Input and output
09:47 -
Lesson 1.5 Python Coding Standards
12:32
Module 2: Data Structures, Control Flow and Functions
-
2.1 Lists, Tuples, Dictionaries, and Sets
17:03 -
2.2 Conditions and Loops
14:23 -
2.3 Functions
09:53 -
2.4 Modules and Packages
11:58 -
2.5 Basic Debugging
06:06
Module 3: File Handling, Errors and NumPy
-
3.1 Working with text, CSV, Excel, and JSON files
28:14 -
3.2 Handling errors using try, except, else, and finally
10:06 -
3.3 Managing file paths, folders, and directories
09:49 -
3.4 Using NumPy arrays and vectorised operations
10:14
Module 4: Data Cleaning and Transformation with pandas
-
Section files
-
4.1 Importing Data
08:02 -
4.2 Handling Missing Values
08:46 -
4.3 Identifying and Removing Duplicates
08:11 -
4.4 Managing Data Types
16:36 -
4.5 String and Date Cleaning
11:22 -
4.6 Merging and Reshaping Data
12:08
Module 5: SQL and Database Integration
-
Section files
-
5.1 SQL Queries
14:50 -
5.2 Joins and Aggregations
05:23 -
5.3 SQLite and MySQL
13:07
Module 6: Statistics and Exploratory Data Analysis
-
Section files
-
6.1 Descriptive Statistics
13:28 -
6.2 Statistical Distributions
09:44 -
6.3 Correlation Analysis
09:52 -
6.4 Outlier Detection and Treatment
11:16 -
6.5 Business Key Performance Indicators (KPIs)
06:35
Module 7: Data Visualization and Storytelling
-
Section files
-
7.1 Data Visualization with Matplotlib
19:07 -
7.2 Data Visualization with Seaborn and Plotly
09:39 -
7.3 Selecting the Appropriate Chart
05:00 -
7.4 Dashboard Design Principles
05:43 -
7.5 Communicating Data Findings and Insights
07:01
Module 8: APIs, Automation and Data Collection
-
8.1 HTTP Requests
10:51 -
8.2 Working with JSON Data
10:07 -
8.3 API Authentication
10:23 -
8.4 Handling API Pagination
08:52 -
8.5 Scheduling Automated Data Extraction
07:33
Module 9: Data Engineering and ETL Foundations
-
Section files
-
9.1 ETL and ELT Processes
12:28 -
9.2 Databases and Database Schemas
11:29 -
9.3 Data Validation and Quality Checks
08:07 -
9.4 Logging and Error Tracking
09:40 -
9.5 Pipeline Scheduling and Automation
11:01
Module 10: Machine Learning Foundations
-
Section files
-
10.1 Data Preprocessing
15:44 -
10.2 Regression Models
16:36 -
10.3 Classification Models
16:18 -
10.4 Clustering Techniques
10:18 -
10.5 Model Evaluation
14:10
Student Ratings & Reviews
About the instructors
Offered by
BRCE waa xarun ka shaqaysa horu marinta iyo barashada arimaha la xariira xirfadaha Casriga ah oo ku salaysan Technology-ga.