Analyze the business file you already have

Pick the kind of export on your desk. Each guide covers what that file contains, what usually goes wrong with it, and the questions people ask of it — and every answer DataMimi gives shows which rows and columns it came from.

Accounting and finance exports

QuickBooks, Xero, FreshBooks and bank exports: P&L, cash flow, AR and AP, reconciled and explained.

All 28 guides →

Ecommerce and marketplace exports

Shopify, Amazon, Etsy and WooCommerce orders joined to your product list, with margin after fees.

All 21 guides →

Amazon seller reports

Seller Central business, settlement, inventory and advertising reports, read the way they are actually exported.

All 5 guides →

Marketing and ad reports

Google Ads, Meta, TikTok and email platform exports turned into spend, ROAS and campaign comparisons.

All 19 guides →

SaaS and subscription metrics

MRR, churn, cohorts and LTV from Stripe, Chargebee or a billing export.

All 6 guides →

Payments and reconciliation

Stripe, PayPal and processor payouts matched against orders and bank deposits.

All 9 guides →

HR and operations data

Headcount, turnover, timesheets and operational logs, summarised without a BI project.

All 5 guides →

Payroll data

Payroll registers from Gusto, ADP and Paychex checked, totalled and compared period to period.

All 1 guides →

Industry reports

Restaurants, clinics, property managers, agencies: the exports each industry's software produces.

All 19 guides →

AI spreadsheet analysis

Ask questions of any Excel or CSV file, compare tools, and see how DataMimi differs from ChatGPT and BI software.

All 63 guides →

Exports from the apps you use

QuickBooks, Shopify, Airtable, Notion, Zoho, Pipedrive and more: what each export contains and what to ask of it.

All 9 guides →

Analysis methods

Cohorts, forecasts, anomalies, break-even, CAC and LTV: the analysis, explained on your own file.

All 78 guides →

Analysis by role

What a CFO, a finance manager, a product manager or a small-business owner actually needs from their spreadsheets.

All 12 guides →

AI data tools compared

DataMimi next to ChatGPT, Power BI, Tableau and the rest: what each is for, and where each falls short.

All 11 guides →

Excel formulas

Working with formulas and solvers inside a spreadsheet.

All 1 guides →

More guides

Everything else we have written about working with business spreadsheets.

All 99 guides →