Advanced Visualisations

DATA4100
Data Visualisation Software
Lesson 10
Interactive Workshop 4: Advanced Visualisations
and comparison of analytics and visualisation
platforms

COMMONWEALTH OF AUSTRALIA
Copyright Regulations 1969
WARNING
This material has been reproduced and communicated to you by or on behalf of Kaplan
Business School pursuant to Part VB of the Copyright Act 1968 (the Act).
The material in this communication may be subject to copyright under the Act. Any further
reproduction or communication of this material by you may be the subject of copyright
protection under the Act.
Do not remove this notice.

Lesson Learning Outcomes

1 Perform data modelling
2 Create a range of advanced data types
3 Interpret results

Business Problem
‡ Suppose that you are an analyst for a U.S. real estate company.
‡ You have performed some basic analytics and presented drill through
dashboards in order to provide the executives with initial insight
regarding sales.
‡ You have been asked to report to the board again and this time want to
impress them with advanced charts
‡
Today you will be learning how to create a range of charts that could be
used to summarise results and impress those who observe them

7RGD¶V’DWDVHW
‡ We have obtained Iowa real estate data for you to
explore and perhaps answer some of your questions
‡ 3OHDVHILQGWRGD¶VGDWDVHW³LRZDBKRXVHBSULFHVFVY´RQ
the KBS portal
‡ This dataset has a great range of variables, such as lot
area, sale price, type of heating, fences, etc.
/HW¶VVHHLIRXFDQJDLQLQVLJKWIURPWKLVGDWD
Creating Linear models
Data labels for Trend Lines
Changing axes ranges
Creating Trend Lines
Interpretation
‡ Take a moment to discuss
the interpretation of the
chart with your teacher and
peers
Q. Which houses seem to
keep their value? Why do you
think that is?

Charts with dual axes
Labels for charts with dual axes
Changing axes ranges
Interpretation
‡ Take a moment to discuss the
interpretation of the chart with
your teacher and peers
Q. How do you read this sort of
chart?
This Photo by Unknown Author is licensed under CC BYNC
Doughnut and Pie charts
and filters
Try a range of filters, e.g. top 20 neighbourhoods, top 10 subclasses, etc.
Filter out the top 5 neighbourhoods
Try different colours
Interpretation
‡ Take a moment to discuss the interpretation of the chart with
your teacher and peers
Q. How do the sale prices vary this time with subclass and
zone?
Q. Where are the largest lot sizes?
Q. Which neighbourhood are more affordable?
This Photo by Unknown Author is
licensed under
CC BY-NC
Adding custom visuals
Search for other charts
Search for more charts
Sunburst chart
Sunburst chart
Interpretation
‡ Take a moment to discuss the interpretation of the chart with
your teacher and peers
Q. What does the sunburst chart tell you about sales price for
building type and neighbourhood?
This Photo by Unknown Author is licensed under CC BY-NC-ND
Radar charts
This Photo by Unknown Author is licensed under CC BY
Interpretation
Q. How do the inner (blue) webs provide information?
Q. In which months were the houses most expensive?
Q. How does price vary per sales type?
Take a moment to discuss the interpretation of the chart with
your teacher and peers

Scatter charts with varying sized dots
Scatter trend lines
Creating Quadrants
Formatting Quadrants
Changing from sum to other
summary values, e.g. average

Interpretation
‡ Take a moment to discuss the interpretation of the chart with
your teacher and peers
Q. What can you gather from the quadrants of average lot area
versus median of lot frontage?
Q. Is there a lot of variation when you consider lot area,
frontage and prices?
This Photo by Unknown Author is licensed under CC BY
Scatter plots and clusters
Creating clusters
Specifying cluster numbers
Interpret this dashboard
Multivariate clusters
Multivariate clusters
Interpretation
‡ Take a moment to
discuss the
interpretation of the
chart with your teacher
and peers
Q. Can you interpret the
multivariate clusters chart?

Influence charts
Analysis of segments
Analysis of segments
Analysis of segments
Interpret your results
Composition chart
Expanding the composition chart
More expansion
More expansion
Sankey Chart
Interpret the Sankey Chart
Software comparison
‡ Many types of visualisation software
‡ Your own experience will enable you to see some differences
‡ Not all charts are in all software, however add-ons may be available
‡
Charts like that below and next pages (as well as the Gartner magic
quadrant) allows comparison
https://au.pcmag.com/cloud-services-1/48920/the-best-data-visualization-tools-for-2020
See also sponsored sites but beware of bias, e.g.
https://www.qlik.com/us/data-visualization/data-visualization-tools
Software comparison
https://www.softwarereviews.com/categories/business-intelligence-analytics
Software comparison
https://www.capterra.com/sem-compare/data-visualizationsoftware/?gclid=CjwKCAjw64eJBhAGEiwABr9o2IV6Ysoc2_ns4Z1USavhDVk
D0uhWBAGqTDkojrHqkjQPdTW3tV5UyRoC9kEQAvD_BwE

Advanced Visualisations

DATA4100
Data Visualisation Software
Lesson 10
Interactive Workshop 4: Advanced Visualisations
and comparison of analytics and visualisation
platforms

COMMONWEALTH OF AUSTRALIA
Copyright Regulations 1969
WARNING
This material has been reproduced and communicated to you by or on behalf of Kaplan
Business School pursuant to Part VB of the Copyright Act 1968 (the Act).
The material in this communication may be subject to copyright under the Act. Any further
reproduction or communication of this material by you may be the subject of copyright
protection under the Act.
Do not remove this notice.

Lesson Learning Outcomes

1 Perform data modelling
2 Create a range of advanced data types
3 Interpret results

Business Problem
‡ Suppose that you are an analyst for a U.S. real estate company.
‡ You have performed some basic analytics and presented drill through
dashboards in order to provide the executives with initial insight
regarding sales.
‡ You have been asked to report to the board again and this time want to
impress them with advanced charts
‡
Today you will be learning how to create a range of charts that could be
used to summarise results and impress those who observe them

7RGD¶V’DWDVHW
‡ We have obtained Iowa real estate data for you to
explore and perhaps answer some of your questions
‡ 3OHDVHILQGWRGD¶VGDWDVHW³LRZDBKRXVHBSULFHVFVY´RQ
the KBS portal
‡ This dataset has a great range of variables, such as lot
area, sale price, type of heating, fences, etc.
/HW¶VVHHLIRXFDQJDLQLQVLJKWIURPWKLVGDWD
Creating Linear models
Data labels for Trend Lines
Changing axes ranges
Creating Trend Lines
Interpretation
‡ Take a moment to discuss
the interpretation of the
chart with your teacher and
peers
Q. Which houses seem to
keep their value? Why do you
think that is?

Charts with dual axes
Labels for charts with dual axes
Changing axes ranges
Interpretation
‡ Take a moment to discuss the
interpretation of the chart with
your teacher and peers
Q. How do you read this sort of
chart?
This Photo by Unknown Author is licensed under CC BYNC
Doughnut and Pie charts
and filters
Try a range of filters, e.g. top 20 neighbourhoods, top 10 subclasses, etc.
Filter out the top 5 neighbourhoods
Try different colours
Interpretation
‡ Take a moment to discuss the interpretation of the chart with
your teacher and peers
Q. How do the sale prices vary this time with subclass and
zone?
Q. Where are the largest lot sizes?
Q. Which neighbourhood are more affordable?
This Photo by Unknown Author is
licensed under
CC BY-NC
Adding custom visuals
Search for other charts
Search for more charts
Sunburst chart
Sunburst chart
Interpretation
‡ Take a moment to discuss the interpretation of the chart with
your teacher and peers
Q. What does the sunburst chart tell you about sales price for
building type and neighbourhood?
This Photo by Unknown Author is licensed under CC BY-NC-ND
Radar charts
This Photo by Unknown Author is licensed under CC BY
Interpretation
Q. How do the inner (blue) webs provide information?
Q. In which months were the houses most expensive?
Q. How does price vary per sales type?
Take a moment to discuss the interpretation of the chart with
your teacher and peers

Scatter charts with varying sized dots
Scatter trend lines
Creating Quadrants
Formatting Quadrants
Changing from sum to other
summary values, e.g. average

Interpretation
‡ Take a moment to discuss the interpretation of the chart with
your teacher and peers
Q. What can you gather from the quadrants of average lot area
versus median of lot frontage?
Q. Is there a lot of variation when you consider lot area,
frontage and prices?
This Photo by Unknown Author is licensed under CC BY
Scatter plots and clusters
Creating clusters
Specifying cluster numbers
Interpret this dashboard
Multivariate clusters
Multivariate clusters
Interpretation
‡ Take a moment to
discuss the
interpretation of the
chart with your teacher
and peers
Q. Can you interpret the
multivariate clusters chart?

Influence charts
Analysis of segments
Analysis of segments
Analysis of segments
Interpret your results
Composition chart
Expanding the composition chart
More expansion
More expansion
Sankey Chart
Interpret the Sankey Chart
Software comparison
‡ Many types of visualisation software
‡ Your own experience will enable you to see some differences
‡ Not all charts are in all software, however add-ons may be available
‡
Charts like that below and next pages (as well as the Gartner magic
quadrant) allows comparison
https://au.pcmag.com/cloud-services-1/48920/the-best-data-visualization-tools-for-2020
See also sponsored sites but beware of bias, e.g.
https://www.qlik.com/us/data-visualization/data-visualization-tools
Software comparison
https://www.softwarereviews.com/categories/business-intelligence-analytics
Software comparison
https://www.capterra.com/sem-compare/data-visualizationsoftware/?gclid=CjwKCAjw64eJBhAGEiwABr9o2IV6Ysoc2_ns4Z1USavhDVk
D0uhWBAGqTDkojrHqkjQPdTW3tV5UyRoC9kEQAvD_BwE