Building an infrastructure to support real-time OLAP
Users love the flexible analytics offered by OLAP cubes but they hate to wait for the data to be loaded into a traditional data warehouse. John will describe how to build an infrastructure to support real-time loading of your OLAP cubes so your user's get exactly what they want NOW.
John will present a variety of approaches, highlight some of the pitfalls and provide tips and tricks.
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.