FULL STACK DATA PROFESSIONAL PROGRAM
DATA ANALYST + DATA ENGINEERING
JOB-READY BOOTCAMP
Gen AI for Data Analysis included ✨
Enrolment Open.
What's included?
Gen AI for Data Analysis included ✨
-
12-week live training
-
6-month Live internship
-
Guaranteed job support
-
Dedicated Mentor
-
12-Month LMS Access
-
Full stack Data Professaional Certificate
Ready to land your first data job?
Train and upskill on core technical skills (Excel, Database Querying – SQL, Data Visualization, Tableau, Power BI, Python and Basic Statistics)
One program, multiple roles.
You can apply for a number of roles such as Data Analyst, Insights Analyst, Marketing Data Analyst, Data Quality Analyst, SQL Analyst, Data Journalist, Tableau/Power BI Developer etc.
See detailed Curriculum Below
Live training session delivery methodology
- Live instructor-led group classes (via Google Meet) every week for 12 weeks
- The classes are highly interactive and we try to replicate a classroom environment as much as possible.
- These classes will be recorded and all the doubts & clarifications would be answered during the class
- You will need to engage in pre-reading on the other days (you will be provided with all the materials through our portal)
- A mentor would be assigned to you for the complete duration of academia as well as the internship to help you through the entire journey
- OUR PROMISE: these sessions are NEVER going to be boring and one-way.
Interactive, live sessions with annotations
The training + portfolio building timeline that helped 100's land a data job
Training agenda (4 hours):
- 7 stages of a data analytics project
- Kmart example: Interactive sales dashboard
- Hands-on data preparation
- Hands-on data quality analysis & cleaning
- Dashboard building process
- Hands-on interactive dashboard in Excel
- Dashboard hygiene factor
- Uploading your second portfolio project
Training agenda (4 hours):
- Introduction to Power BI
- Power BI services & apps
- Why companies choose Power BI over other tools
- Power BI workflow and UI
- Woolworths example: Rewards analytics dashboard
- Power BI end-to-end guided exercise
- Data connection
- Data modelling & transformation
- Data Analysis Expressions (DAX)
Training agenda (4 hours):
- Power BI advanced concepts
- Drill through
- Smart narratives
- Quick measures
- Clustering
- Introduction to Tableau
- How Tableau works
- Tableau dashboard examples
- Walkthrough of the Tableau dashboard
- Dan Murphy example: Tableau dashboard
- Tableau Public vs Desktop
Training agenda (4 hours):
- Statistics for data analysts
- Power BI end-to-end statistics walkthrough
- Types of statistics
- Description & predictive examples
- Measures of central tendency: mean, median, mode
- Variability measurement: range, var, st. dev, IQR
- Graphical stats - histogram, box plot, scatter plot
- Dealing with outliers
Training agenda (4 hours):
- Introduction to SQL
- SQL's advantage over Excel
- SQL platforms
- SQL Workbench UI/ UX walkthrough
- Databases & Tables definition
- SQL syntax order
- Basic syntax: SELECT, FROM, WHERE, ORDER BY
- Employees database installation"
Training agenda (4 hours):
- Revision of basic syntax
- Intro to more SQL syntaxes: GROUP BY, HAVING clause
- HAVING versus WHERE clause
- In-class SQL case-study
- Intermediate concepts introduction
- JOINS, UNIONS and SUB QUERY
- Types of JOINS
Training agenda (4 hours):
- Revision of JOINS, UNIONS and SUB QUERIES
- In-class SQL case-study
- Introduction to advanced SQL concepts
- CASE statements
- TEMP tables
- Handling nulls (ISNULL, IFNULL, COALESCE)
Training agenda (4 hours):
- Revision of CASE statement & SUB QUERIES
- In-class SQL case study
- Introduction to advanced concepts
- Common table expression (CTE)
- String functions (LEN, SUBSTR, CONCAT, TRIM, FORMAT)
- Handling data type (numeric, date, Boolean)
- CAST / CONVERT
- Window function & PARTITION BY function
- ROW, RANK, DENSE_RANK, LAG/LEAD, FIRST/LAST VALUE
Training agenda (4 hours):
- Building end-to-end Data Apps from scratch using Streamlit and AI-assisted coding (Vibe Coding).
- Streamlit
- Build & deploy a real data app
- Git-based workflow
Training agenda (4 hours):
- Design a schema and build a Data Warehouse using SQL Server & Git.
- Star / Snowflake schema
- Draw.io architecture diagrams
- SQL Server Express + SSMS
- Git version control
- Data cataloging
- Business Objects
Training agenda (4 hours):
- The Azure Cloud Ecosystem: End-to-end pipeline creation using ADF, Databricks, and Lakehouse architecture.
- Azure Data Factory (ADF)
- Azure Data Lake
- Databricks
- Synapse Analytics
- Medallion architecture
- Azure Active Directory
- Enterprise-style access control
Microsoft Certified "Generative AI ✨Data Analyst"
Detailed curriculum
[Live From Sydney]
🔴Live Class
🔵Assignment submission
🟢Project submission
Created with
