cart Cart
Your cart
Your cart is empty

Browse courses to find something that interests you.


Business Analyst Toolkit

Learn about the key tools, platforms and functions required to work in business analyst roles – this short course focuses on the tools needed for business metric analysis and report building.

About this course

Business Analyst Toolkit is a collaboration between UTS and ITIC.ITIC logo[1].png

This short course will provide a foundational understanding of the key areas and tools that all business analysts need to help start the journey in their business analyst careers.

You will navigate the use of databases, as well as prepare to use data and data analytics tools to create business analysis reports showing key metrics and data.            

Course structure

This course comprises three modules. Each module will be run as a one-day, small-group virtual workshop, focusing on one specific tool in the data analyst toolkit.

Day 1 - SQL

  • SQL for data and business analysis
  • SQL basics and functions
  • Storing and grouping.

Day 2 – Excel, macros and visual basics

  • Excel formulas
  • Macros and reporting
  • Visual basics.

Day 3 - Power BI

  • Connect to data with Power BI
  • Data manipulation and visualisations
  • Data analysis expressions (DAX).

Learning outcomes

By successfully completing this course, participants will gain an understanding of data and how to utilise it in effective ways through SQL, Excel and Power BI, to create reports used by business to display key data and metrics.

Participants will specifically be able to:

  • Analyse databases and extract key data
  • Present data in a structured way
  • Apply advanced Excel techniques
  • Build reports and data visualisations in Power BI.


To participate in this online course, you will need a personal computer with adequate internet access, web conferencing capability and an operating system with a web browser compatible with Canvas, Zoom and Microsoft Teams.

Enrolment conditions

COVID-19 response 

Who is this course for?

This course is suitable for:

  • Recent graduates looking to expand their skills
  • Professionals who would like to start their journey in data and business analytics
  • Anyone looking for a quick and effective way to upskill into a business analyst role.        






3 wks

Join Waitlist

Have a question ?
We use cookies

We use cookies to help personalise content, tailor and measure ads, plus provide a safer experience. By navigating the site, you agree to the use of cookies to collect information. Read our Cookie Policy to learn more.