Scribd
Upload
132 views7 pages

Data Visualization Techniques Guide

Data visualization presents data visually, enabling decision-makers to easily understand concepts and patterns. Interactive visualization allows drilling down into charts for more detail. Common chart types include histograms, pie charts, and line charts. Dashboards amalgamate pivot charts and tables to facilitate instant data analysis through dynamic filtering and drilling down. Slicers act as quick filters for pivot charts and connect data points across charts to enable multivariate analysis.

Uploaded by

Mukesh Rana
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
132 views7 pages

Data Visualization Techniques Guide

Data visualization presents data visually, enabling decision-makers to easily understand concepts and patterns. Interactive visualization allows drilling down into charts for more detail. Common chart types include histograms, pie charts, and line charts. Dashboards amalgamate pivot charts and tables to facilitate instant data analysis through dynamic filtering and drilling down. Slicers act as quick filters for pivot charts and connect data points across charts to enable multivariate analysis.

Uploaded by

Mukesh Rana
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Drawing Inferences From the Data

Session 2 Data Visualisation


DATA VISUALISATION
Why visualise data?

Data Visualisation is the presentation of


data in a pictorial or graphical format which
enables decision-makers to see analytics
presented visually, so they can grasp difficult
concepts or identify new patterns.

With interactive visualisation, you can


take the concept a step further by using
technology to drill down into charts
and graphs for more detail,
interactively changing what data you
see and how it’s processed.
DATA VISULATION
Categorisation

Pivot charts

01
Dynamic tables used as the
backend framework for final
dashboards.
Charts

02
Primary data visuals
might be created from
static data table or from
Dashboards
the dynamic pivot table.

03
An amalgamation of pivot
charts and tables that aids in
instant analysis of data due to
its dynamic and drill down
nature.
CHARTS
Categorisations

HISTOGRAM
A histogram is a plot that lets
you discover, and show the
PIE CHART
underlying frequency A Pie Chart is a type of graph
distribution (shape) of a set of that displays data in a circular
continuous data. graph. The pieces of the graph
are proportional to the fraction
of the whole in each category.

Complex Charts
Any one form one visualisation LINE CHARTS
might not be enough to Line charts are used to display
comprehend a data set, a trends over time. Use a line
combination of these graphs and chart if you have text labels,
other visual elements form dates or a few numeric labels
‘complex’ graphs and they might on the horizontal axis.
be used to understand the nature
of the data.
DASHBOARD

An Excel dashboard is one-pager (mostly, but not always


necessary) that helps managers and business leaders in
tracking key KPIs or metrics and take a decision based on it. It
contains charts/tables/views that are backed by data.
SLICERS
Quick Filters and Connections

Quick Filter
1 The main purpose of any slicer is to act as a quick
filter for any pivot chart and graph.

Data Connections
2 Helps to connects all the data points across the
charts.

Multivariate Analysis
3 By making unique selections on the slicers,
multivariate analysis across categories is possible.
Example: Sales under a particular manager.

You might also like