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

Use Case Diagram in Mermaid (The Simple Workaround) How to Get Jira and Confluence for FREE (Atlassian Free Plan Setup) Comments and Mentions in Jira (Get Answers Faster) How to Make a Pivot Chart in Excel (A Chart That Follows Your Pivot) How to Make a Mind Map in Excalidraw How to Make an ER Diagram in Visio (Crow's Foot Notation) Use Case Description Template in Confluence (Actors, Flows, Exceptions) Primary and Foreign Keys in SQL Tables (Explained With a Join)

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 13

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 13 →

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 43

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 43 →

Mermaid for Business Analysts 22

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 22 →

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 13

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 13 →

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 →