Posted by
Andy Brown
on 24 March 2021
Last month I blogged on a folding laptop with 7 screens; this week it's a five-inch fully-formed mini-computer.
Posted by
Andy Brown
on 22 March 2021
If you're using SQL Server with compatibility level 130 or greater you can now use the new String_Split function to divide a comma-delimited string into a table of values.
Posted by
Andy Brown
on 22 March 2021
How can you highlight the row in a table corresponding to the slicer value you've chosen? With a disconnected slicer and a clever measure!
Posted by
Andy Brown
on 01 March 2021
Not sure what to buy your loved ones for their birthday? How about a laptop which weighs 12 kilos and includes 7 screens?
Posted by
Andy Brown
on 26 February 2021
You know what an online course looks like as a delegate, but what happens at the Wise Owl end? We thought we'd shed some light on what goes on from a trainer's point of view.
Posted by
Andy Brown
on 23 February 2021
Details of an impressive new Excel word search system which allows you to recreate a randomised grid every time you recalculate your formulae!
Posted by
Andy Brown
on 22 February 2021
Be careful of referencing measures in calculations when you have duplicate rows in a table! This blog explains why you might want to hang on to that unused primary key column.
Posted by
Andy Brown
on 02 February 2021
Did you know that you can apply Snapchat filters to your Teams background? Or show a test card? Or send customised stickers? Read this blog to find out more ...
Posted by
Andy Brown
on 02 February 2021
My aim in this blog is to show how you can go about building any computer system from scratch (and not just a word search in Excel VBA). Along the way I've included lots of hints and tips!
Posted by
Andy Brown
on 01 February 2021
Follow this blog to construct your own word search, complete with a missing phrase spelt out by the unused letters!
Posted by
Andy Brown
on 22 January 2021
How can you show each aggregate value in a group as a percentage of the highest aggregate value? This blog shows two ways to use DAX measures to solve this deceptively difficult problem.
Posted by
Andy Brown
on 14 January 2021
Did you know that you can write an EVALUATE DAX query in software like DAX Studio and then run it from within Power BI to create a new table? You do now!
Posted by
Andy Brown
on 23 December 2020
Puzzled as to why there are two near-identical versions of Power BI Desktop? Wondering if web portal is anything like Power BI report server? Confused as to what a paginated report is? This blog answers all these questions, and more!
Posted by
Andy Brown
on 21 December 2020
You can now create and use anonymous functions in Excel (usually called "Lambda functions"). Learn how to add to the stock of Excel functions without having to learn any programming code!
Posted by
Andy Brown
on 02 December 2020
Thanks to Simon Ranson for contributing this bit of trivia: what to type into your browser's address bar to turn it into a text editor.
Posted by
Andy Brown
on 02 December 2020
Inspired by a question from a course, in this blog Andy Brown builds up a measure to show cumulative totals for a calendar matrix, dotting his DAX i's and crossing his t's!
Posted by
Andy Brown
on 27 November 2020
This awesome game shows what's possible using bookmarks in Power BI (think of it as the sequel to Sam's 2019 Pin the Tail on Rudolf game).
Posted by
Andy Brown
on 26 November 2020
There's an uncanny correlation between the Mr Men series and the list of American presidents. Donald Trump comes in as Mr Rude, Barack Obama as Mr Cool … see how many correlations you can find!
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.