Gross vs Operating vs Net Margin: What Each One Tells You
By Michael Nocito , data analyst · Published August 11, 2026 By the end of this page you can look at an income statement and say, in one sentence, w…
DevOps
⚑ Report a ProblemLatest DevOps news from Tech News
Contribution Margin and Break-Even: The Fixed Cost That Does Not Belong in the Unit
By Michael Nocito , data analyst · Published August 11, 2026 By the end of this page you can answer three questions that come up constantly and get…
SUM vs SUMX in DAX: Why a Row-by-Row Calculation Needs an Iterator
By Michael Nocito , data analyst · Published August 10, 2026 By the end of this page you can look at any DAX aggregation and say which of the two it…
Tableau Dashboard Extensions: What They Add, and What They Can Read
By Michael Nocito , data analyst · Published August 9, 2026 By the end of this page you can add an extension to a dashboard, tell the two hosting ki…
pandas pct_change and cumsum: Percent Change and Running Totals
By Michael Nocito , data analyst · Published August 8, 2026 By the end of this page you can turn transactions into a monthly series, add period-on-p…
pandas merge: Left Join, Inner Join, and the One That Doubled the Revenue
By Michael Nocito , data analyst · Published August 8, 2026 By the end of this page you can attach columns from one DataFrame to another on a shared…
Handling Missing Values in pandas: dropna, fillna and What Each One Claims
By Michael Nocito , data analyst · Published August 8, 2026 By the end of this page you can count what is missing and where, choose between dropping…
Excel Tables vs Ranges: What Ctrl+T Actually Changes
By Michael Nocito , data analyst · Published August 8, 2026 By the end of this page you can turn a list into a real Excel table, write formulas that…
Excel Dynamic Arrays: FILTER, UNIQUE and SORT in One Formula
By Michael Nocito , data analyst · Published August 8, 2026 By the end of this page you can pull a distinct list out of a column, extract every row…
Excel Drop Down Lists and Data Validation, and the Paste That Removes Them
By Michael Nocito , data analyst · Published August 8, 2026 By the end of this page you can put a dropdown on a column in about a minute, keep its l…
pandas GroupBy: How to Summarize a DataFrame Without Losing Track of Your Rows
By Michael Nocito , data analyst · Published August 7, 2026 By the end of this page you can take a DataFrame, summarize it by any column or combinat…
Your Tableau Dashboard Needs Two or Three Views, Not Eight
By the end of this page you can look at a folder of eight finished sheets and say which two or three belong on the dashboard, which one goes in the…
What Is Data Analysis?
By the end of this page you will have done a real piece of data analysis. It is a small one, on paper, with arithmetic you can do in your head. You…
How to Verify an AI Agent Actually Did the Work
An AI agent tells you the work is done. Here are five checks that show whether it is. Each check takes a minute or two. Each one looks at the thing…
How SQL and Python Work Together in Data Analysis
Every data analyst job posting asks for SQL and Python. That raises an honest beginner question nobody seems to answer directly. If both work with d…
Your Data Is Never Fully Clean, and Analysts Ship Anyway
Analysts ship work that still has flaws in it. They do it by documenting every imperfection and making it defensible . This guide covers how, at the…
Who actually feels lost about Germany's new automatic platform and crypto tax reporting? (a pandas cut)
Since January 2026, if you sell on eBay or Vinted, rent a room on Airbnb, or trade on Coinbase or Bitpanda, the platform now reports your income str…
When should you publish a dev post? I counted, and JP vs EN are mirror images
Let me confess something a little creepy. I have a habit of peeking at other people's dev posts. Not stealing the writing — relax. I run a tiny read…
I scraped 50,000 G2 reviews to map the 2026 SaaS Battlecard Atlas
The 2026 SaaS Battlecard Atlas: What 50,000 G2 Reviews Reveal About 25 of the Most-Used B2B Tools A few weeks ago I got tired of guessing which B2B…
The Python Data Analytics Handbook: A Guide for Beginners
Introduction Python is a computer programming language often used to build websites and software, automate tasks, and conduct data analysis. Python…