Mark Whitehorn specialises in the areas of databases, data analysis, data modelling, data warehousing and business intelligence (BI).
Mark works with national and international companies, designing databases and BI systems. In addition to his consultancy practice he has also acted as an expert witness for the police in cases of computer fraud.
He is a well-recognised commentator on the computer world, publishing articles, white papers and eleven books on database and BI technology. The first one, Inside Relational Databases has been selling well since it was published in 1997 and is now in its third edition. It has also been translated into three languages. Another of his books FastTrack to MDX was co-written with the inventor of the language, Mosha Pasumansky.
Mark is also an associate with QA Ltd. He developed the company's database analysis and design course as well as its data warehousing course and teaches both.
On the academic side, Mark is a Professor at the University of Dundee where he designed and runs a Masters course in BI. There he also works with the prestigious Lamond labs. applying BI to proteomics. In addition he is a research associate at the University of Cambridge. There he is involved in an international research project analysing the hitherto unknown data that was available to Darwin before he wrote The Origin of Species. This group has used BI techniques to rewrite our understanding of how Darwin came to develop the theory of evolution.
For relaxation he collects, restores and races historic cars which keeps him out of too much trouble. He only wears a tie under duress, doesn't possess a suit that fits and unashamedly belongs to the beard-and-sandals school of computing.
Why and when denormalisation makes sense.
This talk looks at MDX and DAX, examining their similarities and differences. It won’t turn you into an expert in either but it will help you to decide, given your particular career plans, if either or both are worth learning.