Cross-tool cheat sheet
The same operation written five ways — SQL, Python (pandas), Excel, Tableau and Power BI (DAX). For when you know how to do something in one tool and need it in another, which is most of an analyst’s week.
Show tools
Category
Examples assume a table or DataFrame with columns
Sales, Category, Date, OrderID
and CustomerID unless stated. Adjust the names to your own data.