AWAdam Wilsoninhiadam.hashnode.dev·Feb 26 · 8 min readHow to Set Up the Qlik MCP Server with Claude.ai and Actually Do Useful Stuff With ItI've been in data long enough to remember when "self-service analytics" meant you could run your own queries in SQL Management Studio instead of asking someone else to do it for you, but this is actua00
AWAdam Wilsoninhiadam.hashnode.dev·Feb 24 · 3 min readBuild Measures Faster: Using DAX Query View in Microsoft Power BIIf you’ve spent any serious time building models in Microsoft Power BI, you’ll remember the old ritual. Create measure. Hit Enter Wait Watch the little spinner Question your life choices Repeat Over a00
AWAdam Wilsoninhiadam.hashnode.dev·Feb 23 · 4 min readGrouping Measures in a Field ParameterField parameters are one of those Power BI features that feel like witchcraft the first time you use them. Switch between measures dynamically? No calculated columns? No DAX spaghetti? Sold. Then the 00
AWAdam Wilsoninhiadam.hashnode.dev·Feb 16 · 3 min readUsing Qlik Regex to Organise Messy Comment FieldsFree-text fields are both a blessing and a curse. They give users flexibility, but from a reporting point of view they’re often messy, inconsistent, and hard to work with. In this case, a customer had a Comments field where users manually typed infor...00
AWAdam Wilsoninhiadam.hashnode.dev·Feb 9 · 2 min readDeveloping in Production (Yes, Really)There’s a version of data work that exists in documentation, architecture diagrams, and conference talks. It has clean environments, clear requirements, and a sensible deployment process. And then there’s the version I keep encountering, the one wher...00