Dr John Tunnicliffe

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 and professional services organisations.

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

John's key skills are in systems integration, bringing together disparate components and getting them working in a coherent fashion.

Specialties: Design and development of business intelligence, data warehouse and reporting systems based on OLAP technologies delivered to the end-user via SharePoint.

http://sqlblogcasts.com/blogs/drjohn/ http://sqlblogcasts.com/blogs/drjohn/rss.aspx

John will introduce you to Analysis Services 2008, demonstrate browsing cubes with Excel 2007, deploying dashboards in SharePoint built using Excel Services and demonstrate how PerformancePoint Services can add the glitz to your BI project.
This session will present the tools and techniques used to create OLAP cubes and supporting data marts on-the-fly from a mere set of data files and configuration metadata.
Users love flexible analytics but 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
Processing of SSAS OLAP databases can be a tricky business, particularly when it comes to incremental processing of dimensions. John will give you real life examples of why certain approaches work and others do not.
Data warehouse designers often ignore the specific needs of an OLAP database. In this session, John will outline the best ways to optimise your relational database to support your multidimensional OLAP cubes

Blog posts RSS

Supercharge your SSDT database projects using T4 to auto-generate T-SQL code! 08 Jul 2015
There are many techniques that data warehouse developers could learn from other parts of the software industry and automated code generation is one of them. Most database developers have at some point in their careers written T-SQL code to query the SQL Server catalog views to automate the ...

Dynamic Partition Creation in SSAS multidimensional using the SSAS Partition Manager 28 May 2015
<<Updated blog entry to reflect the new release of SSAS Partition Manager>> There are plenty of blog entries out there that outline how to dynamically create partitions in SSAS multidimensional databases. However, all of them suffer the same drawback: they always hard-code some part of ...

SSAS Partition Manager for both SSAS Tabular Models and SSAS Multidimensional Cubes 26 May 2015
Today I am proud to announce the release of SSAS Partition Manager that can dynamically create partitions in both SSAS Tabular models and SSAS Multidimensional cubes using a wide variety of partitioning schemes (yearly, monthly, weekly etc.).   What is more, for OLAP cubes it correctly ...

SSAS: Automating OLAP cube deployment, dynamic partitioning and processing 18 May 2015
Imagine been able to deploy your OLAP database, dynamically partition the cube and then process the new database all in one step from an .asDatabase file with minimal configuration.  Well now you can!  Today’s release of the SSAS Partition Manager provides a set of features which allow ...

SSAS: Utility to check you have the correct data types and sizes in your cube definition 15 Mar 2012
This blog describes a tool I developed which allows you to compare the data types and data sizes found in the cube’s data source view with the data types/sizes of the corresponding dimensional attribute.  Why is this important?  Well when creating named queries in a cube’s data source ...