Executive Information Systems -- Session 1

Executive Information Systems -- Session 1 “Turning Data into Knowledge” Henry Weigel Energy Information Administration February 2000

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)

Definition of an EIS  

 



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

Characteristics of an EIS 

   

Tailored to executive’s information needs Reports Analysis and graphics “Drill-down” process Easy to use

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

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.

Structure of an EIS      

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

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)

Tools 

Database Interfaces   

   

Queries Forms Modules (Code)

Hypertext Interfaces Active Server Pages (MS ASP) Off-the shelf Software Custom Programming

Vendors 

..\DOCs\EIS Notes 3 Vendors.doc

DOE/EIA Examples 

Action Tracking System 



Oil Tutorial 



Prototyping using MS Access ..\..\..\SanFran\OilTool\default.htm

Presentation Graphics 

..\..\Session2\25YROPEC\html\anniversar

DOE/EIA Examples, Cont’d. 

Portal 



Cross-Referencing 



..\..\eh\Portal\portal.html

..\..\..\SanFran\HTMLs\emeu\aer\contents

World Energy (MDB)

DOE/EIA Examples, Cont’d. 

World Energy (MDB) 



Monthly Energy Review (MDB) 



..\..\Session4\World2000.mdb ..\merdb2000.mdb

Monthly Energy Review (ASP) 

..\..\Session3\PDOEmer\default.htm

<script language="JavaScript"> = 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);