4+ hour, 51+ min ago   (333+ words) As I have started my Data analysis and science curriculum, Microsoft excel is the first tool we have learnt. In my life before getting into this course, I used to underestimate the power of Microsoft excel. This is a spreadsheet…...

5+ hour, 50+ min ago   (611+ words) I just came to the realization that Microsoft Excel is one of the most commonly tools used at the workplace. Not for anything else but for data analysis. I have never thought of it this way. Given my background in…...

23+ hour, 5+ min ago   (327+ words) To improve readability, I standardized the First Name and Last Name columns. By applying the =PROPER(text) function, I converted names to proper case (> e.g., john → John). The corrected values were pasted into new columns, and the original raw data was…...

1+ day, 14+ hour ago   (1690+ words) ClickHouse® 26.8 is the newest LTS release, and it is a substantial one: 21 backward-incompatible changes, 49 new features, 127 performance improvements, and around 30 settings that changed their default value. This article covers 26.8 on its own — what landed, what breaks, and what to verify…...

1+ day, 19+ hour ago   (162+ words) I built LuaDB – an embeddable relational database written 100% from scratch in pure Lua (no C extensions or external dependencies). Key features: Slotted 4KB binary pages with B+Tree primary/secondary indexing ACID transactions via Write-Ahead Logging (WAL) Built-in PostgreSQL Wire Protocol…...

1+ day, 23+ hour ago   (691+ words) Adding analytics to an application sounds simple. Install a tracking script. In practice, good analytics integration requires a little more thought. You need to decide what to track, where tracking code should live, how events should be structured, how tracking…...

1+ day, 23+ hour ago   (755+ words) When someone opens a website, the experience feels simple. A page loads. They click something. They navigate to another page. Maybe they submit a form or leave the website. For the visitor, that's it. But for a real-time analytics platform,…...

1+ day, 23+ hour ago   (986+ words) When you add analytics to a website, the visible part is usually simple. You install a tracking script. You open the dashboard. You see visitors, sessions, pageviews, and events. It can make analytics look like a straightforward problem: Capture an…...

1+ day, 23+ hour ago   (685+ words) Analytics is often treated as harmless infrastructure. A small tracking script runs on a website, events are collected, and a dashboard displays charts. It can look simple. But analytics systems can contain a surprisingly detailed picture of how a website…...

2+ day, 20+ hour ago   (506+ words) Short answer: start with a hosted metrics dashboard API, send a small set of custom application metrics from Node.js, and retain reconstruction fields in Postgres. Choose the custom Postgres path when joins are the investigation, or self-hosting when data…...