The Data Warehouse Concepts test is designed to measure the knowledge and skills of entry-level to mid-level information technology professionals in designing, implementing, and operating data warehouses for common business uses. The test evaluates a broad range of topic areas, including Dimensional Modeling, ETL Processes, Data Quality and Cleansing, Slowly Changing Dimensions, Reporting, Aggregations, and Query Design, as well as Data Governance and Metadata. Candidates are assessed through a variety of question formats, including Essay Composition, Multiple Choice, and Multiple Correct Answer questions, with questions drawn from a large pool to help prevent cheating, and one or more questions featuring individual time limits to further deter cheating and improve predictive performance. One or more questions are scored using artificial intelligence to ensure accurate and consistent evaluation of candidate responses.

The specific attributes measured include:

Following completion, the test produces a Candidate Selection Report that includes an overall score and detailed scores for each attribute.

The Candidate Selection Report also provides expert interview questions that help you probe critical or low-scoring areas, along with a guide for noting your evaluation of the candidate's responses. Consistent use of an interview guide is an important part of gaining better candidate insights and making better hiring decisions.

Note that while the Data Warehouse Concepts assessment is a useful and efficient instrument for confirming a base level of skill or knowledge about this important topic, it is not intended to pinpoint the exact level of candidate or skill. We recommend that skills tests, like this one, be used in parallel with other measurements, such as cognitive ability, job fit, and behavioral history. Each different type of test provides a valuable piece of information you can use when evaluating potential job performance.