Michal KuderskiDATA ANALYST · B.S. STATISTICS
← Selected work

Analytics engineering · Independent portfolio project

GraphOS | Validated Retail Analytics Demo

A Python workflow that turns fictional retail records into clear, independently checked results, with data-quality evidence and saved-run history.

Python · CSV profiling · JavaScript · HTML/CSSAI-assisted developmentEvidence reviewed: November 3, 2026

The analytical question

How do cancellation-record shares vary by channel and month?

GraphOS brings discovery, profiling, calculation, and independent validation into a fixed local workflow. The Northstar Direct fictional retail benchmark supplies six related CSV tables: customers, products, orders, order items, campaigns, and returns.

The completed demo focuses on two useful tasks: channel/status counts and cancellation-record shares. Results appear with readable tables, charts, definitions, and optional technical evidence.

Contribution
Directed an AI-assisted build and iterative review of the analytical workflow, evidence interface, and saved-run experience.
Demonstrated result
All 60 channel/month groups reconciled to an independent calculation. Two saved results reopened unchanged after a controlled restart.
Project status
Completed local demo on fictional data. Production-readiness work continues; the application is not presented as a deployed public service.
30,035SOURCE ORDER RECORDSOriginal records retained, including repeated keys
60 groups3 CHANNELS × 20 MONTHSJanuary 2025–August 2026
6 tables114,256 TOTAL RECORDSFictional benchmark, separate from the small UI fixture

Demonstrated output

Compare channels with a consistent denominator.

For August 2026, the benchmark produces the following descriptive shares. Each denominator is the number of source order records for that channel and month; the numerator is the number marked cancelled.

Northstar Direct fictional benchmark · August 2026 · shares rounded to one decimal
ChannelCancelled recordsSource recordsCancellation share
Marketplace5920828.4%
Mobile10748322.2%
Web20980126.1%

Marketplace has the highest observed share in this month. This provides a starting point for investigation; it does not establish why cancellations occurred.

Metric scope: The benchmark retains 35 order records that repeat a declared business key. These are source-record shares, rather than unique-order rates, refunds, financial losses, or evidence of a real retailer’s performance.

Workflow & engineering

Make each result inspectable.

Profile the source

Inventory tables and columns, verify source hashes, and report empty cells, repeated keys, and numeric/date-format issues while preserving the original records.

Reconcile the calculation

Use separate parsing and counters to check group counts, totals, dates, and shares before presenting a successful result.

Explain the answer

Lead with a concise result, then expose the table, chart, metric definitions, quality evidence, and technical record through progressive disclosure.

Retain the evidence

Save bounded analysis receipts in a hash-chained journal. Reopen archived results read-only, with separate backup and restore-copy checks.

A separately bounded optional Analyst/Reviewer model pair completed once using aggregate metrics. Core calculations remain deterministic and scripted. This demonstrates a narrow review integration rather than a general autonomous analytics platform.

Evidence & interface

A working demo, with a defined scope.

The retained November 3 acceptance record documents reconciliation of all 60 groups, saved-result reopening after restart, a real backup with a separate restore copy, and served-browser checks at 390px and 1280px. A later source candidate records 150 passing Python tests and 41 JavaScript checks; its activation remained pending at the reviewed checkpoint.

Interface and data-quality workflow

The capture below shows the application itself, including the answer summary, chart, source-record table, and data-quality checks. Open the original image to inspect the detail.

GraphOS interface on a small synthetic fixture: answer summary, counts, quality tables, and optional model review.
Answer first, supporting evidence close by.This November 2 fixture capture illustrates the interface design. Its 18 source order records are separate from the 30,035-record benchmark and predate the saved-history and cancellation workflow.

Remaining work: Full native keyboard and screen-reader acceptance, broader analytical workflows, operational recovery, and deployment controls remain open. The public case study summarizes retained local evidence; it does not provide a live app or a standalone GraphOS source repository.