DATA ANALYST
JOB-READY BOOTCAMP
Enrolment Open.
What's 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 program timeline that helped 100's land a data job
Training agenda (4 hours):
Internship agenda (1 hour)
- 7 stages of 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
Internship agenda (1 hour)
- Check-in
Training agenda (4 hours):
- Introduction to Power BI
- Power BI services & apps
- Why companies choose Power BI over other tools
- PowerBI workflow and UI
- Woolworths example: Rewards analytics dashboard
- Power BI end-to-end guided exercise
- Data connection
- Data modeling & transformation
- Data Analysis Expressions (DAX)
Internship agenda (1 hour)
- Check-in
Training agenda (4 hours):
- PowerBI advanced concepts
- Drill through
- Smart narratives
- Quick measures
- Clustering
- Introduction to Tableau
- How Tableau works
- Tableau dashboard examples
- Walkthrough of Tableau dashboard
- Dan Murphy example: Tableau dashboard
- Tableau Public vs Desktop
Internship agenda (1 hour)
- Check-in
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
Career coaching agenda (3 hours)
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
Internship agenda (1 hour)
- Check-in
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"
Internship agenda (1 hour)
- Check-in
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
Internship agenda (1 hour)
- Check-in
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)
Internship agenda (1 hour)
- Check-in
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
Internship agenda (1 hour)
- Check-in
Training agenda (4 hours):
- Jupyter Notebook overview of 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
Career coaching (2 hours)
- Check-in
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
Internship agenda (1 hour)
- Check-in
Week 13 to 24: Immersive client internship
- 1:1 client work led by an internship supervisor
- Work on atleast 3 client projects Internship projects will include work with real datasets & databases
- You will get to work with tools like SQL, Tableau, PowerBI, Python, Cloud Platforms etc.
- Get an opportunity to work with Founders, Head of Data, Data Analytics Managers etc.
- Get plenty of presentation opportunities (e.g. PPT and dashboard presentations)
- Get real experience you can add to your resume and LinkedIn
Detailed curriculum
[Live From Sydney]
🔴Live Class
🔵Assignment submission
🟢Project submission
Created with
