Receive Information:
Learn about seminars,
webinars, free white
papers and more. Click here to be placed
on our mailing list.
We do not share your
name with anyone.
...the premier site listing service providers who can help your business grow!
Database Development: A Structured Approach
Mission Statement
Create a single repository for all data identified as relevant to meet the requirements of the department or business entity, including user friendly tools and
systems & procedures to empower users to successfully use the data to achieve the organization's mission.
The Process
Create A Task Force
Key Staff members who understand and can convey needs/wants
Must represent
Each Marketing User Unit within the Business
Administrative Staff
Management
Define Major Marketing Objectives for the Database
Define Process Methodology
Segment User Groups
Function
Needs
Identify hardware, software available to achieve tasks
Perform An Audit
See data samples from all current sources
Know data origins
Know how data is captured and fed into which system
Confirm whether data fields are populated/with what/are blank
Determine Data Usage
Task Force members must provide wish/want list for area represent
Screens
Queries
Reports
Define/Address inconsistencies/obstacles
Define
All files and data needs
All in-house IT rules
All data elements required
All data enhancements required
Evaluate/Address Gaps
Develop Specifications
Standardization Specs
De-duplication and Aggregation rules
Roll-up of Orders, tracking and other transactional data
Data Dictionaries
Definition
Data update volume/frequency
Define
Input editing procedures
Data Capture methods
Output requirements
Address/Define
Security
Privacy
User Access Levels
Build A Prototype
Test Prototype
Begin Training key users
Load Data
Continue Training
Run concurrent with present system until satisfied
