Course Detail(DGT004ET : Data Visualisation for Accountants and Auditors: Digital techniques to enable better decision making)

DGT004ET : Data Visualisation for Accountants and Auditors: Digital techniques to enable better decision making

7.00 CPE Hours (Others)
Classroom
In Collaboration with:  

(Course formally known as: Business Decision through Data Visualisation)

Programme Objective
 
To empower senior executives and corporate professionals with knowledge of popular data visualisation tools by providing them with classroom exercises based on real life situations.

Programme Outline


Data has transformed the world we live in. More and more companies are using data analytics to excel in the market place. As human minds can process visual objects more easily than data on spreadsheets and reports, data visualization is an effective way to convey complex concepts and identify new patterns in data.
 
This course will take you through how data visualisation can help to analyse data. We will provide step by step guidance during our hands on exercises covering popular data visualisation tools in the market.
 
Following the Chinese adage “I hear and I forget; I see and I remember; I do and I understand”, this course allows you to learn by doing. We will also share with you experiences and case studies by practitioners bringing alive real life scenarios.
 
We will address questions such as:

  • How can data visualisation create impact by uncovering patterns and trends in the data?
  • What are the visual analytic tools available?
  • How can I learn the basics of the key features in these tools?
  • What are practical hints and tips in data visualisation?

 
The benefits this will provide you are:

  • Recognise the application of data visualisation in business settings
  • Hands on experience on data visualisation tools
  • Recognise practical hints and tips on data visualisation
  • Improve use of visualisation to enhance your decision making

 
An overview of Data Visualisation for data analytics

  • Recognise how data visualisation helps in analytics through exploratory analysis
  • Recognise the landscape of tools available in the market for data visualisation
  • Self service analytics with ‘slide and dice’ capabilities for impactful communication
  • Leading practices in data visualisation

 
Tips and tricks using Excel Charts

  • An overview of key features of Excel Charts including
    • Using the ‘recommended charts’
    • Chart level filters
    • Combination charts
  • Hands on exercises covering the above and more

 
Intro to PivotCharts using Microsoft Power Pivot

  • An overview of key features of PivotCharts including:
    • Creating charts from multiple tables (sheets)
    • Unravelling the power of Data Slicers
    • Say goodbye to complex ‘vlookups’ and ‘index-match’
  • Hands on exercises using PowerPivot PivotCharts
    • Introducing Table joins using PowerPivot
    • Advanced PivotCharts

 
Intro to Data Visualisation tools: Power BI, Tableau and QlikView

  • Learn how to tell a story using visual analytics through the use of powerful dashboards and filters
  • Create interactive Dashboards on using Data Linking on Pages – a new way to draw insights from your data
  • Hands on exercises:
    • Create good looking charts and graphs through simple drag and drop of variables
    • Built in interactivity between different charts on a consolidated dashboard
    • Drill down techniques to quickly understand trends & patterns that exist within your data – however voluminous it is
    • Use of geographical location mapping
    • Dashboards as part of story telling

 
Additional real life examples

  • Real life examples from data practitioners covering a number of industries and business settings

Training Methodology
 
Workshop with group discussion
 
Closing Date for Registration

1 week before programme or until full enrolment

Intended For

Finance and audit professionals and any other professionals keen to learn how data visualisation can help to spot trends, anomalies or any pattern hidden within the data. Hands on exercises allow participants to compare and contrast the most popular data visualisation tools in the market today.

Competency Mapping

Others = 7.00 Hours

Schedule & Fees

Date & Time

18 Mar 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 585.00
For Non-Members: $ 642.00

Programme Facilitator(s)

Loo Soo Kiat
Raj Balaraman

Venue

Marina One, 7 Straits View,
East Tower,
Singapore 018936

Date & Time

20 May 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 585.00
For Non-Members: $ 642.00

Programme Facilitator(s)

Loo Soo Kiat
Raj Balaraman

Venue

Marina One, 7 Straits View,
East Tower,
Singapore 018936

Date & Time

12 Nov 2019 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Loo Soo Kiat
Raj Balaraman

Date & Time

22 Aug 2019 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Loo Soo Kiat
Raj Balaraman

Date & Time

04 Oct 2018 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Loo Soo Kiat
Raj Balaraman

Testimonial

Funding

No funding Available!

Programme Facilitator(s)


Loo Soo Kiat
Director, PwC Singapore

Soo Kiat has over 12 years of experience in providing advisory services to clients primarily in the Technology, Media and Telecommunications industry on matters ranging from strategy to execution.

Soo Kiat is focused on solutions that are underpinned by data and analytics, combined with his deep industry experience  to derive insights with impact.
He has worked in the US and Australia, and was previously an internal auditor at a major telecommunications  service provider in Singapore. 

Raj Balaraman
Senior Manager, PwC Singapore

Raj brings his experience from helping clients on data advisory engagements to enable them to maximise their investments in system and data tools. 

He has worked in India, UK and Singapore over the last 14 years on a variety of engagements including the creation of a data analytics course for a leading local bank in Singapore and supporting internal audit & external audits using data tools and techniques.
 

(Course formally known as: Business Decision through Data Visualisation)

Programme Objective
 
To empower senior executives and corporate professionals with knowledge of popular data visualisation tools by providing them with classroom exercises based on real life situations.

Programme Outline


Data has transformed the world we live in. More and more companies are using data analytics to excel in the market place. As human minds can process visual objects more easily than data on spreadsheets and reports, data visualization is an effective way to convey complex concepts and identify new patterns in data.
 
This course will take you through how data visualisation can help to analyse data. We will provide step by step guidance during our hands on exercises covering popular data visualisation tools in the market.
 
Following the Chinese adage “I hear and I forget; I see and I remember; I do and I understand”, this course allows you to learn by doing. We will also share with you experiences and case studies by practitioners bringing alive real life scenarios.
 
We will address questions such as:

  • How can data visualisation create impact by uncovering patterns and trends in the data?
  • What are the visual analytic tools available?
  • How can I learn the basics of the key features in these tools?
  • What are practical hints and tips in data visualisation?

 
The benefits this will provide you are:

  • Recognise the application of data visualisation in business settings
  • Hands on experience on data visualisation tools
  • Recognise practical hints and tips on data visualisation
  • Improve use of visualisation to enhance your decision making

 
An overview of Data Visualisation for data analytics

  • Recognise how data visualisation helps in analytics through exploratory analysis
  • Recognise the landscape of tools available in the market for data visualisation
  • Self service analytics with ‘slide and dice’ capabilities for impactful communication
  • Leading practices in data visualisation

 
Tips and tricks using Excel Charts

  • An overview of key features of Excel Charts including
    • Using the ‘recommended charts’
    • Chart level filters
    • Combination charts
  • Hands on exercises covering the above and more

 
Intro to PivotCharts using Microsoft Power Pivot

  • An overview of key features of PivotCharts including:
    • Creating charts from multiple tables (sheets)
    • Unravelling the power of Data Slicers
    • Say goodbye to complex ‘vlookups’ and ‘index-match’
  • Hands on exercises using PowerPivot PivotCharts
    • Introducing Table joins using PowerPivot
    • Advanced PivotCharts

 
Intro to Data Visualisation tools: Power BI, Tableau and QlikView

  • Learn how to tell a story using visual analytics through the use of powerful dashboards and filters
  • Create interactive Dashboards on using Data Linking on Pages – a new way to draw insights from your data
  • Hands on exercises:
    • Create good looking charts and graphs through simple drag and drop of variables
    • Built in interactivity between different charts on a consolidated dashboard
    • Drill down techniques to quickly understand trends & patterns that exist within your data – however voluminous it is
    • Use of geographical location mapping
    • Dashboards as part of story telling

 
Additional real life examples

  • Real life examples from data practitioners covering a number of industries and business settings

Training Methodology
 
Workshop with group discussion
 
Closing Date for Registration

1 week before programme or until full enrolment

Intended For

Finance and audit professionals and any other professionals keen to learn how data visualisation can help to spot trends, anomalies or any pattern hidden within the data. Hands on exercises allow participants to compare and contrast the most popular data visualisation tools in the market today.

Competency Mapping

Others = 7.00 Hours

Programme Facilitator(s)

Loo Soo Kiat
Director, PwC Singapore

Soo Kiat has over 12 years of experience in providing advisory services to clients primarily in the Technology, Media and Telecommunications industry on matters ranging from strategy to execution.

Soo Kiat is focused on solutions that are underpinned by data and analytics, combined with his deep industry experience  to derive insights with impact.
He has worked in the US and Australia, and was previously an internal auditor at a major telecommunications  service provider in Singapore. 
Raj Balaraman
Senior Manager, PwC Singapore

Raj brings his experience from helping clients on data advisory engagements to enable them to maximise their investments in system and data tools. 

He has worked in India, UK and Singapore over the last 14 years on a variety of engagements including the creation of a data analytics course for a leading local bank in Singapore and supporting internal audit & external audits using data tools and techniques.
 

Upcoming Schedule

Date & Time

18 Mar 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 585.00
For Non-Members: $ 642.00

Programme Facilitator(s)

Loo Soo Kiat
Raj Balaraman

Venue

Marina One, 7 Straits View,
East Tower,
Singapore 018936