by Alison Rowe | Apr 11, 2019 | Business Intelligence, Microsoft |
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)...
by Ben Lee | Mar 25, 2019 | Amazon Web Services, Microsoft |
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...
by Kate Loguteva | Jan 24, 2019 | Business Intelligence, Microsoft |
It’s typical in Business Intelligence that users are not getting data from the Data Warehouse database directly. Although the table structure should speak to them, one should be careful when querying Slowly changing dimension type 2 tables to get only point in...
by Bronwyn Scott | Dec 17, 2018 | Community, General, Microsoft, Optimal Company |
Hello and happy how-is-it-December-already?! What a year 2018 has been. We hope yours has been exciting, full of opportunity and you’re looking forward to a well deserved break very soon. This newsletter is the last for the year, so taking the opportunity to...
by Kate Loguteva | Dec 13, 2018 | Data Integration, Microsoft |
It is not uncommon for data warehousing to get the data from any possible source the organisation has. ETL developers like myself are enabling data collection from different database types, files and APIs. Recently I had to deal with something I haven’t came...
by Ben Lee | Sep 20, 2018 | Business Intelligence, Microsoft |
When you work with databases all day every day it’s easy to forget that many people new to the technology development space will not have used a relational database. Once I get over the moment of surprise, I think about the question if I wanted to learn now,...
