Data Visualisation Software

DATA4100

Data Visualisation Software

Lesson 1

Interactive, real time visualisation for business

Learning outcomes

1 Investigate Industry 4.0

2 Evaluate the application of visualisation software to

various business problems

3 Assess the capabilities of various software packages:

Tableau, Tibco, SAS, Power BI

4 Recognise how interactive and real-time

visualisations can improve business decision making

5 Speculate on applications of augmented/AI & virtual

reality

Note on software needed for

the course

You will need

• Power BI

https://powerbi.microsoft.com/en-us/get-

started/

• Tableau Public or trial version

https://public.tableau.com/en-us/s/download

What is driving the surge in

visualisation in business ?

• Drivers of the surge in visualisation in business are

1. Technology and real-time analytics

2. The realisation that big data can influence customer

service and business performance

3. Ease of interpretation (compared to reports and

spreadsheets)

https://www.sas.com/en_au/insights/big-data/data-visualization.html

https://quid.com/solutions/healthcare

Opening Activity: Context

• The Fourth Industrial

Revolution: AI and

Quantum Computing

(Information)

• Exponential Global shifts

As a group , watch the video on the fourth Industrial revolution

Q. What are the promises of the fourth industrial revolution,

i.e. what majors shifts are mentioned in the video?

Motivations

• According to Prof. Klaus Schwab Founder and Chairman of the World Economic Forum, the fourth industrial revolution will change

– Life and relations of individuals

– The way we conduct business due to real-time access to data

[https://www2.deloitte.com/us/en/insights/focus/industry-4-

0/overview.html?id=us:2el:3lk:4di_gl:5eng:6di&range=0/3/1/1/1/3/1/5/23/11/0:0,0/3/1/1/1/3/1/5/23/11/0:30#]

Industry 4.0

• Promises to combine digital technology and current advanced production and operations to create a digital enterprise.

• Features – Interconnected

– Automated

– Drives further action in the real world via analytics & communication

• How? Embedding the following in Business – IoT

– AI, Robotics and cognitive technology

– Quantum computing

– Nanotechnology

– Wearables

– Additive manufacturing

– Advanced materials

• Smart connected technologies change the way business understands information

This Photo by Unknown Author is

licensed under CC BY-SA

Industry 4.0 – User-centric Experiences

• Industry 4.0 is user-centric

• It is characterized by new patterns of consumer behaviour

• Thus companies must adapt by changing the way they “design, market, and deliver products and services”

• How?

– Using AI and Agile microservices enhancing user experiences

This Photo by Unknown Author is licensed under CC BY-SA-NC

Digital & Physical Reality Lifecycle

• Real-time access to data and business intelligence is

driven by the continuous and cyclical flow of information

and actions between the physical and digital worlds

• Intelligent Autonomous and Semi-Autonomous Systems –

AI (Machine Learning)

Physical Digital

Example: NASDAQ partners with

Sisense

Real-time Data

Human to Digital Interactions

Unstructured and structured data

have to be visualised

https://lawtomated.com/structured-data-vs-unstructured-data-what-are-they-and-why-care/

So what proportion

of each is being

generated?

Unstructured vs structured data

Visualisations – Key Aspects

• User Experiences

– Projection of Soft Power – Win hearts and minds

– Deliberately craft compelling user experiences and

Journeys through storytelling

– Narrative Intelligence

– User Experience Design

This Photo by Unknown Author is licensed under CC BY-

NC-ND

Visualisation Technologies

• Visualisation Technologies

– Current: PowerBI, Tableau, Spotfire, Splunk, Elasticsearch, etc…

– Data Streams:

• https://www.striim.com/

• https://www.arcadiadata.com/product/streaming-visualizations/

• https://www.zoomdata.com/

– In-coming: Virtual and Augmented Reality

• Visualisations are moving into the very phenomenon that Big

Data is capturing

• Graphics Processing Units (GPUs) have inbuilt AI

17

Review of Quadrant Analysis

•A scatter plot (or 2-dim matrix) divided into four quadrants

•Helps you locate data points with certain characteristics

•Example, x axis relates to difficulty to eat a particular fruit(difficult to easy)

•Y is a measure of taste (sour to sweet)

The quadrant suggests that because strawberries are sweet, they are easier to eat than lemons

http://meetingsift.com/quadrant-analysis/

• Peach

SWEET

SOUR

Difficult to eat Easy to eat

• Apricot

• Strawberry

• Pomegranate

• Lemon

• Water melon

•Banana

• Orange

• Lime • Green Apple

Gartner Magic Quadrant

• Ranking

Visualisations

Activity 1: Think –Pair – Share

• Form pairs and discuss the following

1. What drives real-time access to data and business intelligence

2. What are the key aspects of visualisation? Can you think of others?

Visualisation Software Applications

1. Kelly Services partnering with Tableau software

2. Mercedes-AMG Petronas Motorsport

partners with TIBCO Spotfire

3. 1-800 flowers.com partners with SAS software

See next slides

Business Application 1: Kelly

Services partner with Tableau

“Kelly Services continues to lead the staffing industry in business

intelligence by leveraging Tableau for talent supply chain management

and workforce solutions.”

• Business Problem: Kelly is a staffing company and refer to their

business as “Talent Supply chain management” . They pioneered

the temporary help industry in 1946. They wanted to transition from

general reporting to analytics, optimize operations, perform

workforce planning, benchmark pay rates and visualize data.

• Solution: Kelly services partnered with tableau to build a data

warehouse create analytics dashboards and make their insights

more transparent.

https://www.persolkelly.com.au/about/

Business Application 1:Kelly’s

client data

https://www.tableau.com/solutions/services-analytics#content-162520

Business Application 1: Tableau

environment for Kelly Services

https://www.tableau.com/solutions/services-analytics#content-162520

Business Application 2:

Motor sport and Spotfire • Business Problem: Mercedes-AMG Petronas Motorsport (MAPM)

makes Formula One™ racing cars. MAPM wanted to make the fastest

car from many choices.

• Solution: MAPM partnered with TIBCO Spotfire.

• Thousands of data points per second per racing car and track are

analysed, e.g. lap times, tyre wear, tyre grip

• Spotfire Machine learning algorithms used for a formula one

simulator

• Cars now optimised for performance

• See video next slide https://www.tibco.com/customers/mercedes-amg-petronas-motorsport

Petronas – Spotfire partnership

video

Business Application 3: 1-800

Flowers.com and SAS • Business Problem: 1-800 flowers.com and delivers flower

arrangements to customers. The company wanted to improve their

customer experience.

• Solution: 1-800 flowers.com partnered with SAS to optimise customer

experience using

• SAS data management and analytics

• SAS marketing automation

https://www.sas.com/en_au/customers/1-800-flowers-ma.html

https://www.1800flowers.com/

Activity 2: Which data?

• Form groups & discuss what type of data each application

might be using.

• Q1: How would unstructured data be of use in these

cases?

• Q2: What value add did each software have in

relation to the business?

Visualising conversational (unstructured) data

A well known large pharmaceutical company wanted to

understand how conversations between sales representatives

and Dermatologists were changing over time, with reference

to a particular treatment for a chronic skin condition.

Q1. What type of data would they need to process

and visualise?

Q2. How could they source this data?

Desktop Software

Microsoft Excel

• Excel enables you to plot various charts,

graphs, models and histograms

• The user highlights specific groups of cells

Microsoft Power BI

• Business analytics service

• Provides interactive visualisations &

business intelligence, reports and

dashboards

• Integrates with Excel and Office 365.

29

SAS software

• Originally just statistical software

• Modified for advanced analytics and

visualisation (Artificial intelligence &

Internet of Things)

30

Desktop Software

This Photo by Unknown Author is

licensed under CC BY

https://www.sas.com/en_au/home.html

TIBCO Spotfire

• Provides advanced data analytics and visualisation

• Enables sharing and embedding of dashboards

Tableau

• Capable of creating relational databases, cubes (multi-dimensional data), cloud databases, and spreadsheets.

• Generates interactive charts from the databases, etc.

• Graphs can be combined into dashboards and shared over a computer network or the internet.

31

Desktop Software

Activity 3: Tableau overview

• Watch the video on Tableau at

https://www.youtube.com/watch?v=YfE9jBq002s

Q: What user related features, e.g. drag and drop variable

names to get graphs, are mentioned in the video?

33

• As a group, go to the following website on your computer

• https://www.g2.com/categories/business-intelligence-platforms

• Click on “View Grid” and observe the comparison grid for different business intelligence software.

• Identify the software by passing your cursor over the icons

• Experiment with the view menu on the left (e.g. live versus trending)

Q1. Where are SAS, Spotfire,

Power BI and Tableau placed on the grid?

Q2. Investigate a contender on the internet.

Suggest from first impression how it could be used to build a supply chain related dashboard.

• Share with the class

Activity 4: Interactive comparison

of visualisation software

Watch

Three Applications of Real-time Data

Visualisations

• https://www.pubnub.co

m/developers/realtime-

data-streams/

• https://www.striim.com/

What are the applications in this video?

35

Activity 5: Real-time visuals

1. Click on some of the links below to see some real-time

visualisation applications.

2. Give the visualisation a rating between 1 and 10 in terms

of how effectively the visualisation represents the

data.

Global weather conditions visual updates every three hours

(https://earth.nullschool.net/)

Deviant art activity (https://world.deviantart.com/)

World births and deaths (https://worldbirthsanddeaths.com/)

• Report back to class

Original source: https://mashable.com/2014/01/08/data-visualizations-real-time/

Interactive visualisations LO3

• Interactive visualisations allow you to investigate parts

of the visualisation, e.g.

• turn a map around

• click on an chart and see a table behind it or connection to

another chart

• select particular features of a chart and see summary data

• Boost Labs build interactive visualisations

Activity 6: Interactive visualisation:

Mapping the flow of global trade • Click on the link below to access an interactive visual

showing the flow of goods trade around the world.

• https://www.visualcapitalist.com/interactive-mapping-

flow-international-trade/ 1. What goods are being traded with

Australia?

2. How many different dimensions of

information are being represented?

3. What business decisions can be

made based on this visualisation?

Automated Visualisation

• Artificial intelligence can be used to turn data into

visualisations.

• Algorithms are trained on data then output a visualisation of

the data

• For example, AI can generate product designs

https://towardsdatascience.com/data2vis-automatic-generation-of-data-visualizations-using-

sequence-to-sequence-recurrent-neural-5da8e9d3e43e

https://medium.com/plotly/data-visualization-for-artificial-intelligence-and-vice-versa-a38869065d88

This Photo by Unknown Author is licensed under CC BY

Generative (machine) Design

• Using AI to create new designs of objects and visualise

them

• Designer informs the program of the purpose for designing

the object

• Many different designs are generated

• User makes a choice

• The example in the video below relates to vehicle part

design

• https://www.youtube.com/watch?v=vtfNlWEJxw4

Example: AI - Art

Using AI to help Visualise high

dimensional data • AI algorithms help visualise high dimensional data

• Learn form the data

• Form clusters of similar objects

• The video below explains how

• https://www.youtube.com/watch?v=wvsE8jm1GzE

Augmented reality for business

• Augmented reality allows you to interact with the

visualisation as if it were a real environment

• The computer generates perceptual information, e.g. a

virtual world we can see, smell, hear and touch

• Applications

• Marketing

• Job recruitment

• Occupational health and safety

Augmented Reality Business

• Augmented reality allows you to interact with the

visualisation as if it were a real environment

• The computer generates perceptual information, e.g. a

virtual world we can see, smell, hear and touch

• Applications

• Marketing

• Job recruitment

• Occupational health and

safety

Example: HoloLense Business

As individuals,

1. List four different business problems and software or

technology from the lecture that could be used to solve the

problem

2. List four different types of visualisations

3. Review previous slides to match the business problem,

software and visualisations

4. Review your answers in week 4

Exit Activity (if time)