Transcript The First Steps in Building a Virtual Information Center

The First Steps in Building a
Virtual Information Center
Mr. Erik Bowe
Mr. Tomek Skurzak
Enterprise Information Management
Kennesaw State University
Agenda
• Reinventing Institutional Effectiveness and
Institutional Research
• Using a Data Management Framework
– Corporate Information Factory
• Designing a Virtual Information Center
– Characteristics
– Features
• Technologies
– Demo
• Conclusion
Reinventing Institutional Effectiveness and
Institutional Research
Evolutionary Trends in IE, IR, & IM:
• High priorities with Web publishing as well data
warehouse and data mart creation and usage
• Increased efficiency and effectiveness through the
adoption of new technologies and technical expertise
• Improvement of KSU’s enterprise-wide information
systems and reporting functions
– Including the University’s overall institutional effectiveness
Reinventing Institutional Effectiveness and Institutional
Research
Organization chart prior to April 2007:
Director of the
Center for
Institutional Effectiveness
Administrative
Coordinator
Director of
Institutional Research and
Information Management
Associate Director of
Institutional Research
Assistant Director of
Information Management
Administrative Associate
Administrative Coordinator
Information Analyst II
Reinventing Institutional Effectiveness and Institutional
Research
Organization chart after April 2007:
Executive Director of
Enterprise Information
Management
Administrative
Coordinator
Director
of
Enterprise Information
Reporting
Director
of
Enterprise Data Management
and Information Architect
Business Intelligence
Developer and Manager
Database
Developer and Manager
Metadata and
Analytics Manager
Coordinator of
Enterprise
System Reports
Institutional
Research Associate
Coordinator of
Survey Reporting
Reinventing Institutional Effectiveness and Institutional
Research
2007-2012 Performance Goals:
• Improve Academic Access to Strategic Information
• Improve KSU’s Data Quality
• Improve Interpretation and Consistency in Information
Reporting
• Improve Statistical Tracking for Strategic Initiatives
• Improve Professional Contributions to SACS and
Information Management
Using a Data Management Framework
The Corporate Information Factory
The Corporate Information Factory (CIF) is a logical
architecture whose purpose is to deliver business
intelligence and business management capabilities
driven by data provided from business operations.
The CIF has proven to be a stable and enduring
technical architecture for any size enterprise
desiring to build strategic and tactical decision
support systems (DSSs).
The CIF consists of producers of data and
consumers of information.
http://www.inmoncif.com/library/cif/
http://www.dmreview.com/article_sub.cfm?articleId=1667
Using a Data Management Framework
•
Defines the scope and basic concepts of the Data Management (DRM, IRM) function
•
Developed, owned and offered by DAMA International and the DAMA Foundation
•
A two dimensional matrix
•
–
9 Data Management Functions
–
7 Environmental Elements
Outlines the content of the Data Management Body of Knowledge (DMBOK)
document
–
•
Modeled after the PMI PMBOK’s Project Management disciplines
A guide to help:
–
Define an Enterprise Data Management Strategy
–
Assess Data Management Efforts
–
Establish the Context for Data Management Programs and Initiatives
–
Develop an IT Curriculum (for Higher Education Institutions)
–
Organize DAMA Initiatives
Data Management Functions
Unstructured
Data
Management
Data Quality
Improvement
Reference &
Master Data
Management
Data
Architecture,
Analysis &
Design
Data
Stewardship,
Strategy &
Governance
Data
Warehousing
& Business
Intelligence
Source:
Database
Administration
Data Security
Management
Metadata
Management
http://www.dama.org/public/pages/index.cfm?pageid=1
Data
Management
Functions
Unstructured Data
Management
Data Quality
Improvement
• Document Mgmt
• Image Mgmt
• XML Mgmt
• Geodata Mgmt
• Content Mgmt
• Taxonomy Mgmt
• Knowledge Mgmt
• Regulatory Compliance
• DQ Analysis / Profiling
• DQ Audit & Certification
• Cleanup Campaigns
• DQ Rqmts Analysis
Reference / Master
Data Management
Data Architecture,
Analysis & Design
• Enterprise Modeling
• Value Chain Analysis
• Data Integration Arch.
• DW / BI Architecture
• Logical Modeling
Database
• Physical Modeling
Administration
• Design Stds
• Model Mgmt
• DB Design
Data Stewardship,
Strategy & Governance
• IT DRM Organization
• Data Stewardship Council
• Data Strategy Definition
• Data Issue Management
• Data Cost Management
• Oversight & Enforcement
• Customer Data Integration
• Product Data Integration
• Code Management
Data
• Data Steward Control
Warehousing &
Business
Intelligence
• DW / Mart Implementation
• User Training & Support
• Enterprise Reporting
• Query & OLAP Analysis
• Stat Analysis / Data Mining
• Scenario Modeling
Source:
Metadata
Management
• DB Change Control
• Backup & Recovery
• Performance & Tuning
• Archival & Purging
• Technology Mgmt
Data Security Management
• Data Privacy Standards
• User and Group Admin
• Access View Admin
• Password Practices
• User Authentication
• Data Security Audit
• Metadata Arch
• Metadata Standards
• Capture & Maintenance
• Integration & Sharing
• Query & Reporting
• Lexicons, Glossaries, ...
• Repository Admin
http://www.dama.org/public/pages/index.cfm?pageid=1
Designing a Virtual Information Center
Characteristics
• Easy
– Chinese proverb: “Give a man a fish, and he will eat for a day. Teach
a man to fish and you feed him for a lifetime.”
– No more technological “nightmares”
• Flexible
– KSU is a dynamic, changing organization
– Change follows a pattern of mathematical geometric progression
• Cost Effective
– Tangible and intangible benefits from the money spent
– 1% of KSU’s annual budget
• Integrates
– Adhere with KSU’s EWTA (Enterprise-Wide Technology Architecture)
– Existing systems
Designing a Virtual Information Center
Features
• Drill-down (vertical)
– Move downward:
•
•
•
•
University
College/Division
School/Department
Degree Program
• Drill-through (horizontal)
– Totals:
• Ethnicity
• Gender
• Integrated detail view to ANY drill-down and drill-through level
– Microsoft Excel file of details
– User authentication/authorization at any of the levels
• No generation of browser history
– Interactive, synchronous
Designing a Virtual Information Center
Features
• “Smart” graphs
– Dynamic, change during drill-down and drill-through
– Style and characteristic changes
• Time stamped pages
– When the data was last submitted to the data warehouse
– When the web page is generated
• Object-oriented
– High reusability
– To include:
• Data warehouse (no use of star or snowflake schemas)
• Web pages
• Continuous logging of user activity
– Web analytics
Designing a Virtual Information Center
Features
• Easily modifiable web pages and analytical based programs
– More than just style
• Integration text and analysis in unstructured digital documents
with structured data
– WebDAV (Web-based Distributed Authoring and Versioning)
• Track user profiles and interact with the KSU community
– Capture IP address and username when the browser “hits” the website
– Electronically “talk” with Dean’s and Chair’s using web 2.0
collaboration technologies
Designing a Virtual Information Center
Make the KSU Fact Book Dynamic
• The Fact Book is currently oriented to the past
– Basic trend analysis
• Currently uses structured data
– Some “sneaker net”
• The focus is gravitating toward using automated processes
– Most are run manually
• The orientation will include present
– Integral part of enterprise information reporting
• The orientation will ultimately include the future
– Forecasting
Technologies
• SAS Enterprise Intelligence Suite for Higher
Education (EISE)
– This ain’t your mama’s SAS, so do be given’ your
mama none
• Oracle Database 10g Release 2 Enterprise
Edition
• Microsoft Visual Studio 2005 Professional Edition
– ASP.NET (Visual Basic)
Technologies
What technologies is KSU currently deploying:
• Enterprise Data Warehouse Creation
– SAS Data Integration Studio
– SAS Information Map Studio
– Oracle Database Enterprise Edition
• Enterprise Data Marts Creation
– SAS OLAP Cube Studio
• Expand Self-Service Access to Information
– ASP.NET (Visual Basic)
– SAS Information Delivery Portal
– SAS Web Reports Studio
• Make the KSU Fact Book Dynamic
– ASP.NET (Visual Basic)
– SAS Enterprise Guide
ASP.NET (Visual Basic)
Demo
SAS EISE
Demo
Conclusion
In building a virtual information center:
• Having a plan is key
– The Corporate Information Factory
– DAMA Data Management Functional Framework
• Technology should not drive the plan, but be an
integral part of the plan
• The right technology tools are always needed
• Need upper management involvement to
succeed
Resources
• Corporate Information Factory
– http://www.inmoncif.com/
• The Data Management Association
– http://www.dama.org
• The Data Warehousing Institute
– http://www.tdwi.org/
• The Data Administration Newsletter
– http://www.tdan.com/
Questions and Answers
Thank you for your time
Contact Information
http://vic.kennesaw.edu/
Erik Bowe
Director, Enterprise Data Management
Kennesaw State University
1000 Chastain Road, MD 0110
Kennesaw, GA 30144-5591
770.499.3360
[email protected]
Tomek Skurzak
Database Developer and Manager
Kennesaw State University
1000 Chastain Road, MD 0110
Kennesaw, GA 30144-5591
770.499.3579
[email protected]