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 MoreMore Local Authority Data – Brexit and Party »
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 MoreLocal Authority Data »
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 MoreFeeling nostalgic about Better connected »
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 MoreTableau at Jaguar Land Rover »
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.
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 MoreHP Service Manager Metrics for HMG »
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 MoreAgile XI31 at Sun Life of Canada »
Migration and conversion of Full Client documents from Business Objects version 6.5 to both XIR2 and XI31. The main challenges in this project were the multiple platforms and environments in existence at this client, the fact that the user base was geographically distributed throughout the UK, Europe and the US, and the complexity of the migrated reports.
Oracle EBS Reporting – a challenging project that involved the design, build and implementation of a Business Objects and Oracle reporting solution that provided management information reports from an Oracle EBS R12 Financials system. There were many parts to this project which ran for approximately 12 months and included: complex universes for an OLTP schema; complex Web Intelligence reports; PL/SQL… Read MoreBusiness Objects XIR2 and Oracle EBS Financials at Cardiff University »