Knowledge base

All lessons, free to read

36 lessons on Power BI, AI and prompting. You start reading right away. Halfway through the first lesson I ask for your name and email address, and after that they're all open. No password, no confirmation email.

Power BI Kickstart Foundation

Building your data model: star vs snowflakeYou understand the difference between star and snowflake schemas and can set up a reliable data model.
Time intelligence, YTD analysis and the date tableYou understand time intelligence functions and build a date table.
Relationships in depthYou check relationships and choose the correct filter direction; you understand active and inactive relationships.

Power BI Kickstart Advanced

Visuals that workYou choose the right visual for the right question.
Sharing reports without losing controlYou publish and share reports through the Power BI Service.

AI agents & no-code automation

What is an AI agent? From chatbot to autonomous assistantYou understand the difference between a chatbot, a copilot and an autonomous agent.
Agent architecture: tools, memory and decisionsYou understand how agents use tools, retain context and make autonomous decisions.
Building your first agent with Custom GPTsYou build a working agent as a Custom GPT with instructions, a Knowledge Base and Actions.
N8N: visual workflows with AI nodesYou build an AI workflow in N8N that automatically processes data and executes actions.
Make & Zapier: integrating AI into your existing toolsYou connect AI to your daily tools via Make or Zapier without writing code.
Claude MCP: agents that operate your toolsYou understand MCP and can connect Claude to databases, Slack, GitHub and more.

Prompting fundamentals

What is a prompt? From question to instructionYou understand the difference between a question and an effective prompt.
Prompt engineering: structure, context and constraintsYou can build a prompt with role, task, format and constraints.
Providing context: from vague to preciseYou learn how context drastically improves AI output quality.
Iterative prompting: refining step by stepYou can guide an AI conversation by refining, redirecting and asking follow-ups.

Claude Deep Dive

Claude.ai: interface, Projects and ArtifactsYou navigate Claude.ai and use Projects to organise context and Artifacts to structure output.
Setting up Claude for your team: Projects, Knowledge Bases and rolesYou set up Claude as a team tool with shared Projects, Knowledge Bases and permissions.
Pro vs Team vs Enterprise: which plan fits you?You understand the differences between Claude plans and choose the right one.
System prompts and custom instructionsYou create reusable system prompts that make Claude work consistently.
Claude Code: AI in your terminalYou install and use Claude Code CLI for code assistance and automation.
Claude for analysis: data, documents and researchYou upload files, analyse data and do research with Claude.
Claude API basics: automating without codingYou understand how the API works and can set up integrations.

ChatGPT & Gemini

ChatGPT: GPTs, plugins and Code InterpreterYou know ChatGPT's unique features and when to use them.
Google Gemini: multimodal and integratedYou understand Gemini's strengths and Google Workspace integration.
Tool comparison: the same task in three AI toolsYou compare Claude, ChatGPT and Gemini on the same task.

AI in your daily work

Excel formulas and data analysis with AIYou generate complex Excel formulas and analyse datasets with AI.
Emails, reports and presentations with AIYou use AI to create professional communication faster.
Summarising and comparing documentsYou quickly analyse long documents and contracts with AI.

AI workflows & automation

Building AI workflows: input → processing → outputYou design reusable AI workflows for recurring tasks.
Combining AI with other tools (Notion, Sheets, Slack)You integrate AI into your existing tool stack.

Responsible AI use

Checking AI output: hallucinations, bias and verificationYou recognise unreliable AI output and know how to verify it.
Privacy and compliance: what can you share with AI?You understand privacy implications and know which data to share.

AI features in Power BI

Copilot in Power BI: building reports with natural languageYou can use Copilot to generate reports and DAX measures.
Q&A visual: asking questions of your dataYou configure Q&A so end users can ask questions in natural language.
Smart narratives: automatic text summariesYou add text summaries to your reports that update with the data.
Key influencers & Decomposition treeYou use AI visuals to automatically discover drivers and patterns in your data.