Business Analyst Toolkit

University of Technology Sydney

How long?

  • 3 days
  • online

What are the topics?

University of Technology Sydney

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Read more about Business Analytics

Business Analytics courses will introduce you to a popular and diverse profession. A business analyst is a specialist in many IT fields as well as in ...

Who should attend

  • 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.

About the course

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.

This course is a collaboration between UTS and ITIC.

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.

Experts

Ava Assadi

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 candi...

Business Analyst Toolkit at University of Technology Sydney

From  AUD 1 495$1,122

Something went wrong. We're trying to fix this error.

Thank you for your application

We will contact the provider to ensure that seats are available and, if there is an admissions process, that you satisfy any requirements or prerequisites.

We may ask you for additional information.

To finalize your enrollment we will be in touch shortly.

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Read more about Business Analytics

What will you learn from Business Analytics courses? First of all, you will learn about the profession of a business analyst, his duties, and what such a specialist does. You will get various soft skills, such as organizing teamwork, for example, acc...

Because of COVID-19, many providers are cancelling or postponing in-person programs or providing online participation options.

We are happy to help you find a suitable online alternative.