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

Group by Month in SQL: Monthly Totals From Daily Rows Filter by Date in SQL (Last 30 Days, Last Month, This Month) Data Quality Checks in SQL for Business Analysts Profile a New Table in SQL in 5 Queries SQL CTE (WITH): Make Long Queries Readable, Step by Step COUNT vs COUNT DISTINCT in SQL SQL CASE WHEN: If-Then Logic in a Query SUM, AVG, MIN, MAX in SQL: Summary Stats for a Report

Business Analysis Explained 2

Requirements Gathering: 10 Questions Every Business Analyst Should Ask Business Analyst for Beginners: The 6 BABOK Knowledge Areas in One Example

Visio for Business Analysts 5

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

Excel for Business Analysts 9

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

SQL for Business Analysts 8

COUNT vs COUNT DISTINCT in SQL SUM, AVG, MIN, MAX in SQL: Summary Stats for a Report SQL CASE WHEN: If-Then Logic in a Query Filter by Date in SQL (Last 30 Days, Last Month, This Month)

See all 8 →

Jira & Confluence for BAs 31

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

Mermaid for Business Analysts 16

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

draw.io for Business Analysts 13

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

Excalidraw for Business Analysts 6

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

BPMN for Business Analysts 6

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

Airtable for Business Analysts 6

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