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
Meet your instructors & mentors
Krish Pillai
Lead Mentor & Career Coach
Write your awesome label here.
Hi👋 I'm Krish Pillai, the Lead Mentor at The Data Analytics Institute, Australia.
Let me share a candid reflection: 10 years back, after finishing my master's degree from UNSW, I struggled to land my first tech job. I knew I needed to do something outside-of-the-box to land a job.
That's when I came up with the M.I.N.T method and soon realised data is the easiest route into the tech industry. Once I started working with data, I was hooked.
Today, I have 10+ years of experience in data, having worked with leading firms like Westpac, Deloitte, NBN Co, and the NSW Government, and have interviewed with companies like EY, Atlassian, and Uber.
I took all my learning, including what I wished I knew, and packaged it to help people land their data job faster & easier.
Reach out to me on LinkedIn if you have any questions.
Let me share a candid reflection: 10 years back, after finishing my master's degree from UNSW, I struggled to land my first tech job. I knew I needed to do something outside-of-the-box to land a job.
That's when I came up with the M.I.N.T method and soon realised data is the easiest route into the tech industry. Once I started working with data, I was hooked.
Today, I have 10+ years of experience in data, having worked with leading firms like Westpac, Deloitte, NBN Co, and the NSW Government, and have interviewed with companies like EY, Atlassian, and Uber.
I took all my learning, including what I wished I knew, and packaged it to help people land their data job faster & easier.
Reach out to me on LinkedIn if you have any questions.
Saurabh Dev
Lead Instructor
Write your awesome label here.
Hi👋 I'm Saurabh Dev, the Lead Instructor at The Data Analytics Institute, Australia.
I remember how tricky it was to transition to data analytics without an IT background.
My mantra is simple - If I can do it, then anyone can.
Today, I have 12+ years of data analytics experience and worked with renowned organisations such as NSW Government, Energy Australia, IBM, Lomotif, and Wipro etc.
But my true passion lies in teaching. So, I gave up my well-paying corporate job to focus on teaching essential data skills and have helped over 300+ students pick up data skills from scratch.
Message me on LinkedIn if you have any questions.
I remember how tricky it was to transition to data analytics without an IT background.
My mantra is simple - If I can do it, then anyone can.
Today, I have 12+ years of data analytics experience and worked with renowned organisations such as NSW Government, Energy Australia, IBM, Lomotif, and Wipro etc.
But my true passion lies in teaching. So, I gave up my well-paying corporate job to focus on teaching essential data skills and have helped over 300+ students pick up data skills from scratch.
Message me on LinkedIn if you have any questions.
Don't just take our word for it
100s have landed a job. You could be the next.