Posted by
Andy Brown
on 27 April 2021
ZoomIt allows you to use keystrokes to zoom in and out in any Windows program, and allows you to draw or write on screen.
Posted by
Andy Brown
on 27 April 2021
What happens when you want an aquarium AND a laptop, but are short of space? Sadly, the answer is that you get a computer in a fish tank.
Posted by
Andy Brown
on 27 April 2021
Is this the next thing in laptops? Meet a laptop which you can break down into its component parts, each of which you can easily replace.
Posted by
Andy Brown
on 24 March 2021
A life-changing (or at least job-changing) new software update from Microsoft - you can now see a visual view of data flows in Power BI (at least in the online version, anyway).
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!