AAA Adarshinadarshgowda.hashnode.dev·1d ago · 6 min readPre-aggregation gets you 100× — until someone applies a filterYou have a dashboard over a large fact table. Tens of millions of new rows a month, thirty tiles on the page, and every tile is an aggregate: orders by channel, revenue by region, units by device. Eac00
SLSean Liuinzhaidata.com·1d ago · 7 min readMy semantic layer answers this question confidently. The answer is ambiguous.I'm building an evaluation harness for AI-generated SQL. While simplifying my semantic layer, I accidentally removed a guardrail I didn't know I had — and discovered a class of question that conventio00
АДАртём Дяченкоinartemdiachenko.hashnode.dev·3d ago · 6 min readI was proud of 4,410 impressions. Then I read the queries.For about a month I had a number I was quietly proud of. 4,410 impressions in Google Search Console. 31 clicks. Not a lot, but the line went up and to the right, and I'd built the thing myself, so I l00
DDravonicxintheory-vs-reality.hashnode.dev·5d ago · 3 min readSQL Window Functions: Calculating Cumulative Sums with Unbounded RowsA cumulative sum (or running total) continuously adds a sequence of numbers, providing a running aggregate at each step. In SQL, you calculate this using window functions combined with specific frame 00
AAmrinsmartlinks-live.hashnode.dev·5d ago · 5 min readYour app is live. How do you decide what to fix next?Getting an app into the store gives you a clear finish line. The build passes, the screenshots are uploaded, the review is approved, and the download button finally works. After that, the questions be00
NCN Chandra Prakash Reddyindevopstour.hashnode.dev·6d ago · 11 min readFrom Data Lake to Lakehouse: Building Modern Analytics Platforms on AWS with S3 Tables & AWS GlueOkay, we will be honest – data architecture is usually one of those topics that makes your head spin. I was there at AWS Community Day Chennai on 07-Mar-2026. There were a lot of good talks on many ki00
Aafietinafiet.hashnode.dev·6d ago · 10 min readllms.txt got zero requests in 18 daysI shipped llms.txt and llms-full.txt on my site, the way a lot of people were recommending at the time. Then I built a table that logs every AI crawler request that reaches the server, because I wante00
GGgyapa gandainlattice.hashnode.dev·Sep 4 · 6 min readI was going to write that a cited page never plateaus. Then I checked.I had the sentence written. A cited page does not plateau, it gets cited harder. It followed neatly from the previous piece, it sounded like a law, and the numbers in front of me appeared to support i00
GGalleryDockingallerydock.hashnode.dev·Sep 3 · 2 min readDesigning Explainable Opportunity Detection in SaaS AnalyticsAnalytics products often start with a simple request: “Show users where they should take action.” The tempting implementation is a score. const score = impressions * 0.2 + clicks * 0.4 + positio10
KPKPI Partnersinkpipartners.hashnode.dev·Aug 25 · 7 min readHow to Model Service Analytics for Salesforce Across Cases and Service RequestsA scalable Service Analytics for Salesforce architecture extracts service data without disrupting operational workflows, retains important lifecycle events, separates Cases from Service Requests, and 00
