CUF vs PR vs specific yield: three solar metrics that sound similar but answer different questions. See the formulas, a four plant comparison and which one to use.
CUF vs PR vs Specific Yield: Three Metrics, Three Different Questions Read Post »
Solar KPIs turn raw energy readings into decisions. Learn 12 essential metrics, from performance ratio and CUF to degradation and LCOE, with simple formulas and one worked example plant.
Solar KPIs: 12 Essential Metrics With Simple Formulas Read Post »
I add things to my cart and change my mind too, and it turns out businesses can measure exactly where that happens. Here is how I explored cart abandonment analysis with SQL and a dashboard.
Diwali offers are everywhere, but which channels actually convert? In this festive season funnel analysis, I break a Diwali campaign down by funnel stage, channel, CAC, ROAS and RTO, so “sales went up” turns into a decision you can act on.
Festive Season Funnel Analysis: Where Diwali Marketing Campaigns Actually Convert Read Post »
A working set of 75 ecommerce and marketing analytics interview questions, each with a model answer and SQL query built against one shared practice schema, from business fundamentals through advanced SQL and statistics.
75 Ecommerce and Marketing Analytics Interview Questions (With Model SQL and Answers) Read Post »
Revenue is up 20% — but is that really good news? Learn how e-commerce analysts can look beyond revenue, analyze discounts, returns, margins, and repeatability, and uncover when impressive growth is actually a warning sign.
Why Your SQL Answer Is Wrong: 5 Critical Questions to Ask First Read Post »
A data-analyst aspirant’s real breakdown of the e-commerce metrics that actually come up in interviews—CAC, ROAS, conversion rate, AOV, and LTV—with a worked example you can follow along with.
Why domain knowledge matters (and why I had to learn it the hard way) Read Post »
