by Wyn Hopkins Vibe coding is the new macro recorder I saw a lovely analogy from Eugene Meidinger on BlueSky the other day “Vibe-maintaining an app is like cleaning with a dirty mop. No matter how hard you try, you seem to leave a layer of dirt and filth” Cast your mind back to [...]
by Wyn Hopkins Why I Prefer Building Reports in Power BI I recently presented a session at the Global Excel Summit in London entitled “Why Power BI is better than Excel … or is it?” Tough crowd! My co-presenter Sue Bayes and I were up against our Unpivot co-hosts Giles Male and Mark Proctor [...]
Most organisations already use dashboards to report performance. The real differentiator is not the platform used to build them. It is whether the dashboard is designed in a way that helps leaders understand performance and act with confidence. Excel, Power BI, and other analytics platforms can all produce clear, insightful dashboards when they are [...]
Looking to enable Copilot in Power BI or Microsoft Fabric? You’re not alone. As more organisations look to integrate AI into their analytics workflows, understanding how to correctly set up Copilot Capacity is key. In this practical step-by-step video, Wyn shows you exactly how to configure Copilot for Power BI, covering everything from setup to [...]
In today’s data-driven world, businesses need the right tools to make sense of their data. Power BI is a popular choice for data visualisation, and with the addition of Deneb, users can take their Power BI reports to the next level. Throughout this blog, we’ll introduce you to Deneb, a declarative visualisation tool designed to [...]
By Simone Palmas Want to keep your Power BI reports up-to-date without waiting for scheduled refreshes? Now, you can manually refresh your report directly from the report interface using Power Automate. Below, Access Analytic team member Simone Palmas has created a step-by-step guide to set it up. Setting up Manual Refresh in Power BI [...]
By Melina Louzada You've made it to the final part of our blog series on mastering dynamic measure formatting in Power BI! If you're joining us now, you can catch up with Part 1 here, Part 2 here, and Part 3 here. In this post, we'll explore dynamic formatting based on value ranges, a method [...]
Mastering Dynamic Measure Formatting in Power BI |Part 3: Using SWITCH/SELECTEDVALUE() for Dynamic Formatting By Melina Louzada Welcome to the third blog in our series on dynamic measure formatting in Power BI! If you haven’t checked out the first two blogs yet, find Part 1 here and Part 2 here. This post will cover using [...]
Mastering Dynamic Measure Formatting in Power BI | Part 2: Dynamic Cell Colour Formatting By Melina Louzada Welcome back to the second part of our series on mastering dynamic measure formatting in Power BI! If you missed Part 1: Flexibility with Visual Level Format String, you can check it out here and download the working file. [...]
Mastering Dynamic Measure Formatting in Power BI | Part 1 - Flexibility with Visual Level Format String By Melina Louzada In the realm of data analysis, the clarity of data presentation is just as crucial as the data itself. Dynamic measure formatting in Power BI enables analysts to tailor data representations to enhance readability and [...]
by Wyn Hopkins Setting up a free Personal Power BI / Fabric Account Do you want to try out the Power BI / Fabric Service (PowerBI.com) or share your portfolio of reports with potential new employers? If you have a PowerBI.com account then you can use the Publish to Web option to share your [...]
by Wyn Hopkins Instant Analysis with Code Interpreter and ChatGPT Take 8 Excel files, write 2 instructions ( 25 words in total ), done…data summarized and charts built! Go to OpenAI.com GPT -4, enable Code Interpreter Write 1 sentence and upload folder of data (do not use sensitive data) Here’s the content of the zipped [...]
Contact us today to learn more about our Power BI training options
08 6210 8500
