Advanced Data Presentation Techniques via the Internet

1
Advanced Data Presentation Techniques via the
Internet

• Session IA
• Executive Information Systems
• Henry Weigel
• May 23, 2000
• Bangladesh Ministry of Energy and Mineral
  Resources

2
Overview

• Session 1 Fundamentals of an EIS, types and
  structure, development approaches, tools,
  vendors, examples, Oil Gas Demo
• Session 2 The use of presentation graphics,
  making sense of a sea of data, the use of Excel,
  PowerPoint, HTML, Word
• Session 3 Internet/Intranet and Active Server
  Pages
• Session 4 MS Access (World MER MDBs)

3
Executive Information Systems

• Turning Data into Knowledge
• A tool for the senior manager
• Direct on-line access to relevant information
• Timely and accurate
• For individuals with limited time, limited
  keyboarding skills, and little direct experience
  with computers
• An EIS is easy to navigate

4
Characteristics of an EIS

• Tailored to executives information needs
• Reports
• Analysis and graphics
• Drill-down process
• Easy to use

5
Purpose of an EIS

• Gives managers access to the data
• Promotes managerial learning
• Provides timely information
• Looking at the data leads to questions
• Identifies trends
• Measures performance

6
Types of EISs

• Corporate Management
• E.g., Management functions, human resources,
  financial data, correspondence, performance
  measures, etc. (whatever is interesting to
  executives)
• Technical Information Dissemination
• E.g., Energy, environment, aerospace, weather,
  etc.

7
Structure of an EIS

• Presentation Graphics
• Tutorials
• Web Pages
• Internet Portals
• Intranet
• Database Queries and Reporting

8
Development Approaches

• Classical System Development
• System Requirements
• Functional Description
• System Specifications
• Data Requirements
• User Interfaces
• Rapid Prototyping
• User involvement
• Low resources (if no good start over)

9
Tools

• Database Interfaces
• Queries
• Forms
• Modules (Code)
• Hypertext Interfaces
• Active Server Pages (MS ASP)
• Off-the shelf Software
• Custom Programming

10
Vendors

• ..\DOCs\EIS Notes 3 Vendors.doc

11
DOE/EIA Examples

• Action Tracking System
• Prototyping using MS Access
• Oil Tutorial
• ..\..\SanFran\OilTool\default.htm
• Presentation Graphics
• ..\Session2\25YROPEC\html\anniversary.htm

12
DOE/EIA Examples, Contd.

• Portal
• ..\eh\Portal\portal.html
• Cross-Referencing
• ..\..\SanFran\HTMLs\emeu\aer\contents.html
• World Energy (MDB)

13
DOE/EIA Examples, Contd.

• World Energy (MDB)
• ..\Session4\World_Demo\World2000.mdb
• Monthly Energy Review (MDB)
• ..\Session4\MER_Demo\merdb2000_x.mdb
• Monthly Energy Review (ASP)
• ..\Session3\MER_Demo\default.htm

14
Portal Code Sample
lttitlegtOffice of Environment, Safety and
Healthlt/titlegt ltscript language"JavaScript"gt lt!-
- agent navigator.userAgent browserVer
2 if (agent.substring(0,7) "Mozilla")
if (parseInt(agent.substring(8,9)) gt 3)
browserVer 1 if (browserVer 1)
var zero_nml new Image(119,159), one
_nml new Image(119,159), two_nml
new Image (119,159), three_nml new
Image (119,159), four_nml new Image
(119,159), five_nml new Image
(119,159), six_nml new Image
(119,159), seven_nml new Image
(180,240), eight_nml new Image
(180,240), nine_nml new Image
(180,240), ten_nml new Image
(180,240), eleven_nml new Image
(180,240), twelve_nml new Image
(180,240), thirteen_nml new Image
(180,240), fourteen_nml new Image
(180,240), fifteen_nml new Image
(180,240)
15
The Use of Portals
16
Portals -- Personalizing
17
Portals -- Registration
18
Portals -- Confirmation
19
Oil Tutorial Intro Page ..\OilTool\default.htm
20
Intro Page, Contd
21
Frames Supply Page
22
Petro- leum Trap Sche- matic
23
World Crude Production
24
Crude Production
25
Reserves
26
Data Sources
27
Supply Page -- Bottom
28
Demand for Oil
29
U.S. Oil Consumption
30
World Per Capita Consumption
31
Oil Refining
32
Refining -- Distillation
33
Refining Profit Rate
34
World Refining Capacity
35
Refinery Output
36
Refining Page -- Bottom
37
Petroleum Trade
38
U.S. Oil Imports
39
Imports by Origin
40
Oil Stocks
41
Oil Prices
42
Gasoline Price Components
43
Price Data Sources
44
Price Page -- Bottom
45
Oil Data Links
46
List of Graphs
47
List of Graphs, Contd.