08 6210 8500
by Wyn Hopkins Excel Hash 2021 A bit of fun to be had and a challenge set by fellow Excel MVP Oz du Soleil. Finding a solution to the spare seat assigner. Our solution incorporates the following items: 1. Cutout person 2. Pick at least 2 from the following list: LET, LAMBDA, Dynamic Arrays, Power [...]
by Wyn Hopkins Granting access to reports Adding a Power BI report to Teams is straight forward, but granting access can be a challenge. For more on this topic check out our blog article Securely sharing Power BI in Teams
by Wyn Hopkins Brief guide for Power BI users A brief guide for users of Power BI reports. This is a brief guide for users of Power BI reports and not a guide on how to build Power BI reports. This is aimed to help users of Power BI dashboards and reports to understand how [...]
by Eric Marshall Assigning Data Types Assigning data types is an essential step when working with Power Query in Excel or Transform Data in Power BI Desktop. Here are some useful tips on how to change data types while maximising the efficiency of your models: Tip #1: Don’t Change Types Until the End of a [...]
by Wyn Hopkins How to handle teams when you have multiple different logins Often people are required to be part of "Teams" in organisations other than their own. The desktop app is OK at allowing you to switch between different organisations if you have the same email address for all teams. The trouble starts when [...]
Tricking Non-Dynamic Array Formulas into Spilling by Jeff Robson Tricking non-dynamic array formulas into spilling isn't something you'd naturally think of doing. Dynamic Arrays are great but sometimes the formulas that refer to them behave in unexpected ways, and sometimes these don't spill ... without any obvious reason. For example, the DATE function spills, [...]
by Wyn Hopkins Create Power BI themes using the Adobe colour wheel You can create your own Power BI Themes but knowing what colours to use is a challenge. Adobe colour wheel can help. Want to learn more? Jump on to one of our courses We've trained over 1,000 people from all types of [...]
by Wyn Hopkins Boost your productivity with these shortcuts With over 20 years' experience in Excel we've picked up a few tips and tricks. We'll show you the shortcuts, features and formulas that will speed up your daily use of Excel. From SWITCH to Dependent Drop downs, Grouping to Conditional Formatting, clever validation lists and [...]
by Wyn Hopkins Power BI - Prepare for the new Ribbon Per the 2020 Power BI planned release notes the new ribbon, that has been in preview for several months, will be switched on by April 2020 for everyone. Check out the update from Microsoft here. You can turn it on now by going to [...]
by Wyn Hopkins How to use Power Query to connect to a file on OneDrive or SharePoint A growing number of organisations are starting to store their files on OneDrive for Business and SharePoint. Users will begin to discover that connecting to these files with Power Query is not as straight forward as clicking the button for [...]
by Wyn Hopkins Securely sharing Power BI in Teams Embedding a Power BI report inside your Teams channel is a great way of sharing reports and discussing them during meetings. Adding a Report to Teams To add a report, just click the + sign at the top of your Teams Channel window and then [...]
By Eric Marshall Hard coded data sources in Power BI Simple, hard-coded data tables can be useful data sources in Power BI (provided your data won’t change!). Here’s how to incorporate hard-coded data into your data model: Under the Home ribbon of Power BI Desktop, click “Enter Data”. Double click on “Column1” and rename [...]
Reach out to the Access Analytic team Monday to Friday on (08) 6210 8500 or submit your contact information and we will be in touch.
Get Ahead of the Game – Book Your Training Now!
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
