by Alison Rowe | Nov 5, 2019 | Business Intelligence, Microsoft |
Are you new to Power BI? If the answer is yes, where do you start to learn how to use it? There is a lot of useful information on the Internet, but how do you know if it is any good? Look no further, I have compiled a list of useful resources that I have used over the...
by Nick Borrell | Jul 18, 2019 | Microsoft, Open Source |
When is paranoia a good thing?When it comes to downloading files for sure. Using a cryptographic hash function to test the authenticity of a file is a good practice. Such a good practice, that I wanted to make it as easy as possible to perform.I’ve written two...
by Nic Cox | May 23, 2019 | Data Integration, Microsoft |
I am currently working on a project that has chosen to use Varigence BimlFlex as the preferred tool to create and manage the data warehouse. BimlFlex is a data warehouse framework that allows you to model and build an end to end data warehouse solution using a...
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...