Posted by
Andy Brown
on 20 January 2022
We have launched two new courses: a two-day Advanced Power BI (Reports) course for report authors, and a two-day advanced Power BI (Data) course for data modellers.
Posted by
Andy Brown
on 17 December 2021
This blog shows you various ways in which you can loop over the columns of a pandas dataframe, and also explains how to loop over the rows of a dataframe (together with why you should avoid doing this!).
Posted by
Andy Brown
on 17 December 2021
A summary of how to package up your Python program (including any referenced modules) into a single executable file.
Posted by
Andy Brown
on 24 November 2021
Ten reasons why Python is a better programmng language than C# (and most other languages), as well as two reasons why it might not be.
Posted by
Andy Brown
on 24 November 2021
To celebrate the 10th birthday of our video channel we've created this infographic, showing for example that the number of hours spent watching our videos would have covered 2,949,152 views of the first episode of Squid Game.
Posted by
Andy Brown
on 24 November 2021
This blog shows how to generate a table which includes not only all of the dates in your data model, but also a range of aggregator columns such as financial year and month name for reporting purposes.
Posted by
Andy Brown
on 24 November 2021
You can use SQLCMD mode to parameterise the connection, database name, table name and select columns for a query - and much more besides, as this blog explains.
Posted by
Andy Brown
on 18 November 2021
Tired of doing repetitive tasks at Christmas? This blog shows you how to create a Power Automate Desktop flow to send emails out to your nearest and dearest programmatically, with each email including instructions on how they should use the gifts they've been given.
Posted by
Andy Brown
on 18 November 2021
Power Automate Desktop allows you to automate any common sequence of tasks that you perform in Windows, and has the potential to change your working life. So what is it?
Posted by
Andy Brown
on 28 October 2021
To commemorate the rather dubious International Keyboard Short-Cut Day 2021 (the first Wednesday in November of each year, apparently), we offer the 10 Windows key short-cuts which will save you the most time.
Posted by
Andy Brown
on 28 October 2021
In Power BI Service you can now create personal bookmarks to retain any changes you've made to filtering for a report.
Posted by
Andy Brown
on 28 October 2021
Consumers of your reports can alter filters, but you can change an option to prevent these changes persisting for other users.
Posted by
Andy Brown
on 28 October 2021
You can add a tab for a Power BI report within a Teams channel, and also share a report from Power BI Service within Teams - this blog shows you how to do both these things!
Posted by
Andy Brown
on 08 October 2021
This blog shows how you can use Python to loop over all of the emails in a folder in Outlook, saving the attachments for each to your hard disk.
Posted by
Andy Brown
on 08 October 2021
How to solve the problem that Visual Studio Code can't find a module that you've imported.
Posted by
Andy Brown
on 29 September 2021
Some of the sites on this page will make you laugh, and some make you shake your head, but they should all entertain you for a moment or two!
Posted by
Andy Brown
on 31 August 2021
How does Python compare with other programming languages like C#, VB or SQL? This blog looks at the differences we've come across in preparing our Python courses and videos.
Posted by
Andy Brown
on 31 August 2021
The IKEA blue Frakta shopping bag is iconic, and everywhere. Here are 5 suggestions (not always totally serious) for how you can recycle your IKEA bags!
Posted by
Andy Brown
on 31 August 2021
The Stuxnet worm was one of the most sophisticated bits of software ever written. Find out exactly how the US and Israel used it to target Iranian uranium centrifuges, and see the implications this has for us all.
Posted by
Andy Brown
on 27 July 2021
You may know about What 3 Words, which allows you to pinpoint your location in the world using just 3 words. Now there's Four King Words, which does the same for the UK and Ireland using just 4 swear words.