Using API Gateway Private Endpoints: Cost and Considerations

Using API Gateway Private Endpoints: Cost and Considerations

Square pegs in round holes (or how Sparx EA handles database structures)

Square pegs in round holes (or how Sparx EA handles database structures)

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...

Database Testing Automation

It is hard to overstate the importance of the database testing, erroneous data costs a lot for a business. Yet, when you say testing, developers' noses crinkle as they think it's hard and boring. I have worked on a multiple data warehouse development projects, and I...

Privacy, why should you care???

Privacy, why should you care???

I had the privilege to listen to the Assistant Commissioner of Privacy, Jon Duffy during National Privacy Week. Jon started at the beginning by exploring what defines privacy simply put as, something that identifies a person. He then took us through a highlights real...

MongoDB Graphic Interface Apps: Honest Review

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

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...

Reporting Jira data in Power BI

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)...