Author Archives: scottbw

Weekly Update May 12-19

So, what have I been up to lately? Working again on agile business intelligence with both of my Jisc Analytics Labs teams; I went to a meeting in London for the team focussed on postgraduate courses, and worked remotely for the team working … Continue reading

Posted in Uncategorized | Leave a comment

Weekly Update May 8-12

Weekly update time! So what have I been up to? Actually its been a pretty quiet week. Working on agile business intelligence with one of my Jisc Analytics Labs teams, getting them up to speed with data reshaping in Alteryx … Continue reading

Posted in Uncategorized | 1 Comment

Weekly Update May 1-5

Another week goes by … this week I’ve been Working with my Analytics Labs teams once more. I stood in as Scrum Master for my PGT analysis team, took charge of the Trello board, and helped out with various Tableau-related … Continue reading

Posted in Uncategorized | Leave a comment

Weekly Update Apr 24-28

I’m going to try to blog some weekly updates, inspired by Doug. Lets see how it goes, eh? This week I’ve been: Working with a team of HEI data analysts looking into Taught Postgraduate courses as part of Analytics Labs, a … Continue reading

Posted in Uncategorized | 1 Comment

Busy busy busy!

OK, I admit it, I’ve been ignoring this blog for way too long! But that doesn’t mean nothing has been happening – quite the opposite. About a year ago I became one of the founding partners of Cetis LLP, and since … Continue reading

Posted in Uncategorized | Leave a comment

How are things going with HtmlCleaner?

HtmlCleaner is the FOSS project I’ve been maintaining since 2013. So, how is it going so far? Downloads and users I can get download stats from Sourceforge, which hosts the binaries, but perhaps a better perspective is the number of times the project … Continue reading

Posted in development, open source | Tagged | Leave a comment

Creating a simple SQL query editor

I recently needed to add a simple visual interface for building SQL queries based on existing schema models – you know the sort of thing, a bit like the UI you get in Access, but running in the browser. I really, … Continue reading

Posted in development, open source | Leave a comment

Going old skool with SQL: from Access to PostgreSQL

Well, after several years where I mostly worked on Redis, MongoDB and client-side browser storage, I’m currently working on a project that is most definitely old-skool SQL. So I spent much of today writing code to handle importing Access databases into PostgreSQL … Continue reading

Posted in development | Leave a comment

HtmlCleaner 2.10 released

Get it here!

Posted in Uncategorized | Leave a comment

Tracking student blogs using Google Spreadsheets and WordPress

I’m currently teaching a first year module on Open Source Software, one of the requirements for which is students write their findings up as blog posts. For that reason I thought it might be useful to be able to keep … Continue reading

Posted in mashups | 1 Comment