Partition Projection | John Nessime

Shopify Sales Dashboard with AWS: Build One That Actually Reconciles

Post category:Cloud Computing Technical Guides

Most Shopify dashboards built on AWS work perfectly for about three weeks, then quietly drift away from the numbers in the Shopify admin. Here is why that happens, and how to design the ingestion, storage and query layers so your totals still reconcile six months in.

Building a Jira Analytics Pipeline with AWS Lambda and Athena (Without Double-Counting Everything)

Post category:Cloud Computing DevOps Technical Guides

Jira's built-in reports stop at the board boundary. This guide walks through a Jira analytics pipeline built on AWS Lambda, S3 and Athena, organised around the four failure families that actually bite: the removed search endpoint, silently truncated changelogs, incremental loads that duplicate rows, and an S3 layout that quietly inflates your query bill.