perceptive analytics - creating compelling dashboards
DESCRIPTION
TRANSCRIPT
Creating Compelling Dashboards
Chaitanya Sagar [email protected] 646.583.0001
Data Analytics Spreadsheet Solutions |
2
New York Hyderabad San Bruno Boston
Analytics Spreadsheet
Solutions
Our Services
3
Spreadsheet Applications Contract Negotiation Litigation Modeling Decision Support Tools
Dashboards Reporting Simulations Financial Modeling
Analytics Spreadsheet
Solutions
Data Visualizations Marketing Marketing Mix Modeling Price Promotion Analysis Catalogue Optimization Segmentation Web Analytics Churn Analysis
Risk Management Credit Risk Management Liquidity Risk Management Capital Allocation Analysis Collateral Management Fraud Detection
Supply Chain Inventory Optimization Demand Analytics Distribution Network Optimization Sourcing Analytics Freight Lane Analytics
Verticals Banking, Financial Services and Insurance Consumer Packaged Goods Retail
Our Services
4
Location Strategy to Improve Effectiveness of a Branch Network
perceptive-analytics.com/tag/case-study/
Reinventing Coupons: Strategies for Successful Coupon Campaign
perceptive-analytics.com/tag/case-study/
Data Visualizations
#Dashboard
8
Rate your knowledge of Dashboards
• Beginner
• Intermediate
• Expert
[email protected] 646.583.0001 #Dashboard 9
Which industry do you work in?
• Information Technology & Services
• Financial Services
• Management Consulting
• Telecommunications
• Others
[email protected] 646.583.0001 #Dashboard 10
DASHBOARDS
[email protected] 646.583.0001 #Dashboard 11
Your Work!
What audience see
Pic by http://blackbeltbartending.com [email protected] 646.583.0001 #Dashboard 12
Dashboard
Pic by http://blackbeltbartending.com [email protected] 646.583.0001 #Dashboard 13
A Dashboard is a Communication Tool
Priorities
Performance
Insights
Action Items
[email protected] 646.583.0001 #Dashboard 14
A Dashboard Increases Your Visibility
The real you The invisible you Good Dashboard
Craigyc
[email protected] 646.583.0001 #Dashboard 15
http://dilbert.com/strips/comic/2007-05-16/
What Makes a Dashboard Awesome?
Bac
kgro
un
d P
ic B
ev G
oo
dw
in
[email protected] 646.583.0001 #Dashboard 16
Dilbert is awesome! http://dilbert.com/strips/comic/2007-05-16/
Key Performance Indicators Key Performance Indicators
Pic
by
pla
its
[email protected] 646.583.0001 #Dashboard 18
Purpose Design
[email protected] 646.583.0001 #Dashboard 21
Purpose
Pic
by
Mer
vi E
skel
inen
Scope Audience Value Add
[email protected] 646.583.0001 #Dashboard 22
Target Audience
What is the role of the person?
What is the context of usage?
What are their biases?
Is the audience heterogeneous?
What are their goals?
What questions will they ask?
[email protected] 646.583.0001 #Dashboard 23
What Value Add?
Help management stay on top
Help management make a decision
Set goals for individuals or groups
Highlight exceptions
Track progress
Inform important information to teams
Pic b
y MD
Go
vpics
[email protected] 646.583.0001 #Dashboard 24
Scope
Organization Wide One Operation/Unit
Strategic Tactical
Historical Predictive
High Level Detailed
Pic
by
futu
reat
las.
com
Snapshot Interactive
[email protected] 646.583.0001 #Dashboard 25
26
Strategic?
[email protected] 646.583.0001 #Dashboard
Pic
: Ec
otr
ust
Can
ada
28
Structure Elements
Colors Process
Design
[email protected] 646.583.0001 #Dashboard
Pic
: Ec
otr
ust
Can
ada
29
Structure Elements
Colors Process
Design
Case study
Dashboard design should support analytical thinking
[email protected] 646.583.0001 #Dashboard 30
32
Canvas
Important
Important
33
[email protected] 646.583.0001 #Dashboard 37
39
Step 1 Step 2 Step 3
[email protected] 646.583.0001 #Dashboard 40
Pilot Training Status Monitor
John Smith Patricia Young Elizabeth Johnson Lisa Clark
License #: 123394 License #: 268395 License #: 268423 License #: 268395
Flight Training Flight Training Aircraft Servicing
Flight Follower Flight Follower Single Engine PPC
Low Visibility External Load
Aircraft Servicing Night VFR
Linda White Daniel Brown Mark Williams Ronald Green
License #: 268395 License #: 123450 License #: 268512 License #: 328390
Flight Training Flight Training
Flight Follower Single Engine PPC
Low Visibility External Load
Night VFR Night VFR
Nancy Miller Edward Hall Paul Baker Kevin Wright
License #: 268421 License #: 268390 License #: 299301 License #: 345123
Flight Training Flight Training External Load Flight Training
Flight Follower Single Engine PPC Night VFR Night VFR
Low Visibility External Load
Night VFR Night VFR
Training Due Date Past Training Due Date in 30 days No Trainings Due within 30 days
-1
62
-1019 -10 25
-4 45 2
19 0 100
htt
p:/
/ww
w.f
lickr
.co
m/p
ho
tos/
97
31
36
7@
N0
2/
Choosing Dashboard Elements
[email protected] 646.583.0001 #Dashboard 42
www.diverbi.com
Colors
[email protected] 646.583.0001 #Dashboard 47
[email protected] 646.583.0001 #Dashboard 49
Analogous
Complementary
Ideas for Color Harmony
Use colorbrewer2.org
Perceptive’s Step Process
1. Create a laundry list of KPIs
2. Prioritize. Choose the top 20% that has 80+% impact
3. Allocate the 20% to most visible areas
4. Choose elements wisely
5. Beautify
[email protected] 646.583.0001 #Dashboard 50
Laundry List
• Cost of Goods Sold
• Advance paid to manufacturer
• Average cost of acquisition
• Advertisement expenditure
• Revenue by channel
• Sundry debtors
• Accounts payable
• Prepaid expenses
• Miscellaneous expenses
• Net profit
• Salaries
• Short-term Investments
• Long-term investments
• Citibank Checking Account
• Bank of America Checking Account
• Actual
• Forecast
• Net Sales
• Gross sales
• Cash position
• Net margin
• Total head count
• Average selling price
• Revenue by product
• Total expenses
• Gross margin
• Head count by department
• Total head count
• Debt Equity Ratio
• Equity
• Depreciation
• Income taxes
• EBITDA
• General and Administrative Expenses
• Work in progress
• Gross profit
• Preference Shares
• Cash flow
Context
• CEO worried about cash position
• Sales are just picking up
• “How many can we hire now?”
• “Can we spend marketing dollars as planned?”
• “Are our (profitable) direct sales picking up?”
Priority
• Cost of Goods Sold
• Advance paid to manufacturer
• Average cost of acquisition
• Advertisement expenditure
• Revenue by channel
• Sundry debtors
• Accounts payable
• Prepaid expenses
• Miscellaneous expenses
• Net profit
• Salaries
• Short-term Investments
• Long-term investments
• Citibank Checking Account
• Bank of America Checking Account
• Actual
• Forecast
• Net Sales
• Gross sales
• Cash position
• Net margin
• Total head count
• Average selling price
• Revenue by product
• Total expenses
• Gross margin
• Head count by department
• Total head count
• Debt Equity Ratio
• Equity
• Depreciation
• Income taxes
• EBITDA
• General and Administrative Expenses
• Work in progress
• Gross profit
• Preference Shares
• Cash flow
Draw a draft dashboard manually. A paper and a pencil works best!
Examples and Critique of Dashboards
57
$ M $ M $ M $ M
Axis? Axis?
1 2
Intelligent use of secondary axis for D/E ratio
Visual Encodings suggests use of horizontal bars
Shapes/colours used to indicate performance
Resources
Juice Analytics A Guide to Creating Dashboards People Love to Use
Color Harmony Crash Course colormatters.com/color-and-design/basic-color-theory
Visual Encoding – How to use?
http://complexdiagrams.com/properties
Edward Tufte’s Book
http://www.edwardtufte.com
[email protected] 646.583.0001 #Dashboard 60
Perceptive’s Dashboard Tool Kit
http://www.perceptive-analytics.com/excel-dashboard-reporting/#dbtk
(link will be sent to you via chat)
61