Logan's Analytics Bootcamp
Dashboard β€Ί Phase 5: AI for Analytics
M5.1

AI Governance and Data Security for Gov/Defense Analytics

⏱ 3 hoursπŸ“… Week 27❓ 4 quiz questions
Phase 5 goal

Use AI to speed up every layer you've learned (formulas, M, DAX, flows, Python, narrative) while keeping data security airtight and checking every output.

The golden rule (government and defense): Only use AI tools your organization has approved, for the data types they are approved for. Never put CUI, PII, proprietary, export-controlled, source selection, pre-decisional, or classified information into public or consumer AI tools. When unsure, use schema-only prompts with fictional sample data, and ask your security or CUI office.

🎯 Learning objectives

Tick each one when you can actually do it.

πŸ’‘ Key concepts

  • Tool tiers (generic model; your organization's policy decides):
    Tier Examples Typical allowed data
    Public/consumer AI Free web chatbots, personal accounts Public info + fictional data only
    Enterprise AI in your tenant M365 Copilot / Copilot in Excel/Power BI if enabled and authorized Whatever your organization approves for that tenant
    Agency-authorized platforms Government-cloud or DoD-authorized AI services Per authorization (e.g., the CUI level it's approved for)
  • Why public tools are risky: Data leaves your boundary and may be logged, retained, or reviewed. Prompts can include identifying context. Outputs may be stored in chat history.
  • CUI handling: Treat program financials, contract details, schedules, and technical data as potentially CUI until marked or confirmed otherwise. The CUI Registry (National Archives) defines categories. Your agency's implementing policy governs.
  • Sanitization checklist: Remove program names and code names, contract numbers, vendor names, people, locations, and real dollar values. Swap in fictional placeholders. Keep only structure.
  • Aggregation and inference risk: A table schema plus "unusual" field names plus a known program can still reveal sensitive information.
  • Copilot specifics: Copilot inside your M365 tenant respects your permissions. It can surface anything you can access, so oversharing in SharePoint becomes an AI problem too. Per Microsoft's docs, Copilot in Power BI needs paid Fabric/Premium capacity and an admin setting, and isn't supported in sovereign clouds, which is relevant if you're on a government cloud. Check what your tenant actually has.
  • Accountability: You own every number you publish, AI-assisted or not. Keep a record of how AI was used on significant deliverables if your organization requires it.

πŸ›  Hands-on exercise: Classify and Sanitize

For each of 8 (fictional) scenarios, decide: βœ… Safe as-is / 🟑 Sanitize first / β›” Not allowed in a public tool. Then rewrite the 🟑 ones.

  1. "Explain how XLOOKUP's match_mode works."
  2. "Here's our contract mod list with CLIN values for the KESTREL program; summarize changes."
  3. "Write a DAX measure for cumulative CPI for a table with PeriodEnd, BCWP, ACWP."
  4. "Paste of a vendor's proprietary cost proposal; find errors."
  5. "Draft a Python function to parse money strings like $1.2M and 450K."
  6. "Our real IMS export (attached); identify the critical path issues."
  7. "Rewrite this paragraph from last month's internal status report (contains program name and schedule slip)."
  8. "Explain the difference between TCPI and CPI."
Check
Write your classifications first, then reveal the answer guide.

πŸ“¦ Mini-project: Team AI Use Guide (1 page)

Write a one-page guide for your team: approved tools, the safe/sanitize/not-allowed decision chart, the sanitization checklist, review requirements, and contacts (CUI office, IT, AI governance lead). Have it reviewed by the right authority before sharing.

🧠 Self-check quiz

Answer in your own words, then check. Grade yourself honestly; your score is saved.

Q5.1.1
A public chatbot vendor promises not to train on your data. Can you now paste CUI into it?
Write at least a few words to unlock.
Q5.1.2
Why can Copilot inside your own tenant still create data exposure risk?
Write at least a few words to unlock.
Q5.1.3
What is aggregation risk?
Write at least a few words to unlock.
Q5.1.4
Name four items you strip when sanitizing a prompt.
Write at least a few words to unlock.