Archive | Management RSS feed for this section

The BI Trinity

Last month I presented the final chapter of my trilogy on Business Intelligence to the Southampton @SQLSoton User Group and again in Newcastle at the @SQLNE user group on Tuesday. The presentation, entitled “The BI Trinity”, follows on from Star Schema Primer and Transitioning from “Reporting” to BI Solutions. The BI Trinity presentation is composed of Modelling Reputation The data […]

Transitioning from Reporting to BI Solutions

A couple of weeks ago I had the pleasure of delivering a 2nd presentation to the Microsoft SQL Server community via the excellent SQL Relay 2013R2. The event, very well organised by Christopher Taylor (@SQLGeordie) and Michael Robson (@HeyMiky), was held at St James Park, home of  Newcastle United. What an excellent venue, for football […]

Should you bite the hand that feeds you?

Jamie Thompson is an MVP, but more to the point he is a very experienced SSIS developer and a prolific contributor to the SQL Server community. Surely this is why he was awarded an MVP by Microsoft. His recent blog post on GeoFlow (an add-in for Excel that delivers 3D visualisation and story telling) has […]

SQL Santa London

Today I had the very big privilege of delivering my Star Schema Database Primer presentation at the SQL Santa 2012 event, held today at Microsoft in London. The free event, put on by the SQLFAQ group, sold out two weeks prior to the date. A sure sign of the increasing popularity and usage of Microsoft […]

Data Scientists are GO

Was Brains of the Thunderbirds a “data scientist” as well as a genius engineer? If not, which member of the Tracey family designed the world wide data capture system for monitoring disasters & crimes and the necessary analytics system for selecting from that feed the mission for the next episode? International Rescue might have started […]

Super(hung out to)Dry

The admission in April 2012 by SuperGroup (the parent company of fashion brand SuperDry), that the entry of a ‘+’ sign instead of a ‘-’ sign on some forecasting figures, led to its 3rd ‘profit’ warning being issued in 6 months. This led to a revised annual profit shortfall of £8m. Robust business intelligence (BI) […]

ETL origins

I landed my first programming job at Mitsubishi Motors in Australia, in 1988. To my very good fortune they were transitioning from VSAM to DB2 and SQL/COBOL. As a trainee programmer I showed an early proficiency for SQL and after one year of programming I ended up in the newly formed Data Services Group as […]