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 [...]
Jeff's Kokoda Experience | A Journey of Determination In the heart of Papua New Guinea, where the rugged terrain of the Kokoda Track challenges even the most seasoned adventurers, Jeff, Access Analytics Founding Director, embarked on a journey that would test not only his physical limits but also his commitment to a cause close to [...]
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. [...]
by Wyn Hopkins Exciting News: Unlock the Power of AI with our GPTs – Now Available for Free! An exciting announcement from Open AI recently, GPTs (Generative Pre-trained Transformers) are now available for free in the store! These GPTs are simply predefined prompts refined through trial and error to help you achieve more with ease. [...]
The Integral Role of Data Analytics and Power BI in Modern Strategic Planning In today's hyper-competitive business landscape, gut instincts and traditional methods are giving way to data-driven insights. Data analytics now serve as the backbone of strategic planning, providing companies with the hindsight, insights and foresight they require to make well-informed decisions. As the [...]
Navigating the New Normal: Why CFOs are embracing Data Analytics and Power BI The role of the Chief Financial Officer (CFO) has never been more complex or challenging. Driven by many interrelated factors such as rapid technology change, changing consumer expectations and regulatory shifts, Perth CFOs are turning to data analytics to help them navigate [...]
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 [...]
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
