Session ID: 10212

Abstract: You have implemented a data warehouse and created dashboards, but is that good enough? Were you able to capture all the data that your business wants? No – in today’s modern world data is everywhere and it is not possible or meaningful to capture all that data into a data warehouse. So let your power users bring custom data and let them mash-up with the curated data in the data warehouse. In this session you will learn how to extend an existing fact/dimension add new fact/dimension and understand the system behavior.

Objective 1: Learn data mash-up techniques between custom data and curated data sets

Objective 2: Lean how to extend a fact and dimension and notice how BI system behaves in each scenario

Objective 3: Add a new custom dimension or a custom fact and examine SQLs generated by BI server to understand technical concepts

Audience: Developer