Alex is a Data Platform MVP, and is the owner and principle consultant at Purple Frog, a Microsoft Data Analytics consultancy in the UK with multinational clients in a variety of sectors. He specialises in all aspects of data warehousing, ETL, cubes, Machine Learning and Power BI using the Microsoft stack.
Alex is also the creator of Power BI Sentinel, a governance and disaster recovery tool for Power BI.
Alex has an MSc in Business Intelligence, is a chartered engineer, is on the organising committee for SQLBits, and leader of the Birmingham Data Platform Group. Alex is also a regular speaker at many Data events around the world including SQL Bits, Data Relay, Data Saturdays, Data Grillen, 24 HOP and the PASS Summit.
In his spare time he's also a qualified pilot.
Sessions
Previous 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.
Machine Learning is a popular buzzword, but what does it actually look like, and how can we use it? This session will show a number of high level examples of using ML to do some useful and fun stuff, including training a model to play a game
In this session we’ll look at what ML tools are available in the Power BI and Azure worlds, and how you go about using these in your Power BI reports
In this session we’ll look at what ML tools are available in the Power BI and Azure worlds, and how you go about using these in your Power BI reports
Level up your Power BI capability by using calculation groups to simplify time intelligence (WTD, MTD, etc) and more
Take Power BI to the next level to support BIG data, as well as layering logic over the top of an existing cube or dataset for unlimited flexibility.