Skip to main content
Workflow demos · Data analysis

Data analysis

Cleans rows from CSV or Excel files or a database, computes totals, group breakdowns, trends and shares, and returns a checked Excel workbook with charts.

Try it with your own dataHarnesses
Start from a harness templateStart by copying a domain's instructions, skills and completion checks, then connect your company's data to the resources the template recommends.

Data analysisSample run
H1-shipments.xlsx

Total shipments by region and month and chart the trend.

Completion checks
Result files

A sample screen. Real steps and times depend on the model and the files.

01

Task overview

RuntimeBase image
Completion checksCheck script · 1 Excel
02

Input

Sample data

Attachments

H1-shipments.xlsx

Request

Total shipments by region and month and chart the trend.

Company data to connect

Source database

03

Processing steps

  1. Clean
  2. aggregate
  3. trends and shares
  4. verify
04

Output

Result files

shipments-summary.xlsxmonthly-trend.png

Completion check items

  • Summary and total rows recomputed
  • Rows read − dropped = rows used
  • The answer's totals match the workbook
05

Sample data

All file names and figures are sample data.

Sample data

Shipments by month and region

MonthCapitalSoutheastSouthwest
Jan4,1202,2101,080
Feb4,3802,3401,120
Mar4,5102,2801,150
Apr4,2902,4101,170
May4,6502,5301,210
Jun4,8202,6001,340
Total26,77014,3707,070

See it with
your own documents

In a consultation, we connect a few of your documents so you can check the answer quality for yourself. Send us your questions and our team will get back to you.

Try it with your own dataAll workflow demos
Product videosReal product screens · Example company ACME Logistics · 16 videos