Apply a repeatable review cycle to data cleaning and preparation and act on what it produces.
Building Strategies for Cleaning and Preparing Data for Analysis
Build a working method for data cleaning and preparation that stands up to scrutiny and survives daily pressure.
📍 Cairo🗓️ 5 training days📚 4 modules🎓 Accredited certificate
5intensive training days
4scientific modules
8training sessions
32detailed points
Course Overview
Security and delivery speed are traded against each other in data cleaning and preparation whether or not anyone says so. The documentation for cleaning and preparation is accurate only until the next release. Cases are chosen to expose the trade-offs in the technology and systems delivery capability rather than to illustrate ideal conditions. Field experience suggests that the barrier to better data cleaning and preparation is rarely technical. The version of this area of technology and systems delivery described in the manual and the version practised on the floor tend to diverge over time. The material serves both public bodies and commercial organisations dealing with cleaning and preparation. The result is the confidence to make and defend decisions about data cleaning and preparation under scrutiny. The course covers cleaning and preparation at the level of detail needed to act, and stops there. Participants leave with a first-ninety-days plan for the technology and systems delivery capability rather than a set of notes.
Expected Learning Outcomes
Define the availability, performance and recovery targets for cleaning and preparation.
Assess and manage third-party and cloud dependencies in data cleaning and preparation.
Review contracts and agreements for the obligations they create around cleaning and preparation.
Design backup and recovery for data cleaning and preparation and prove it by restoring.
Diagnose whether a problem in cleaning and preparation is one of design, resourcing or discipline.
Establish monitoring and alerting on data cleaning and preparation that reflects user experience.
Who Should Attend
IT managers and service owners responsible for data cleaning and preparation.
Department heads accountable for the results of cleaning and preparation.
Solution architects designing data cleaning and preparation.
Risk managers assessing the exposure created by cleaning and preparation.
Service desk and support leads handling incidents in data cleaning and preparation.
Infrastructure and platform engineers operating cleaning and preparation.
Course Modules
Data cleaning and preparation: architecture and designing for failure
2 sessions · 8 pointsSession 1Setting availability and recovery targets for data cleaning and preparation honestly
- Restore a backup of data cleaning and preparation in a test environment and time it.
- Identify single points of dependency in cleaning and preparation and reduce them.
- Assign responsibility for keeping documentation of data cleaning and preparation current.
- Identify the single points of failure in cleaning and preparation.
Session 2Proving the backup of cleaning and preparation by restoring it
- Set out how exceptions to data cleaning and preparation are requested and approved.
- Confirm that reporting on cleaning and preparation reaches the people who can act.
- Record the technical debt in data cleaning and preparation and schedule repayment.
- Run a load test on cleaning and preparation at expected peak plus a margin.
Cleaning and preparation: build, pipeline and release discipline
2 sessions · 8 pointsSession 1Reviewing cleaning and preparation when nothing has gone wrong
- Anticipate the objections data cleaning and preparation will raise and prepare the answers.
- Set escalation thresholds for cleaning and preparation that work out of hours.
- Confirm every release of data cleaning and preparation can be rolled back within a defined time.
- Review access rights on cleaning and preparation and remove what is no longer needed.
Session 2What has to be agreed before work on cleaning and preparation starts
- Agree the indicators that will show whether data cleaning and preparation is improving.
- State the availability and recovery objectives for cleaning and preparation as numbers.
- Write down the assumptions underpinning the approach to data cleaning and preparation.
- Set delivery and reliability indicators for cleaning and preparation the team trusts.
Cleaning and preparation: backup, recovery and continuity
2 sessions · 8 pointsSession 1The paperwork for cleaning and preparation that is actually needed
- Document the runbook for data cleaning and preparation to the level a new engineer could use.
- Close out actions on cleaning and preparation rather than leaving them open indefinitely.
- Inventory third-party dependencies inside data cleaning and preparation and their update status.
- Prepare the summary of cleaning and preparation that senior management will read.
Session 2Documenting data cleaning and preparation so someone else can operate it
- Confirm that those complying with data cleaning and preparation understand why it exists.
- Rehearse the briefing on cleaning and preparation that would follow an incident.
- Name a single owner for each element of data cleaning and preparation.
- Measure current load on cleaning and preparation and project it forward twelve months.
Cleaning and preparation: documentation, support and handover
2 sessions · 8 pointsSession 1Dependencies and supply chain risk in cleaning and preparation
- Review logging on data cleaning and preparation for coverage and retention.
- Estimate the resource cleaning and preparation requires to run as designed.
- Identify the data already collected that bears on data cleaning and preparation.
- Confirm the support model and escalation path for cleaning and preparation.
Session 2Monitoring cleaning and preparation from the user's point of view
- Confirm data retention and deletion rules applied within data cleaning and preparation.
- Apply change control to cleaning and preparation including emergency changes.
- Build the internal briefing that explains data cleaning and preparation to those affected.
- Assess the exit route from any cloud or vendor dependency in cleaning and preparation.
Choose the package that suits you
Silver Package
At least 3 people
USD1,250
- Workshop or Program Participation
- Airport Transfers
- Customized Badge
- Expert Mentorship (Private Sessions)
- Supervision & Secretarial Services
- Accredited Certificate of Participation
- Complete Training Kit
- Coffee Break
- Closing Ceremony
Gold Package
At least 3 people
USD1,850
- 5-night stay in a 5-star hotel
- Workshop or Program Participation
- Airport Transfers
- Customized Badge
- Expert Mentorship (Private Sessions)
- Supervision & Secretarial Services
- Accredited Certificate of Participation
- Complete Training Kit
- Coffee Break
- Closing Ceremony
Complete your registration
We will contact you within one business day to confirm.