Data Analyst
-
Nationally recognised training
-
100% online learning
-
Live classes and cohort-based
Data Analyst
Program Details
Learn how to harness the power of data to predict trends, drive decision making and improve performance.
Duration
6 months - 2 days per week, evening and weekend hours
Delivery Mode
100% online, face-to-face interactive cohort learning
Intake Date
2023
Program Fee
$3,570.00
Data Analyst
Program Overview
In the digital kingdom where web and mobile applications help us manage nearly every aspect of our lives, data is king. Every digital action is visible and trackable, enabling corporations to accumulate and analyse vast amounts of both personal and business data.
Data analytics is the science of collecting and analysing raw data in order to make conclusions about that information. A Data Analyst is a person who can skillfully extract this information using data modeling and inform management on what it needs to know for decision-making.
Experienced Trainers from the Industry
The program is taught by local trainers with experience working in the tech sector, with additional workshops with Israeli data science and analysis experts.
Hands-On Training and Live Simulators
Get real-life experience in data science through the program’s focus on hands-on exercises and projects, which you’d be able to show to employers.
Help with finding a Job Post Graduation
You’ll be job-ready as soon as the program ends and we’ll help successful graduates with job placement in the local tech industry through our business network and dedicated HR team.
Don't take our word for it
Read what others have to say
I've been a tradie most of my life and decided I wanted a change. I saw an ad for CTIA and their Cyber Security course and figured why not. I really enjoyed the content and learnt a lot. After some help from their career advisor, I'm now working for a small business taking care of their cyber security and really enjoying it.
I previously worked in an administrative role for my company, but I love numbers and really wanted to find a job I was passionate about. I didn’t want to leave my current employer because they really look after us, and then we found out about the government funding. They put me through CTIA’s Data Analyst course and now I’m in a job I love AND I got to stay with my company.
I’ve always been a creative person but being a mum, I had to make sure my kids came first so wasn’t in a job I really enjoyed. Now they’ve grown up, I decided it was time to find my passion. A friend told me about CTIA and their Full Stack Developer course and I’m absolutely loving it! I can’t wait to finish and finally find a job I love!
Program Curriculum
Introduction to Data Analytics
- General introduction
- Analyst role and capabilities required
- KPI
- Analyst work circle
- Introduction to relational database
- Insights that can be derived from the data
SQL for Data Analysis
- Introduction to MSSQL
- Introduction to work environment
- Basic SQL query
- Calculated columns
- Basic built-in functions
- Sorting the results
- Grouping and aggregate
- Advance filtering
- Working with NULL values
- Diagram
- Join tables
- Conditional Statement
- Related and unrelated nested queries
- Most common built-in functions
- Window functions
- CTE (Common Table Expression)
- DML (Data manipulation language)
- DDL (Data definition language)
- Data analysis using work circle
- Writing User scalar functions
- Stored procedure
Advanced Excel Skills
- Formulas
- Basic and advanced filtering data
- Sorting data
- Common use build-in functions
- Connectivity to outer data source
- If functions
- VLOOKUP
- Error handling
- What is analysis functionality
- Conditional formatting
- Charts and chart components
- Pivot tables
- Pivot charts
- Slicers
- Dashboarding
Data visualization and data analysis with Tableau
- Introduction to tableau
- Connect to data
- Connections
- Dimensions
- Measures
- Basic chart types
- Grouping
- Advance chart types
- Combo chart
- Dual axis
- Filtering
- Sorting
- Hierarchy
- Total and subtotals
- Calculated fields
- Custom aggregations
- Logic statements
- Dashboards
- Exporting a dashboard
Python
- Python fundamentals
- Basic operations and use of operators
- Documentation
- Variables and basic data types
- Python basic build in functions
- String slicing
- Conditions
- Introduction to Pandas package
- Import data from CSV
- Pandas data structures
- Pandas descriptive methods
- Filter records by conditions
- Regex
- Sorting data
- Retrieving data
- Handling NULL values
- Update data
- Grouping and aggregations
- Pivot table
- Cross tab
- Merging
- Data Frame methods
- Loops: For, while, Loop flow control
- Def functions
- Local and global variable
- Lambda function
- Apply method
- Connect to MSSQL
- Visualization with Seaborn
- Adjusting the graph display
- Save data and pictures into Excel file
- Make your script a running program
Final Bring It Together (BIT) Project
Are you ready to enrol?
Get in contact with us today and commence your Pre-Training Review (PTR) to ensure that CTIA’s Cyber Security Analyst program is able to meet your individual needs.
Why Choose Us
We have your best interests at the core of our being.
70% Hands-On Practice
70% of the training program is dedicated to actual hands-on practice of the materials and skills taught.
Global Industry Connections
Leverage our strong global industry connections to pursue a career within or outside of Australia.
How It Works
Free Consultation
Book a free consultation with our team to
find out the best pathway to your dream job.
PTR & Enrolment
Enrol in the most appropriate program to
achieve your intended outcomes.
Payment Plans & Funding
Explore our flexible payment plans or access
a range of funding to subsidise your tuition.
Enquire Now
Future-proof your career with CTIA
Provide your details and one of our career consultants will get in touch.
Frequently Asked Questions
FAQs
Data analytics is the science of collecting and analyzing raw data in order to make conclusions about that information.
A Data Analyst is a person who can skillfully extract this information using data modeling and inform management on what it needs to know for decision-making.
Day-to-day tasks focus on gathering data from a variety of sources according to predefined data sets and variables. Collected data is then cleaned up and validated for accuracy and uniformity. Using statistical tools, Data Analysts then analyze and interpret results to identify trends, patterns, and new opportunities from the data.
Data and predictive analytics are changing everything from medicine and manufacturing, to marketing, HR and education. The future of products and services all around us is being driven by data and the data professionals who know how to wield it.
Yes! All graduates who have successfully completed the program will receive a Data Analyst certificate.
Thousands of alumni use their course certificate to demonstrate skills to potential employers, along with their LinkedIn networks. Our data programs are well-regarded by many top employers, who contribute to our curriculum and partner with us to train their own teams.
Studies take place 100% online and recordings can be watched on-demand from anywhere.
Register your interest, take a 1-hour online assessment test, and have a talk with one of our career advisors.
This is an entry-level program for beginners and career changes, no background needed. However, all candidates take a computerized assessment to ensure that they have the right personality, as well as the basic math and logic skills, to complete the program and be successful in their future jobs.
