cart Cart
Your cart
Your cart is empty

Browse courses to find something that interests you.

Register search
SHORT COURSE

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

This course 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.

Requirements    

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.        
$1,495.00

START DATE

11 November

MODE

Online

DURATION

3 wks

Meet the Expert

Ava Assadi

Ava Assadi
Lead AI and Data Science Instructor

Ava is an experienced data analyst, skilled in research, machine learning, data mining, recommender systems and computer vision.  She has extensive experience in teaching subjects such as Python, database, machine learning, deep learning and data visualisation tools.

Ava is currently a PhD candidate, engaging in the research area of computer vision, with the objective of her research being to develop a new algorithm for identifying brain tumours in MRIs.

More Less

Book a session

Thu 11 Nov 2021 -
Thu 25 Nov 2021
Expert: Ava Assadi
  • 11, 18, 25 November 2021, 9am-5pm
  • Online
  • 3 sessions, 24 hours total
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.

loading