Andrew Hubbard·Jan 4Data-Driven System Administration on Windows Servers: Analyzing Event Logs and MetricsAs a Windows sysadmin, you’re no stranger to Event Viewer, Performance Monitor, and endless troubleshooting. The problem with this approach…
InPower BIbyAndrew Hubbard·Sep 19, 2025FILTER() vs. ALL() vs. REMOVEFILTERS(): When and Why to Use EachWhen working with DAX, you probably have moments where you find the measure you wrote doesn’t behave as expected. So, you make tweaks to…
InPower BIbyAndrew Hubbard·Sep 8, 2025Mastering Context Transitions in Power BI: CALCULATE + ALLEXCEPT + USERELATIONSHIPIn the world of Power BI, context is king. Whether you’re building a dashboard for executive insights or troubleshooting a stubborn DAX…
InPower BIbyAndrew Hubbard·Jul 28, 2025From Gridlock to Clarity: My Journey Building a Global CO₂ DashboardWhen I started building my Global CO₂ Emissions dashboard. I had a clear mission: make climate data digestible, interactive, and genuinely…
Andrew Hubbard·Jul 23, 2025Word Embeddings Explained: Why ‘King’ and ‘Queen’ Are Closer Than You ThinkWhat Are Word Embeddings?
Andrew Hubbard·Jul 7, 2025When SEO Killed My CreativityHow I Lost My Voice Trying to Win Search Traffic — and What I’m Doing About It
Andrew Hubbard·Apr 23, 2025Creating Metadata with PySpark Notebook when processing filesRecently, I undertook a technical assessment to test my skills in building data pipelines in Microsoft Fabric. As part of the hiring…
InPower BIbyAndrew Hubbard·Nov 21, 20245 Powerful Ways the EARLIEST Function can Transform DAX CalculationsIntroduction
InPower BIbyAndrew Hubbard·Nov 10, 20247 Powerful Ways to Use Custom Gauge Charts in Power BI VisualsIntroduction: Why Custom Gauge Charts and KPI Indicators Matter in Power BI.