BATCH START DATE
- 26th September 2026
- Start with IT System/Network Support course.
- 23rd September 2026
- Start with Data Analytics
Sydney
- Suite 2, Level 2, 22 George Street
- North Strathfield, NSW, 2137
- Phone: +61 2 8319 8440
Sydney
- Ground Floor, 6 - 10 Geeves Ave,
- Rockdale, NSW, 2216
Melbourne
- Suite 4, Level 13 ,55 Swanston Street,
- Melbourne, VIC, 3000
- Phone: +61 3 9123 6236
One of the best Job Ready Programs in Australia!
Course Duration
- 23 Weeks
- 10 Weeks For ITS
- 13 Weeks For DAE
Course Fees
$4800 inc GST
Flexible Installment payment options available
Career Opportunities
Entry Level Data Analyst:
Data Officer, Junior Data Analyst, Junior Business Analyst, Junior Data Visualization Officer etc.
Entry Level, Level 1, Level 2:
Help Desk Support, Help Desk Analyst, IT support specialist, Onsite Technician, Junior Network Engineer, Junior Cloud support, Junior System Administrator, any IT support roles.
Average Salary Range
$75,000 - $100,000
| Topic |
|---|
| Course Overview |
| Excel for Data Analysis (6 Hours) |
| SQL Basics (6 hrs) |
| Intermediate SQL (6 hrs) |
| Power BI Basics (6 hrs) |
| Power BI Intermediate (6 hrs) |
| Tableau for Visual Analytics (6 Hours) |
| Python Basics (6 hrs) |
| Python with Pandas (6 hrs) |
| Visualization & APIs (6 hrs) |
| Azure for Data Analytics (6 Hours) |
| Snowflake Basics (6 hrs) |
| Snowflake Intermediate (6 hrs) |
| Databricks for Big Data Analysis (6 Hours) |
| Portfolio Project |
| IT Service Desk Ticketing System |
| End User Device Support |
| Managing Active Directory Users and Groups |
| Office365 & Cloud Technologies Support |
| Network/Internet Connection Support |
| Company File Sharing Support |
| Backup Technologies and Support |
| End Point Protection |
| Printers/Multifunction Devices |
| Certification Training |
| Advanced Topics in Data Analysis Job Search |
| JOB SEARCH: Assistance |
"The Journey of a thousand miles begins with one step" - Lau Tzu
Time Table
IT Support Online Schedule
| Online Class | Time (AEDT) | Duration |
|---|---|---|
| Saturday & Sunday (Evenings) | 6:30 PM - 9:30 PM | (3 + 3) Hours = 6 Hours |
Data Analytics Schedule
| Data Analytics Class | Time (AEDT) | Duration |
|---|---|---|
| Wednesday & Thursday (Evenings) | 6:30 PM - 9:30 PM | (3 + 3) Hours = 6 Hours |
"The Journey of a thousand miles begins with one step" - Lau Tzu
IT System/Network SupPort L1/L2
TOPIC-1: IT Service Desk Ticketing System
- Introduction to ticketing systems
- Guide to dealing with tickets
- Creating, allocating and updating tickets
- Escalating, following up and closing tickets
- Creating knowledge base and IT documentation
- Introduction to Service Level Agreement
TOPIC-2: End User Device Support
- Introduction to computer components
- Computer assembly, parts replacements, and upgrades
- OS installation, updates, and upgrades
- End user devices troubleshooting
- PC migration, cloning, and deployment
- End user device backups and restores
- End user device maintenance and optimization
TOPIC-3: Managing Active Directory Users and Groups
- Introduction to Active Directory
- Installing and configuring Active Directory
- Creating and managing Active Directory users & groups
- Managing organisational units (OUs)
- Managing security roles and permission
- Introduction to group policy & implementing GPOs
- Introduction to server audits & conducting audits
TOPIC-4: Office365 & Cloud Technologies Support
- Cloud computing fundamentals training
- Setting up and configuring cloud accounts
- Managing and supporting Office365 exchange online
- Managing and supporting Microsoft Azure
- Managing cloud resources and security
- Working with Microsoft Teams
- Managing and supporting SharePoint Online
- Monitoring and optimising cloud performance
TOPIC-5: Network/Internet Connection Support
- Network fundamentals training
- Configuring and managing network devices
- Setting up LAN/WAN and configuring SOHO routers
- Data cabling and working on a server rack
- Cable tracing, testing, and repairing
- Introduction to VPN
- Introduction to VLAN
- Configuring Wi-Fi, hotspots, mesh connections
- Troubleshooting network issues
TOPIC-6: Company File Sharing Support
- Introduction to File Server and Network Attached Storage (NAS)
- Sharing files in a workgroup environment
- Sharing files in a domain environment
- Introduction to NTFS Permission
- Managing user access to shared folders
- Troubleshooting file sharing issue
- Setting up and configuring a NAS device
- Configuring data protection and security on the NAS
TOPIC-7: Backup Technologies and Support
- Introduction to backup technologies
- Setting up server backups and performing restore
- Setting up cloud backup and performing restore
- Setting up image backup and performing full restore
- Introduction to disaster recovery/business continuity
TOPIC-8: End Point Protection
- Introduction to end point protection
- Using various anti-virus software & best practices
- Configuring and managing end point protection
- Troubleshooting and removing viruses and malware
- Introduction to Anti-spam | email security
- Firewall and intrusion prevention training
- Introduction to parental controls and content filtering
TOPIC-9: Printers/Multifunction Devices
- Introduction to types of printers and MFDs
- Setting up and configuring various printers and MFDs
- Setting up scan to email and scan to folder
- Troubleshooting most common printer issues
- Printer and multifunction device maintenance
- Introduction to printer management software
TOPIC-10: Certification Training
- AZ-900 Microsoft Azure Fundamentals
- AB-900 Microsoft 365 Fundamentals
Data Analytics Engineer
Week 1: Excel for Data Analysis (6 Hours)
- Excel Interface & Formatting
- Basic Functions: SUM, AVERAGE, COUNT, IF, IFERROR
- Lookup Functions: VLOOKUP, XLOOKUP, INDEX-MATCH
- Data Sorting & Filtering
- Power Query
- Pivot Tables and Pivot Charts
- Excel Dashboards
Week 2: SQL Basics (6 hrs)
- Introduction to Databases and MySQL setup
- SQL Syntax: SELECT, FROM, WHERE, ORDER BY, LIMIT
- Logical Operators (AND, OR, NOT)
- Aggregation Functions: SUM(), AVG(), COUNT()
- GROUP BY and HAVING Clauses
Week 3: Intermediate SQL (6 hrs)
- SQL Joins: INNER, LEFT, RIGHT, FULL
- Date Functions in SQL
- Subqueries and Aliases, CASE Statements
- Window Functions: ROW_NUMBER(), RANK(), DENSE_RANK()
Week 4: Power BI Basics (6 hrs)
- Installing Power BI Desktop
- Connecting to Excel/CSV/SQL Data Sources
- Data Cleaning using Power Query
- Basic Visualizations: Tables, Bar, Line, Pie Charts
- Slicers and Filters
Week 5: Power BI Intermediate (6 hrs)
- DAX Basics: Measures, Calculated Columns
- Time Intelligence Functions
- Drill-Down, Tooltips, Bookmarks
- Interactive Dashboards
- Power BI Service: Publishing & Sharing and Schedule Refresh
- Row level Security and Incremental Refresh
Week 6: Tableau for Visual Analytics (6 Hours)
- Tableau Overview and Interface
- Connecting to Data
- Visuals: Bar, Line, Pie, Tree Maps
- Filters, Sorting, Highlighting
- Calculated Fields & Parameters
- Dashboard Design and Storytelling
- Joins & Blends (Basic)
Week 7: Python Basics (6 hrs)
- Python Setup with Jupyter Notebook
- Data Types, Variables, Loops, Conditions
- Functions & List Comprehensions
- Introduction to NumPy (arrays, operations)
Week 8: Python with Pandas (6 hrs)
- Intro to pandas DataFrames & Series
- Reading data (CSV, Excel)
- Data Cleaning (dropna, fillna, duplicates)
- Filtering, Sorting, Grouping, Merging
Week 9: Visualization & APIs (6 hrs)
- Plotting with matplotlib and seaborn
- Visual types: Histograms, Boxplots, Heatmaps
- Calling APIs and working with JSON
- Intro to Machine Learning Libraries (sklearn)
Week 10: Azure for Data Analytics (6 Hours)
- Introduction to Cloud & Azure Platform
- Azure Virtual Machines and Networking
- Azure Storage Accounts & Containers
- Microsoft Entra Id and RBAC
- Azure Data Factory (Basics of ETL pipeline)
- Azure SQL & Azure Synapse Analytics (overview)
Week 11: Snowflake Basics (6 hrs)
- Snowflake Architecture & Cloud Platforms
- Warehouses, Databases, Schemas, Tables
- Data Types, Constraints, Keys
- Ingestion: Loading Data from CSV/JSON
- SQL in Snowflake (Basic Queries)
Week 12: Snowflake Intermediate (6 hrs)
- Views, Temporary & Transient Tables
- Cloning, Time Travel & Fail-safe
- Query Optimization Techniques
- Virtual Warehouses and Scaling
- Using Snowpipe for Continuous Ingestion
Week 13: Databricks for Big Data Analysis (6 Hours)
- Introduction to Databricks & Unified Analytics
- Notebooks, Clusters, and Jobs
- DataFrames in PySpark
- Data Cleaning with Spark
- Writing SQL in Databricks
- Delta Lake Concepts
Portfolio Project
Your IT career begins here!
Advanced Topics in Data Analysis Job Search
- Advanced data manipulation and analysis techniques using SQL, Excel, and Python
- Building advanced visualizations and dashboards using Power BI and Tableau
- Machine learning and predictive modeling using Python
- Communicating insights and recommendations based on data analysis.
JOB SEARCH: Assistance
- Resume preparation, optimisation, support & training
- Interview preparation | mock interviews & training
- Job search strategies and assistance
- LinkedIn profile optimisation and networking
- Access to TechSkills portal & Interview questions
- Lifetime support until you get the job in IT
