AI Data & Automation

Foundation

Spend less time rebuilding reports. Reach reliable answers faster. Give connected work shared definitions.

Most organisations already have useful data. The problem is that it sits across operational systems, finance tools, spreadsheets, databases and files that do not agree or move together reliably. Dashboards become reconciliation exercises, automations break silently and AI tools cannot answer from the operating reality of the business.

Foundation connects selected systems, creates reliable data flows, builds tested business views and ships useful reports, dashboards or a first controlled workflow where the agreed scope supports it. The result is shared business context the organisation can inspect, operate and build on.

All prices are excl. VAT and third-party costs.

Scope your Foundation

What makes business data AI-ready?

For the agreed purpose, in-scope business data is AI-ready when it is current, defined, tested, permissioned, traceable, observable and owned. This is not a certification and does not mean every dataset is perfect:

ConditionBuyer meaning
CurrentFresh enough for the decision or workflow it supports.
DefinedImportant business terms and fields have an agreed meaning.
TestedMaterial data flows and definitions have checks and acceptance evidence.
PermissionedAccess matches the approved users, systems and purpose.
TraceableA result can be followed back to its source and transformation path where scoped.
ObservableStale data, failed runs and important quality problems can become visible.
OwnedA named client role owns the definitions, access, decisions and post-handoff operation, or explicitly approves them.

The exact acceptance conditions are engagement-specific and written into the scope or SOW.

What Foundation is

Foundation is the working data and automation layer between the systems the organisation already uses and the interfaces people need: trusted reports, dashboards, internal tools, AI-assisted analysis and controlled workflows.

It is a custom build, not a seat-based software product. The implementation is designed for the client’s approved environment and constraints, with engagement-specific code, models, connectors, runbooks and delivery artefacts handled under the written agreement.

Scope

A typical Foundation includes the following.

SOURCES

10 data sources connected

Shopify, Stripe, HubSpot, Klaviyo, Meta Ads, NetSuite—or the systems that matter most to your operations.

Reliable ingestion, retries, monitoring and alerting are implemented according to the requirements of each connection.

REPORTS

5 reports and dashboards

Built around the questions your team actually needs to answer, using shared data and agreed definitions to reduce manual reporting and conflicting numbers.

WORKFLOW

1 production AI or automation workflow

For example, an AI assistant, automated leadership report or operational workflow grounded in your business data.

Final scope, price and timeline depend on source access, connector complexity, data quality, security and procurement requirements, stakeholder availability, documentation needs and operating requirements.

How success is agreed

Each Foundation uses measures that match its tier and intended outcome. The written scope may cover:

  • accepted sources, data flows, reports, dashboards or a first bounded capability;
  • reporting-preparation time, reconciliation effort, freshness and time-to-answer;
  • data-quality exceptions, failed-run visibility and recovery readiness;
  • permissions, human review, fallback and runbook completion;
  • active use, owner readiness and handoff acceptance;
  • client-specific change from the Assessment baseline where evidence supports comparison.

Each selected measure states the baseline or current condition, measurement period, evidence source, owner and review point. Targets apply only as written in the agreement; they are not universal performance, savings, ROI or payback promises.

What we connect

Memory(One) connects the selected sources that support the agreed business outcome and have a workable approved access path.

A source is one place relevant data comes from: a SaaS platform, internal database, ERP, warehouse system, SharePoint site, Google Drive folder, SFTP delivery, webhook, API or spreadsheet export.

Examples include:

  • CRM: Salesforce, HubSpot and Pipedrive.
  • Billing and finance: Stripe, Chargebee, QuickBooks, NetSuite, Sage and Xero.
  • Advertising and growth: Google, Meta and LinkedIn Ads.
  • Support: Zendesk, Intercom and Freshdesk.
  • Project and operations: Jira, Asana, Linear and Monday.
  • Product and analytical data: Postgres, MySQL, MongoDB and BigQuery.
  • Commerce and fulfilment: Shopify, warehouse-management systems and logistics platforms.
  • Files and custom paths: SharePoint, Google Drive, SFTP, webhooks and custom APIs.

Where standard connectors do not cover the required entities, fields, freshness or controls, Memory(One) can build or extend a connector. Supported patterns can include REST APIs, GraphQL, webhooks, direct database access, SFTP/file ingestion and custom wrappers, subject to access and scope.

Our Operating Philosophy: Five Layers, Two Disciplines

1. Source

Identify the business questions, the systems and fields that can answer them, the owners, access paths and first priorities. A source is included because it supports an agreed outcome, not because it happens to be available.

2. Ingest

Move selected data reliably into the agreed environment. Depending on the source and freshness need, this may use webhooks, scheduled API polling, batch files or change-data capture. Connectors include the retry, reconciliation and visibility needed for production use.

3. Model

Turn source-shaped data into tested business concepts and definitions. SQL, dbt, Python or the client’s approved modelling tools can create reusable views for customers, orders, subscriptions, revenue, workflow cases and other agreed domains.

4. Orchestration

Run ingestion, models, checks and downstream outputs in the right order. Simple schedules remain simple; more complex work can use Dagster, Prefect, Airflow, cloud-native orchestration or an approved equivalent when dependencies, backfills and lineage justify it.

5. AI Interface

Expose a bounded result people can use: a dashboard, report, internal tool, assistant or controlled workflow grounded in the modelled data. Risky or consequential actions retain an appropriate human-approval path.

Across all five layers:

  • Trust covers freshness, row volume, schema changes, key-field quality, monitoring, alerts and visible degraded states.
  • Identity & Compliance covers least-privilege access, service identities, secrets, sensitive-data boundaries, role-based access, audit logging and offboarding requirements.

Technology and environment

Built around the client’s approved environment

Foundation does not rely on one mandatory vendor stack. We select the cloud, data platform, storage, modelling and orchestration components that fit the client’s existing architecture, operating capability, security requirements and support model.

Cloud and data platforms

Memory(One) can work within an established cloud, warehouse or lakehouse environment, or assemble a focused foundation in an approved client account.

  • AWS
  • Snowflake
  • Google BigQuery
  • Databricks
  • Microsoft Fabric

Data infrastructure and orchestration

Depending on the agreed scope, the implementation may use services such as Amazon S3, Redshift, Athena, Glue, Lambda, Step Functions and EventBridge, together with dbt, Python, Dagster, Prefect, Airflow or an approved equivalent.

The architecture remains as simple as the operating requirements allow. More specialised components are introduced only when data volume, dependencies, backfills, governance or operating responsibility justify them.

  • Amazon S3
  • Amazon Redshift
  • Amazon Athena
  • AWS Glue
  • AWS Lambda
  • AWS Step Functions
  • Amazon EventBridge
  • dbt
  • Python
  • Dagster
  • Prefect
  • Apache Airflow

AI interfaces and development environments

Approved AI and developer tools can connect to the client’s governed query or semantic layer through scoped interfaces, permissions, logging and human-review controls where required.

This may include Claude, ChatGPT, Cursor, GitHub Copilot or MCP-compatible clients. A .NET/C#-oriented implementation can be used where it better matches the client environment.

  • Claude
  • ChatGPT
  • Cursor
  • GitHub Copilot
  • MCP-compatible
  • .NET / C#

These are illustrative implementation options, not a universal stack commitment or a statement of partnership, certification or endorsement. The written scope defines the selected components, ownership, security requirements, operating responsibilities and support boundary.

What the client receives

Depending on the agreed tier:

  • priority-source map and access plan;
  • selected connectors and reliable ingestion paths;
  • raw, staging and business-modelled data layers;
  • agreed definitions and tested business views;
  • reports or dashboards tied to real business questions;
  • a first controlled workflow or AI interface where included;
  • monitoring, alerting and recovery paths;
  • permissions and audit behaviour appropriate to scope;
  • documentation, runbooks, handoff and agreed post-launch support.

Process

  1. Kickoff and priorities — confirm the SOW, business questions, sources, access, owner, environment and acceptance criteria.
  2. Map and connect — rank the sources, establish access and make the first agreed data flows visible.
  3. Model and reconcile — create tested business views and tie important numbers back to trusted references where available.
  4. Build the outputs — ship the agreed dashboards, reports and bounded interface or workflow in usable increments.
  5. Add operating controls — complete monitoring, alerts, access controls, runbooks and recovery routes.
  6. Handoff and stabilise — train the owner, confirm acceptance and begin any included post-launch support.

What we need from the client

  • 2–4 hours per week from the relevant client team during a standard build.
  • A named business owner and the people who understand the sources and decisions.
  • Credentials or service-account access, source by source, through an approved process.
  • Existing definitions, reports and reference numbers used to validate the result.
  • Timely security, IT, procurement and stakeholder decisions.
  • Known data-residency, privacy, retention, audit and access requirements.
  • Agreement on acceptance criteria, priority sources and the post-handoff owner.

Credentials should not be shared through informal channels. Memory(One) works with the client’s approved secrets and access process where possible.

Week-2 Priority Source Guarantee

For qualifying Foundation projects, the priority sources are agreed before kickoff. If the agreed priority sources are not live in the agreed client-approved environment by the end of week 2 for reasons within Memory(One)’s control, the Foundation deposit is refunded.

The written SOW must name the covered sources, access prerequisites, start point, meaning of live and exclusions. Delays caused by missing or incorrect access, client approvals, undisclosed source limitations, third-party outages, security or procurement blocks, or client-requested scope changes are excluded.

Ownership and post-launch boundary

Foundation projects generally use client-owned or client-approved infrastructure. Engagement-specific code, connectors, schemas, transformations, data, documentation, runbooks and deployed infrastructure are handled under the written agreement. Memory(One) retains generic methods, reusable patterns and pre-existing tooling.

Where included in the SOW, the first 30 days after launch can cover bugs, schema changes, edge cases and stabilisation. Longer monitoring, connector maintenance and agreed improvements are handled through Post-Launch Support & Improvement. Material additions remain new scope.

This project model is distinct from Managed Automation, which uses a Memory(One)-managed platform and depends on an active care subscription.

Illustrative walkthrough

An operations team wants to know which orders need attention today. Order, billing and support systems hold different pieces of the answer.

  1. Source: identify the required order, payment and support records.
  2. Ingest: bring current records into the approved environment and flag missing or delayed inputs.
  3. Model: define shared order status, payment state and exception rules.
  4. Orchestration: refresh the data, run checks and route exceptions in the right sequence.
  5. AI Interface: present a daily view showing the affected orders, supporting context, freshness and owner.

Trust controls prevent incomplete data from appearing as current. Identity & Compliance controls limit records and actions according to role. Actual sources, outputs and controls depend on the agreed scope.

When it fits — and when it does not

A good fit whenProbably not the right fit when
Relevant data is spread across systems and teams cannot agree on a shared view.The buyer wants a generic chatbot connected to static files.
Reports depend on manual exports, reconciliation or fragile spreadsheets.The required systems have no workable access path.
AI or automation needs reliable, current business data and visible controls.There is no internal owner for access, definitions and handoff.
The organisation wants an owned, maintainable foundation rather than another manual process.The expectation is to model everything perfectly before any useful output appears.
A phased first result can create value while Foundation expands.The requirement is one already-bounded point-to-point workflow better served by a focused build.

When reliable data exists but teams need daily review surfaces, approval queues, exception handling or workflow control, continue to Operations.

Ready to build the foundation?

Bring the business questions, the first systems, the reports people do not trust and the person who will own the result.

Scope your Foundation