Course Details
Course Details
What You'll Learn
Topic 1 Get Started on Python
Overview of Python
Setup Python
Code Your First Python Script
Topic 2: Data Types
Number
String
List
Tuple
Dictionary
Set
Topic 3 Operators
Arithmetic Operators
Compound Operators
Comparison Operators
Membership Operators
Logical Operators
Topic 4 Control Structure, Loop and Comprehension
Conditional
Loop
Iterating Over Multiple Sequences
Comprehension
Topic 5 Function
Function Syntax
Return Values
Default Arguments
Variable Arguments
Lambda, Map, Filter
Topic 6 Modules & Packages
Import Modules and Packages
Python Standard Packages
Third Party Packages
Topic 7 Finance Data Preparation
Data Analytics with Pandas
Pandas DataFrame and Series
Import and Export Finance Data
Filter and Slice Finance Data
Clean Missing Data
Topic 8 Finance Data Transformation
Create Computed Data Column
Join Finance Data with Concat, Append and Merge
Aggregate Data with Groupby and Pivot Table
Topic 9 Finance Data Visualization
Visualize Time Series Data with Line Plot
Visualize Statistical Relationships with Scatter Plot
Visualize Categorical Data with Bar Plot and Pie Plot
Visualize Variation with Box Plot
Visualize Distribution with Histogram
Topic 10 Finance Data Analysis
Descriptive Statistics
Rolling Window Average Analysis
Covariance and Correlation
Apply
Data Piping
Course Info
Promotion Code
Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.
Minimum Entry Requirement
Knowledge and Skills
- Able to operate using computer functions
- Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)
Attitude
- Positive Learning Attitude
- Enthusiastic Learner
Experience
- Minimum of 1 year of working experience.
This is an intermediate level course. The following prerequisite is assumed
Target Age Group: 18-65 years old
Minimum Software/Hardware Requirement
Software:
- Python 3.x https://www.python.org/downloads/
- Sublime Text 3 https://www.sublimetext.com/3
- Pycharm https://www.jetbrains.com/pycharm/download/
Hardware: Window or Mac Laptops
Job Roles
Job Roles
- Aspiring Software Developer
- Data Analyst
- Web Developer
- Automation Engineer
- Data Scientist
- System Administrator
- Bioinformatics Specialist
- Research Scientist
- Finance Professional
- Machine Learning Enthusiast
- GIS (Geographic Information System) Specialist
- IT Consultant
- Network Engineer
- Database Administrator
- Tech Entrepreneur.
Trainers
Trainers
is an accomplished IT and data specialist with over 20 years of experience in academia, ICT leadership, and professional training, with a strong focus on data analytics and Excel-based solutions. He has developed and delivered specialized training programs on Statistical Data Analysis with Excel and Visual Basic for Applications (VBA) for Excel, equipping learners with advanced data manipulation, automation, and reporting skills. His expertise extends to automating institutional reporting systems, where he successfully streamlined academic records management through Excel-based tools, integrating macros and automation to improve efficiency and accuracy. As a trainer and consultant, Dr. Siraj has taught Excel to diverse audiences, including university staff, administrative teams, and professionals in banking, security, and education, ensuring they can apply Excel for decision-making, statistical modeling, and process automation. His practical mastery of Excel is complemented by his deep knowledge of office automation and ICT project management, making him a highly sought-after trainer in data analysis and productivity tools. With his blend of hands-on technical expertise and instructional experience, Dr. Siraj stands out as a credible authority in leveraging Excel to drive organizational efficiency and data-driven strategies
Review
Customer Reviews (9)
- Exceeded my expectations Review by Course Participant/Trainee
-
The training was very practical and hands-on. I could apply what I learned to my work immediately. (Posted on 12/16/2024)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Practical and relevant Review by Course Participant/Trainee
-
The training was very practical and hands-on. I could apply what I learned to my work immediately. (Posted on 9/11/2024)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Good course materials Review by Course Participant/Trainee
-
Very engaging session. The trainer patiently answered all our questions and gave useful tips. (Posted on 8/15/2024)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Highly recommended Review by Course Participant/Trainee
-
A very practical course. The trainer made a complex topic simple and enjoyable to learn. (Posted on 2/4/2024)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment
Write Your Own Review
- Recommended Courses