BUSINESS ANALYTICS WITH SQL AND PYTHON​

SIM X RMIT

Course overview

Category

RMIT Online Series

Course date

08-08-2022 to 19-09-2022
05-09-2022 to 17-10-2022
26-09-2022 to 07-11-2022
10-10-2022 to 21-11-2022
07-11-2022 to 19-12-2022

Provider

RMIT

Course type

Instructor-Led

Course fee

(including 7% GST)

Non-Member Total Fee : $1,080.00
RMIT Alumni Total Fee : $918.00

Funding/Subsidy

UTAP Funding

Course Overview

Why study Business Analytics with SQL and Python 

Business analytics is the process in which data is obtained, cleaned, and presented by teams and organisations to drive useful predictions and insights. Two ways in which businesses do this is through SQL and Python. SQL, or Structured Query Language, is a query that extracts data from tables within a database. Python, on the other hand, is a programming language that has data analysis libraries built on top of it, allowing for data to be analysed and manipulated in order to tell compelling stories and drive business decisions.  

With the opportunity to work on your own data set, or with a data set provided, now’s the perfect time to roll up your sleeves and get hands on with SQL and Python. Develop the critical data wrangling, exploring, analysing, and communication of data skills that will make you highly desirable in the industry.  


Course benefits

What you'll learn

  • The data analytics process  
  • How to determine the right questions and right methods to address a business issue 
  • The wrangling, exploring, analysing, and communication of data 
  • Hypothesis testing and A/B testing for business 
  • An intro to SQL: How to obtain SQL databases, including basic and intermediate queries, joins, and aggregations 
  • An intro to Python: How to rest and manipulate data 
  • Utilise data libraries such as Pandas and NumPy 
  • Forecasting segmentation and classification 

Course outline

How it works

As part of this course, you will complete one final project; a slide deck presentation where you’ll build and apply a simple data analytics model to a business problem and demonstrate the following learning outcomes: 

  • Utilise SQL and Python to drive powerful analysis and predictions for your team or business 
  • Assess and implement data modelling, forecasting, and classification using introductory SQL and Python functions 
  • Build and apply a simple data analytics model to solve a defined business problem 

Duration

6 Weeks

Course runs

Date Time Venue Registration Closing Date Register
08-08-2022 to
19-09-2022
08.00 - 17.00 Online 25-07-2022
05-09-2022 to
17-10-2022
08.00 - 17.00 Online 22-08-2022
26-09-2022 to
07-11-2022
08.00 - 17.00 Online 12-09-2022
10-10-2022 to
21-11-2022
08.00 - 17.00 Online 26-09-2022
07-11-2022 to
19-12-2022
08.00 - 17.00 Online 24-10-2022

Who should attend?

Level 2 - Supervisor, Executive, & Emerging Managers
Level 3 - New Managers
Level 4 - Managers
Level 5 - Senior Managers & Directors
Level 6 - C-Suite

Programme leader

RMIT Instructor

Course fee

Programme Fee Amount (including 7% GST) Remarks
Non-Member Total Fee $1,080.00 -
RMIT Alumni Total Fee $918.00 -

Learning mode: Self-paced learning


Enquiries : Patricia Lee - 62489447 | patricialee@sim.edu.sg

professional-development