About

Cubes, PowerPivot, data mining, and dashboards with SSAS, Excel, PerformancePoint

SSAS - cube, tabular, and data mining design - MDX - DMX

PowerPivot and DAX for Excel 2010

PowerPivot for SharePoint - PowerView

PerformancePoint for SharePoint

SQL Server star schema and OLTP database design

21 years in relational database design and SQL

11 years in SSAS multidimensional, MDX, DMX, cube and data mining model design

2 years in PowerPivot and DAX formulas

4 years in PerformancePoint dashboard design

1 year in SSAS tabular design, DAX queries, and PowerView

Finance

Recent clients: Bank of America and Nomura

Analysis of technical and fundamental indicators of share and option price movements. Loan assessment and fraud detection.

Retail

Recent clients: M&S, Tesco, Poundland

Cross-selling, up-selling, and sales forecasting. I am tempted to add Northwind, Adventure Works, and Contoso as clients.

Health

Recent clients: Leicestershire PCT and Warwickshire PCT

Patient tracking and analysing patient outcomes. Correlations between input factors and recovery.

Media

Recent client: confused.com

Tracking and analyzing hits on web site, page navigation, duration and retention on site pages.