Building a dynamic OLAP environment

You will have heard of (and hopefully used) dynamic SQL; but dynamic OLAP? 

Often end-users demand that extra attributes are added to the cube to meet their own specific analysis needs.  This is particularly true when you are selling market data where each client demands their own cube with their own set of attributes.  Building several hundred OLAP databases per day, each with its own unique set of data and attributes becomes a tall order unless the process is automated. 

This session will present the tools and techniques used to create fully functional OLAP data marts on-the-fly from a mere set of data files and configuration metadata.

  • Downloads
  • SpeakerBIO

    John is a well-respected designer and architect of business intelligence solutions who likes nothing more than getting his hands dirty with real life coding problems.  John is an independent consultant with extensive experience of implementing Business Intelligence solutions on the Microsoft platform across a wide range of industries including financial services, retail and professional services organisations.

    John designs and builds solutions based on Microsoft SQL Server / SSAS / SSRS / SSIS delivered to the end-user through Power BI dashboards.

    Pulling on his systems integration skills whereby disparate components are brought together in a coherent fashion, John has become an expert in applying continuous integration techniques to data warehouse projects, thereby ensuring code is automatically built, deployed and tested as changes are made by the development team. John is also a regular speaker at the SQLBits conference and SQL Saturday events.
  • Video