Cookies on this site

We would like to use cookies to understand how the site is used and to measure our campaigns. Nothing is set until you choose, and you can change your mind at any time from “Cookie settings” at the foot of every page. Privacy policy

Contact UsContact Us

Work / Client case study

  • Data Analytics
  • Systems Integration
  • Energy & utilities

Data quality program for a state public power authority

We run data quality work on Ataccama ONE for a public power authority: quality rules, monitoring projects and issue tracking, connected to Power Automate so every data issue becomes a tracked task with an audit trail.

Client
State public power authority
Status
Ongoing engagement

Results

  • Issues tracked to fix

    Headline result

  • Data issues tracked from detection to fix
  • Ataccama ONE connected to Power Automate

Built with

  • Ataccama ONE
  • GraphQL API
  • Power Automate

Client names are withheld. We are happy to share details on a call.

More work

Related projects

Same practice areas, different problems.

All case studies
  • In delivery

    4 systems, 1 record

    Food manufacturing

    Systems Integration

    One customer record across four business systems for a national food cooperative

    Wholesale customers sign up in the online store, are approved in the CRM, copied to the ERP and marketed to from a separate platform, and changes made by phone reached none of the others. The workflow keeps customer records, approvals, order history and profile changes in step across all four, and flags anything that needs a person.

    • Four systems, one customer record
    • Exceptions routed to a named reviewer
  • Delivered

    KPIs on request

    Food manufacturing

    Data Analytics

    Marketing performance agent for a national food cooperative

    Marketing staff ask about paid-media results in plain English. The agent reads campaign data from SharePoint, runs the calculations in Python on Azure Functions rather than summarizing, and returns charts and Word or Excel reports.

    • Campaign KPIs without waiting for an analyst
    • Secure access with managed identity, no stored passwords
  • Delivered

    600k files, < 3 days

    Document management

    Microsoft

    600,000 documents moved from ImageRight to SharePoint in under three days

    A one-file-at-a-time script would have needed about 22 days of continuous running. We rebuilt the migration around a SQL work queue with parallel uploads, automatic retries and crash recovery, and it finished unattended in under three days.

    • 1,125 → 8,314 files per hour
    • Under 3 days instead of about 22

Reports nobody trusts?

We will profile one data set for free and show you exactly what is wrong with it.

Tell us what you are working on

A few lines is enough. The engineers who do this work will reply within one business day.

Or email it.services@princetonits.com or call +1 (212) 507-9350.