08 6210 8500
How to Create an Advanced Filter in Excel without Macros By Simone Palmas Want to filter your Excel data efficiently without using macros? Filtering data can sometimes feel restrictive, especially when you want to search for multiple words independently of their order or the specific columns they might appear in. Access Analytic team member, Simone [...]
Mastering Dynamic Measure Formatting in Power BI | Part 4: Dynamic Formatting Based on Value Ranges 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 [...]
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 [...]
Leveraging ChatGPT for Transformative Finance Functions: A Guide for CFOs Technology is disrupting traditional business models more than ever and as such the role of the Chief Financial Officer (CFO) has evolved significantly. No longer limited to number-crunching, today’s CFOs are expected to play a strategic role in decision-making processes. Enter ChatGPT, a large language [...]
How ChatGPT’s Premium Features are Revolutionising Financial Modelling Financial modelling has long been a mainstay of the financial industry, essential for everything from risk assessment to capital allocation. Generative Artificial Intelligence (AI) technologies, like ChatGPT, are fundamentally changing financial modelling processes. At the risk of sounding like an advertisement for ChatGPT, the premium features (e.g. [...]
Wyn has been awarded MVP status by Microsoft every year since 2017 and is the author of the book “Power BI for the Excel Analyst”. He is known worldwide for sharing his knowledge via the Access Analytic YouTube channel with over 5 million views and 90,000+ subscribers.
He gained his Chartered Accountant qualification at PwC in 2000 and has extensive Business Analyst experience with HBOS and Barclays in the UK plus multinational clients in Perth.
Wyn is skilled in Excel and Power BI development, Power Query automation, management reporting and is an experienced Excel and Power Bl trainer.
Pay my invoice
