🦞 Claw Command Centre

Today's work. No vague motivation.

14-Day Sprint

🖥️ Microsoft

PL-200: Power Platform Functional Consultant

Consultant progression — concept, action, check, proof.

Topics Covered

  • Dataverse fundamentals
  • Model-driven & canvas apps
  • Power Automate
  • Power BI basics
  • Solutions & ALM
  • Security model
  • Business rules

14-Day Progression

Day 1

Microsoft — Day 1: What is Dataverse?

Concept → Action → Check → Proof. No passive watching without notes.

Day 2

Microsoft — Day 2: Tables & Columns Deep Dive

Yesterday was the overview. Today you understand the building blocks properly.

  • Read: Tables, columns, data types — resource ↗
  • Build: Add 5 meaningful columns to your tables
  • Explain column types to yourself

Day 3

Microsoft — Day 3: Model-Driven Apps

Build your first actual Power App interface on top of Dataverse.

  • Learn: What is a model-driven app? — resource ↗
  • Build: Create a model-driven app from your tables
  • 5 review questions

Day 4

Microsoft — Day 4: Canvas Apps Intro

Canvas apps = the flexible, pixel-perfect option. When and why.

  • Learn: Canvas vs model-driven — resource ↗
  • Build: Simple canvas app from data
  • Explain: when canvas vs model-driven?

Day 5

Microsoft — Day 5: Power Automate Basics

Automation is the money skill. Flows connect everything.

  • Learn: What is Power Automate? — resource ↗
  • Build: Automated flow from Dataverse
  • Name 5 real automation scenarios

Day 6

Microsoft — Day 6: Power Automate Conditions & Branches

Real flows have logic. If this, then that. Literally.

  • Learn: Conditions, switches, apply-to-each — resource ↗
  • Build: Flow with a condition branch
  • Write pseudocode for 3 flows

Day 7

Microsoft — Day 7: Week 1 Review + Knowledge Dump

Don't learn new stuff. Consolidate what you've covered.

  • Review all notes from this week
  • Draw a concept map
  • List your top 3 weak areas

Day 8

Microsoft — Day 8: Power BI Basics

Reporting layer. Show the data visually. Clients love dashboards.

  • Learn: Power BI for beginners — resource ↗
  • Build: Dashboard from your Dataverse data
  • Name 3 Power BI use cases for UK SMEs

Day 9

Microsoft — Day 9: Solutions & ALM Basics

How to package and move your work between environments. Essential for real projects.

  • Learn: What is a Solution? — resource ↗
  • Build: Package your work into a Solution
  • Explain ALM to a non-technical client

Day 10

Microsoft — Day 10: Security & Roles

Who sees what. Security is always a client question.

  • Learn: Dataverse security model — resource ↗
  • Build: Create 2 security roles
  • Map security to a real scenario

Day 11

Microsoft — Day 11: Business Rules & Validation

Keep bad data out. Business rules are the first line of defence.

  • Learn: Business rules in Dataverse — resource ↗
  • Build: Add 3 business rules
  • What can't business rules do?

Day 12

Microsoft — Day 12: Client Scenario Practice

Put it all together. Imagine a real client brief.

  • Read: fictional client brief
  • Design: tables, relationships, and roles
  • Present: write a 1-page solution summary

Day 13

Microsoft — Day 13: PL-200 Practice Test

Test yourself. Find the gaps before they find you.

  • Take a PL-200 practice assessment — resource ↗
  • Identify your weakest topic areas
  • Write a study plan for weak areas

Day 14

Microsoft — Day 14: Fortnight Review + Demo Build

Build something small end-to-end. Prove to yourself you can do it.

  • Build: mini end-to-end demo (60 mins)
  • Write fortnight Microsoft review
  • Draft: LinkedIn post about your learning