Thanks for visiting my Blog. My name’s Richard Pearce and I’ve been working with Business Intelligence for over 20 years and absolutely love this type of work.
I read recently creating dashboards is akin to being an architect or engineer. The technical knowledge you need along with the creative aspect makes for very interesting work. Of course like many careers it can be challenging although with a good support network help is never too far away.
Hence this blog. Somewhere to store insight and technical examples I develop along the way (sometimes with a little help from my friends who I will be sure to mention)
My first encounter with dashboards was in 1994.
The National Lottery had just started and the nation was gripped with lotto fever. Back then I was 16 years old and, as a hobby, developing games and tools on the Commodore Amiga (using Amos the Creator). I had a crack at developing a ‘number picker’. Not a simple random number generator but a scientific program which stored a history of the numbers drawn so far to predict the next likely outcome.
Needless to say I never got all six numbers although I did better than most – for those interested the chance of getting three numbers (£10 win) is approx. 1 in 50 using a random number generator. My software could pick three correct numbers once in every 20 attempts…. so still loosing money.
An off-shot of the project was developing statistics on the lottery itself and the performance on my software. My first dashboard was created. Unfortunately, I don’t have the program anymore (or an Amiga), although someone out there may still have a working copy as it was distributed through Amiga Format magazine (The National Lottery – Liberty Software).
Skip forward a few years and I was working with a large media company. They had a challenge connecting two systems together to generate reports. They were using excel workbooks with pivot tables. Seeing the issue I bought a number of books and learned Visual Basic. Due to my history of software coding whilst I was younger I was already half way there and within a short amount of time I’d written the code required and the systems were linked (and I was hooked)
Over the next 15 years I worked for a number of prominent organizations (banking, manufacturing and health care). I moved away from development and into leadership roles and project management.
I then found myself as a stakeholder on a Data Warehouse project. The initial scope was to build a SQL database to aid the reporting function. As a stakeholder I asked for the scope to be expanded to include a dashboarding tool like Business Objects (as I’d had some experience using this software). subsequently the scope was changed to include procurement of a new system…..
Soon afterwards I moved roles and now on the project team became responsible for the delivery of the database including the new tool I requested.
I began speaking with the main vendors of dashboarding tools and organized meetings with them to review and compare their products. Skip forward again and I’d purchased QlikView for the organization.
The challenge now was we had a great tool although no in house experience on how to use it. Not for the first time I got the books together and began to learn.
In my previous role leading their Analyst Team I’d already worked with the end users and gathered their requirements and I was fortunate to have a green field with QlikView. Server sizing, installation, development and production were built up from scratch.
Now my focus is with Qlik development (QlikView and Qlik Sense) as a consultant and I’m enjoying working with new organizations helping them get the most out of the Qlik analytics platform.
From 2016 I joined the QlikDevGroup leadership team in London. In this role I organise regular events where developers can come for free in the evening, Eat Pizza, Drink Beer and hear all about Qlik’s latest developments and ideas from a whole host of speakers from around the world (http://qlikdevgroup.com/london-home/)
In 2017 I joined the Qlik Luminary program and was successful again in 2018 and 2019.