Olive IT – Business Intelligence | Analytics

All Change in Local Elections May 2019

Huw Williams
May 21, 2019May 23, 2019

With the main parties expected to suffer heavy defeats in the imminent European elections, we took a look at the recent local council elections in England to see where the Conservatives and Labour had lost and to whom. The map shows Lib Dems making good gains but in more areas the political power switched from one party to no overall… Read More »

UK Trade Deals Post Brexit – Who You Gonna Call?

Huw Williams
April 5, 2019April 6, 2019

Here’s a bit of Friday fun playing around with Tableau. The map shows the UK’s top 20 trading partners currently, and the size of goods imports and exports we trade with each country. So who are currently our biggest trading partners the trade secretary should be calling up? Well, apart from the USA and China we definitely need to be… Read More »

More Local Authority Data – Brexit and Party

Huw Williams
March 7, 2019March 8, 2019

Following on from my previous post Local Authority Data, I thought I’d highlight some of the other great data sources that are available at the local authority level. You can’t escape Brexit in the UK at the moment, and apologies if you have just had enough, but if not, did you know that all the EU Referendum 2016 results are… Read More »

Local Authority Data

Huw Williams
February 25, 2019March 6, 2019

Reading Helen’s recent blog Feeling nostalgic about better connected got me thinking about what local authority data is now available and how such data might be visualised using tools like Tableau that weren’t available 20 years ago. It turns out data availability for all areas of government is much improved. The Office for National Statistics is a treasure trove of… Read More »

Feeling nostalgic about Better connected

Helen Williams
February 14, 2019March 6, 2019

This is the first year in almost 20 years that I haven’t been reviewing local authority websites for Socitm’s Better connected, and it’s turned my thoughts to how I got involved in the first place. Colleagues with my experience now call themselves UX Architects, but back in the 90s there was no such term; only three quarters of local authorities… Read More »

Tableau at Jaguar Land Rover

Huw Williams
August 8, 2018March 6, 2019

Tableau Server migration of on-premises Tableau cluster to Google Virtual Private Cloud. Design of high performance ‘Self-Serve’ architecture in Google VPC. Migration of 200 projects and 4000 users to the new platform. Tableau Server Cluster implementation serving 6000 users located across the world; design and implementation of the complete service including the Tableau Server security model, self-serve fair usage policy,… Read More »

Data Mapping and Dimensional Modelling for HMG

Huw Williams
May 31, 2014February 4, 2019

Data mapping and dimensional model design for an OBIEE MI solution to provide reports on the main functional areas of HP Service Manger. OBIEE Dashboards for Service Manager reporting.

BI Report Building for HMG

Huw Williams
November 29, 2013February 1, 2019

Dashboard and report building service using Hyperion Interactive Reporting and Oracle PL/SQL. All the usual BI tools were utilised including PL/SQL packages, table functions, views, synonyms and JavaScript scripting. Automation of several key reports resulting in significant time savings for the customer as well as supply of general Business Intelligence best practice advice.

HP Service Manager Metrics for HMG

Huw Williams
January 1, 2012February 1, 2019

Oracle MI development for a HP Service Manager and Asset Manager enterprise-wide implementation project. Oracle and Hyperion used to deliver business critical MI reports for multiple business units. The build, test and implementation of PL/SQL packages using table functions to build ‘on-the-fly’ history and snapshot tables with complex runtime transformation logic. The creation of views and synonyms. The build and… Read More »

Agile XI31 at Sun Life of Canada

Huw Williams
January 6, 2011February 1, 2019

Business Objects development using Agile methodology. We delivered a working MI system in 6 weeks that provided key metrics about pension product sales activity and performance. Activities included: The design, development, implementation and support of the entire Business Objects Enterprise component including server build, presentation database design (Kimball methodology), security model, universes, reports and dashboards. Extensive use of all Business… Read More »