end user applications l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
End User Applications PowerPoint Presentation
Download Presentation
End User Applications

Loading in 2 Seconds...

play fullscreen
1 / 13

End User Applications - PowerPoint PPT Presentation


  • 157 Views
  • Uploaded on

End User Applications. What to build. Metadata Management. Enterprise Reporting. Data Extraction Data Cleansing Data Integration Data Improvement. External Data. Datamarts. OLAP Query. Data Mining. Data Transformation. Operational Data Store. Data Warehouse. Source

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'End User Applications' - Samuel


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
framework architecture kerr mcgee

Metadata Management

Enterprise

Reporting

Data

Extraction

Data

Cleansing

Data

Integration

Data

Improvement

External Data

Datamarts

OLAP

Query

Data

Mining

Data

Transformation

Operational

Data Store

Data

Warehouse

Source

Systems

Information

Delivery

Project Management & Quality Assurance

Operations & Systems Management

Framework Architecture (Kerr McGee)
the role of end user applications
The Role of End User Applications

Desktop tools /

do-it-yourself

queries

Ad hoc power

user

End user

applications

Push-button

knowledge worker

Standard

report customer

Operational reporting

environment

application template
Application Template
  • Provides the layout and structure of a report that is driven by parameters
  • Users set parameters from pick lists or drop down menus
template design steps
Template Design Steps
  • Identify an initial template set. 10 – 20 high value templates.
  • Collect report candidates. What are the important report requests?
  • Consolidate report categories. Based on data needs and type of report.
  • Prioritize the list.
common report types
Common Report Types
  • How’s business?
  • What are the trends?
  • What’s unusual?
  • What is driving those exceptions?
  • What if …?
  • Make a business decision.
  • Implement the decision.
slide8
Note
  • Do not recreate the past.
    • Old reports often do not reconcile
    • Recreating old reports gains little
template management
Template Management
  • Navigation. How do you find the one you want?
  • Shop standards.
    • Naming standards for templates and columns
    • Look and feel
  • Template creation
    • Definition and layout
    • Match with dimensional model
    • Review with users
application development
Application Development
  • Environments
    • Web based
    • Direct template access
    • Structured/menu based template access
    • Custom coded
data requirements
Data Requirements

It is hard to evaluate forms and templates without meaningful data. Problems to manage include:

  • Meaningless descriptions
  • Duplicate dimensions or dimension access keys
  • Incorrect dimensional relationships
  • Data not matching legacy reports. May be a legacy problem.
managing the process
Managing the process
  • Remember the milestones
    • First demo 25%
    • System test with all modules 25%
    • Validated in simulated production 25%
    • Documented and delivered final

system 25%

managing cont
Managing (cont.)
  • Code is not self-documenting
  • Use a bug reporting database or log
  • Acknowledge bug reports from users and testers
  • Place a high premium on testing and repairing