BA Prince the B.A. Subscribe

Learn the tools business analysts use every day

Short, step-by-step video tutorials for Visio, Excel, SQL, Jira, BPMN and more, each with written instructions you can follow at your own pace.

Subscribe on YouTube Browse topics

Latest videos

Primary and Foreign Keys in SQL Tables (Explained With a Join) Requirements Traceability in Jira (Stories to Tests) Count Things With a Pivot Table in Excel (Tickets by Status and Priority) 10 Excalidraw Tips Every Business Analyst Should Know Write a Business Requirements Document in Confluence (BRD on One Page) Workflow Patterns in BPMN: Sequence, Split, Join and Loop Mermaid vs draw.io vs Visio: Which Should a BA Use? Jira Timeline (Roadmap): How to Plan Epics on a Timeline

Business Analysis Explained 3

Requirements Gathering: 10 Questions Every Business Analyst Should Ask Business Analyst for Beginners: The 6 BABOK Knowledge Areas in One Example RACI Matrix Explained: The 4 Letters and the One-A Rule (Full Example)

Visio for Business Analysts 31

How to Make a Basic Flowchart in Visio (Step by Step) How to Draw a BPMN Diagram in Visio (Beginner Friendly) How to Make a Data Flow Diagram (DFD) in Visio, Step by Step How to Make a Use Case Diagram in Visio (UML for Business Analysts)

See all 31 →

Excel for Business Analysts 12

VLOOKUP vs XLOOKUP in Excel (Which One Should You Use?) How to Make a Pivot Table in Excel (Beginner, in 5 Minutes) Excel Conditional Formatting for a RAID Log (Business Analyst Tips) How to Use XLOOKUP in Excel (Beginner Tutorial for Business Analysts)

See all 12 →

SQL for Business Analysts 36

SQL for Business Analysts: The 5 Queries You Actually Need SQL SELECT Basics: Get Data Out of a Table (Beginner Tutorial) SQL WHERE Clause: Filter Rows Like an Analyst SQL INNER JOIN Explained With a Simple Example

See all 36 →

Jira & Confluence for BAs 41

How to Get Jira and Confluence for FREE (Atlassian Free Plan Setup) How to Write a User Story in Jira (With Acceptance Criteria) How to Create an Epic and Add Stories in Jira Sprint Planning in Jira: Plan Your Next Sprint From the Backlog

See all 41 →

Mermaid for Business Analysts 21

Mermaid Flowchart Tutorial: Your First Process Map Mermaid Sequence Diagram for a Login Flow Mermaid ER Diagram: Customers, Orders and Products Mermaid State Diagram: Order Status Lifecycle

See all 21 →

draw.io for Business Analysts 18

draw.io Tutorial for Business Analysts: Your First Flowchart Swimlane Diagram in draw.io (Cross-Functional Flowchart) BPMN in draw.io: Events, Tasks and Gateways Use Case Diagram in draw.io (Actors and Use Cases)

See all 18 →

Excalidraw for Business Analysts 12

Excalidraw Tutorial for Business Analysts: Your First Flowchart How to Change Colours, Fill and Stroke in Excalidraw How to Wireframe a Website in Excalidraw (Product Page) How to Convert Mermaid to Excalidraw (Code to Hand-Drawn Diagram)

See all 12 →

BPMN for Business Analysts 11

BPMN Tutorial for Beginners: Your First Process Model BPMN Gateways Explained: Exclusive vs Parallel vs Inclusive BPMN Pools and Lanes: Show Who Does Each Step Message Flow vs Sequence Flow in BPMN: Talking Between Pools

See all 11 →

Airtable for Business Analysts 8

Airtable for Beginners: A Business Analyst's Requirements Tracker Tour How to Add Records and Fields in Airtable (Requirements Tracker) Airtable Linked Records: Connect User Stories to Requirements How to Make a Kanban Board in Airtable (User Story Backlog)

See all 8 →