08 6210 8500
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 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 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 [...]
Virtual Classroom - Power BI & Excel We're 100% still open for business and set up to deliver our highly rated Power BI and Excel "in - person" training via the magic of the internet! This is great, as not only do Perth clients continue to get access to our training courses, folks around Australia [...]
By Eric Marshall Get more out of Power BI Slicers The slicer visual in Power BI is a simple, yet powerful means of selecting criteria to filter your reports. Here are two useful tips on how to get more out of this visual: Tip #1: Turn Off Single Select By default, Power BI slicers behave [...]
by Wyn Hopkins Did you know about these hidden Power BI features? It seems unfortunate that for such an awesome product there are a few user interface features that are very difficult to discover. I have trained hundreds and hundreds of users in Power BI, and I get to experience people hitting these issues over [...]
By Wyn Hopkins Adding a password box to a Power BI report Here’s a process that allows you to add a password input box to your Power BI report. DO NOT, REPEAT DO NOT use this for sensitive data. We have no idea if there are ways to hack this but it’s just an interesting [...]
By Wyn Hopkins If you find the default Icon settings confusing in both Excel and Power BI, you're not alone! In July 2019 conditional formatting Icon Sets were added to Power BI and it caused us to revisit how they work in Excel. In Excel you would highlight a range of numbers and choose Conditional [...]
Power Query is an amazing tool for cleaning and transforming your data to make it ready for analysis in Power BI or Excel. Here are 5 useful hints to help you use Power Query more effectively: Hint #1 – Use the Formula Bar The Formula Bar helps you quickly understand which step you have previously [...]
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
