Posted by
Andy Brown
on 06 November 2024
We've silently added a fair few blogs on Power BI in the last couple of months - this short blog gives a useful index to them.
Posted by
Andy Brown
on 05 November 2024
You can now create data-bound reference layers in Azure maps, document your model's measures, tables and columns using the INFO.VIEW function in DAX, format chart markers within inches of their lives and apply dynamic formatting using DAX.
Posted by
Andy Brown
on 05 November 2024
This blog gives a practical example of using the new Excel PIVOTBY function to create a dynamic pivot table (one where you can choose the row, column and data fields from drop lists).
Posted by
Andy Brown
on 05 November 2024
The new PIVOTBY function in Excel allows you to create a pivot table with a dynamic formula. Does this mean that the pivot table is redundant?
Posted by
Andy Brown
on 05 November 2024
Rachel has created two custom GPTs allowing you to get any information on our courses and services. You can use either of these as intended (to get course details, dates, venues or prices) or to give you ideas for how you could implement a similar search GPT within your own organisation.
Posted by
Andy Brown
on 05 November 2024
Google are right to worry about the safety of their current virtual monopoly on search, with breaking news on new desktop search versions of AI tools from ChatGPT and Claude.
Posted by
Andy Brown
on 05 November 2024
A website which generates a different (imaginary) human face when you refresh the page doesn't sound that creepy - but somehow it is.
Posted by
Andy Brown
on 01 November 2024
Think you're good at Power BI Desktop data manipulation? See if you can present our Excel football results as a final table (showing games played, goals scored/conceded and points won) to have a chance of winning this month's £50 prize.
Posted by
Andy Brown
on 01 November 2024
Announcing the winner of our October 2024 newsletter competition, giving the answers and showing which questions people found most and least difficult
Posted by
Andy Brown
on 01 November 2024
I regularly include trivia quizzes in our monthly Wise Owl newsletter. Last month for the first - and probably only - time, I decided to enlist the help of ChatGPT to generate the questions, suggest plausible (but wrong) answers and add relevant pictures. Here's how I did this, so that you too can do the same!
Posted by
Andy Brown
on 27 September 2024
Congratulations to Rory O'Connor of Freemans Grattan Holdings for winning last month's logic puzzle competition. Here's the answer!
Posted by
Andy Brown
on 26 September 2024
Feeling stressed? Keep one of these wildlife webcams from Namibia open as you work to put everything in perspective.
Posted by
Andy Brown
on 26 September 2024
Many thanks to all of those people who have kindly reviewed us on Google. We are pleased to say that we now have over 50 reviews!
Posted by
Andy Brown
on 26 September 2024
This month Power BI Desktop gets a new dark mode! Visual calculations and visual level format strings have also been turned on by default (although both remain in preview, strangely).
Posted by
Andy Brown
on 25 September 2024
Excel Labs is an experimental toolkit being developed as part of Microsoft Garage. This blog shows how you can use it to call AI functions, use the advanced formula editor and use an Excel-based Python editor.
Posted by
Andy Brown
on 25 September 2024
Custom GPTs are mini-versions of ChatGPT tailored towards a specific task, whether this be looking up information from your company's procedures or website, subtly skewing answers to questions to meet a particular need - or just having fun!
Posted by
Andy Brown
on 25 September 2024
We've now published our schedule of courses for the coming 15 months (up to the end of 2025 in fact) in a handy format convenient for bookmarking or printing.
Posted by
Andy Brown
on 05 September 2024
If you're a qualified pilot (but also a bit of a data nerd) how do you keep track of your flights? With a Power BI report, of course!
Posted by
Andy Brown
on 05 September 2024
Announcing the winner of last newsletter's competition (and also giving the answers in case anyone is still struggling to identifiy the 16 book titles).
Posted by
Andy Brown
on 05 September 2024
Five tribute acts played in 5 different venues on successive days of one week in September. Can you use your skills of logical deduction to work out who played which venue when, and what the capacity of each venue was? The incentive is a chance to win our monthly fifty-pound prize.