Analytical Portfolio System {EN}

Turn your public-sector experience into 3 data-backed case studies, an optimized LinkedIn profile and a 30-day job plan. Self-paced, 1-2 hours a day.

Most people in policy and local government can say they “work with data”. Few can show it. A certificate proves you studied; a case study proves you can do the job.

This system takes you, step by step, from official open data to three finished case studies about one real territory: where the gaps are, how public money is spent, and whether the plan’s targets will be met. In 14 days of 1-2 hours a day you will have three reports, the spreadsheets behind them, an optimized LinkedIn profile and a 30-day plan to put that evidence in front of the people who hire.

Who it’s for

Track A — you work in or around government in the US, UK, Canada, Australia or India

• Policy analysts who want portfolio pieces built on real public data, not class exercises.
• Local government officers moving toward policy, performance or scrutiny roles.
• Consultants who need public-sector case studies to show prospective clients.

Track B — you are a bilingual Latin American public-sector professional

• Political scientists and public managers aiming at the IDB, the World Bank, UN agencies or English-speaking consultancies.
• You know your territory well; you need evidence, in English, that you can analyze it with data.

Not for you if you want a guaranteed job, live coaching, or a course in Python, R or Power BI.

What’s included

A ~34-page PDF guide, 4 Google Sheets and a prompt doc:

• Self-assessment (10 questions). In 20 minutes it sets your territory, target role, sector, working mode and pace, and saves them as a route card in your Control Panel.
• The 4-step framework. Public problem → Analytical question → Analysis → Actionable insight, with a pass/fail test for each step and two worked examples (a Latin American municipality and an English council).
• 3 project templates. Each has its own Google Sheet (raw data, cleaning, analysis, charts and findings tabs), 7-8 analysis steps and a ready report structure:
• Gap profile: rank the local areas of your region on 5 indicators and find who is falling behind (2-3 page diagnosis).
• Spending brief: analyze an authority’s contracts or, where those are not open, its budget, and compare it with its peers (3-4 page brief).
• Target tracker: test whether a target in the local plan will be met by the end of the term, with a projection and a traffic light (2-page policy brief).
• Source matrix. Official open-data sources mapped for each project in the US, England, Canada, Australia and India; Mexico, Colombia, Spain, Argentina, Peru and Chile for Track B; and a 15-minute protocol to find the equivalent in any other country.
• Prompt pack. 15 copy-ready AI prompts to clean data, plan calculations, interpret results, choose charts and draft reports, including a plain-English mode for non-native writers.
• LinkedIn + portfolio checklist. Exactly what your profile needs and how to present the 3 case studies (on Google Sites by default, no code).
• 14-day roadmap + 30-day exploration plan. What to do each day, what must be done by the end of it, and where to take your evidence afterwards for each target role.
• Control Panel (Google Sheet). Self-assessment, roadmap and checklists with checkboxes.
• A fully worked example. A real case solved end to end, so you see every step before doing it with your own data.

You’ll need: a free Google account, any AI assistant (the free versions of ChatGPT, Claude or Gemini are enough) and 1-2 hours a day for 14 days.

How it works

• Day 1 — Set your route. Take the self-assessment and choose one territory for all 3 projects.
• Days 2-5 — Case study 1, Gap profile. Download, clean, rank and write your territorial diagnosis.
• Days 6-9 — Case study 2, Spending brief. Analyze contracts or budget, benchmark against peers and write the brief.
• Days 10-12 — Case study 3, Target tracker. Track a plan target, project it to the end of the term and write the policy brief.
• Days 13-14 — Go visible. Publish your portfolio, complete your LinkedIn profile, post your first case and write your 30-day plan.

Less than an hour a day? The roadmap includes a 21-day pace.

What’s not included

• No job guarantee. You get evidence you can show; hiring decisions are made by others.
• No coaching, calls, live sessions or feedback on your work. Everything is self-paced.
• No private or paid data. Every project uses official open data.
• No video course. Text, spreadsheets and copy-ready prompts.
• No Python, R or Power BI. Google Sheets and an AI assistant are enough.
• It does not do the work for you. Expect 14-28 hours of your own work.

Price and early access

39 USD — one-time payment

Early access — delivery on October 22, 2026

You are buying before release. You pay today and receive the complete system (PDF, 4 Google Sheets and the prompt doc) by email on October 22, 2026. Early-access buyers get every version 1 update at no extra cost.

Guarantee

7-day refund. If the files do not contain what this page lists, or the data sources mapped for your country do not work, reply to your purchase email within 7 days of delivery and you get 100% back. No forms, no calls. If delivery slips past October 22, 2026, you can also ask for a full refund.

One territory. Three case studies. Fourteen days. Reserve your copy now and start on day 1 as soon as it arrives.

Get early access — 39 USD