VLOOKUP vs XLOOKUP: Which One to Use, and How to Switch
Michael Nocito
Command Palette
Search for a command to run...
Archive
70 posts published so far
Tableau Sorting: A Rule That Re-Runs, or an Order You Froze
Michael Nocito
Your Tableau Dashboard Needs Two or Three Views, Not Eight
Michael Nocito
How to Connect Tableau to Your Data (And What Happens the Moment You Do)
Michael Nocito
How to Install Tableau Public (And Which Free Tableau You Actually Need)
Michael Nocito
CALCULATE and Filter Context in DAX, Explained on Sixteen Rows
Michael Nocito
Calculated Column vs Measure in Power BI: The Rule That Decides
Michael Nocito
How to Import a CSV into Power BI (And the Three Dropdowns Nobody Reads)
Michael Nocito
How to Install Power BI Desktop (Including on a Locked-Down Work Laptop)
Michael Nocito
pandas merge: Left Join, Inner Join, and the One That Doubled the Revenue
Michael Nocito
pandas GroupBy: How to Summarize a DataFrame Without Losing Track of Your Rows
Michael Nocito
pandas read_csv: Your First DataFrame, and What It Guessed
Michael Nocito
How to Set Up Jupyter Notebook (And Why Your Environment Is Missing From the Kernel List)
Michael Nocito
How to Install Python for Data Analysis (And Why pip install Then Fails)
Michael Nocito
Subquery vs CTE in SQL: Same Logic, One You Can Check
Michael Nocito
How to Install PostgreSQL for Beginners (And Whether You Need To)
Michael Nocito
Which SQL Database Should You Install?
Michael Nocito
Month-over-Month Growth in SQL: LAG, the Growth Formula, and the Traps
Michael Nocito
NULL in SQL: Why = NULL Finds Nothing and What to Write Instead
Michael Nocito
How to Find Duplicate Rows in SQL (and Decide What Counts as One)
Michael Nocito
How to Comment in SQL: -- and /* */, and the Two Traps That Break a Query
Michael Nocito
Correlation vs Causation: The Three Explanations for Any Pattern
Michael Nocito
How to Choose the Right Chart: One Question About Your Data
Michael Nocito
Operations Analytics, Start to Finish
Michael Nocito
Build a Dashboard in This Order: Correct, Then Clear, Then Compelling
Michael Nocito