Our Blogs

WE LOVE TO SHARE

So here are our latest blogs sharing what we have learnt lately, we hope it will make your life easier.
How to Model a Reporting Layer

How to Model a Reporting Layer

On my first BI job, where I was an ETL developer, my team was using Microsoft SQL Server Reporting Service (SSRS) as a reporting tool. My job was to model the Data Marts and create the data flows into those tables. Our report analysts were good at SQL, I have even...

Checking the File Path from Database in PowerShell

Checking the File Path from Database in PowerShell

On one of my recent projects I was analysing my customer's data for migration. Their legacy application could handle documents. They were stored on the organisation's shared folder, and the file path was recorded in the database with the rest of data. As a part of the...

Electric Garden: My First IoT Device

Electric Garden: My First IoT Device

Probably you know that our boss Victoria supports many digital initiatives across New Zealand. One day she has shared with us one of the latest Digital Future Aotearoa initiative called Electric Garden. This is an Internet of Things solution for garden monitoring...

Why is Snowflake special?

Why is Snowflake special?

The first I came across Snowflake was a few years ago when I was learning how to use Attunity Replicate, that time I established a data load into this cloud data warehouse. This time I have decided to explore what Snowflake is about. Terminology I watched some...

Making Sense of Google Analytics Data

Making Sense of Google Analytics Data

Here at OptimalBI we love data, and we get upset when it's only piled and doesn't produce value. Like many others who have a website, we use Google Analytics to collect its statistics. This is valuable marketing data, so we want to make use of it and help our...