IT, Techno, Auto, Bike, Money
One four-line list, six languages, and the gotchas nobody mentions: leading zeros that compare as equal, prices and negative numbers that… Continue reading on Medium » One four-line list, six…
An INNER JOIN can lose orders and multiply others in the same query. Here is a reproducible test for the failure that aggregate dashboards… Continue reading on Medium » An…
Writing efficient SQL queries is one of the fundamental responsibilities of a database developer. Continue reading on Medium » Writing efficient SQL queries is one of the fundamental responsibilities of…
Discover how SQL Server schemas simplify database organization, improve security, and make your applications easier to maintain. Continue reading on Medium » Discover how SQL Server schemas simplify database organization,…
When I started learning SQL, I thought GROUP BY was enough to handle most aggregation problems. Need an average? Use AVG(). Want totals by… Continue reading on Medium » When…
A data analytics career in 2026 is open to non-IT graduates, and many of the best analysts in Kerala came from commerce, economics, maths… Continue reading on Medium » A…
A data analytics career in 2026 can start from your laptop. Live online courses now teach Excel, SQL, Power BI and Python with the same… Continue reading on Medium »…
Three customers. Six orders. A report that says six customers. Continue reading on Medium » Three customers. Six orders. A report that says six customers.Continue reading on Medium » Read…
Three customers. Six orders. A report that says six customers. Continue reading on Medium » Three customers. Six orders. A report that says six customers.Continue reading on Medium » Read…
A test can show “p = 0.02” and still be wrong. Here are 5 checks, with tested SQL, to do before you launch. Continue reading on Medium » A test…
A test can show “p = 0.02” and still be wrong. Here are 5 checks, with tested SQL, to do before you launch. Continue reading on Medium » A test…
Less typing, fewer subqueries, safer table changes, and test data in pure SQL Continue reading on Medium » Less typing, fewer subqueries, safer table changes, and test data in pure…
Less typing, fewer subqueries, safer table changes, and test data in pure SQL Continue reading on Medium » Less typing, fewer subqueries, safer table changes, and test data in pure…
Every beginner data analyst asks the same question: which tool first? Continue reading on Medium » Every beginner data analyst asks the same question: which tool first?Continue reading on Medium…
Every beginner data analyst asks the same question: which tool first? Continue reading on Medium » Every beginner data analyst asks the same question: which tool first?Continue reading on Medium…
You create a model, and one of its columns is calculated by the database: a full name built from two fields, a slug, a total. You save it… Continue reading…
A systematic approach to finding logic errors, tracing incorrect results, and fixing SQL queries with confidence. Continue reading on Medium » A systematic approach to finding logic errors, tracing incorrect…
How data analysts can use SQL, customer segmentation, and business thinking to help companies understand customer churn and make better… Continue reading on Medium » How data analysts can use…
Power BI’s date-table rules as SQL checks, 23 columns from one macro, and the week 53 bug. Continue reading on Medium » Power BI’s date-table rules as SQL checks, 23…
Preserve same-millisecond events with precise ordering and robust SQL window function strategies Continue reading on Medium » Preserve same-millisecond events with precise ordering and robust SQL window function strategiesContinue reading…