Data Analytics & Business Intelligence Training Course Logo

DATA ANALYTICS & BUSINESS INTELLIGENCE TRAINING

Data Analytics & Business Intelligence Training endorsed by IIBA Program ID: E47903-029 | PD Hours/CDU:14

Duration: 2 days | Instructor-Led | Course Fee: $1,680 + GST


Join this intensive Data Analytics & Business Intelligence course and make strides in your career by upskilling with one of the most in-demand skill sets in 2021.

Organisations are now developing strategies to understand and analyse their data to present information to help executives, managers and end users to make informed business decisions.

In this course, you will discover some of the Data Analytics / Business Intelligence technologies and techniques used in organisations to support a wide range of business decisions ranging from operational to strategic.

This is a hands-on course where you practice using some BI tools to access, develop, analyse and report on internal and external data sets.

With strong focus on practicality, the group size is limited to 12 and you will be guided by 1 to 2 instructors, each having 15 – 25+ years’ experience. With the small group size you may be guided a bit more closely or you may be given more challenging tasks depending on your level of experience.

Course Outline
The main BI tool used on this course is Tableau, but you should be able to translate the knowledge learned to other BI tools such as Power BI.

💡 The emphasis of the course is not on how to use a particular tool, but rather on how to understand data. It is more about exploring what questions can be asked for different types of data to extract useful information, rather than how to use a particular tool to get to an answer.

Module 1 – Overview

  • The Road to Business Intelligence and Data Analytics
  • Getting Started Using Tableau

Module 2 – Design of Transaction Processing Systems and Their Data

  • Transactions, Database and Database Management System
  • ACID Properties

Module 3 – Modelling for Business Intelligence and Data Analytics

  • Conceptual and Logical Model
  • ER (Entity Relationship) Modelling

Module 4 – Relational Model

  • Simple Relational Model
  • Physical Table Model
  • Normalisation

Module 5 – The Demand for Analytical Process

  • Information Types, Levels, Formats and Granularity
  • The Data Warehouse Approach and Architecture
  • Multi-dimensional Data Models

Module 6 – Dimensional Modelling

  • Facts, Dimensions and Hierarchies
  • Star and Snowflake Schemas
  • Summary Tables
  • Aggregating Data using SQL

Module 7 – Dimension Dynamics

Module 8 – ETL (Extract, Transform and Load)

  • The ETL Process and Cycle
  • Data Validation
  • Data Cleaning, Error Tracking, Data Quality Problems
  • Data Auditing
  • Data Publishing

Module 9 – Business Intelligence and Business Analytics

  • Business Intelligence vs Business Analytics
  • Software and Tools for BI / BA

Module 10 – Big Data

  • Big Data in Business Intelligence and Business Analytics
What is the Training Like?
This is a hands-on short course where most modules start with a trainer running a presentation interactively, followed by discussions and case-study-based exercises.

For most exercises you will break out into small groups of 3-4 people, creating the opportunity to exchange ideas with other keen learners.

Running in small groups, there is plenty of opportunity for questions and discussions. For questions that are not directly related to the course topics, the trainer(s) may schedule a time during one of the breaks to answer them, to ensure your questions are answered while keeping the course on track.

In line with the working-from-home trend, you can now also attend this course remotely. The course will still be practical, hands-on, interactive and delivered live by a senior instructor with 15 – 25+ years’ experience with the skills to make the intensive short course interesting and enjoyable.

Find out more about practical training delivered remotely (live).

Who Are the Trainers?
Eligibility requirements to become an IRM Training trainer: 

  • A minimum of 15 years’ business analysis experience in Australia.
  • The ability to demonstrate in-depth knowledge in the real-world application of the course topics.
  • Driven by the passion to help develop others.
  • Excellent communication, presentation and people skills.
  • A good sense of humour! You can absorb and retain more knowledge when the training is fun!

IRM Training trainers have worked in / with a diverse range of industries and government departments. Some also came from academic background as lecturers at Australian leading universities, on top of their 15+ years’ hands-on experience.

Course Endorsement / Certification

This course is endorsed by the International Institute of Business Analysis (IIBA®). Upon completion of this course you will receive a Certificate of Completion, awarding you 14 CDU / Professional Development Hours (PD Hours).

For more information about PD Hours and certification in relation to this business analyst course, please refer to the Business Analyst Certification page.

Is This the Right Course for You?

This Data Analytics course is suitable for:

  • Professionals who need to work with and understand data within the context of their organisation.
  • Business Analysts (or other similar roles) who are looking to specialise / transition into the Data Analytics / Business Intelligence field.
  • Business professionals who work with Data Analysts and would like further clarity on data analytics concepts.
  • People who are interested in Business Intelligence and Data Analytics but do not come from a technical background.

This Data Analytics & Business Intelligence course addresses the needs of professionals who want an overview of data analytics and business intelligence as well as developing usable skills applicable to the everyday work environment. Moreover, you will learn methods for manipulating and analysing data sets with modern tools (e.g.: Tableau, Power BI), making it relevant to business professionals who want to use business intelligence to support informed business decisions.

Learning Outcomes
Business Intelligence comprises the strategies and technologies used by enterprises for the data analysis of business information to allow managers to make effective decisions.

In this Data Analytics & Business Intelligence course you will learn:

  • How data drives Business Intelligence solutions
  • How to use BI tools (such as Tableau or Power BI) to provide an information visualisation platform to your organisation
  • Data modelling for Data Analytics and Business Intelligence solutions
  • Understand the Extract, Transform and Load (ETL) process for a Data Warehouse
  • Discern and develop data quality and data cleaning strategies
  • Understand data architecture – data warehouses and data marts
  • Interpret and develop Dimensional Modelling techniques and approaches
  • Understand data visualisation techniques and approaches
  • Understand the basic concept of Big Data.

This is a practical short course that will walk you through real-world scenarios and get you practicing data cleaning and analysing during the course.

You will develop the skills to collect, use and transform data into information. This information can help you make strategic decisions whilst weighing risk in business and you will walk away with a diverse set of skills which can be applied to various business and technology problems.

The ability to work with data for organising, analysing and interpreting information will make you invaluable to government and businesses organisations in Australia.

Above all, it is our aim to instill the confidence in your new skills to be able to immediately apply your knowledge in the workplace.

Industry & Careers

Data analytics is booming world-wide as businesses come up to speed with data being the foundational driver of the digital age. Consequently, there are massive amounts of data amassing every minute and skilled data analytics / Business Intelligence professionals are in high demand across all industries globally.

Most importantly, the demand for data analysts comes from the struggle to find increasingly skilled professionals who can extract useful insights and business value from data.

This course will propel you to the forefront by providing knowledge and experience in this rapidly growing area.

What Past Attendees Said

It was very interesting and really took you through the process from start to finish. – Business Analyst, Australian Electoral Commission

Engaging, relatable to my role. Can apply the skills & knowledge to my role.” – Data Analyst, Energy Queensland Limited

Very pragmatic approach. Very experienced instructor.” – Enterprise Architect – Victorian Managed Insurance Authority

Enjoyable & interesting course. Plenty of knowledge passed on by instructor.” – Marketing Analyst, CSG Limited

It’s a good course suitable for a good range of audiences.” – Research & Evaluation Officer – Latrobe Community Health Service

Can see practical applications from this course to work & even home life. Good information to develop business case to bring organisations into the 21 century!!” – General Manager – RHealth Limited

Read more testimonials

Related Courses

Related courses to Data Analytics & Business Intelligence:

 

COURSE DATES & BOOKINGS

LocationDate 
Anywhere - Remote Delivery9 - 10 March 2022
Group Booking - Remote DeliveryFlexible Dates & Hours
Your Office - In PersonFlexible Dates & Hours
AdelaideSelect one of the options above
BrisbaneSelect one of the options above
CanberraSelect one of the options above
MelbourneSelect one of the options above
PerthSelect one of the options above
SydneySelect one of the options above

Course hours during daylight saving time (3 October 2021 – 3 April 2022):

  • AEDT: 9:00am – 5:00pm (ACT, NSW, TAS, VIC)
  • ACDT: 8:30am – 4:30pm (SA)
  • AEST: 8:00am – 4:00pm (QLD)
  • ACST: 7:30am – 3:30pm (NT)
  • AWST: 6:00am – 2:00pm (WA)

Course hours during standard time: 9:00am5:00pm AEST.

For other locations or time zones, Convert to your time zone.

Need more information?
Contact Us
Not ready to book yet?
Remind Me

We train professionals from these Australian organisations and more:

IRM Clients