We will identify your skill gap + train you + help you build a stellar portfolio.
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"
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
Some amazing parts of the program.
-
Guaranteed-interview or money back!
We're so certain of our method that we guarantee you will land an interview if you follow it diligently. If you don't, we'll work with you for free until you do. -
Gen AI for data analysis
More companies are asking for Gen AI skills. We want our students to stand out, so we will fully sponsor a Microsoft Gen AI for Data Analysis Certification.
-
Internship comes with references
Upon successful completion of the internship, interns are eligible to receive a professional letter of recommendation/verbal reference. -
1:1 Career Coaching & Search Hack
Placement guidance check-in sessions, where we cover career hack tips like PAM (Post-application Mantra) and VVP (Value Validation Project),
But the cool thing is, you don't have take our word for it.
You can test it out for yourself.
We have a 14-day money-back guarantee!
We have a 14-day money-back guarantee!
This means you can join the program risk-free, & if you don't absolutely love it after 14 days, you can get your money back. No questions asked.
Write your awesome label here.
Frequently asked questions
Who is the Data Analyst Job-Ready Program for?
This course is for anyone who wants to upskill in data and start a career in Data Analytics. We help people who are struggling to find their first IT job in Australia like international students, migrants, recent IT graduates, people with long career breaks/parental breaks etc.
How long is the program?
The program goes on for around 6 months on average. We want our students to land a paid job before the 6-month mark. The training will last for 12 weeks, and the rest will be spent doing the internship and attending our placement guidance workshops.
How are the classes and internships run?
For the training, you will have an instructor teaching you live through Google Meet. The sessions are very interactive and we try to replicate the classroom environment. The internships will be run remotely by the host companies allowing you to easily manage them alongside your regular job. However, there may be occasions when you need to visit the office in person for orientation sessions.
Do you have a physical campus?
No, we don't have a physical campus. This helps us provide affordable services to students like you. Using technology, we make our online sessions interactive and fun filled. The data coaches are based in Sydney, so they are always happy to catch-up for a cup of coffee.
Do you promise a paid job after the program?
No, we don't guarantee. Australia is a very competitive market, so you will have to fight it out. But we guarantee a few other things 1) Guaranteed Internship 2) Guaranteed Job Support until you get a job.
I have a full-time job now, how can I train and do the internship?
You can do our program in parallel with your current commitment. Our training is outside of regular hours. You will be assigned an internship supervisor and can be set-up according to mutual convenience. Most of our internships can be done remotely, so you don't have to physically go to the office.
Is the internship guaranteed after the training?
Yes, the internship is guaranteed. Note that the internship's main aim is for you to get local work experience and do a real-world data project end-to-end. You will work with an Australian tech start-up and will have an internship supervisor assigned to you.
Is the internship a paid or unpaid opportunity?
Most of our internships are unpaid opportunities. The intention of the unpaid work experience/unpaid internship is to give a person experience in a job or industry and provide a meaningful learning experience, training, and skill development.
Is there anything out of pocket other than the fees?
No, there is nothing you need to spend extra. All tools, software and support will be provided as part of the package. We want to make our pricing transparent and simple for our students. We also have instalment options. You will pay slightly higher if you choose this method of payment.
Can I get a refund if I am not happy with the course?
If you don't love us we are more than happy to refund the money in full. No questions asked, seriously. You can try our program for 14 days and if you wish to exit let us know on or before this day.
Will you help in preparing a data analytics portfolio?
Definitely. An online data portfolio is a great way to showcase your data skills especially if you don't have a lot of work experience. We will share our blueprint on how to create one and show you how to upload all your academic projects.
I don't have any basics, can I still do this program?
We assume no prerequisites or background. We will start from scratch and help you build a strong data foundation. On top of the LIVE sessions, you will have access to 300+ lessons through our e-learning portal. However, you will need basic computer and Excel skills to fully enjoy the program.
How do you run the live classes & program?
Our live sessions are run once a week on Google Meet. Every program will have a total of 12 LIVE-ONLINE interactive sessions with our Data Coach lasting for 12 weeks. Outside of the live classes, we will get you to do some self-paced reading, assignments, and project work.
Is your course recognised in Australia?
Our training course is not accredited by anybody in Australia, as we operate as a private school. Formal recognition is not required for Data Analytics in our opinion. It really boils down to who can help you land your first job, fast.
Do you apply for jobs on our behalf?
Please note that we do not handle job applications on your behalf. Rather, we offer general guidance and support to help you in your job search process as part of the program. Take a look at our MINT approach above.
Which companies will I do my internship at?
You will most intern at an Australian-based tech company/start-up. The internship is fully remote and in rare cases you will need to visit their office or tech workshop. Flexible working arrangements can be discussed - e.g. full-time or part-time. We have partnered with 7 start-ups so far.
How many students per batch for the training ?
We try not to go more than our sweet spot of 20 students per batch. A smaller class allows us to provide increased individual attention, enhanced student engagement, and increased collaboration.
How do you provide such affordable services?
We know that other training centres charge their students tens and thousands of dollars. Fortunately for you, we have managed to bring our price point that is more wallet-friendly by not having a physical campus and running all of this virtually.
Take the first step toward your data analytics journey.
Book an obligation free career consultation call now.
During this call, we will delve into your career goals, academic background, and professional experience in order to create a personalized plan that will guide you toward becoming a Data Analyst.
Created with
