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.
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 business analyst toolkit.
Day one - SQL
SQL for data and business analysis
SQL basics and functions
Storing and grouping.
Day two – Excel, macros and visual basics
Excel formulas
Macros and reporting
Visual basics.
Day three - 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.
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.
Book a session
Sign up at UTS Open Website
Fee:
$1,495.00
Mode:
Online
Duration:
3 days
Meet the Expert
Matineh Pooshideh
Lead AI and Data Science Instructor
Matineh is a Lead Data Scientist at Domain, with a strong computer science and software engineering background. She has extensive experience in tutoring at university, both in her Bachelor's and Master of Research in the areas of Data Science and Software Engineering.
View Matineh ’s full profile here