Adatis BI Blogs

What's New

  • Power BI and SSAS Tabular conversion

    One of the most compelling aspects of the Microsoft Power Pivot tool is the ability to take a workbook that has been developed as a quick prototype in Excel and promote it to a corporate SSAS Tabular model.  This way a business team is able to ‘self serve’ their requirements with Power Pivot and deploy to SharePoint or their Power BI Site. ...
    Posted to Calvin Fern's Blog (Weblog) by Calvin Ferns on 03-26-2014
  • Slowly-Changing Parent-Child Dimensions – Part 1: The Theory

    A common structure in OLTP systems is a parent-child relationship with Object and ObjectParent tables creating a recursive structure. This is easily represented as a Warehouse dimension table, usually flattened out but occasionally left as native Parent-Child if required. I recently encountered an issue where the client not only required a flexible...
    Posted to Simon Whiteley's Blog (Weblog) by Simon.Whiteley on 03-14-2014
  • Introduction to Slowly Changing Dimensions (SCD) Types

    When setting about writing a recent blog post, I wanted to link to a clear, concise blog post on the different SCD types for anyone not familiar with the topic. Whilst there are a variety of thorough introductions out there, I didn’t find one as clear and concise as I’d like. I therefore give you my own offering, a quick introduction to Slowly Changing...
    Posted to Simon Whiteley's Blog (Weblog) by Simon.Whiteley on 03-14-2014