[All skill tests](https://jobicy.com/tests.md) Skill assessment # Data Lineage Mapping and Impact Analysis Skills Test Assess the ability to document data movement, trace transformations, and evaluate downstream consequences of change. This test focuses on practical lineage records that support reliable reporting, governance, and operational decisions. [Start the test](#test-start) Share Assessment setup Ready ## Choose the level that matches your current experience. * 01 Basic Available * 02 Intermediate Available * 03 Advanced Available Instant result Review your score after submission 20–30 Questions per assessment 15–45 min Estimated completion time 3 levels Choose your difficulty Data Quality & Governance [View category](https://jobicy.com/test-category/data-quality-governance.md) Start assessment ## Choose your level and begin. Answer without outside help so the result reflects your current knowledge. You will see your score after completing the selected assessment. Data lineage creates an evidence trail from source data through transformations, storage layers, semantic models, and business outputs. Well-maintained lineage helps teams investigate data incidents, assess planned changes, demonstrate control effectiveness, and establish confidence in reported metrics. Basic Intermediate Advanced This is a demo version of the test. You may attempt up to 3 questions. To take the full test and save your results, please [log in](https://jobicy.com/dashboard-page.md) or [create an account](https://jobicy.com/dashboard-page#tab2.md). This is a demo version of the test. You may attempt up to 3 questions. To take the full test and save your results, please [log in](https://jobicy.com/dashboard-page.md) or [create an account](https://jobicy.com/dashboard-page#tab2.md). This is a demo version of the test. You may attempt up to 3 questions. To take the full test and save your results, please [log in](https://jobicy.com/dashboard-page.md) or [create an account](https://jobicy.com/dashboard-page#tab2.md). Test details ## Know what to expect. Review the instructions, covered skills, example question themes, and intended audience before beginning. 01 ### Instructions and covered skills Read each question carefully before selecting a response. Focus on the stated systems, fields, transformations, and business outputs. Do not assume undocumented relationships or controls. Choose the response that best reflects a maintainable lineage practice. Stay focused and avoid distractions while working through the test. Turn off notifications and reserve enough uninterrupted time to review each scenario. ### Key Areas This test evaluates the ability to map and interpret how data moves across operational sources, ingestion processes, transformation layers, curated datasets, semantic models, dashboards, extracts, and regulatory outputs. Candidates should be able to distinguish dataset-level relationships from column-level relationships and identify when more detailed field tracing is necessary. They should understand how to document source systems, source objects, target objects, transformation logic, owners, refresh dependencies, and business definitions in a lineage record. Strong performance requires practical impact-analysis judgment. This includes tracing a proposed source-field change through pipelines and derived assets, identifying reports or metrics affected by a failed transformation, and separating direct dependencies from downstream dependencies. The test also covers lineage for joins, aggregations, filters, unions, calculated fields, reference-data lookups, and manual inputs. Attention is given to preserving the relationship between technical metadata and the business meaning of a metric. Candidates should recognize that lineage is not a one-time diagram. Useful records have accountable owners, validation evidence, review triggers, and a process for reflecting changes. They should also understand how lineage supports incident investigation, change approval, audit requests, data-access review, and trust in published information. ### Recommended Preparation Review examples of data catalogs, lineage diagrams, pipeline documentation, and impact-assessment records used in analytics or data-platform environments. Practice tracing a business metric backward from a dashboard to a semantic measure, curated table, transformation job, and source field. Then trace a source change forward to the models, reports, extracts, and operational processes that consume it. Study common transformation patterns, including field renaming, type conversion, deduplication, aggregation, joins, filtering, derived calculations, and reference-data enrichment. Practice writing lineage statements that name the source, target, logic, schedule, and accountable role without relying on undocumented assumptions. When reviewing a lineage map, look for missing manual steps, ambiguous ownership, hidden spreadsheet dependencies, and stale references after system changes. 02 ### Examples of questions 1. What information should a lineage record capture for a calculated reporting field? 2. How does column-level lineage differ from dataset-level lineage? 3. Which relationship should be recorded when a dashboard metric uses a semantic-model measure? 4. What should occur when a source column is renamed? 5. How can lineage support investigation of an incorrect monthly total? 6. What is the purpose of documenting a transformation rule in a lineage map? 7. Which downstream assets should be included in an impact assessment? 8. How should a lineage record represent a many-to-one data consolidation? 9. Why should manual spreadsheet inputs be included in lineage documentation? 10. What evidence can validate that a lineage relationship remains current? 03 ### Who this test is best for Data analysts, analytics engineers, data stewards, BI developers, data governance practitioners, and platform teams responsible for trusted data products. Related assessments ## Continue with a similar skill test. Explore assessments from the same professional area to compare adjacent skills and build a broader picture of your knowledge. [Statistics & Experimentation 3 levelsA/B Test Statistical Inference and Experiment Analysis Skills TestThis test evaluates the statistical reasoning used to design, analyze, and communicate A/B test results. It focuses on valid comparisons, uncertainty, decision rules,… Open assessment →](https://jobicy.com/tests/a-b-test-statistical-inference-and-experiment-analysis-skills-test.md) [Excel & Google Sheets 3 levelsExcel and Google Sheets Lookup Formula Design Skills TestThis test evaluates the ability to retrieve, match, and validate data with lookup formulas in Excel and Google Sheets. It focuses on selecting… Open assessment →](https://jobicy.com/tests/excel-and-google-sheets-lookup-formula-design-skills-test.md) [SQL & Databases 3 levelsPostgreSQL Index Design and Query Plan Analysis Skills TestEvaluate how well you design PostgreSQL indexes and interpret query execution plans. The test focuses on matching index structures to query predicates, joins,… Open assessment →](https://jobicy.com/tests/postgresql-index-design-and-query-plan-analysis-skills-test.md) [Data Interpretation & Visualization 3 levelsTableau Dashboard Design and Visual Encoding Skills TestAssess the ability to design Tableau dashboards that communicate data clearly and support sound decisions. The test focuses on chart selection, visual encodings,… Open assessment →](https://jobicy.com/tests/tableau-dashboard-design-and-visual-encoding-skills-test.md) [Business Metrics & KPI Analysis 3 levelsSaaS Cohort Retention and Churn Analysis Skills TestThis test evaluates the ability to build, interpret, and act on SaaS customer retention cohorts. It focuses on consistent cohort definitions, retention calculations,… Open assessment →](https://jobicy.com/tests/saas-cohort-retention-and-churn-analysis-skills-test.md) [Business Metrics & KPI Analysis 3 levelsRole-Specific KPI Identification Skills TestThis test evaluates your ability to select the most relevant Key Performance Indicators for various digital roles. Master this skill to ensure your… Open assessment →](https://jobicy.com/tests/role-specific-kpi-identification-skills-test.md) [SQL & Databases 3 levelsSQL JOINs and Multi-Table Queries Skills TestMaster the art of combining data from multiple tables using SQL JOINs. This test evaluates your ability to write efficient queries using various… Open assessment →](https://jobicy.com/tests/sql-joins-and-multi-table-queries-skills-test.md) [Data Interpretation & Visualization 3 levelsData Storytelling Techniques Skills AssessmentThis assessment evaluates your ability to craft compelling narratives using data. It covers key techniques for turning raw numbers into actionable insights. Open assessment →](https://jobicy.com/tests/data-storytelling-techniques-skills-assessment.md) [Excel & Google Sheets 3 levelsPivot Tables and Data Summarization Skills TestThis test assesses your proficiency with pivot tables in Excel and Google Sheets, focusing on data summarization, grouping, and analysis techniques. Ideal for… Open assessment →](https://jobicy.com/tests/pivot-tables-and-data-summarization-skills-test.md) ## Share the assessment or try another skill. Send this test to a colleague or friend, or return to the assessment library to explore another professional area. Share this test [Browse all tests](https://jobicy.com/tests.md)