Data Modeling for Analysis Services Cubes

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 to optimise it for cubes and MDX. We’ll see how adding functionality into the ETL layer can have a dramatic effect on the functionality and simplicity of the cube.
Presented by Alex Whittles at SQLBits XI
  • Downloads
  • SpeakerBIO
    Alex_Whittles.jpg
    Alex is the owner and lead consultant at Purple Frog, a SQL Server Business Intelligence consultancy with clients including Barclays Capital and Confused.com. He specialises in all aspects of dimensional data modelling, data warehousing and cubes using the SQL Server stack. Alex has an MSc in Business Intelligence, runs the Midlands SQL Server User Group and the Birmingham SQL Relay conferences. As well as speaking at SQLBits, he is also a regular speaker at other events including SQL Saturday and SQL Server user groups around the country.
    http://www.PurpleFrogSystems.com http://www.purplefrogsystems.com/blog/feed/
  • Video