Data Analytics Classes Canberra

In this program, participants will learn the key skills and tools needed to succeed as a data analyst, including Excel, SQL, and Tableau. Attendees will learn how to use Excel to create graphs, summarize data with PivotTables, and analyze data. In SQL, attendees will learn the essentials of relational databases, queries, functions, and more. Finally, participants will learn Tableau to create visualizations to express their data. The program is open to beginners and has flexible scheduling options. Tuition includes hands-on training, a free retake, and training manuals for each course.

Learn to problem solve, and effectively communicate, like an analyst. This course teaches you to use industry-standard tools to make ethical, data-driven decisions. Experience hands-on training to master SQL, Excel, Tableau, PowerBI, and Python – tools listed in virtually every data analytics job posting across industries.

Data Analytics Flex is a 6-month part-time program designed to get you a job as a data analyst. You will begin by learning how to master Excel and storytell with Powerpoint. Afterwards, you'll learn how to query data using SQL and visualize data using Tableau. Once you've mastered these building blocks, you'll receive business case studies to simulate real-world work projects and you'll also be exposed to statistics. Finally, you'll learn how to clean data using Python and work on your capstone project. This program comes with a tuition backed guarantee if you don't land a job within 6 months of graduation.

In this 8-day intensive Data Analytics bootcamp, students with little to no background in data analytics will learn how to use Microsoft Excel, SQL, and Tableau to summarize, display, and discover key insights hidden in data sets. By the end of this bootcamp, students will be able to use Excel to aggregate and summarize data, sort data with PivotTables, create charts and tables in Excel, use SQL to filter and sort large data sets, use advanced database queries, create visualizations with Tableau, and much more. Students will also be able to reinforce what they learn through the numerous projects they encounter throughout the course. This course also offers a free retake within six months to allow students to revisit any concepts needing to be refreshed and walk away with a much stronger grasp of the material.

In this introductory, 2-day SQL course, participants will learn the basics of databases and start querying databases with SQL. Participants will get comfortable with databases and start performing basic querying techniques like SELECT, ORDER, SUM, and GROUP BY. This course is intended to give students a fundamental understanding of the use of SQL for database management.

This 2-day advanced SQL course is designed for individuals who want to better understand database structure and querying data. Specifically, the course will cover connecting to a SQL server, executing a query, adding a condition to a query, using functions to make calculations, organizing data, and retrieving data from multiple tables. Students will be able to apply what they learn to PostgreSQL, MySQL & MariaDB and Oracle among others.

This 1-day introductory Microsoft Excel course will teach those new to Excel how to successfully get up and running with Microsoft’s powerful spreadsheet program. The course explores a range of core Excel concepts, including an overview of the Excel interface, how to create a new workbook, editing data, working with formulas and functions, selecting ranges, copying and pasting data, applying borders to cells, row and column formatting, adjusting pages, printing, and more. Students will also receive a certificate of completion, training manual, 12 months of email support, and the option to take the class again for free.

This 1-day intermediate Microsoft Excel course will teach those with a basic understanding of Excel some intermediate tools and shortcuts to enhance their spreadsheet knowledge and workflow. The course explores a range of Excel concepts, including data filling, formula referencing, defining names, essential functions, conditional formatting, working with worksheets, find and replace, sorting and filtering data, creating charts, and more. Students will also receive a certificate of completion, training manual, 12 months of email support, and the option to take the class again for free.

This 1-day advanced Microsoft Excel course will teach those with a good grasp of Excel some of the advanced tools to elevate their spreadsheet knowledge and workflow capabilities. The course explores a range of advanced Excel concepts, including lookup and text functions, finance functions, complex formulas, goal seek, data linking, data protection, summarizing and subtotaling, grouping, pivot tables, pivot charts, macros, and more. Students will also receive a certificate of completion, training manual, 12 months of email support, and the option to take the class again for free.