DATA ANALYST
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
-
Certified Data Analyst Certificate Issued
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):
- End-to-end Tableau dashboard creation
- Blackmores example: HR Tableau dashboard
- Best practices when designing a chart
- Data-ink ratio
- Correct data representation
- Data selection
- Tell a story using charts
- Dashboard UI structure
- Pattern of colour & choosing the right one
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):
- Jupyter Notebook overview of the interface
- In-class end-to-end EDA using Python
- Data manipulation with Pandas
- Data cleaning (renaming columns, changing data types, APPLY function)
- EDA using MATPLOT and SEABORN
- Working with NumPy
- Basic statistics & insights
Training agenda (4 hours):
- Introduction to Big Data & Cloud Computing
- For Vs of Big Data
- The fat and thin book analogy
- 'Scale up' versus 'scale out'
- Distributed computing & parallel processing
- Spark versus Hadoop
- Introduction to Apache Spark and cluster (master worker concept)
- Databricks introduction
- Cluster creation, notebook, PYSPARK, SPARKSQL
Microsoft Certified "Generative AI ✨Data Analyst"
Detailed curriculum
[Live From Sydney]
🔴Live Class
🔵Assignment submission
🟢Project submission
Created with
