
Wyn Hopkins
Microsoft MVP | Author | Speaker | Power BI & Excel Consultant & Instructor | YouTube- 100K subscribers | Helping people thrive with data
Perth, Australia
Actions
Director at Access Analytic
Wyn Hopkins
Edit profile
Microsoft MVP since 2017
Published author of the highly regarded book "Power BI for the Excel Analyst"
A leading YouTube contributor in the Power BI and Excel world with over 5 million views and 87,000 subscribers
Developing amazing Power BI and Excel solutions to clients in Australia and around the World.
Area of Expertise
Topics
Dashboards That Deliver: Power BI Design Essentials
You’ve got the data. You’ve built the report. But does it actually communicate?
After 10 years of building Power BI solutions for clients across industries, Wyn Hopkins knows what makes a dashboard land—and what makes users tune out. In this practical session, Wyn shares real-world advice on designing Power BI visuals that are clear, effective, business-ready and easy to maintain.
Expect to learn:
Why less is more (but not always)
How to guide the user’s eye with layout and interactivity
Common design traps (and how to dodge them)
Smart techniques to minimise future maintenance
Not conceptual theory—just tested techniques that improve how people see and use your reports.
45 minutes
Power Query & SharePoint: What Every Analyst Needs to Know"
SharePoint is taking over, and network drives are fading fast. But for many Excel and Power BI users, that shift brings confusion—especially when your usual “Get Data” button is no longer sufficient.
Join Wyn Hopkins—9-time Microsoft MVP and trusted Excel/Power BI trainer—as he unpacks the must-know techniques for connecting to SharePoint files the right way.
In this practical, demo-driven session, you’ll learn:
How to connect Power Query to SharePoint folders and files
The best way to migrate existing reports to new SharePoint locations
Proven tips and gotchas that save hours of frustration
Whether you’re building from scratch or adapting old reports, this is the session that clears up the confusion and sets you up for success.
45 minutes
I never knew Excel could do that!
Excel is the most flexible and easiest to use programming platform in the world. Come and join 9-times MVP Wyn Hopkins for a jam-packed whirlwind tour of what's possible!
From creating 3D Maps, to analysing 5 million records, to producing engaging interactive dashboards it can do it all.
Whether it's Dynamic Arrays, Lambdas, Data Models, Dashboards or just a few good old fashion hidden tips you're after then Wyn has you covered.
45 minute fast pace fun and engaging show and tell session
DAX Demystified: Helping Excel Pros Make the Leap
For many Excel users diving into Power BI, the biggest roadblock isn’t the formula syntax, it’s the mindset shift. DAX doesn’t follow the cell-by-cell logic we’re used to. And no function captures that better (or confuses us more) than CALCULATE.
When I first learned DAX through Rob Collie’s Power Pivot and Power BI, I made the classic mistake: treating CALCULATE like a turbocharged SUMIFS. That worked—until it didn’t. And once I understood why, everything changed.
In this session, I’ll break down how I explain the core concepts of DAX—especially to Excel pros—and why reframing your thinking is key to mastering it. If you've ever felt like DAX makes no sense, this talk is for you.
45 minute session focussed on upskilling Excel and Power BI users to change the way they approach DAX
Power BI vs Excel: Where to Start and Why It Matters
Curious about Power BI but not sure where it fits—or how it stacks up against Excel?
Join Wyn Hopkins—9-time Microsoft MVP and author of Power BI for the Excel Analyst—for a jargon-free, demo-packed introduction to Power BI. Whether you're an Excel veteran or just Power BI-curious, Wyn will break down what it is, where it shines (and where it doesn’t), and how to get started with confidence.
Expect real examples, zero fluff, and a few laughs along the way. If you've been wondering whether Power BI is worth your time, this is your chance to find out—fast.
45 mins to 1 hour - how to with demos
Workflow Magic: Power Automate, Power Query & Power BI in Action
What happens when you combine Power Automate, Power Query, and Power BI?
You stop doing repetitive tasks—and start building smart, connected workflows that work for you.
In this high-energy, interactive session, we’ll collect live feedback from the audience and analyze it in real time—showing exactly how these tools come together to turn manual processes into powerful, automated insights.
With step-by-step demos and practical takeaways, you'll leave with ideas you can apply immediately—and a fresh perspective on what modern Excel and Power Platform tools can do.
45 minute session
Excel Like a Consultant: Pro Techniques That Wow Clients
Want to see how the experts do it?
Join Wyn Hopkins—9-time Microsoft MVP and Excel consultant with 25 years of real-world experience—as he reveals some of the powerful techniques he uses to build polished, scalable Excel solutions for clients around the world.
In this fast-paced, practical session, Wyn will demo high-impact tips like:
Must-have template features
Dynamic, hyperlinked error checking
Clever filtering and navigation hacks
Whether you're building reports for your team or for paying clients, these consultant-level tricks will help you take your Excel game to the next level.
45 mins aimed at intermediate Excel audience
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top