Skills Census (Kantata)

⚡ Generate from source material ⬇ Export .yarnpack.json Advanced: raw JSON

Metadata

Scales, categories & audiences

Scales: none · Categories: fabric powerbi data_eng databricks ai_ml azure_cloud dev devops power_platform sql_server governance delivery · Audiences: none (everyone gets everything)

Edit these in the raw JSON editor below — they change rarely and carry structure (levels, signals, deep-dive wiring) that a form would mangle.

About you about

Thirty seconds of context — it calibrates everything after.

Id	Question	Type	Category	Scale
consultant_level	What's your current level?	single_select	—	—

＋ Add question to “About you”

Certifications certs

Certs first — they pre-answer some of the detail questions.

Id	Question	Type	Category	Scale
ms_certs	Which Microsoft certifications do you currently hold?	multi_select	—	—
other_certs	And any of these others?	multi_select	—	—

＋ Add question to “Certifications”

Your areas areas

The broad strokes — only the areas you pick get follow-up questions.

Id	Question	Type	Category	Scale
work_areas	Which of these areas do you genuinely work in? (Your certs will open some automatically.)	multi_select	—	—

＋ Add question to “Your areas”

Microsoft Fabric dd_fabric · conditional

Lakehouse, pipelines, RTI, Copilot, admin — the Fabric estate.

Id	Question	Type	Category	Scale
fabric_use	Microsoft Fabric: which of these do you work with hands-on?	multi_select	fabric	—
fabric_lead	And which of those could you lead or design at client-facing level?	multi_select	fabric	—

＋ Add question to “Microsoft Fabric”

Power BI & Reporting dd_powerbi · conditional

Modelling, DAX, Power Query, visualisation, governance.

Id	Question	Type	Category	Scale
powerbi_use	Power BI & Reporting: which of these do you work with hands-on?	multi_select	powerbi	—
powerbi_lead	And which of those could you lead or design at client-facing level?	multi_select	powerbi	—

＋ Add question to “Power BI & Reporting”

Data Engineering & Azure Data Platform dd_data_eng · conditional

ADF, Synapse, SQL DB, Cosmos, dbt — moving and shaping data.

Id	Question	Type	Category	Scale
data_eng_use	Data Engineering & Azure Data Platform: which of these do you work with hands-on?	multi_select	data_eng	—
data_eng_lead	And which of those could you lead or design at client-facing level?	multi_select	data_eng	—

＋ Add question to “Data Engineering & Azure Data Platform”

Databricks dd_databricks · conditional

Development, DLT, streaming, workflows, admin — and its ML side.

Id	Question	Type	Category	Scale
databricks_use	Databricks: which of these do you work with hands-on?	multi_select	databricks	—
databricks_lead	And which of those could you lead or design at client-facing level?	multi_select	databricks	—

＋ Add question to “Databricks”

AI & Machine Learning dd_ai_ml · conditional

Azure AI/OpenAI, ML engineering, MLOps, advanced analytics.

Id	Question	Type	Category	Scale
ai_ml_use	AI & Machine Learning: which of these do you work with hands-on?	multi_select	ai_ml	—
ai_ml_lead	And which of those could you lead or design at client-facing level?	multi_select	ai_ml	—

＋ Add question to “AI & Machine Learning”

Azure Cloud & Infrastructure dd_azure_cloud · conditional

App services, networking, security, monitoring, cost.

Id	Question	Type	Category	Scale
azure_cloud_use	Azure Cloud & Infrastructure: which of these do you work with hands-on?	multi_select	azure_cloud	—
azure_cloud_lead	And which of those could you lead or design at client-facing level?	multi_select	azure_cloud	—

＋ Add question to “Azure Cloud & Infrastructure”

Software Development dd_dev · conditional

Languages and front-end frameworks.

Id	Question	Type	Category	Scale
dev_use	Software Development: which of these do you work with hands-on?	multi_select	dev	—
dev_lead	And which of those could you lead or design at client-facing level?	multi_select	dev	—

＋ Add question to “Software Development”

DevOps & Infrastructure-as-Code dd_devops · conditional

Azure DevOps, GitHub, ARM/Bicep/Terraform.

Id	Question	Type	Category	Scale
devops_use	DevOps & Infrastructure-as-Code: which of these do you work with hands-on?	multi_select	devops	—
devops_lead	And which of those could you lead or design at client-facing level?	multi_select	devops	—

＋ Add question to “DevOps & Infrastructure-as-Code”

Power Platform & Business Apps dd_power_platform · conditional

Power Apps, Power Automate, chatbots/agents.

Id	Question	Type	Category	Scale
power_platform_use	Power Platform & Business Apps: which of these do you work with hands-on?	multi_select	power_platform	—
power_platform_lead	And which of those could you lead or design at client-facing level?	multi_select	power_platform	—

＋ Add question to “Power Platform & Business Apps”

SQL Server & classic Microsoft BI dd_sql_server · conditional

SQL Server, SSAS, SSIS, SSRS.

Id	Question	Type	Category	Scale
sql_server_use	SQL Server & classic Microsoft BI: which of these do you work with hands-on?	multi_select	sql_server	—
sql_server_lead	And which of those could you lead or design at client-facing level?	multi_select	sql_server	—

＋ Add question to “SQL Server & classic Microsoft BI”

Data Governance & Purview dd_governance · conditional

Purview, DLP, information protection — plus our governance IP.

Id	Question	Type	Category	Scale
governance_use	Data Governance & Purview: which of these do you work with hands-on?	multi_select	governance	—
governance_lead	And which of those could you lead or design at client-facing level?	multi_select	governance	—

＋ Add question to “Data Governance & Purview”

Delivery, Advisory & Architecture dd_delivery · conditional

PM, business analysis, roadmaps and architecture.

Id	Question	Type	Category	Scale
delivery_use	Delivery, Advisory & Architecture: which of these do you work with hands-on?	multi_select	delivery	—
delivery_lead	And which of those could you lead or design at client-facing level?	multi_select	delivery	—

＋ Add question to “Delivery, Advisory & Architecture”

The bits lists miss closers

Id	Question	Type	Category	Scale
not_listed	Any skills or certifications you have that weren't listed?	verbatim	—	—
growth_next	Which two or three skills do you most want to grow next year?	verbatim	—	—

＋ Add question to “The bits lists miss”

Add section

Advanced — raw JSON

Full pack document, validated on save (schema yarn-pack/2). This is where scales, audiences, structured conditions and adaptive config live.

{
  "schema": "yarn-pack/2",
  "id": "skills-stocktake",
  "version": "0.2.0",
  "name": "Skills Census (Kantata)",
  "engagement": "Internal — consultant skills census on the Kantata skill list",
  "intro": "A quick skills census — mostly ticking, five minutes or so. Your certs open the right deep-dives automatically, and you only get asked about areas you actually work in.",
  "tone_default": "professional",
  "prefill_fields": {},
  "scales": [],
  "categories": [
    {
      "id": "fabric",
      "name": "Microsoft Fabric",
      "order": 1
    },
    {
      "id": "powerbi",
      "name": "Power BI & Reporting",
      "order": 2
    },
    {
      "id": "data_eng",
      "name": "Data Engineering & Azure Data Platform",
      "order": 3
    },
    {
      "id": "databricks",
      "name": "Databricks",
      "order": 4
    },
    {
      "id": "ai_ml",
      "name": "AI & Machine Learning",
      "order": 5
    },
    {
      "id": "azure_cloud",
      "name": "Azure Cloud & Infrastructure",
      "order": 6
    },
    {
      "id": "dev",
      "name": "Software Development",
      "order": 7
    },
    {
      "id": "devops",
      "name": "DevOps & Infrastructure-as-Code",
      "order": 8
    },
    {
      "id": "power_platform",
      "name": "Power Platform & Business Apps",
      "order": 9
    },
    {
      "id": "sql_server",
      "name": "SQL Server & classic Microsoft BI",
      "order": 10
    },
    {
      "id": "governance",
      "name": "Data Governance & Purview",
      "order": 11
    },
    {
      "id": "delivery",
      "name": "Delivery, Advisory & Architecture",
      "order": 12
    }
  ],
  "audiences": [],
  "sections": [
    {
      "id": "about",
      "title": "About you",
      "blurb": "Thirty seconds of context — it calibrates everything after.",
      "optional": false,
      "questions": [
        {
          "id": "consultant_level",
          "type": "single_select",
          "name": "Consultant level",
          "text": "What's your current level?",
          "scored": false,
          "star": false,
          "options": [
            {
              "value": "consultant",
              "label": "Consultant"
            },
            {
              "value": "senior",
              "label": "Senior Consultant"
            },
            {
              "value": "lead",
              "label": "Lead Consultant"
            },
            {
              "value": "principal",
              "label": "Principal"
            }
          ],
          "ai_drafted": false
        }
      ]
    },
    {
      "id": "certs",
      "title": "Certifications",
      "blurb": "Certs first — they pre-answer some of the detail questions.",
      "optional": false,
      "questions": [
        {
          "id": "ms_certs",
          "type": "multi_select",
          "name": "Microsoft certifications",
          "text": "Which Microsoft certifications do you currently hold?",
          "scored": false,
          "star": false,
          "options": [
            {
              "value": "ai_102_azure_ai_engineer_associate",
              "label": "AI-102 Azure AI Engineer Associate"
            },
            {
              "value": "az_104_azure_administrator_associate",
              "label": "AZ-104 Azure Administrator Associate"
            },
            {
              "value": "az_204_azure_developer_associate",
              "label": "AZ-204 Azure Developer Associate"
            },
            {
              "value": "az_305_azure_solutions_architect_expert",
              "label": "AZ-305 Azure Solutions Architect Expert"
            },
            {
              "value": "az_400_devops_engineer_expert",
              "label": "AZ-400 DevOps Engineer Expert"
            },
            {
              "value": "az_500_azure_security_technologies",
              "label": "AZ-500 Azure Security Technologies"
            },
            {
              "value": "az_700_azure_network_solutions",
              "label": "AZ-700 Azure Network Solutions"
            },
            {
              "value": "az_900_azure_fundamentals",
              "label": "AZ-900 Azure Fundamentals"
            },
            {
              "value": "dp_100_azure_data_scientist_associate",
              "label": "DP-100 Azure Data Scientist Associate"
            },
            {
              "value": "dp_100_designing_and_implementing_a_data",
              "label": "DP-100 Designing and Implementing a Data Science Solution on Azure"
            },
            {
              "value": "dp_203_data_engineering_on_microsoft_azu",
              "label": "DP-203 Data Engineering on Microsoft Azure"
            },
            {
              "value": "dp_300_azure_database_administrator_asso",
              "label": "DP-300 Azure Database Administrator Associate"
            },
            {
              "value": "dp_420_azure_cosmos_db_developer_special",
              "label": "DP-420 Azure Cosmos DB Developer Specialty"
            },
            {
              "value": "dp_600_fabric_analytics_engineer_associa",
              "label": "DP-600 Fabric Analytics Engineer Associate"
            },
            {
              "value": "dp_700_fabric_data_engineer_associate",
              "label": "DP-700 Fabric Data Engineer Associate"
            },
            {
              "value": "dp_900_azure_data_fundamentals",
              "label": "DP-900 Azure Data Fundamentals"
            },
            {
              "value": "mb_920_dynamics_365_fundamentals_erp",
              "label": "MB-920 Dynamics 365 Fundamentals (ERP)"
            },
            {
              "value": "mcsa_bi_reporting",
              "label": "MCSA BI Reporting"
            },
            {
              "value": "mcse_azure_cloud_platform",
              "label": "MCSE Azure Cloud Platform"
            },
            {
              "value": "microsoft_certified_professional",
              "label": "Microsoft Certified Professional"
            },
            {
              "value": "microsoft_certified_trainer",
              "label": "Microsoft Certified Trainer"
            },
            {
              "value": "microsoft_applied_skills_copilot_studio_",
              "label": "Microsoft Applied Skills: Copilot Studio agents (APL-7008)"
            },
            {
              "value": "microsoft_applied_skills_real_time_intel",
              "label": "Microsoft Applied Skills: Real-Time Intelligence with Fabric"
            },
            {
              "value": "pl_200_power_platform_functional_consult",
              "label": "PL-200 Power Platform Functional Consultant"
            },
            {
              "value": "pl_300_power_bi_data_analyst_associate",
              "label": "PL-300 Power BI Data Analyst Associate"
            },
            {
              "value": "pl_400_power_platform_developer_associat",
              "label": "PL-400 Power Platform Developer Associate"
            },
            {
              "value": "pl_500_power_automate_rpa_developer",
              "label": "PL-500 Power Automate RPA Developer"
            },
            {
              "value": "pl_600_power_platform_solution_architect",
              "label": "PL-600 Power Platform Solution Architect Expert"
            }
          ],
          "ai_drafted": false
        },
        {
          "id": "other_certs",
          "type": "multi_select",
          "name": "Other certifications",
          "text": "And any of these others?",
          "scored": false,
          "star": false,
          "options": [
            {
              "value": "aws_cloud_practitioner",
              "label": "AWS Cloud Practitioner"
            },
            {
              "value": "aws_dea_c01_aws_certified_data_engineer",
              "label": "AWS-DEA-C01 AWS Certified Data Engineer"
            },
            {
              "value": "cb_100_couchbase_capella_associate_admin",
              "label": "CB-100 Couchbase Capella Associate Administrator"
            },
            {
              "value": "cb131_couchbase_certified_associate_arch",
              "label": "CB131 Couchbase Certified Associate Architect"
            },
            {
              "value": "cs300_couchbase_certified_professional_a",
              "label": "CS300 Couchbase Certified Professional Administrator"
            },
            {
              "value": "certified_scrum_master",
              "label": "Certified Scrum Master"
            },
            {
              "value": "databricks_certified_generative_ai_engin",
              "label": "Databricks Certified Generative AI Engineer Associate"
            },
            {
              "value": "databricks_data_engineer_associate",
              "label": "Databricks Data Engineer Associate"
            },
            {
              "value": "databricks_data_engineer_professional",
              "label": "Databricks Data Engineer Professional"
            },
            {
              "value": "p3o_foundation",
              "label": "P3O Foundation"
            },
            {
              "value": "pmi_agile_certified_practitioner_pmi_acp",
              "label": "PMI Agile Certified Practitioner (PMI-ACP)"
            },
            {
              "value": "project_management_professional_pmp",
              "label": "Project Management Professional (PMP)"
            },
            {
              "value": "safe_scrum_master",
              "label": "SAFe Scrum Master"
            },
            {
              "value": "salesforce_tableau_desktop_foundations",
              "label": "Salesforce Tableau Desktop Foundations"
            },
            {
              "value": "togaf_foundation",
              "label": "TOGAF Foundation"
            }
          ],
          "ai_drafted": false
        }
      ]
    },
    {
      "id": "areas",
      "title": "Your areas",
      "blurb": "The broad strokes — only the areas you pick get follow-up questions.",
      "optional": false,
      "questions": [
        {
          "id": "work_areas",
          "type": "multi_select",
          "name": "Areas you work in",
          "text": "Which of these areas do you genuinely work in? (Your certs will open some automatically.)",
          "scored": false,
          "star": false,
          "options": [
            {
              "value": "fabric",
              "label": "Microsoft Fabric"
            },
            {
              "value": "powerbi",
              "label": "Power BI & Reporting"
            },
            {
              "value": "data_eng",
              "label": "Data Engineering & Azure Data Platform"
            },
            {
              "value": "databricks",
              "label": "Databricks"
            },
            {
              "value": "ai_ml",
              "label": "AI & Machine Learning"
            },
            {
              "value": "azure_cloud",
              "label": "Azure Cloud & Infrastructure"
            },
            {
              "value": "dev",
              "label": "Software Development"
            },
            {
              "value": "devops",
              "label": "DevOps & Infrastructure-as-Code"
            },
            {
              "value": "power_platform",
              "label": "Power Platform & Business Apps"
            },
            {
              "value": "sql_server",
              "label": "SQL Server & classic Microsoft BI"
            },
            {
              "value": "governance",
              "label": "Data Governance & Purview"
            },
            {
              "value": "delivery",
              "label": "Delivery, Advisory & Architecture"
            }
          ],
          "ai_drafted": false
        }
      ]
    },
    {
      "id": "dd_fabric",
      "title": "Microsoft Fabric",
      "blurb": "Lakehouse, pipelines, RTI, Copilot, admin — the Fabric estate.",
      "optional": false,
      "condition": {
        "any": [
          {
            "q": "work_areas",
            "op": "has",
            "value": "fabric"
          },
          {
            "q": "ms_certs",
            "op": "has",
            "value": "dp_600_fabric_analytics_engineer_associa"
          },
          {
            "q": "ms_certs",
            "op": "has",
            "value": "dp_700_fabric_data_engineer_associate"
          },
          {
            "q": "ms_certs",
            "op": "has",
            "value": "microsoft_applied_skills_real_time_intel"
          }
        ]
      },
      "condition_note": "opens when the area is claimed OR a matching certification is ticked",
      "questions": [
        {
          "id": "fabric_use",
          "type": "multi_select",
          "category": "fabric",
          "name": "Microsoft Fabric — works with",
          "text": "Microsoft Fabric: which of these do you work with hands-on?",
          "scored": false,
          "star": false,
          "options": [
            {
              "value": "agile_insights_fabric_framework_deployme",
              "label": "Agile Insights: Fabric Framework - Deployment"
            },
            {
              "value": "agile_insights_fabric_framework_usage",
              "label": "Agile Insights: Fabric Framework - Usage"
            },
            {
              "value": "fabric_administration",
              "label": "Fabric - Administration"
            },
            {
              "value": "fabric_ai_ml",
              "label": "Fabric - AI / ML"
            },
            {
              "value": "fabric_analytics",
              "label": "Fabric - Analytics"
            },
            {
              "value": "fabric_collaboration_productivity",
              "label": "Fabric - Collaboration & Productivity"
            },
            {
              "value": "fabric_copilot",
              "label": "Fabric - Copilot"
            },
            {
              "value": "fabric_data_engineering",
              "label": "Fabric - Data Engineering"
            },
            {
              "value": "fabric_deployment_pipelines",
              "label": "Fabric - Deployment Pipelines"
            },
            {
              "value": "fabric_git_driven_deployments",
              "label": "Fabric - Git-driven Deployments"
            },
            {
              "value": "fabric_governance_data_security",
              "label": "Fabric - Governance & Data Security"
            },
            {
              "value": "fabric_licensing",
              "label": "Fabric - Licensing"
            },
            {
              "value": "fabric_overview",
              "label": "Fabric - Overview"
            },
            {
              "value": "fabric_real_time_intelligence",
              "label": "Fabric - Real-time Intelligence"
            }
          ],
          "ai_drafted": false
        },
        {
          "id": "fabric_lead",
          "type": "multi_select",
          "category": "fabric",
          "name": "Microsoft Fabric — can lead",
          "text": "And which of those could you lead or design at client-facing level?",
          "scored": false,
          "star": false,
          "options": [
            {
              "value": "agile_insights_fabric_framework_deployme",
              "label": "Agile Insights: Fabric Framework - Deployment"
            },
            {
              "value": "agile_insights_fabric_framework_usage",
              "label": "Agile Insights: Fabric Framework - Usage"
            },
            {
              "value": "fabric_administration",
              "label": "Fabric - Administration"
            },
            {
              "value": "fabric_ai_ml",
              "label": "Fabric - AI / ML"
            },
            {
              "value": "fabric_analytics",
              "label": "Fabric - Analytics"
            },
            {
              "value": "fabric_collaboration_productivity",
              "label": "Fabric - Collaboration & Productivity"
            },
            {
              "value": "fabric_copilot",
              "label": "Fabric - Copilot"
            },
            {
              "value": "fabric_data_engineering",
              "label": "Fabric - Data Engineering"
            },
            {
              "value": "fabric_deployment_pipelines",
              "label": "Fabric - Deployment Pipelines"
            },
            {
              "value": "fabric_git_driven_deployments",
              "label": "Fabric - Git-driven Deployments"
            },
            {
              "value": "fabric_governance_data_security",
              "label": "Fabric - Governance & Data Security"
            },
            {
              "value": "fabric_licensing",
              "label": "Fabric - Licensing"
            },
            {
              "value": "fabric_overview",
              "label": "Fabric - Overview"
            },
            {
              "value": "fabric_real_time_intelligence",
              "label": "Fabric - Real-time Intelligence"
            }
          ],
          "ai_drafted": false
        }
      ]
    },
    {
      "id": "dd_powerbi",
      "title": "Power BI & Reporting",
      "blurb": "Modelling, DAX, Power Query, visualisation, governance.",
      "optional": false,
      "condition": {
        "any": [
          {
            "q": "work_areas",
            "op": "has",
            "value": "powerbi"
          },
          {
            "q": "ms_certs",
            "op": "has",
            "value": "pl_300_power_bi_data_analyst_associate"
          },
          {
            "q": "ms_certs",
            "op": "has",
            "value": "mcsa_bi_reporting"
          }
        ]
      },
      "condition_note": "opens when the area is claimed OR a matching certification is ticked",
      "questions": [
        {
          "id": "powerbi_use",
          "type": "multi_select",
          "category": "powerbi",
          "name": "Power BI & Reporting — works with",
          "text": "Power BI & Reporting: which of these do you work with hands-on?",
          "scored": false,
          "star": false,
          "options": [
            {
              "value": "bi_general",
              "label": "BI - General"
            },
            {
              "value": "power_bi_admin_governance_security",
              "label": "Power BI - Admin, Governance & Security"
            },
            {
              "value": "power_bi_data_modeling",
              "label": "Power BI - Data Modeling"
            },
            {
              "value": "power_bi_dax_language",
              "label": "Power BI - DAX Language"
            },
            {
              "value": "power_bi_desktop",
              "label": "Power BI - Desktop"
            },
            {
              "value": "power_bi_dimensional_modelling",
              "label": "Power BI - Dimensional Modelling"
            },
            {
              "value": "power_bi_pagination",
              "label": "Power BI - Pagination"
            },
            {
              "value": "power_bi_power_query_functions_and_inter",
              "label": "Power BI - Power Query (Functions and Interface)"
            },
            {
              "value": "power_bi_power_query_m_language",
              "label": "Power BI - Power Query (M Language)"
            },
            {
              "value": "power_bi_visualisation_and_design",
              "label": "Power BI - Visualisation and Design"
            }
          ],
          "ai_drafted": false
        },
        {
          "id": "powerbi_lead",
          "type": "multi_select",
          "category": "powerbi",
          "name": "Power BI & Reporting — can lead",
          "text": "And which of those could you lead or design at client-facing level?",
          "scored": false,
          "star": false,
          "options": [
            {
              "value": "bi_general",
              "label": "BI - General"
            },
            {
              "value": "power_bi_admin_governance_security",
              "label": "Power BI - Admin, Governance & Security"
            },
            {
              "value": "power_bi_data_modeling",
              "label": "Power BI - Data Modeling"
            },
            {
              "value": "power_bi_dax_language",
              "label": "Power BI - DAX Language"
            },
            {
              "value": "power_bi_desktop",
              "label": "Power BI - Desktop"
            },
            {
              "value": "power_bi_dimensional_modelling",
              "label": "Power BI - Dimensional Modelling"
            },
            {
              "value": "power_bi_pagination",
              "label": "Power BI - Pagination"
            },
            {
              "value": "power_bi_power_query_functions_and_inter",
              "label": "Power BI - Power Query (Functions and Interface)"
            },
            {
              "value": "power_bi_power_query_m_language",
              "label": "Power BI - Power Query (M Language)"
            },
            {
              "value": "power_bi_visualisation_and_design",
              "label": "Power BI - Visualisation and Design"
            }
          ],
          "ai_drafted": false
        }
      ]
    },
    {
      "id": "dd_data_eng",
      "title": "Data Engineering & Azure Data Platform",
      "blurb": "ADF, Synapse, SQL DB, Cosmos, dbt — moving and shaping data.",
      "optional": false,
      "condition": {
        "any": [
          {
            "q": "work_areas",
            "op": "has",
            "value": "data_eng"
          },
          {
            "q": "ms_certs",
            "op": "has",
            "value": "dp_203_data_engineering_on_microsoft_azu"
          },
          {
            "q": "ms_certs",
            "op": "has",
            "value": "dp_300_azure_database_administrator_asso"
          },
          {
            "q": "ms_certs",
            "op": "has",
            "value": "dp_420_azure_cosmos_db_developer_special"
          },
          {
            "q": "ms_certs",
            "op": "has",
            "value": "dp_900_azure_data_fundamentals"
          },
          {
            "q": "other_certs",
            "op": "has",
            "value": "aws_dea_c01_aws_certified_data_engineer"
          }
        ]
      },
      "condition_note": "opens when the area is claimed OR a matching certification is ticked",
      "questions": [
        {
          "id": "data_eng_use",
          "type": "multi_select",
          "category": "data_eng",
          "name": "Data Engineering & Azure Data Platform — works with",
          "text": "Data Engineering & Azure Data Platform: which of these do you work with hands-on?",
          "scored": false,
          "star": false,
          "options": [
            {
              "value": "azure_cosmosdb",
              "label": "Azure - CosmosDB"
            },
            {
              "value": "azure_data_factory",
              "label": "Azure - Data Factory"
            },
            {
              "value": "azure_data_warehouse_synapse",
              "label": "Azure - Data Warehouse/Synapse"
            },
            {
              "value": "azure_sql_database",
              "label": "Azure - SQL Database"
            },
            {
              "value": "dbt",
              "label": "dbt"
            },
            {
              "value": "de_general_data_engineering",
              "label": "DE - General (Data Engineering)"
            }
          ],
          "ai_drafted": false
        },
        {
          "id": "data_eng_lead",
          "type": "multi_select",
          "category": "data_eng",
          "name": "Data Engineering & Azure Data Platform — can lead",
          "text": "And which of those could you lead or design at client-facing level?",
          "scored": false,
          "star": false,
          "options": [
            {
              "value": "azure_cosmosdb",
              "label": "Azure - CosmosDB"
            },
            {
              "value": "azure_data_factory",
              "label": "Azure - Data Factory"
            },
            {
              "value": "azure_data_warehouse_synapse",
              "label": "Azure - Data Warehouse/Synapse"
            },
            {
              "value": "azure_sql_database",
              "label": "Azure - SQL Database"
            },
            {
              "value": "dbt",
              "label": "dbt"
            },
            {
              "value": "de_general_data_engineering",
              "label": "DE - General (Data Engineering)"
            }
          ],
          "ai_drafted": false
        }
      ]
    },
    {
      "id": "dd_databricks",
      "title": "Databricks",
      "blurb": "Development, DLT, streaming, workflows, admin — and its ML side.",
      "optional": false,
      "condition": {
        "any": [
          {
            "q": "work_areas",
            "op": "has",
            "value": "databricks"
          },
          {
            "q": "other_certs",
            "op": "has",
            "value": "databricks_certified_generative_ai_engin"
          },
          {
            "q": "other_certs",
            "op": "has",
            "value": "databricks_data_engineer_associate"
          },
          {
            "q": "other_certs",
            "op": "has",
            "value": "databricks_data_engineer_professional"
          }
        ]
      },
      "condition_note": "opens when the area is claimed OR a matching certification is ticked",
      "questions": [
        {
          "id": "databricks_use",
          "type": "multi_select",
          "category": "databricks",
          "name": "Databricks — works with",
          "text": "Databricks: which of these do you work with hands-on?",
          "scored": false,
          "star": false,
          "options": [
            {
              "value": "advanced_analytics_databricks_ml_focus",
              "label": "Advanced Analytics - Databricks (ML Focus)"
            },
            {
              "value": "agile_insights_databricks_framework_depl",
              "label": "Agile Insights: Databricks Framework - Deployment"
            },
            {
              "value": "agile_insights_databricks_framework_usag",
              "label": "Agile Insights: Databricks Framework - Usage"
            },
            {
              "value": "databricks_administration",
              "label": "Databricks - Administration"
            },
            {
              "value": "databricks_asset_bundles",
              "label": "Databricks - Asset Bundles"
            },
            {
              "value": "databricks_delta_live_tables",
              "label": "Databricks - Delta Live Tables"
            },
            {
              "value": "databricks_development",
              "label": "Databricks - Development"
            },
            {
              "value": "databricks_streaming",
              "label": "Databricks - Streaming"
            },
            {
              "value": "databricks_workflows",
              "label": "Databricks - Workflows"
            }
          ],
          "ai_drafted": false
        },
        {
          "id": "databricks_lead",
          "type": "multi_select",
          "category": "databricks",
          "name": "Databricks — can lead",
          "text": "And which of those could you lead or design at client-facing level?",
          "scored": false,
          "star": false,
          "options": [
            {
              "value": "advanced_analytics_databricks_ml_focus",
              "label": "Advanced Analytics - Databricks (ML Focus)"
            },
            {
              "value": "agile_insights_databricks_framework_depl",
              "label": "Agile Insights: Databricks Framework - Deployment"
            },
            {
              "value": "agile_insights_databricks_framework_usag",
              "label": "Agile Insights: Databricks Framework - Usage"
            },
            {
              "value": "databricks_administration",
              "label": "Databricks - Administration"
            },
            {
              "value": "databricks_asset_bundles",
              "label": "Databricks - Asset Bundles"
            },
            {
              "value": "databricks_delta_live_tables",
              "label": "Databricks - Delta Live Tables"
            },
            {
              "value": "databricks_development",
              "label": "Databricks - Development"
            },
            {
              "value": "databricks_streaming",
              "label": "Databricks - Streaming"
            },
            {
              "value": "databricks_workflows",
              "label": "Databricks - Workflows"
            }
          ],
          "ai_drafted": false
        }
      ]
    },
    {
      "id": "dd_ai_ml",
      "title": "AI & Machine Learning",
      "blurb": "Azure AI/OpenAI, ML engineering, MLOps, advanced analytics.",
      "optional": false,
      "condition": {
        "any": [
          {
            "q": "work_areas",
            "op": "has",
            "value": "ai_ml"
          },
          {
            "q": "ms_certs",
            "op": "has",
            "value": "ai_102_azure_ai_engineer_associate"
          },
          {
            "q": "ms_certs",
            "op": "has",
            "value": "dp_100_azure_data_scientist_associate"
          },
          {
            "q": "ms_certs",
            "op": "has",
            "value": "dp_100_designing_and_implementing_a_data"
          }
        ]
      },
      "condition_note": "opens when the area is claimed OR a matching certification is ticked",
      "questions": [
        {
          "id": "ai_ml_use",
          "type": "multi_select",
          "category": "ai_ml",
          "name": "AI & Machine Learning — works with",
          "text": "AI & Machine Learning: which of these do you work with hands-on?",
          "scored": false,
          "star": false,
          "options": [
            {
              "value": "advanced_analytics_azure_ml_custom_model",
              "label": "Advanced Analytics - Azure ML (Custom Modeling)"
            },
            {
              "value": "advanced_analytics_azure_ml_custom",
              "label": "Advanced Analytics - Azure ML Custom"
            },
            {
              "value": "advanced_analytics_cognitive_services_pr",
              "label": "Advanced Analytics - Cognitive Services (Prebuilt ML Models)"
            },
            {
              "value": "advanced_analytics_iot",
              "label": "Advanced Analytics - IOT"
            },
            {
              "value": "advanced_analytics_ml_deep_learning_fram",
              "label": "Advanced Analytics - ML Deep Learning Frameworks - Pytorch, Tensorflow"
            },
            {
              "value": "advanced_analytics_ml_engineering_archit",
              "label": "Advanced Analytics - ML Engineering/Architect"
            },
            {
              "value": "advanced_analytics_mlops",
              "label": "Advanced Analytics - MLOps"
            },
            {
              "value": "ai_general",
              "label": "AI - General"
            },
            {
              "value": "azure_ai_azure_ai_search",
              "label": "Azure AI - Azure AI Search"
            },
            {
              "value": "azure_ai_azure_ai_services_vision_voice_",
              "label": "Azure AI - Azure AI Services (Vision, Voice, Language)"
            },
            {
              "value": "azure_ai_azure_openai",
              "label": "Azure AI - Azure OpenAI"
            },
            {
              "value": "azure_ai_document_intelligence",
              "label": "Azure AI - Document Intelligence"
            }
          ],
          "ai_drafted": false
        },
        {
          "id": "ai_ml_lead",
          "type": "multi_select",
          "category": "ai_ml",
          "name": "AI & Machine Learning — can lead",
          "text": "And which of those could you lead or design at client-facing level?",
          "scored": false,
          "star": false,
          "options": [
            {
              "value": "advanced_analytics_azure_ml_custom_model",
              "label": "Advanced Analytics - Azure ML (Custom Modeling)"
            },
            {
              "value": "advanced_analytics_azure_ml_custom",
              "label": "Advanced Analytics - Azure ML Custom"
            },
            {
              "value": "advanced_analytics_cognitive_services_pr",
              "label": "Advanced Analytics - Cognitive Services (Prebuilt ML Models)"
            },
            {
              "value": "advanced_analytics_iot",
              "label": "Advanced Analytics - IOT"
            },
            {
              "value": "advanced_analytics_ml_deep_learning_fram",
              "label": "Advanced Analytics - ML Deep Learning Frameworks - Pytorch, Tensorflow"
            },
            {
              "value": "advanced_analytics_ml_engineering_archit",
              "label": "Advanced Analytics - ML Engineering/Architect"
            },
            {
              "value": "advanced_analytics_mlops",
              "label": "Advanced Analytics - MLOps"
            },
            {
              "value": "ai_general",
              "label": "AI - General"
            },
            {
              "value": "azure_ai_azure_ai_search",
              "label": "Azure AI - Azure AI Search"
            },
            {
              "value": "azure_ai_azure_ai_services_vision_voice_",
              "label": "Azure AI - Azure AI Services (Vision, Voice, Language)"
            },
            {
              "value": "azure_ai_azure_openai",
              "label": "Azure AI - Azure OpenAI"
            },
            {
              "value": "azure_ai_document_intelligence",
              "label": "Azure AI - Document Intelligence"
            }
          ],
          "ai_drafted": false
        }
      ]
    },
    {
      "id": "dd_azure_cloud",
      "title": "Azure Cloud & Infrastructure",
      "blurb": "App services, networking, security, monitoring, cost.",
      "optional": false,
      "condition": {
        "any": [
          {
            "q": "work_areas",
            "op": "has",
            "value": "azure_cloud"
          },
          {
            "q": "ms_certs",
            "op": "has",
            "value": "az_104_azure_administrator_associate"
          },
          {
            "q": "ms_certs",
            "op": "has",
            "value": "az_305_azure_solutions_architect_expert"
          },
          {
            "q": "ms_certs",
            "op": "has",
            "value": "az_500_azure_security_technologies"
          },
          {
            "q": "ms_certs",
            "op": "has",
            "value": "az_700_azure_network_solutions"
          },
          {
            "q": "ms_certs",
            "op": "has",
            "value": "az_900_azure_fundamentals"
          },
          {
            "q": "ms_certs",
            "op": "has",
            "value": "mcse_azure_cloud_platform"
          }
        ]
      },
      "condition_note": "opens when the area is claimed OR a matching certification is ticked",
      "questions": [
        {
          "id": "azure_cloud_use",
          "type": "multi_select",
          "category": "azure_cloud",
          "name": "Azure Cloud & Infrastructure — works with",
          "text": "Azure Cloud & Infrastructure: which of these do you work with hands-on?",
          "scored": false,
          "star": false,
          "options": [
            {
              "value": "azure_app_services_app_service_function_",
              "label": "Azure - App Services (App Service, Function Apps)"
            },
            {
              "value": "azure_consulting",
              "label": "Azure - Consulting"
            },
            {
              "value": "azure_cost_management",
              "label": "Azure - Cost Management"
            },
            {
              "value": "azure_integration_services_apim_logic_ap",
              "label": "Azure - Integration Services (APIM, Logic Apps, Service Bus)"
            },
            {
              "value": "azure_monitoring_azure_monitor_applicati",
              "label": "Azure - Monitoring (Azure Monitor, Application Insights)"
            },
            {
              "value": "azure_networking_vnets_app_gateway_front",
              "label": "Azure - Networking (VNETs, App Gateway, Frontdoor)"
            },
            {
              "value": "azure_security",
              "label": "Azure - Security"
            }
          ],
          "ai_drafted": false
        },
        {
          "id": "azure_cloud_lead",
          "type": "multi_select",
          "category": "azure_cloud",
          "name": "Azure Cloud & Infrastructure — can lead",
          "text": "And which of those could you lead or design at client-facing level?",
          "scored": false,
          "star": false,
          "options": [
            {
              "value": "azure_app_services_app_service_function_",
              "label": "Azure - App Services (App Service, Function Apps)"
            },
            {
              "value": "azure_consulting",
              "label": "Azure - Consulting"
            },
            {
              "value": "azure_cost_management",
              "label": "Azure - Cost Management"
            },
            {
              "value": "azure_integration_services_apim_logic_ap",
              "label": "Azure - Integration Services (APIM, Logic Apps, Service Bus)"
            },
            {
              "value": "azure_monitoring_azure_monitor_applicati",
              "label": "Azure - Monitoring (Azure Monitor, Application Insights)"
            },
            {
              "value": "azure_networking_vnets_app_gateway_front",
              "label": "Azure - Networking (VNETs, App Gateway, Frontdoor)"
            },
            {
              "value": "azure_security",
              "label": "Azure - Security"
            }
          ],
          "ai_drafted": false
        }
      ]
    },
    {
      "id": "dd_dev",
      "title": "Software Development",
      "blurb": "Languages and front-end frameworks.",
      "optional": false,
      "condition": {
        "any": [
          {
            "q": "work_areas",
            "op": "has",
            "value": "dev"
          },
          {
            "q": "ms_certs",
            "op": "has",
            "value": "az_204_azure_developer_associate"
          }
        ]
      },
      "condition_note": "opens when the area is claimed OR a matching certification is ticked",
      "questions": [
        {
          "id": "dev_use",
          "type": "multi_select",
          "category": "dev",
          "name": "Software Development — works with",
          "text": "Software Development: which of these do you work with hands-on?",
          "scored": false,
          "star": false,
          "options": [
            {
              "value": "development_net",
              "label": "Development - .NET"
            },
            {
              "value": "development_c",
              "label": "Development - C#"
            },
            {
              "value": "development_front_end_angular_vue_etc",
              "label": "Development - Front End (Angular, Vue, etc)"
            },
            {
              "value": "development_front_end_css_frameworks_tai",
              "label": "Development - Front End (CSS frameworks: Tailwind, Bootstrap etc)"
            },
            {
              "value": "development_front_end_react",
              "label": "Development - Front End (React)"
            },
            {
              "value": "development_go",
              "label": "Development - Go"
            },
            {
              "value": "development_node",
              "label": "Development - Node"
            },
            {
              "value": "development_powershell",
              "label": "Development - PowerShell"
            },
            {
              "value": "development_python",
              "label": "Development - Python"
            },
            {
              "value": "development_r",
              "label": "Development - R"
            },
            {
              "value": "development_sql",
              "label": "Development - SQL"
            }
          ],
          "ai_drafted": false
        },
        {
          "id": "dev_lead",
          "type": "multi_select",
          "category": "dev",
          "name": "Software Development — can lead",
          "text": "And which of those could you lead or design at client-facing level?",
          "scored": false,
          "star": false,
          "options": [
            {
              "value": "development_net",
              "label": "Development - .NET"
            },
            {
              "value": "development_c",
              "label": "Development - C#"
            },
            {
              "value": "development_front_end_angular_vue_etc",
              "label": "Development - Front End (Angular, Vue, etc)"
            },
            {
              "value": "development_front_end_css_frameworks_tai",
              "label": "Development - Front End (CSS frameworks: Tailwind, Bootstrap etc)"
            },
            {
              "value": "development_front_end_react",
              "label": "Development - Front End (React)"
            },
            {
              "value": "development_go",
              "label": "Development - Go"
            },
            {
              "value": "development_node",
              "label": "Development - Node"
            },
            {
              "value": "development_powershell",
              "label": "Development - PowerShell"
            },
            {
              "value": "development_python",
              "label": "Development - Python"
            },
            {
              "value": "development_r",
              "label": "Development - R"
            },
            {
              "value": "development_sql",
              "label": "Development - SQL"
            }
          ],
          "ai_drafted": false
        }
      ]
    },
    {
      "id": "dd_devops",
      "title": "DevOps & Infrastructure-as-Code",
      "blurb": "Azure DevOps, GitHub, ARM/Bicep/Terraform.",
      "optional": false,
      "condition": {
        "any": [
          {
            "q": "work_areas",
            "op": "has",
            "value": "devops"
          },
          {
            "q": "ms_certs",
            "op": "has",
            "value": "az_400_devops_engineer_expert"
          }
        ]
      },
      "condition_note": "opens when the area is claimed OR a matching certification is ticked",
      "questions": [
        {
          "id": "devops_use",
          "type": "multi_select",
          "category": "devops",
          "name": "DevOps & Infrastructure-as-Code — works with",
          "text": "DevOps & Infrastructure-as-Code: which of these do you work with hands-on?",
          "scored": false,
          "star": false,
          "options": [
            {
              "value": "devops_tooling_azure_devops",
              "label": "DevOps Tooling - Azure DevOps"
            },
            {
              "value": "devops_tooling_github",
              "label": "DevOps Tooling - GitHub"
            },
            {
              "value": "devops_tooling_iac_arm",
              "label": "DevOps Tooling - IaC (ARM)"
            },
            {
              "value": "devops_tooling_iac_bicep",
              "label": "DevOps Tooling - IaC (Bicep)"
            },
            {
              "value": "devops_tooling_iac_terraform",
              "label": "DevOps Tooling - IaC (Terraform)"
            }
          ],
          "ai_drafted": false
        },
        {
          "id": "devops_lead",
          "type": "multi_select",
          "category": "devops",
          "name": "DevOps & Infrastructure-as-Code — can lead",
          "text": "And which of those could you lead or design at client-facing level?",
          "scored": false,
          "star": false,
          "options": [
            {
              "value": "devops_tooling_azure_devops",
              "label": "DevOps Tooling - Azure DevOps"
            },
            {
              "value": "devops_tooling_github",
              "label": "DevOps Tooling - GitHub"
            },
            {
              "value": "devops_tooling_iac_arm",
              "label": "DevOps Tooling - IaC (ARM)"
            },
            {
              "value": "devops_tooling_iac_bicep",
              "label": "DevOps Tooling - IaC (Bicep)"
            },
            {
              "value": "devops_tooling_iac_terraform",
              "label": "DevOps Tooling - IaC (Terraform)"
            }
          ],
          "ai_drafted": false
        }
      ]
    },
    {
      "id": "dd_power_platform",
      "title": "Power Platform & Business Apps",
      "blurb": "Power Apps, Power Automate, chatbots/agents.",
      "optional": false,
      "condition": {
        "any": [
          {
            "q": "work_areas",
            "op": "has",
            "value": "power_platform"
          },
          {
            "q": "ms_certs",
            "op": "has",
            "value": "pl_200_power_platform_functional_consult"
          },
          {
            "q": "ms_certs",
            "op": "has",
            "value": "pl_400_power_platform_developer_associat"
          },
          {
            "q": "ms_certs",
            "op": "has",
            "value": "pl_500_power_automate_rpa_developer"
          },
          {
            "q": "ms_certs",
            "op": "has",
            "value": "pl_600_power_platform_solution_architect"
          },
          {
            "q": "ms_certs",
            "op": "has",
            "value": "microsoft_applied_skills_copilot_studio_"
          }
        ]
      },
      "condition_note": "opens when the area is claimed OR a matching certification is ticked",
      "questions": [
        {
          "id": "power_platform_use",
          "type": "multi_select",
          "category": "power_platform",
          "name": "Power Platform & Business Apps — works with",
          "text": "Power Platform & Business Apps: which of these do you work with hands-on?",
          "scored": false,
          "star": false,
          "options": [
            {
              "value": "power_platform_power_apps_low_code_web_a",
              "label": "Power Platform - Power Apps (Low-Code Web Apps)"
            },
            {
              "value": "power_platform_power_automate_flow_proce",
              "label": "Power Platform - Power Automate / Flow (Process Automation)"
            },
            {
              "value": "power_platform_power_virtual_agents_chat",
              "label": "Power Platform - Power Virtual Agents (Chatbots)"
            }
          ],
          "ai_drafted": false
        },
        {
          "id": "power_platform_lead",
          "type": "multi_select",
          "category": "power_platform",
          "name": "Power Platform & Business Apps — can lead",
          "text": "And which of those could you lead or design at client-facing level?",
          "scored": false,
          "star": false,
          "options": [
            {
              "value": "power_platform_power_apps_low_code_web_a",
              "label": "Power Platform - Power Apps (Low-Code Web Apps)"
            },
            {
              "value": "power_platform_power_automate_flow_proce",
              "label": "Power Platform - Power Automate / Flow (Process Automation)"
            },
            {
              "value": "power_platform_power_virtual_agents_chat",
              "label": "Power Platform - Power Virtual Agents (Chatbots)"
            }
          ],
          "ai_drafted": false
        }
      ]
    },
    {
      "id": "dd_sql_server",
      "title": "SQL Server & classic Microsoft BI",
      "blurb": "SQL Server, SSAS, SSIS, SSRS.",
      "optional": false,
      "condition": {
        "any": [
          {
            "q": "work_areas",
            "op": "has",
            "value": "sql_server"
          }
        ]
      },
      "condition_note": "opens when the area is claimed OR a matching certification is ticked",
      "questions": [
        {
          "id": "sql_server_use",
          "type": "multi_select",
          "category": "sql_server",
          "name": "SQL Server & classic Microsoft BI — works with",
          "text": "SQL Server & classic Microsoft BI: which of these do you work with hands-on?",
          "scored": false,
          "star": false,
          "options": [
            {
              "value": "sql_server",
              "label": "SQL Server"
            },
            {
              "value": "sql_server_analysis_service_ssas_olap_md",
              "label": "SQL Server Analysis Service (SSAS) - OLAP/MDX"
            },
            {
              "value": "sql_server_analysis_service_ssas_tabular",
              "label": "SQL Server Analysis Service (SSAS) - Tabular/AAS"
            },
            {
              "value": "sql_server_integration_service_ssis",
              "label": "SQL Server Integration Service (SSIS)"
            },
            {
              "value": "sql_server_reporting_service_ssrs",
              "label": "SQL Server Reporting Service (SSRS)"
            }
          ],
          "ai_drafted": false
        },
        {
          "id": "sql_server_lead",
          "type": "multi_select",
          "category": "sql_server",
          "name": "SQL Server & classic Microsoft BI — can lead",
          "text": "And which of those could you lead or design at client-facing level?",
          "scored": false,
          "star": false,
          "options": [
            {
              "value": "sql_server",
              "label": "SQL Server"
            },
            {
              "value": "sql_server_analysis_service_ssas_olap_md",
              "label": "SQL Server Analysis Service (SSAS) - OLAP/MDX"
            },
            {
              "value": "sql_server_analysis_service_ssas_tabular",
              "label": "SQL Server Analysis Service (SSAS) - Tabular/AAS"
            },
            {
              "value": "sql_server_integration_service_ssis",
              "label": "SQL Server Integration Service (SSIS)"
            },
            {
              "value": "sql_server_reporting_service_ssrs",
              "label": "SQL Server Reporting Service (SSRS)"
            }
          ],
          "ai_drafted": false
        }
      ]
    },
    {
      "id": "dd_governance",
      "title": "Data Governance & Purview",
      "blurb": "Purview, DLP, information protection — plus our governance IP.",
      "optional": false,
      "condition": {
        "any": [
          {
            "q": "work_areas",
            "op": "has",
            "value": "governance"
          }
        ]
      },
      "condition_note": "opens when the area is claimed OR a matching certification is ticked",
      "questions": [
        {
          "id": "governance_use",
          "type": "multi_select",
          "category": "governance",
          "name": "Data Governance & Purview — works with",
          "text": "Data Governance & Purview: which of these do you work with hands-on?",
          "scored": false,
          "star": false,
          "options": [
            {
              "value": "agile_insights_admin_and_governance_pack",
              "label": "Agile Insights: Admin and Governance Pack - Deployment"
            },
            {
              "value": "agile_insights_admin_and_governance__2",
              "label": "Agile Insights: Admin and Governance Pack - Usage"
            },
            {
              "value": "purview_administration",
              "label": "Purview: Administration"
            },
            {
              "value": "purview_data_governance_data_map_and_uni",
              "label": "Purview: Data Governance (Data Map and Unified Catalog)"
            },
            {
              "value": "purview_data_loss_prevention_dlp",
              "label": "Purview: Data Loss Prevention (DLP)"
            },
            {
              "value": "purview_information_protection",
              "label": "Purview: Information Protection"
            }
          ],
          "ai_drafted": false
        },
        {
          "id": "governance_lead",
          "type": "multi_select",
          "category": "governance",
          "name": "Data Governance & Purview — can lead",
          "text": "And which of those could you lead or design at client-facing level?",
          "scored": false,
          "star": false,
          "options": [
            {
              "value": "agile_insights_admin_and_governance_pack",
              "label": "Agile Insights: Admin and Governance Pack - Deployment"
            },
            {
              "value": "agile_insights_admin_and_governance__2",
              "label": "Agile Insights: Admin and Governance Pack - Usage"
            },
            {
              "value": "purview_administration",
              "label": "Purview: Administration"
            },
            {
              "value": "purview_data_governance_data_map_and_uni",
              "label": "Purview: Data Governance (Data Map and Unified Catalog)"
            },
            {
              "value": "purview_data_loss_prevention_dlp",
              "label": "Purview: Data Loss Prevention (DLP)"
            },
            {
              "value": "purview_information_protection",
              "label": "Purview: Information Protection"
            }
          ],
          "ai_drafted": false
        }
      ]
    },
    {
      "id": "dd_delivery",
      "title": "Delivery, Advisory & Architecture",
      "blurb": "PM, business analysis, roadmaps and architecture.",
      "optional": false,
      "condition": {
        "any": [
          {
            "q": "work_areas",
            "op": "has",
            "value": "delivery"
          },
          {
            "q": "other_certs",
            "op": "has",
            "value": "certified_scrum_master"
          },
          {
            "q": "other_certs",
            "op": "has",
            "value": "project_management_professional_pmp"
          },
          {
            "q": "other_certs",
            "op": "has",
            "value": "pmi_agile_certified_practitioner_pmi_acp"
          },
          {
            "q": "other_certs",
            "op": "has",
            "value": "safe_scrum_master"
          },
          {
            "q": "other_certs",
            "op": "has",
            "value": "p3o_foundation"
          },
          {
            "q": "other_certs",
            "op": "has",
            "value": "togaf_foundation"
          }
        ]
      },
      "condition_note": "opens when the area is claimed OR a matching certification is ticked",
      "questions": [
        {
          "id": "delivery_use",
          "type": "multi_select",
          "category": "delivery",
          "name": "Delivery, Advisory & Architecture — works with",
          "text": "Delivery, Advisory & Architecture: which of these do you work with hands-on?",
          "scored": false,
          "star": false,
          "options": [
            {
              "value": "project_business_analysis_requirements_e",
              "label": "Project - Business Analysis, Requirements Elicitation"
            },
            {
              "value": "project_project_management",
              "label": "Project - Project Management"
            },
            {
              "value": "road_maps_roadmap_architecture",
              "label": "Road Maps - Roadmap / Architecture"
            }
          ],
          "ai_drafted": false
        },
        {
          "id": "delivery_lead",
          "type": "multi_select",
          "category": "delivery",
          "name": "Delivery, Advisory & Architecture — can lead",
          "text": "And which of those could you lead or design at client-facing level?",
          "scored": false,
          "star": false,
          "options": [
            {
              "value": "project_business_analysis_requirements_e",
              "label": "Project - Business Analysis, Requirements Elicitation"
            },
            {
              "value": "project_project_management",
              "label": "Project - Project Management"
            },
            {
              "value": "road_maps_roadmap_architecture",
              "label": "Road Maps - Roadmap / Architecture"
            }
          ],
          "ai_drafted": false
        }
      ]
    },
    {
      "id": "closers",
      "title": "The bits lists miss",
      "optional": false,
      "questions": [
        {
          "id": "not_listed",
          "type": "verbatim",
          "name": "Not listed",
          "text": "Any skills or certifications you have that weren't listed?",
          "scored": false,
          "star": false,
          "ai_drafted": false
        },
        {
          "id": "growth_next",
          "type": "verbatim",
          "name": "Growth",
          "text": "Which two or three skills do you most want to grow next year?",
          "scored": false,
          "star": false,
          "ai_drafted": false
        }
      ]
    }
  ],
  "grids": {},
  "outputs": [
    "Per-consultant skill grid (none / uses / leads + cert-backed) — matrix.csv",
    "Bench coverage by area",
    "Kantata skills import feed"
  ],
  "report_defaults": []
}

Skills Census (Kantata) v0.2.0