A simple way to use Power Automate to enable importation of a Summary Excel Workbook into 3rd party reporting tools.

This post outlines how to add a Service Principal connection for Dataverse to a Managed Power Automate Solution.

An overview of the Visualisations available within Power BI to help present your data.

This blog is an introduction to Microsoft Power BI and the first in a series on how your organisation can use it to explore the data to make business decisions.

A blog on why Data Literacy is so important for companies in the modern data driven world of commerce and steps to improve data literacy within your organisation.

I have started my career in Business Intelligence with SSIS. We had a reasonably small data warehouse, and my job was to maintain the existing SSIS packages and create new ones. Most of what I was doing was same again, so I could copy and paste many elements from one package into another...

Over my years of web design, I have used many different tools from pure HTML, CSS and JS to WordPress and even Square Space. When I started looking into Webflow I was a bit apprehensive about another no code web-based designer. After I got started playing around with the designer, I was sold...

So a little while ago I showed some examples of using Power Automate and Excel files. One of the major caveats of using the Excel files was that there needed to be a defined data table in the Worksheet of interest. This blog post will show you a way to get around that limitation…

An overview of the Low Code - No Code platforms and the benefits that they can bring to your business.

If you have a look around our website, you made notice a few slight changes to our site this is because we have finally made the change from WordPress to Webflow. Why we did this is for a few reasons one of the top reasons being speed...

It was the day when I finally fell in love with Postgres. I got a challenging task to generate data that haven’t existed for reporting. It turned out that it’s very easy to achieve in Postgres…

It has been a very weird few years now and a lot has changed. Lockdowns and borders being closed thanks to Covid has changed our little group of islands from an international tourist destination to a place for the locals to wander around...

Power Automate is an online tool designed to make your life easier and more productive. This article will show you how to do this with Excel in a way to get rid of the good old manual copy and paste that is a bane of many peoples existence.

One of my customers has a very elegant multi-tenanted application with the flexible schema achieved by the extensive use of JSON. While base tables are the same, JSON allow a lot of customisation. Unfortunately, the tradeoff of this is a lot of manipulation...

Data suggests you should get the COVID-19 vaccine Data for this New Zealand focused blog was collected from various worldwide sources between the 18th and 31st August 2021. A list of sources can be found at the end. NZ is currently vaccinating solely with the...

photo by kolibri5 Some RDBMS support SQL statement MERGE, which also referred as upsert. This is a very common task in data warehousing: we compare the source dataset with what has been recorded in DW, insert new values and update those which have changed since the...

I have done a bit of web scraping lately both to automate some of the tasks I do regularly and some to get data for projects. I have learned one big thing from doing this it is ok to do something for a one off ... sometimes. There are times when working on scripts...

I have been using python for a while now and have used it for a number of different projects, but this one surprised me. Word clouds are something I have not used before. Then, I had the idea of using it for a project a while ago and struggled with finding a way to...