Skip to content

Training Request Form

Summary

Summary

Education: Address Cleaning - Live Training

Interested in learning how addresses support the MRI Education system? Fill out this training request form.

Step 1: Auto Match and Analyse (Test)

Key Prerequisites

  • Access to emsmain and emsprocs database vis SQL tools or similar SQL app.
  • SSRS Report access to load and run reports

Objectives

  • Analyse existing address data. Auto Match LLPG/AddressBase files to the MRI Education database

Audienc

  • System Administrator

Standard Agenda

  • Analyse address data
  • Backup address tables
  • Bulk Match existing addresses with LLPG/AddressBase Premium data
  • Remove telephone numbers and OSAPRs

Outcomes

  • Full address database matched to any existing database using standard system matching.

Step 2: Fuzzy Match and Update (Test)

Key Prerequisites

  • Access to emsmain and emsprocs database vis SQL tools or similar SQL app.
  • SSRS Report access to load and run reports

Objectives

  • Additional matching and tidy of existing address to the imported data using fuzzy matching routines

Audience

  • System Administrator

Standard Agenda

  • Fuzzy match remaining addresses
  • Update dwelling and street data to match LLPG/AddressBase Premium data
  • Add missing streets
  • Re-link dwellings to correct street records
  • Add missing properties

Outcomes

  • Full address database imported into MRI Education and matched to any existing database using standard system and fuzzy matching.

Step 3: Address Tidy (Test)

Key Prerequisites

  • Access to emsmain and emsprocs database vis SQL tools or similar SQL app.
  • SSRS Report access to load and run reports
  • Access to System Administration Online

Objectives

  • Run the built in Address Tidy routine and compare data before and after Address Cleaning Service

Audience

  • System Administrator

Standard Agenda

  • Remove blank addresses
  • Remove unused dwellings and streets
  • Remove duplicate addresses
  • Analysis address data

Outcomes

  • At least 95% or more addresses in MRI Education now matching LLPG data

Step 4: Q & A

Key Prerequisites

  • Access to emsmain and emsprocs database vis SQL tools or similar SQL app.
  • SSRS Report access to load and run reports
  • Access to System Administration Online
  • Access to Back Office

Objectives

  • Discuss the output and answer any questions

Audience

  • System Administrator

Standard Agenda

  • Discuss Outcome
  • Request sign off so the steps can be run in live

Outcomes

  • LA Happy to sign off for Test and work to commence from Step 5

Step 5: Auto Match and Analyse (Live)

Key Prerequisites

  • Access to emsmain and emsprocs database vis SQL tools or similar SQL app.
  • SSRS Report access to load and run reports

Objectives

  • Analyse existing address data. Auto Match LLPG/AddressBase files to the MRI Education database

Audience

  • System Administrator

Standard Agenda

  • Analyse address data
  • Backup address tables
  • Bulk Match existing addresses with LLPG/AddressBase Premium data
  • Remove telephone numbers and OSAPRs

Outcomes

  • Full address database matched to any existing database using standard system matching.

Step 6: Fuzzy Match and Update (Live)

Key Prerequisites

  • Access to emsmain and emsprocs database vis SQL tools or similar SQL app.
  • SSRS Report access to load and run reports

Objectives

  • Additional matching and tidy of existing address to the imported data using fuzzy matching routines

Audience

  • System Administrator

Standard Agenda

  • Fuzzy match remaining addresses
  • Update dwelling and street data to match LLPG/AddressBase Premium data
  • Add missing streets
  • Re-link dwellings to correct street records
  • Add missing properties

Outcomes

  • Full address database in the main MRI Education database and matched to any existing addresses using fuzzy matching.

Step 7 (Remote): Address Tidy (Live)

Key Prerequisites

  • Access to emsmain and emsprocs database vis SQL tools or similar SQL app.
  • SSRS Report access to load and run reports
  • Access to System Administration Online

Objectives

  • Run the built in Address Tidy routine and compare data before and after Address Cleaning Service

Audience

  • System Administrator

Standard Agenda

  • Remove blank addresses
  • Remove unused dwellings and streets with no UPRN
  • Remove duplicate addresses
  • Analysis address data

Outcomes

  • At least 95% or more addresses in MRI Education now matching LLPG data

Step 8 (Remote): Q & A

Key Prerequisites

  • Access to emsmain and emsprocs database vis SQL tools or similar SQL app.
  • SSRS Report access to load and run reports
  • Access to System Administration Online
  • Access to Back Office

Objectives

  • Discuss the output and answer any questions

Audience

  • System Administrator

Standard Agenda

  • Discuss Outcome
  • Sign Off

Outcomes

  • LA Happy to sign off for Test and work to commence from Step 5