Top Sydney Business Analyst Courses
-
NYIM Training Excel for Business Bootcamp
In this comprehensive Excel bootcamp, participants learn beginner to advanced Excel techniques, including formulas & functions, VLOOKUP, macros, and more. Students learn how to work more efficiently, summarize, and analyze data with tables, charts, and PivotTables. By the end of this hands-on course, participants will be ready to use Excel for everyday business tasks. The course has flexible scheduling options and is available live online or in NYC. Tuition includes hands-on training, a free retake, course manual, and supporting video tutorials.
Available live online (virtual training) from anywhere- $549
- 18 Hours
- Weekdays, Evenings, or Weekends
- Beginner
- Free Retake
-
NYIM Training SQL Bootcamp
In this 3-day bootcamp, beginners will be transformed into confident SQL users who can write queries, manipulate tables, and store advanced code. Participants will start by learning about relational databases and SQL fundamentals and will conclude the program having mastered complex retrieval tasks and storing complex code. Topics include composing queries, creating your SQL databases, automating workflow with stored procedures, and step-by-step exercises that will provide an efficient and thorough approach to mastering SQL. Tuition includes hands-on training, a free retake, and a course manual. The course has flexible scheduling options and is available online and in NYC.
Available live online (virtual training) from anywhere- $975
- 18 Hours
- Weekdays, Evenings, or Weekends
- Beginner
- Free Retake
-
Noble Desktop SQL Bootcamp
In this 18-hour SQL Bootcamp open to beginners, participants will discover the essentials of databases and how to write SQL code to retrieve and analyze data. Through hands-on exercises, participants learn everything from data types to basic queries and advanced topics, including aggregating and joining. Topics include SQL GUI basics, fundamental to advanced querying, table creation, joins, views, functions, and external data connections. The course is taught using PostgreSQL and applies to other relational databases, including SQL Server and MySQL. Participants can retake the course for free within one year.
Available live online (virtual training) from anywhere- $975
- 18 Hours
- Weekdays or Evenings
- Beginner
- Free Retake
-
NYIM Training Tableau Bootcamp
In this comprehensive 2-day course, participants can become an advanced Tableau user able to work with data to create visualizations and use the various tools Tableau Public has to offer. They will learn to identify datasets to create desired visualizations and then master the Tableau tools on a deeper level to customize their visualizations. By the end of this course, participants will have learned to create maps to represent geographical data, and build actions to control visualizations within sheets and dashboards. Tuition includes hands-on training, a free retake, and a course manual. The course offers flexible scheduling and is available online or in NYC.
Available live online (virtual training) from anywhere- $499
- 12 Hours
- Weekdays or Evenings
- Beginner
- Free Retake
-
General Assembly SQL Bootcamp: Learning the Language
This SQL bootcamp is a beginner-friendly workshop designed for individuals with no prior knowledge of SQL who are eager to learn. In this hands-on workshop, students will learn the basics of SQL syntax and how databases are organized. Students in this course will also learn how to query data, aggregate data with statistical functions (SUM, AVG, COUNT, etc.), group data, and use conditional operators (=, <, >, etc.) to sort and filter data, and much more. Students will also learn when and how to use UNIONs and JOINs to merge data to spot trends and other insights.
In-person @ 1 Market St, Sydney, NSW Also available online- $350
- 1 Day
- Weekdays or Weekends
- Beginner
-
NYIM Training Excel for Business Fundamentals
Get started with Microsoft Excel in this beginner-friendly course. Learn calculations, basic formulas and functions, tables, charts, and tips for efficiency with hands-on exercises. By the end of this course, you'll build a strong foundation for using Excel as a vital tool in your daily workflow. The course has flexible scheduling options and is available live online or in NYC. Tuition includes hands-on training, a free retake, course manual, and supporting video tutorials.
Available live online (virtual training) from anywhere- $249
- 6 Hours
- Weekdays, Evenings, or Weekends
- Beginner
- Free Retake
-
General Assembly Intro to Advanced SQL Concepts
This advanced SQL course is a 3-hour workshop designed for individuals already familiar with SQL who are looking to take their skills to the next level. In this advanced hands-on workshop, students will dive into advanced calculations and techniques to work with data more effectively through SQL. Students in this course will also learn concepts like Text Searching, Views, and Stored Functions and Procedures. Students will also be provided with resources to hone their skills and practice the concepts covered in the course.
In-person @ 1 Market St, Sydney, NSW Also available online- See provider
- 3 Hours
- Weekdays or Weekends
- Advanced
-
General Assembly Design Your Data: Tableau Bootcamp
This Tableau bootcamp is a beginner-friendly course designed for individuals hungry to learn the basics of Tableau. In this hands-on workshop, students will use Tableau to explore a data set and learn not only how to connect to data and present data with stunning visuals, but also some best practices around data visualization, using Tableau filters, and publishing with Tableau. Students in this course will also learn how to create Tableau dashboards, how to use the built-in Maps function, some helpful tricks, and more.
In-person @ 1 Market St, Sydney, NSW Also available online- See provider
- 1 Day
- Weekdays or Weekends
- Beginner
-
General Assembly Excel Bootcamp: Formulas & Functions
This Excel course is a workshop intended to help individuals who know the fundamentals of Excel to take their skills to the next level. In this hands-on workshop, students will be able to polish and build their Excel capabilities to get one step closer to becoming a spreadsheet power user. Students in this workshop will review shortcuts and formula writing, review spreadsheet formatting best practices, and the basics of data structure and analysis. Students will also learn how to use VLOOKUP, PivotTables, and the logic behind absolute referencing.
In-person @ 1 Market St, Sydney, NSW Also available online- See provider
- 1 Day
- Weekdays or Weekends
- Intermediate
-
General Assembly Advanced Excel Training
This advanced Excel course is a 3-hour class designed for individuals who are comfortable working in Excel but want to learn more advanced functionality. In this hands-on class, students will be able to review and bolster their Excel capabilities to become a spreadsheet power user. Students in this course will walk away from this course with a more robust understanding of when and how to use VLOOKUPs and HLOOKUPs, the power of INDEX & MATCH, using PivotTables and PivotCharts, and how to record macros to automate repetitive tasks.
In-person @ 1 Market St, Sydney, NSW Also available online- See provider
- 3 Hours
- Weekdays or Weekends
- Intermediate
-
General Assembly Excel Bootcamp
This Excel bootcamp is meant to give beginners an overview of Excel and a variety of functions you can use with Excel. Students will learn things like formatting techniques, mathematical formulas, PivotTables, charts, and more. This 4-hour Excel course is offered in-person in NYC or live online.
In-person @ 1 Market St, Sydney, NSW Also available online- $250
- 4 Hours
- Weekdays or Weekends
- Beginner
-
Dynamic Web Training Excel Beginner 2016
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.
In-person @ 32 Walker St, North Sydney, NSW- $385
- 1 Day
- Weekdays
- Beginner
- Free Retake
-
Dynamic Web Training Excel Intermediate 2016
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.
In-person @ 32 Walker St, North Sydney, NSW- $385
- 1 Day
- Weekdays
- Intermediate
- Free Retake
-
Dynamic Web Training Excel Advanced 2016
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.
In-person @ 32 Walker St, North Sydney, NSW- $385
- 1 Day
- Weekdays
- Advanced
- Free Retake
-
Dynamic Web Training SQL Essentials
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.
In-person @ 32 Walker St, North Sydney, NSW- $990
- 2 Days
- Weekdays
- Beginner
- Free Retake
-
Dynamic Web Training Advanced SQL Queries
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.
In-person @ 32 Walker St, North Sydney, NSW- $990
- 2 Days
- Weekdays
- Intermediate
- Free Retake
-
Dynamic Web Training Power BI for Excel 2016
This 1-day Power BI for Excel course will teach those with advanced knowledge of Excel how to incorporate some business intelligence elements into their Excel workbooks. The course explores a range of Power BI tools and concepts, including how to link data to Query, accessing data types from Query, transforming data, importing data into PowerPivot, data model relationships, the differences between PowerPivot and Query, the DAX language and DAX measures, text-based calculations 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.
In-person @ 32 Walker St, North Sydney, NSW- $385
- 1 Day
- Weekdays
- Advanced
- Free Retake
-
Dynamic Web Training Power BI Essentials
This 1-day Power BI Essentials course will teach students how to develop and share dashboards using Microsoft’s dynamic business intelligence software. The course explores a range of Power BI reporting concepts, including a broad overview of business intelligence and data analytics, understanding and getting started with Power BI, importing data, transforming data, an introduction to Power Query, data modeling, an introduction to DAX, data visualization best practices in Power BI, working with filters and slicers, Power BI publisher, 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.
In-person @ 32 Walker St, North Sydney, NSW- $385
- 1 Day
- Weekdays
- Intermediate
- Free Retake
-
Dynamic Web Training Power BI Advanced
Move into advanced data analytics and explore the latest Microsoft Power BI features in this intermediate-level, two-day course. Students learn how to perform advanced data manipulations and create advanced analytical models. Through hands-on learning, participants also explore topics like script visualization, report design, data analytics, and dashboard design.
In-person @ 32 Walker St, North Sydney, NSW- $990
- 2 Days
- Weekdays
- Advanced
- Free Retake
-
Sydney Community College Microsoft Office 2016: Excel Essentials
This 1-day Accessible Documents course was built to teach proficient InDesign users how to create accessible PDFs using Adobe InDesign and Adobe Acrobat. The course a range of InDesign and Acrobat concepts and tools, including an introduction to PDFs and why accessibility matters, various design considerations, best practices for generating an accessible PDF, and how to make an already existing PDF file more accessible.
In-person @ 2A Gordon St, Rozelle, NSW- $149
- 6 Hours
- Weekdays
- Beginner
showing 20 of 36 courses
Please sign in to save your favorite courses
Enter your email address below to create a new account or sign in with an existing account.