Advanced Acceleration for Teams that are ready

Advanced Accelerator Package

The Advanced Accelerator Package is a combined 2 week effort, on-site.  The effort is focused on increasing your teams’ skill set, either upgrading their knowledge of Data Vault (from Data Vault 1.0 to Data Vault 2.0) or increasing their level of skill around Data Vault 2.0 elements.  The implementation that follows is a rigorous advanced session aimed at fine-tuning the implementation practices already in play.

Teams that have undergone a kick start automatically qualify after 6 months of implementation experience.

Here’s what You’ll Learn

The training is fully customized to meet the needs (knowledge needs) of the team.  Many different topics are available from Big Data, to real-time, and Managed Self Service BI to information marts, MPP, performance and tuning, and Data Vault 2.0 best practices.   Because the training is customized, we agree as part of the statement of work, how many days the training will be, and how many students the training will include.  We also work with you to decide exactly what topics will be trained on.  Some of the topics available are listed below (all in relation to Data Vault 2.0 system of Business Intelligence)

  • Big Data – how does it work in MPP, Data Vault Models, and Hadoop platforms
  • NoSQL – best practices in Data Vault 2.0, where does it fit, why and how
  • Multi-structured and semi-structured data – how to incorporate it and work with it in Data Vault 2.0
  • Managed Self Service BI and Data Provisioning – how to execute on the vision and deliver value
  • Automation – getting started, repeatable patterns, authorized tool vendors in the DV2 space
  • Data Vault 2.0 Modeling – Upgrades, changes, and defining the Business Vaults
  • Data Mart (Information Mart) Virtualization – getting started guide, best practices, things to watch for
  • Referential Integrity and DV2 Models – including discussions in parallelism, partitioning, and data layout
  • Co-Location and Indexing on MPP – what it means, how it works, mitigating data redistribution
  • Automation with AnalytixDS and Mapping Manager – ** upon request **

NOTE: other topics available upon request.

Infrastructure Readiness

In order to engage in the advanced accelerator package, you must have in place, all the following components.  

  • Hardware for development & sandbox testing

  • Data for loading within the scope of implementation – MUST be available in a staging capacity before the Kick Start begins

  • ETL / ELT or SQL tooling – MUST be in place, and the team must already have a working knowledge of the tool set

  • Database Engine or Instance – MUST be in place and working prior the Kick Start beginning

Note: If addition to the above, if any addition software is required, it should be installed and ready to go as well.

Minimum Knowledge Exposure

The team must have a working background (at least 10 months or more) in the following skill sets:

  • Database Administration
  • Data Warehousing Concepts
  • Data Modeling
  • ETL / ELT implementation
  • SQL
  • basic project management, risk and mitigation

As an added requirement, this is now included in order to qualify for the Advanced Accelerator Package

  • 8 to 12 months of working experience in Data Vault projects OR Data Vault 1.0 Certified Data Vault Modeler OR Data Vault 2.0 Certified Practitioner (Preferred)

Contract Level Pre-Requisites

The following elements must be defined and are included as part of the statement of work that is submitted before the kick-start package can take place.

  • Scope of implementation – jointly decided between the authorized instructor and the project manager

  • Assigned/Named team implementation members – who will participate in the Kick Start Package.  The team members must be allocated 100% to the training and the project during the kick-start package. It is the only way we can ensure success

  • Assigned / Named resources for training – the team members who will be implementing must be listed in both training, and implementation teams.  There may be however additional resources attending the training who do not wish to participate in the implementation cycle.

  • Definition of goals for implementation – a descriptive paragraph or two that provides the guidance and goals of the implementation, in other words – what do you want to see as a result of the Kick-Start package?  This is written jointly with the authorized instructor and the project manager.

  • Short skills assessment of each of the implementation team members, ie: how well versed are they in SCRUM / AGILE?  Data Modeling? Database Administration? ETL?

  • Business Sponsorship must be in-place, so the objectives or goals are prioritized

The Mechanics of How the Consulting Works

The consulting portion of the Advanced Accelerator Package requires that the goals and objectives are in place, that the systems are in place, and that the requirements have been defined and agreed to by the business sponsor.  The consulting portion also demands that all the data sets are ready to go and have already been sourced and placed in the staging areas at a minimum.  The team is expected to be trained or at least familiar with SCRUM and agile practices.

The consulting follows the training immediately, and the instructor works with the team in an oversight capacity, and guidance capacity – participating in daily stand-up meetings (SCRUM reviews), helping the project manager escalate priorities with the business when necessary, looking for bottlenecks in the sourcing and acquisition process, and continuing to offer corrective guidance for the team while they are implementing.

The instructor will raise red flags and assess risks of the team not meeting the two week deadline, and effectively communicate that with the project managers and business stakeholders.  It is the job of the project manager to execute mitigation strategies that are decided upon by the business stakeholders.  The instructor will also provide working templates for a two week implementation project plan, a sample risk assessment document, a sample change request document and so on.  At the end, the instructor will write a short one or two page review of the entire two week effort, where the team stands, and what they need to do next to continue in a successful direction.

The team may or may not already have an automation or generation tool in place.  If the team does not have an automation tool in place, an authorized Data Vault 2.0 vendor will be suggested.