Add the app's data models, connect their tables to their data, and check them against the organisation's real files
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 case | Who | What it does | The 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.
- The guide
- 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.
- The guide
- 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.
- The guide
- 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.
- The guide
Read next
Why: the next feature area of SMB Pulse