Belfast SQL Server User Group

Welcome to the Belfast Chapter

Next Meeting

Thursday,

August

20

Data Warehouse modelling for data analysis, cubes and mdx

  • In-Person @ Adelaide Exchange Belfast, Antrim, United Kingdom (map)
  • 18:00 - 20:30 GMT Daylight Time
  • Language: English

The presentation will cover the following. 

6:00 - 6:15: Registration & Intro
6:15 - 7:15: Beginners Guide to MDX
7:15 - 7:30: Break and Refreshments
7:30 - 8:30: Data Warehouse modelling for data analysis and cubes.

Sign up https://www.eventbrite.co.uk/e/belfast-sql-server-usergroup-tickets-17831086259

Featured Presentation:

Data Warehouse modelling for data analysis and cubes

Alex Whittles, Business Intelligence Consultant Purple Frog

Analysis Services OLAP cubes provide an incredibly powerful platform for the analysis and reporting of complex data. Unfortunately we often find that our source data is not in the right structure to make the best use of the cube’s power. This limits the cube’s functionality, compromises performance and complicates the reports. In this session we’ll look at a number of different data scenarios that we encounter and explore ways of remodelling the data within the data warehouse to optimise it for cubes and MDX. We’ll see how adding functionality into the ETL layer and data warehouse can have a dramatic effect on the functionality and simplicity of the cube.

About Alex:
Alex is a Data Platform MVP, and is the owner and lead consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the UK. He specializes in Data Warehouse modelling, ETL, Cubes, MDX & DAX. He's a chartered engineer & has an MSc in Business Intelligence. He runs the Birmingham (UK) SQL Pass chapter & Azure user groups, and is on the SQLBits and SQL Relay committees in the UK. Alex is a regular speaker at global events including SQLBits, PASS Summit, SQL Relay, SQL Saturdays as well as numerous SQL Pass chapters around Europe

Beginners Guide to MDX

Alex Whittles, Business Intelligence Consultant Purple Frog

Give your queries a multidimensional makeover. 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. MDX can seem a very daunting language, but when it's broken down into the basics it's easier than you think. We'll start at the beginning, so you need no previous MDX experience, but it does help to have some experience with cubes. If you already write MDX but struggle with the syntax, then you need to attend this session! We'll walk through the difference between a member, measure, tuple, set and dimension. Well describe how to decipher a [] from a {} or a (), and we'll look at some of the awesome power that MDX can provide to our reporting.

About Alex:
Alex is a Data Platform MVP, and is the owner and lead consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the UK. He specializes in Data Warehouse modelling, ETL, Cubes, MDX & DAX. He's a chartered engineer & has an MSc in Business Intelligence. He runs the Birmingham (UK) SQL Pass chapter & Azure user groups, and is on the SQLBits and SQL Relay committees in the UK. Alex is a regular speaker at global events including SQLBits, PASS Summit, SQL Relay, SQL Saturdays as well as numerous SQL Pass chapters around Europe

Supplementary Materials

The following event attachments are available to you:

PASSChapterLogo.jpg

sql_micro_sm.gif

sql_ca_sm.gif

Liberty IT

Momentum NI

Apress

WROX

SQL Sentry

Plural Sight

 

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids