@ everything xcelsius.com 2010 presented by: mico yuk & mike alexander date: march 24 th, 2010...
TRANSCRIPT
![Page 1: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/1.jpg)
@ Everything Xcelsius.com 2010
Presented by: Mico Yuk & Mike AlexanderDate: March 24th, 2010
Day 1 - Advanced Dashboarding Design TechniquesXcelsius Gurus
![Page 2: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/2.jpg)
@ Everything Xcelsius.com 2010
Mico Yuk Founder – EverythingXcelsius.com (popular weblog) Founder - Xcelsius Guru Network Xcelsius Trainer / Developer / Architect / Blogger
Mike Alexander (you already met) Founder – Datapig Technologies Xcelsius Evangelist / Blogger (www.datapigtechnologies.com) Microsoft Excel MVP
Who are We?
![Page 3: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/3.jpg)
@ Everything Xcelsius.com 2010Slide 3
Dashboard Design Resources
Well known Stephen Few (book) – Information Dashboard Design Edward Tufte (book) – Multiple books Jorge Camos (blog) -
http://www.excelcharts.com/blog/data-visualization/
![Page 4: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/4.jpg)
@ Everything Xcelsius.com 2010Slide 4
What will you learn?
How to design better dashboards in 4 easy steps
1. Choose the Correct charts for your Data
2. Choose the correct dashboard layout
3. Implement effective Formatting Techniques
4. Configure component functionality in your dashboard
![Page 5: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/5.jpg)
@ Everything Xcelsius.com 2010
Common Mistakes
Real Word Examples
Which charts to choose?
Class Exercise
Step #1 – Chart Usage
Stop searching for information – Monitor it with Dashboard Technology.- Gregory Hovis, DM Direct
![Page 6: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/6.jpg)
@ Everything Xcelsius.com 2010Slide 6
4 Common Mistakes
I chose this chart because…1. It looked good on the dashboard
2. It fit in the space available
3. The user HAD to have a (name a chart type) on the dashboard so we had to fit it
4. It looked cool aka ‘bling effect’
Reality – Data should dictate what charts are used on the dashboard. Period.
![Page 7: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/7.jpg)
@ Everything Xcelsius.com 2010Slide 7
Example #1 - Data
Preview Data – Sales
Reality – Data should dictate what charts are used on the dashboard. Period.
![Page 8: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/8.jpg)
@ Everything Xcelsius.com 2010Slide 8
Example #1 – Common Scenario
1st Chart Choice = Common Choice
Makes data comparison hard!
![Page 9: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/9.jpg)
@ Everything Xcelsius.com 2010Slide 9
Example #1 – Better Choice
2nd Chart Choice = Final Choice
This works!
![Page 10: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/10.jpg)
@ Everything Xcelsius.com 2010Slide 10
Example #2 - Data
Preview Data – Supply Chain Industry
Reality – Data should dictate what charts are used on the dashboard. Period.
![Page 11: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/11.jpg)
@ Everything Xcelsius.com 2010Slide 11
Example #2 – Common Scenario
1st Chart Choice = Common Choice
Kind of works!
![Page 12: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/12.jpg)
@ Everything Xcelsius.com 2010Slide 12
Example #2 – Better Choice
2nd Chart Choice = Final Choice
This works!
![Page 13: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/13.jpg)
@ Everything Xcelsius.com 2010Slide 13
The most effective means for easily digesting quantitative information is through the use of graph components.
In building a dashboard it is important to understand best practices for choosing a graph to visualize specific metrics, trends, and analysis.
2 things to think about…
Choosing a Chart
![Page 14: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/14.jpg)
@ Everything Xcelsius.com 2010Slide 14
Line Chart Consecutive Interval (mostly time-based) metrics. Any non-consecutive intervals.
Pie Chart & Area Chart Distribution or parts of a single measure. Any metrics that do not represent all parts of a whole (3-8 parts).
Bar & Column Chart Comparison of one or multiple measures with a common axis & scale. Any consecutive interval based metrics.
XY Chart, Bubble Chart Comparison between 2 or 3 measures with like or unlike scales. Use them in place of line or bar chart if 1 measure is not quantitative.
Stacked Chart Visualize how an individual part contributes to a whole. When the emphasis is on comparing the parts.
Understanding Chart Types
![Page 15: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/15.jpg)
@ Everything Xcelsius.com 2010Slide 15
Quiz #1: Which Graph?
Choose the Correct Graph1. Graph #1
Comparing independent data sets Money distribution by time Production against time
2. Graph #2 Money distribution over time Material characteristics by temperature Clinical response by concentration
3. Graph #3 Budgets Money distribution
Bar & Column Chart
Line Chart
Pie Chart
![Page 16: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/16.jpg)
@ Everything Xcelsius.com 2010Slide 16
Quiz #1: Which Graph?
Choose the Correct Graph4. Graph #4
Display changes in cumulative value or percentage over time.
Compare groups on outcome measurements.
Display group trends.
5. Graph #5 Displaying data with three variables Displaying financial data
Area Chart
Bubble Chart
![Page 17: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/17.jpg)
@ Everything Xcelsius.com 2010Slide 17
Choose Charts
Step #1: Exercise
Exercise Steps:
1. Open Sample (borrow data )2. Divide Canvas into 4 parts3. Choose appropriate charts
![Page 18: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/18.jpg)
@ Everything Xcelsius.com 2010
Website Layouts
Common Dashboard Layouts
Real World Examples
Xcelsius Template Review
Class Exercise Continued
Step #2 – Dashboard Layout
Stop searching for information – Monitor it with Dashboard Technology.- Gregory Hovis, DM Direct
![Page 19: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/19.jpg)
@ Everything Xcelsius.com 2010Slide 19
3 Things to Consider
Most users …1. Spend 8+ hours on the internet
2. Most of that time is spent browsing websites
3. Familiar and accustomed to basic website navigation
4. Are not sure where to place items on their dashboard
Conclusion – Why remake the wheel?
![Page 20: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/20.jpg)
@ Everything Xcelsius.com 2010Slide 20
Popular Website #1 Header – Logo, Main Menu Tab Left Side Pane – Main Navigation for each Menu Tab Body – Relevant Data Footer – Copyright Info & Links (not shown here)
![Page 21: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/21.jpg)
@ Everything Xcelsius.com 2010Slide 21
Popular Website #2 Header – Logo, Main Menu Tab Left Side Pane – Main Navigation for each Menu Tab Body – Relevant Data Footer – Copyright Info & Links (not shown here)
![Page 22: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/22.jpg)
@ Everything Xcelsius.com 2010Slide 22
Common Dashboard Layouts
Stick with 2, 3 and 4’s for the body
Don’t forget the navigation!
![Page 23: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/23.jpg)
@ Everything Xcelsius.com 2010Slide 23
Real World Example #1
![Page 24: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/24.jpg)
@ Everything Xcelsius.com 2010Slide 24
Real World Example #2
![Page 25: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/25.jpg)
@ Everything Xcelsius.com 2010Slide 25
Real World Example #3
![Page 26: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/26.jpg)
@ Everything Xcelsius.com 2010Slide 26
Dashboard Template #1
Header – Title, Report Date, Global Buttons Left Side Pane – Dashboard navigation, Static Data,
Links Body – Relevant chart sand bulk of data Footer – Copyright Info, Links
![Page 27: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/27.jpg)
@ Everything Xcelsius.com 2010Slide 27
Dashboard Template #2
Header – Title, Report Date, Global Buttons Left & Right Side Bar – Dashboard navigation, Static
Data, Links Body – Relevant chart sand bulk of data Footer – Copyright Info, Links
![Page 28: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/28.jpg)
@ Everything Xcelsius.com 2010Slide 28
Choose Charts
Step #2: Exercise
Exercise Steps:
1. Choose 2 Layouts as a class2. Handraw to Preview3. Build chosen one on canvas
![Page 29: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/29.jpg)
@ Everything Xcelsius.com 2010
Xcelsius Themes
Setting your Color Scheme
Class Exercise Ctd.
Step #3 – Formatting Techniques
Stop searching for information – Monitor it with Dashboard Technology.- Gregory Hovis, DM Direct
![Page 30: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/30.jpg)
@ Everything Xcelsius.com 2010Slide 30
Recommended1. Nova (default)2. Aqua3. Halo
Xcelsius Themes
![Page 31: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/31.jpg)
@ Everything Xcelsius.com 2010Slide 31
BEST Color Scheme Chooser
URL – http://colorschemedesigner.com/
![Page 32: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/32.jpg)
@ Everything Xcelsius.com 2010
Before / After
Step #4 – Configuring Components
Stop searching for information – Monitor it with Dashboard Technology.- Gregory Hovis, DM Direct
![Page 33: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/33.jpg)
@ Everything Xcelsius.com 2010
Presented by: Mico Yuk & Mike AlexanderDate: March 25th, 2010
Day 2 – Basic Connectivity TechniquesXcelsius Gurus
![Page 34: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/34.jpg)
@ Everything Xcelsius.com 2010Slide 34
Download Files
URL - http://everythingxcelsius.com/wp-content/uploads/Xcelsius_Trainingfiles.zip
![Page 35: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/35.jpg)
@ Everything Xcelsius.com 2010Slide 35
What will you learn?
4 Basic connectivity technique
1. What is XML?
2. How to employ XML Data into your dashboard?
3. Understanding flash vars
4. Passing parameters between dashboards
![Page 36: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/36.jpg)
@ Everything Xcelsius.com 2010
What is XML?
How to deploy it?
Understanding XML
Stop searching for information – Monitor it with Dashboard Technology.- Gregory Hovis, DM Direct
![Page 37: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/37.jpg)
@ Everything Xcelsius.com 2010Slide 37
What is XML?
Important Facts…
1. Defined – Extensible Markup Language
2. Developed in 1998 to allow different programs to pass data
3. Simple text file
4. Great Resource = Mike’s Video -
http://datapigtechnologies.com/flashfiles/xxmlpart1.html
![Page 38: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/38.jpg)
@ Everything Xcelsius.com 2010Slide 38
What is XML?
![Page 39: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/39.jpg)
@ Everything Xcelsius.com 2010Slide 39
Updating XML in Excel
Exercise #1
Exercise Steps:
1. Open ‘Books XML Example’ Folder2. Import data into Excel3. Open XML file and change 2 values4. Refresh data in Excel
![Page 40: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/40.jpg)
@ Everything Xcelsius.com 2010Slide 40
XML Connectivity
Compare 3 Xcelsius options …
![Page 41: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/41.jpg)
@ Everything Xcelsius.com 2010Slide 41
HTTPData PublishedClient DevelopmentMiddleware
XML Connectivity – Design Time
Xcelsius SWF
WebService
WebService
ExcelXML
Maps
ExcelXML
Maps
XMLDataXMLData
Any XML structure
.NET/J2EE
SOAP
<row><column> structure
![Page 42: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/42.jpg)
@ Everything Xcelsius.com 2010Slide 42
HTTPData PublishedMiddleware
XML Connectivity – Run Time
SWFAny XML Structure.NET/J2EE
SOAP
<row><column> Structure
XML Data
Excel XML Maps
Web Service
![Page 43: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/43.jpg)
@ Everything Xcelsius.com 2010Slide 43
![Page 44: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/44.jpg)
@ Everything Xcelsius.com 2010Slide 44
![Page 45: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/45.jpg)
@ Everything Xcelsius.com 2010Slide 45
![Page 46: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/46.jpg)
@ Everything Xcelsius.com 2010Slide 46
![Page 47: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/47.jpg)
@ Everything Xcelsius.com 2010Slide 47
![Page 48: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/48.jpg)
@ Everything Xcelsius.com 2010Slide 48
![Page 49: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/49.jpg)
@ Everything Xcelsius.com 2010Slide 49
![Page 50: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/50.jpg)
@ Everything Xcelsius.com 2010Slide 50
![Page 51: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/51.jpg)
@ Everything Xcelsius.com 2010Slide 51
![Page 52: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/52.jpg)
@ Everything Xcelsius.com 2010Slide 52
![Page 53: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/53.jpg)
@ Everything Xcelsius.com 2010
Understanding Flash Vars
Passing parameters between dashboards
Other Techniques
Stop searching for information – Monitor it with Dashboard Technology.- Gregory Hovis, DM Direct
![Page 54: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/54.jpg)
@ Everything Xcelsius.com 2010Slide 54
Flash VariablesHTMLFLASHVARS=“abc123”
Dashboard (SWF)Dashboard (SWF)
abc123
Pass parameters to into a SWF on-load
![Page 55: @ Everything Xcelsius.com 2010 Presented by: Mico Yuk & Mike Alexander Date: March 24 th, 2010 Day 1 - Advanced Dashboarding Design Techniques Xcelsius](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee15503460f94bf2631/html5/thumbnails/55.jpg)
@ Everything Xcelsius.com 2010Slide 55
Using flash vars to pass parameters
Exercise #2
Exercise Steps:
1. Open ‘Pass_Parameter Example’ folder2. Open parent.swf model3. Change values and click enter4. See right child.swf update5. Open parent.xlf and child.xlf model6. Review code!