Ripotek Technologies Inc.

Design. Engineer. Deliver.

Calgary, Alberta

www.ripotek.com

training@ripotek.com

Python for Data

Professional Training Program Syllabus

Program Overview

Duration

12 Weeks (Weekend sessions)

24 total sessions, 72 instructional hours

Investment

CAD $700

Flexible payment plans available

Schedule

Saturday/Sunday

10:00 AM - 1:00 PM Mountain Time

Level

Beginner

No prior coding required

Program Description

Learn Python from scratch with a focus on data analytics. This beginner-friendly program covers Python fundamentals, pandas for data manipulation, visualization libraries, and automation techniques.

Build practical skills for data analysis, report automation, and working with APIs. Perfect for aspiring data analysts, business analysts, and anyone looking to add Python to their skillset.

Learning Outcomes

Upon completion, you will be able to:

Write clean, readable Python code

Manipulate data with pandas

Create visualizations with matplotlib/seaborn

Work with files (CSV, Excel, JSON)

Connect to databases with SQL

Automate repetitive tasks

Use APIs for data collection

Perform statistical analysis

Debug and test code

Use Jupyter notebooks

Apply data cleaning techniques

Build data pipelines

12-Week Curriculum

Week 1: Python Basics

Installation and setup
Variables and data types
Operators
Input/output

Week 2: Control Flow

If/else statements
Loops (for, while)
Break and continue
List comprehensions

Week 3: Data Structures

Lists and tuples
Dictionaries and sets
String manipulation
Collections module

Week 4: Functions

Defining functions
Parameters and arguments
Lambda functions
Scope and closures

Week 5: File Operations

Reading/writing files
CSV handling
JSON processing
Excel with openpyxl

Week 6: Pandas Fundamentals

Series and DataFrames
Reading data sources
Data inspection
Basic operations

Week 7: Data Manipulation

Filtering and sorting
GroupBy operations
Merging and joining
Reshaping data

Week 8: Data Cleaning

Handling missing values
Data type conversion
Duplicate removal
String operations

Week 9: Visualization

Matplotlib basics
Seaborn for stats
Plotly interactive
Plot customization

Week 10: Working with APIs

HTTP requests
REST APIs
JSON parsing
Authentication

Week 11: Database Connectivity

SQL basics review
SQLite with Python
Pandas and SQL
Query execution

Week 12: Capstone Project

End-to-end analysis
Automation workflow
Presentation
Best practices

Career Pathways

Typical Roles:

Data Analyst
Business Analyst
Junior Data Scientist
Analytics Engineer
Reporting Specialist

$55K+

Average Starting Salary

Perfect foundation for advanced programs like Power BI or Azure Data Engineer