Executive Information Systems -- Session 1 “Turning Data into Knowledge”

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

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. 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 Definition of an EIS

4. Characteristics of an EIS • Tailored to executive’s 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, Cont’d. • Portal • ..\..\eh\Portal\portal.html • Cross-Referencing • ..\..\..\SanFran\HTMLs\emeu\aer\contents.html • World Energy (MDB)

13. DOE/EIA Examples, Cont’d. • World Energy (MDB) • ..\..\Session4\World2000.mdb • Monthly Energy Review (MDB) • ..\merdb2000.mdb • Monthly Energy Review (ASP) • ..\..\Session3\PDOEmer\default.htm

15. <title>Office of Environment, Safety and Health</title> <script language="JavaScript"> <!-- agent = navigator.userAgent; browserVer = 2; if (agent.substring(0,7) == "Mozilla") if (parseInt(agent.substring(8,9)) >= 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);