ai-maturity-client-kit

Orchestrates the production of all client-ready report deliverables for the AI Maturity Assessment Platform. Wraps the lower-level skills /preencher-planilha + /calcular-scores + /gap-analysis + /recomendar-estrategias + /wizard-implementacao + /gerar-relatorio. Renders 5 PDFs (Score Justification + 3 Pillar Roadmaps + Implementation Guide) using Jinja2 + WeasyPrint with paulasilva-ms branding (Microsoft 4-color palette). Mirror of the global skill `~/.github/skills/ai-maturity-reports/` adapted to this self-service kit. Use when the user asks for "pacote completo de relatórios", "gerar todos os PDFs", "todos os 5 PDFs", "rodar tudo de ponta a ponta", "rodar pipeline de reports", "AI Maturity report", "Score Justification", "Transformation Roadmap", "render the assessment PDFs", "ai-maturity-reports", "full reports pipeline", "complete pack", "all pdfs", "generate the bundle".

Computes capability/pillar/overall scores from respostas.json applying the official SUMPRODUCT algorithm from the platform. Generates saida/scores.json. Use when the user asks to "calcular scores", "computar pontuação", "rodar o scoring".

Computes gap (target − current) per capability and priority P0-P3 (weight × gap). Reads saida/scores.json and respostas.json::target_overrides. Generates saida/gaps.json. Use when user asks for "gap analysis", "priorização", "onde estão minhas lacunas".

Renders 5 client-ready PDF reports (Score Justification + 3 Pillar Roadmaps + Implementation Guide) by invoking relatorios/scripts/build_payload_and_render.py. The script merges sample_payload.json (rich structure) with client data from saida/scores.json + gaps.json + recomendacoes.json + respostas.json + implementation-guide-inputs.json. Output is identical-quality to the platform's production PDFs. Use when the user asks to "gerar relatório", "produzir o report executivo", "gerar PDFs", "PDF final", "consolidar resultados", "executive report", "final report", "render PDF", "generate report PDFs", "produzir o PDF executivo".

Converts an Excel exported from Microsoft Forms (or Google Forms / multi-respondent spreadsheet) into structured respostas.json for the AI Maturity Assessment, aggregating multiple respondents via mean per question. Use when the client collected responses via Forms and wants to run the pipeline. Trigger on "importar respostas", "import Forms", "converter Excel para JSON", "respostas-forms.xlsx", "Microsoft Forms para o assessment", "agregar respondentes". Looks for respostas-forms.xlsx at workspace root or path passed by the user.

Imports the Developer Survey results (Microsoft Forms export .xlsx) into structured JSON. The survey has 75 questions across 9 sections (Profile, Copilot adoption + modes, MS/GitHub tools, AI dev practices, Agent concepts, Markdown/Instructions, Usability, Security/Governance, Pain points). Different from /importar-respostas-excel which handles the maturity assessment. Use when user has respostas-survey-devs.xlsx and wants to analyze it.

Imports the Learning & Growth Survey results (Microsoft Forms export .xlsx, IDENTIFIED with name+email) into structured JSON. The survey has 32 questions across 7 sections (identification, self-perception of maturity, growth priorities, topics to learn, formats/cadence, champions, barriers/wishlist). Different from /importar-survey-devs (anonymous). Use when the user has respostas-survey-learning.xlsx and wants to generate the capacitation plan, or asks "importar survey de aprendizado", "importar Learning & Growth", "respostas-survey-learning.xlsx", "survey de treinamento", "survey-learning", "import learning survey", "import training survey", "learning & growth import".

Generates aggregated insights report from imported Developer Survey responses. Reads survey-devs/respostas-devs.json and produces saida/insights-developer-survey-<DATE>.md with: respondent demographics, Copilot adoption + mode usage, agent/MCP awareness, governance gaps, pain points (anonymized quotes), and prioritized recommendations linked to the maturity assessment capabilities (P1-C1, P1-C5, P1-C8, P2-C4, P3-C6). Use after /importar-survey-devs.

Generates a prioritized capacitation roadmap (plano de capacitação) from the Learning & Growth Survey responses. Reads survey-learning/respostas-learning.json (IDENTIFIED respondents with name+email) and produces saida/plano-capacitacao-<DATE>.md with: top 10 topics demanded, suggested cohorts per dimension D2-D8 (with attendee lists), Champions Network candidates, mentor↔mentee pairs, calendar of workshops, barriers to remove, capacitation roadmap, training plan. Use after /importar-survey-learning when user asks for "plano de capacitação", "training roadmap", "Champions Network", "workshops priorizados", "treinamento", "capacitation plan", "plano-capacitacao".

Reads respostas.json and populates the auditable Excel workbook (pontuacao-e-calculo.xlsx) into saida/. Use when the user asks to "preencher a planilha", "transferir respostas para o Excel", "popular o xlsx", "fill the spreadsheet", "fill responses into Excel", "populate scoring workbook", "exportar para planilha", "Excel auditável" or similar.

Maps gaps per capability to the 7 strategies S1-S7 and generates prioritized action plan with specific technologies. Reads saida/gaps.json + framework.json. Generates saida/recomendacoes.json. Use when user asks to "recomendar estratégias", "mapear ações", "que iniciativas devo priorizar".

Guides the client through the 9-step Implementation Guide Wizard (steering committee, TPO, RACI, comms plan, training plan, ADKAR, 3 quick-wins waves) by either pointing to the standalone HTML wizard OR conducting the conversation in chat. Output is implementation-guide-inputs.json that feeds Roadmap Part 4 PDF. Use when the user asks for "wizard", "implementation guide", "guia de implementação", "preencher parte 4", "TPO", "steering committee", "RACI", "ADKAR", "quick wins".