Alex is the owner and principle consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the UK with multinational clients in a variety of sectors. He specialises in all aspects of dimensional data modelling, data warehousing, ETL and cubes using the SQL Server stack.

Alex has an MSc in Business Intelligence, is a chartered engineer, and a member of Mensa. Community leadership includes being on the SQL Bits committee, Director of SQL Relay, founder and leader of the Birmingham Data Platform user group.

Alex is also a regular speaker at many SQL Server events around the world including SQL Relay, SQL Bits, SQL Saturdays, 24 HOP and the PASS Summit.

Sessions

This session will show how to use DMVs (data management views) to query the OLAP cube structure, and then use SSRS to create a set of interactive reports including the BUS matrix, and using spatial data to generate automated star schemas.
How to get started with PowerPivot and QlikView. Covering how to combine data sources, common pitfalls, adding some calculation logic and building a basic dashboard. We’ll walk through the same example on both systems and compare the results.
This session looks at some of the different methods available to load slowly changing dimension data into a data warehouse, and compares the relative performance given different data scenarios and traditional storage compared with FusionIO
In this session we’ll look at a number of different data scenarios and explore ways of remodelling the data to optimise it for cubes and MDX. Sometimes a small ETL change can have a dramatic impact on the cube's functionality and simplicity.
In this session we'll look at the structure and basics of MDX, the Multi Dimensional query eXpression language for querying Analysis Services OLAP cubes. We'll start at the beginning, so no previous experience necessary.
Using PowerQuery, PowerPivot, PowerView and DAX to model, analyse and win a Fantasy Formula 1 league. Guarantee yourself eternal glory as a braniac petrol head, and become a PowerBI and DAX pro in the process.
What are the pros, cons and gotchas of being a permy vs contractor or freelance consultant? We’ll look at what you need to think about from a logistics, financial planning, tax, marketing, career and skills development perspective.
Learn how to build an Azure Machine Learning model, how to use, integrate and consume the model within other applications, and learn the basic principles and statistics concepts available in the different ML algorithms.
Alex_Whittles1230923.jpg