Duration: 2-days | Course Fee: $1,680 + GST
This two-day Data Analytics & Business Intelligence course covers data analysis techniques which are effective for use in business intelligence. Make strides in your career by upskilling with one of the most in-demand skill sets, data analytics.
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 and Business Intelligence technologies and techniques used in organisations to support a wide range of business decisions ranging from operational to strategic.
A key component of this course is how an organisation can utilise the massive amounts of data that is now available to build an effective Business Intelligence and Data Analytics strategy. Therefore, we present how an organisation can transform the operational transactional system data and other data sources into a data warehouse (data mart) to produce an effective Business Intelligence and Data Analytics platform and strategy.
Background in programming, database or statistics is not required for this short course nor are there any prerequisites. This is a hands-on course where you use your laptop (or hire one from us) to practice using some BI tools to access, develop, analyse and report on internal and external data sets.
To support the social distancing measures currently in place due to the COVID-19 pandemic, you can now attend this course remotely.
The course will still be practical, interactive and delivered live by senior instructors with 15 – 25+ years’ experience with the skills to make the intensive learning experience interesting and enjoyable.
Various additional measures to maximise the remote training experience have also been experimented, planned and incorporated. Find out more about practical training delivered remotely (live).
This Data Analytics course is suitable for:
- Business professionals who work with Data Analysts and would like further clarity on data analytics concepts
- New Data Analysts, Business Intelligence Analysts or Data Scientists who are looking for better ways to understand and visualise data and make data prediction
- People who are interested in Business Intelligence and Data Analytics but do not come from a technical background
- Professionals who need to work with and understand data within the context of their organisation
This Data Analytics and 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 Desktop), making it relevant to business professionals who want to use business intelligence to support informed business decisions.
This short course is an excellent introduction to data analytics and suitable for professionals interested in transitioning to the following roles:
- Analytics Manager
- Business Analyst
- Business Intelligence Specialist
- Computer System Analyst
- Data Analyst
- Data Scientist
- Information Analyst
- Information Manager / Information Officer
- Market Research Analyst
- Management Analyst
- Market Analyst
- Predictive Modeller
Business Intelligence comprises the strategies and technologies used by enterprises for the data analysis of business information to allow managers to make effective decisions. This is a hands-on course that covers Tableau Desktop as a tool to visualise information.
In this Data Analytics and Business Intelligence course you will learn:
- Understand how transaction processing data drives Business Intelligence solutions
- Recognise how Tableau can provide an information visualisation platform to your organisation
- Understand 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 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. Within the course, we cover the use of Tableau Desktop to provide a better understanding of how to effectively visualise the information within an organisation.
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.
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
- Introduction to SQL
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
- Big Data technologies – Hadoop
Data science and 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 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. Therefore, this course will propel you to the forefront by providing knowledge and experience in this rapidly growing area.
You can start your career in data analytics or data science by working through data visualisation, data cleaning and data design topics.
COURSE DATES & BOOKINGS
|Remote Delivery||11 - 12 February 2021||Open|
|Group Booking||Flexible Dates & Hours||Open|
|Remote Delivery||14 - 15 December 2020||Closed|
Course hours during daylight saving time (4 October 2020 – 4 April 2021):
- 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)
Other locations / time zones? Convert to your time zone.
We train professionals from these Australian organisations and more: