SMB Pulse · Feature 11 of 12

The payments data

See what the payments data is made of, and answer questions with it: the app's own, or your own kept to ask again

Use cases, each with a guide4 use cases

Use caseWhoWhat it doesThe guide

See what the payments data is made of

Analyst

See the tables behind WidgetCo's payments: what each one holds, where its data comes from, and its rows, before trusting a number built from them.

See money received, by processor and by week

Analyst

Browse the money WidgetCo has received, then turn it into a table of totals by processor and week.

Answer a question the app already knows how to ask

Analyst

Find the failed or pending payments over an amount you choose, using a question the payments model already carries.

Answer a one-off question with SQL, and keep it

Analyst

Write your own question over the payments data, run it, and save it so you or others can ask it again.

Use case

See what the payments data is made of

Who

Analyst

What it does

See the tables behind WidgetCo's payments: what each one holds, where its data comes from, and its rows, before trusting a number built from them.

Use case

See money received, by processor and by week

Who

Analyst

What it does

Browse the money WidgetCo has received, then turn it into a table of totals by processor and week.

Use case

Answer a question the app already knows how to ask

Who

Analyst

What it does

Find the failed or pending payments over an amount you choose, using a question the payments model already carries.

Use case

Answer a one-off question with SQL, and keep it

Who

Analyst

What it does

Write your own question over the payments data, run it, and save it so you or others can ask it again.

Features