{ "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": [] }