DataCello · How To

Solve a real data task,one workflow at a time.

Start from the outcome you need. Every guide is limited to workflows supported by the current DataCello app.

Browse 8 published guides

Prepare source data without changing the original.

Import

01

About 3 min Open a garbled CSV with the right text encoding on MacImport a CSV with readable headers and text values

Prepare

01

About 5 min Reshape monthly sales columns into long formatCreate product, month, and sales columns that are easier to aggregate

Sales & operations

02

About 7 min Extract weekdays from order dates and compare order countsCreate a dataset that compares order counts by weekday About 7 min Aggregate product sales and find the top productsCreate product-level sales totals and a Top N bar chart

Statistical analysis

03

About 10 min Forecast future sales from historical time-series dataReview forecast values together with upper and lower bounds Pro About 10 min Segment customers with numeric metrics and K-MeansExplore customer clusters with similar numeric characteristics Pro About 8 min Test whether average order value differs between A and BEvaluate a two-group mean difference with a p-value and effect size Pro

MCP

01

About 8 min Inspect a local CSV from an MCP-compatible clientInspect CSV structure and a small preview before choosing an analysis

DataCello for Mac

Try the workflow with your own CSV.

Import and inspect CSV data before choosing your next workflow.