Building cubes from ODS or Operational Systems

A step-by-step demo on BIDS of how to build an SSAS cube (DB) from an operational system (normalized database) such as Operational Data Store (ODS) or directly from the transactional business system, without building a star/snowflake schema Data Warehouse/Mart first.

A demo on BIDS of how to build an SSAS cube (DB) from an operational system (normalized database) such as Operational Data Store (ODS) or directly from the transactional business system, without building a star schema Data Warehouse first.Targeted specifically at SSAS developers (those who have developed cubes on top of star/snowflake schema data mart/warehouse). DW architects would also be able to benefit/take away the idea as a new concept.

Speaker

Vincent is a data architect and data scientist specilising in banking and investment. He wrote a book on SQL Server data warehousing & BI, and many articles on www.datawarehouse.org.uk. He works on big data and machine learning.

Vincent Rainardi's Sessions

Credit card fraud detection using Azure Machine Learning

Advanced Dimensional Modelling

Data Warehouse Data Modelling

Building cubes from ODS or Operational Systems