Adatis BI Blogs

What's New

  • Effective Handling Of Failed Lookups In SSIS

    Recently I was working on a project I noticed the many of the packages were using the below pattern to deal with failed lookups. I have seen this in many organisations, whilst this isn’t something new I wanted to write about it as it seems many people are unaware there is a better performing alternative. What I have found is that when handling failed...
    Posted to Jonathon Eve-O'Connor's Blog (Weblog) by JEOC on 02-23-2015
  • Adatis Coding Dojo – Session No.2

    The Challenge Write a program that generates all two-word anagrams of the string "documenting", in SQL Server. e.g. “Documenting” = “Document Gin”. Introduction This weeks’ challenge was….well, a challenge. In our first session everyone attempted it via paired programming, for this dojo we decided to attempt the problem with one larger group...
    Posted to Callum Green (Weblog) by callumg on 02-18-2015
  • Adatis Hackathon Jan 2015 – Predictive Analytics and Azure ML

    Back in January, Adatis hosted an internal hackathon in order to explore the various features of the Azure platform. We were split into three teams: STEAM (using stream analytics) , DREAM (using Azure ML) and GLEAM (using PowerBI). I was looking after the DREAM Team, which was responsible for providing a prediction on when a thermostat system would...
    Posted to Ust Oldfield's Blog (Weblog) by Ust Oldfield on 02-11-2015
  • Adatis Hackathon Jan 2015 – Streaming Analytics First Thoughts

    There have been a huge number of additions to the Azure platform over recent months, with a few exciting features for those of us in the BI world. At the second Adatis Hackathon we decided to delve into these features to see what we could create. The plan was ambitious to say the least – three teams would each take a different new feature and attempt...
    Posted to Simon Whiteley's Blog (Weblog) by Simon.Whiteley on 02-10-2015
  • Core and Custom Dimensions and Facts

    An interesting challenge in data warehousing is how to cope with a dimension that is heterogeneous in nature, e.g. a product dimension that only has a handful of attributes for one particular product type, but then may have many more attributes for a different product type. One way to deal with this problem is to create ‘Core and Custom’ dimensions...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 02-05-2015