Posted by
Sam Lowrie
on 09 September 2024
When using more complex measures there may be a need for each to be formatted differently. This blog shows you how to use the dynamic formatting measure feature.
Posted by
Sam Lowrie
on 04 April 2024
Despite the new flow designer in Power Automate going live several months ago, there are still “features” (read bugs) that can cause confusion. This blog covers 5 of these quirks, showing a way to deal with each.
Posted by
Sam Lowrie
on 21 July 2023
This blog lists 5 reasons why you might like to consider using Google Sheets (perhaps as an alternative to Excel?).
Posted by
Sam Lowrie
on 30 January 2023
How to use Radacad's clean-up tool to see which of the columns and tables in your Power BI data model you're not using.
Posted by
Sam Lowrie
on 19 July 2021
Sometimes our Owls come across little titbits that aren't big enough to count as a full meal. Instead we bide our time and create a smorgasbord of little bites for you to feast on. With that in mind, here are 5 Power BI tips that you might not know.
Posted by
Sam Lowrie
on 01 July 2021
There are many great resources for learning Power BI, and so many of them are completely free! Level up your BI skills with some of the best.
Here Sam covers some of his favourite BI channels. You even get a glimpse behind the curtain to see other channels he watches!
Posted by
Sam Lowrie
on 30 June 2021
Some of our poor delegates don't have the luxury of a home computer to install SQL on (even worse some have made bad life choices and picked a Mac). The good news is that you can still practise your SQL skills in your web browser, using the impressive SQL Fiddle site. Have no fear, SQL Fiddle is here, a browser based sandbox to bring you cheer!
Posted by
Sam Lowrie
on 28 April 2021
Normally when SQL Server Management Studio underlines words with what Microsoft call "red squigglies" it's because you haven't refreshed your local cache, but it could also be because of a recent bug - here's how to get round this!
Posted by
Sam Lowrie
on 20 April 2021
Following the April 2021 update to Power BI (perhaps coincidentally) we started getting this message appearing on our computers, blocking us from running Power BI. Here is how to solve this!
Posted by
Sam Lowrie
on 30 October 2020
This blog show two ways in which you can create custom themes in Power BI without needing to learn how to write JSON: either use the built-in theme editor in Power BI, or use the theme generator from Power BI Tiips.
Posted by
Sam Lowrie
on 30 October 2020
Most people attending our online training courses use Windows computers, but the odd Mac user slips through! This blog explains how you can connect to Remote Desktop on a Mac, and so still enjoy your Wise Owl online training.
Posted by
Sam Lowrie
on 15 November 2023
Sam has a terrible sense of humour which is all too often inflicted on his delegates. Sadly, with this blog, on website viewers too ...
Posted by
Sam Lowrie
on 26 June 2020
Did you know that you can create Microsoft Team meetings using VBA in Outlook? This blog shows you how!
Posted by
Sam Lowrie
on 26 June 2020
Sam was tired of getting told off for crinkled or missing expense receipts. So he had a look at Power Apps and this is what he found…
Posted by
Sam Lowrie
on 19 June 2020
This blog answers some of the frequently asked questions about how our online training works (such as what software and hardware you'll need, and what freebies are included!).
Posted by
Sam Lowrie
on 19 June 2020
Not sure what you need for our online courses? Here's our definitive guide to setting up your computer sofware and hardware to ensure that everything works smoothly.
Posted by
Sam Lowrie
on 25 November 2019
We're proud to announce that YouTube have given us their coveted silver award, in recognition of the fact that our video channel has over 100,000 subscribers.
Posted by
Sam Lowrie
on 08 November 2019
This blogs shows a clever way in which you can use a slicer to choose which values to compare in a measure.
Posted by
Sam Lowrie
on 28 October 2019
The RANKX function does what the name implies - it ranks values based on a calculation. However, the VALUE argument often causes confusion; this blog explains what it does!
Posted by
Sam Lowrie
on 15 May 2019
This blog shows how to create custom date periods within a date table for 28 day cycles, but the principles shown could be applied to create any custom date periods.