adf dvt speed dating - meeting the gantt charts
DESCRIPTION
The Data Visualization components in ADF allow for turning data into information using a large variety of representations. The DVT library ranges from bar, pie and line chart to map, gantt and gauge. With others in between. On our ADF Special Interest Group at AMIS, we discussed six components from the DVT collection. This presentation is one out of those six - on Gantt Charts. Also see the corresponding blog articles on http://technology.amis.nlTRANSCRIPT
MEETING THE GANTT CHARTADF DVT Speed Dating…
AMIS, ADF SIG, 12th February 2013
time
tasks or resources
INTRODUCTION
• Type of Bar Chart – used for visualizing a schedule– Horizontal Axis is Timeline– Vertical list of Tasks or Resources– Bars indicate the ‘when’
• Created by Henry Gantt around 1910– First usage in World War I for
• Commonly used for Project WorkBreak Down structures
EXAMPLES OF GANTT CHART USAGE• Project Schedule
– when are tasks scheduled to be worked on• Resource Schedule
– when are resources (staff, equipment, rooms) allocated
• Historical Era Overview, Event Schedule for the Olympics, Cleaning Schedule, Family Organiser, …
EXAMPLES OF GANTT CHART USAGE
GANTT CHART IN SQL*PLUS
SUPPORT FOR GANTT CHARTS IN ADF DVT• Project Scheduling
– When (from…until) are tasks planned
SUPPORT FOR GANTT CHARTS IN ADF DVT• Project Scheduling
– When (from…until) are tasks planned• Resource Planning
– When (from…until) are resources booked
SUPPORT FOR GANTT CHARTS IN ADF DVT• Project Scheduling
– When (from…until) are tasks planned• Resource Planning
– When (from…until) are resources booked• Resource Utilization
– What capacity/percentage/hours of resources are used in specific time slots
SPECIAL FEATURES IN ADF DVT GANTT• Timescale Zooming and Scrolling• Legend• Context Menus• Popup support• Client Listeners for Click (drill-down) &
Double Click• Support for Drag & Drop:
work on the schedule interactively• Export to Excel• Print Gantt Chart as XSL-FO object• Label & Icon placement and Custom bar
format styles
FUNCTIONAL AREAS AND FACETS
Chart RegionTable Region
Toolbar
DATA MODEL FOR PROJECT GANTT-CHART
• ADF TreeTable Model or CollectionModel• Per element
– Label– Start Time– End Time
• Optional– Type– Actual Start/Actual End– Percentage Complete– Critical?– …
DATA MODEL FOR PROJECT GANTT-CHART
FANCY DATA MODEL ASPECTS
• Detail accessors are supported in the Project Gantt:– SubTasks– Dependent Tasks– Split Tasks– Recurring Tasks
DATA MODEL FOR SCHEDULING GANTT• ADF TreeTable Model or CollectionModel
representing Resources• Per Resource:
– a unique Resource Id – also a tasks accessor for
the collection of ‘scheduled periods’ for the resource
• Each Task (or Allocation)element has an Id, a Start Time and an End Time– Optionally a type
EXAMPLE MODEL FOR SCHEDULING GANTT
EXAMPLE MODEL FOR SCHEDULING GANTT
SUPPORTING DRAG & DROP
• Define dataChangeListener on Gantt Chart• Decipher Data Change event
– Extract Source Resource, Target Resource & Drop Time
• Update model– Remove ‘task’ from allocations under Source
Resource– Add ‘task’ to allocations under Target Resource
• Refresh Iterator• Refresh Gantt Chart (as partial target)
DATA MODEL FOR RESOURCE UTILIZATION GANTT• ADF TreeTable Model or CollectionModel
representing Resources• Per Resource:
– a unique Resource Id attribute– Also a time buckets
accessor for the collection of ‘period records’ for the resource
• Each Time Bucket element has – a Date to indicate the when
of the bucket– any metrics (numerical) that
should be displayed for the resource