Environment Setup

⏱ 1.5 hours📅 Week 1❓ 3 quiz questions

Phase 0 goal

🎯 Learning objectives

Tick each one when you can actually do it.

Confirm which tools and versions you have (Microsoft 365 Excel, Power BI Desktop, Power Automate, Python) and what your organization allows.
Set up a practice workspace that is separate from real work data.

License and tenant checks: Commercial M365 vs. GCC / GCC High / DoD tenants. Features and AI tools often reach government clouds later or work differently there. Ask IT which tenant you're on.
Approved software: In many government environments you can't install Python or Power BI Desktop yourself. Ask for them through your software approval process early (Phase 4 needs Python by Week 19).
Practice sandbox: A personal folder (and later a Power BI workspace and Power Automate environment) used only for training data.

⬇ Practice data for this module

D1 programsProgram dimension (12 rows)CSV XLSX

D2 milestonesMilestones (~150 rows)CSV XLSX

D3 evm_monthlyMonthly EVM by control account (~2,000 rows)CSV XLSX

D4 contractsContracts (30 rows)CSV XLSX

D5 budget_executionBudget execution by appropriation (1,296 rows)CSV XLSX

D6 schedule_tasksIMS task export (1,500 rows)CSV XLSX

D7 risksRisk register (80 rows)CSV XLSX

D8 status_drops/36 messy monthly status workbooksZIP Browse files

In Excel: File → Account. Note your version and update channel. Type =GROUPBY( in a cell to see whether the newest dynamic array functions are available.
Make a folder called Bootcamp with subfolders 01_Excel, 02_PowerBI, 03_Automate, 04_Python, 05_AI, Capstone, Data.
Download or generate the PEO-FS datasets into Data.

Exercise done

Write a one-page "Tooling Readiness" note: tools available, tools requested, tenant type, and blockers.

Mini-project done (saved to my portfolio)

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

Q0.1.1

Why should you request Python access in Week 1 rather than Week 19?

Write at least a few words to unlock.

Q0.1.2

What is the risk of practicing with real program data in a personal sandbox?

Write at least a few words to unlock.

Q0.1.3

Why does your tenant type (commercial vs. GCC/GCC High/DoD) matter for this curriculum?

Write at least a few words to unlock.

Mark M0.1 complete