WE LOVE TO SHARE
So here are our latest blogs sharing what we have learnt lately, we hope it will make your life easier.
MongoDB Graphic Interface Apps: Honest Review
I found it misleading that there are so many graphic interface tools to query and update the data in MongoDB. The hardest bit is to find an honest opinion if it's any good to use. I had to try as many of them as I could find, and below is what I think about them. Note...
Advanced Data Vault Course
Recently I went to the Advanced Data Vault Modeling course run by Hans Hultgren to take my knowledge to the next level. It was held in Melbourne, and this was my first time in Australia as well. It was hilarious to find out that the most attendees were from New...
News and trends in BI and DW – April 2019
Kia ora koutou, This month we have a spotlight on Open Source, our team are passionate about open - Open Data, Open Standards and Open Source. I first worked on an Open Source Linux kernel back in 1989 (showing my age) so have enjoyed watching this space mature and...
A BEAMing success – A 3-day course in Agile Data Warehouse Design
Recently I had the opportunity to attend a three-day Business Event Analysis and Modelling (BEAM*) course run by Lawrence Corr. I really enjoyed the course, Lawrence is an engaging presenter and there are numerous interactive exercises to keep you engaged...
Apache Superset on Linux
Another one of the open source projects I readily follow is Apache Superset. Superset is part of innovative ecosystem surrounding PrestoDB. So to start with, let's cover off what Superset is and why it's so darn awesome... Superset (previously known as Panoramix and...
Reporting Jira data in Power BI
After having an opportunity to use Power BI at a client site, I thought it would be interesting to have a go at trying to create a Power BI report using Jira data. To access this data dynamically I chose to use the Jira REST Application Programme Interface (API)...
Getting Started with OrientDB: Full NoSQL Experience
Have you heard about the full stack web developers? Unlike those developers who are specialised in front-end or back-end, a full stack developer can do all of that alone. My area is databases. I'm quite confident in calling myself a relational databases specialist....
Visualising Volume
Introduction Over the last few months I have been part of a project to help streamline the process of visualising data. The infographic above is part of the output of this project. As I was working through the projects new development cycle, the lack of distractions...
Change Data Capture (CDC)
On a daily basis I have the benefit of working with organisations who are somewhere on a journey with data. Working with big or small, flush or practically bust, petabytes or megabytes, organisations see some innovative solutions deployed. One thing I often see...
Dropbox to SharePoint Migration
We have recently completed a move from Dropbox to SharePoint and given it was such a interesting process I'd thought I'd share some lessons learned. We had been using Dropbox for several years but decided to move onto SharePoint. What we started with was approximately...