1. Thinking in Power Fx correctly
Power Fx is the formula language of the Power Platform — modeled on Excel but with a modern data model underneath. The most common beginner mistake: writing Power Fx like VBA or JavaScript. We train the declarative logic: when do you use ForAll, when Filter, when LookUp — and why performance differs dramatically. Including the typical delegation traps (Filter works locally but not on SharePoint lists over 2,000 records).
2. Dataverse modeling instead of SharePoint lists
Many Power Apps beginners start with SharePoint lists as a data source — and hit growth limits after three months. We train the decision framework: when is Dataverse the right data source, when does SharePoint suffice, when do you need a classic SQL backend? And when Dataverse: how do you model tables, relationships, choice lists, and security roles so the system is still sustainable after three years?
3. Power Automate — cloud flows vs. desktop flows
Cloud flows automate online systems through connectors — fast, scalable, license-controlled. Desktop flows (RPA) automate legacy systems through GUI control — powerful but maintenance-heavy. Who needs what when? We train both worlds and the architecture decision behind it. Including process mining, which can prepare both worlds with data.
4. Power BI — tabular model and DAX as foundation
Many Power BI reports look superficially good but collapse with real data volume or new questions. Reason: weak data model. We train the star schema systematically — fact tables, dimension tables, relationship directions, calculation groups in DAX, performance tuning with DAX Studio. Plus the strategic decision Power BI Pro vs. Premium vs. Fabric.
5. Power Platform governance — before it is too late
The most common Power Platform crisis in the mid-market: 300 apps, 800 flows, 12 Power BI workspaces, no one knows anymore what runs, what connectors consume premium licenses, what processes GDPR-relevant data. We train the governance model from the start — environment concept (Dev/Test/Prod), DLP policies, solutions strategy, license control. With our own solution devonso as a practical example of scalable governance.