Home
About
Contact
Essential BI Links
Essential BI Reading
Essential BI Software
Essential BI Tutorials
 Art Tennick                BI trainer and consultant            UK-based           Business Intelligence by Design
SSAS 2012, cubes, tabular models, data mining, MDX, DMX, XMLA
PowerPivot, DAX
PerformancePoint, PowerView
SQL Server 2012, star schema design, SSIS, SSRS, SQL, BISM

More than happy to answer individual MDX and DAX questions

* Please email from Contact page *

Practical PowerPivot and DAX Formulas
 
250+ downloadable DAX formulas 
Amazon USA   Amazon UK   Podcast - McGraw-Hill
Chapter 1 preview
 
Practical DMX Queries 
 
                                                               
250+ downloadable DMX queries
Amazon USA   Amazon UK
Chapter 1 preview

Practical MDX Queries

  
300+ downloadable MDX queries  
Amazon USA    Amazon UK

Chapter 1 preview

 

Practical SQL Queries

 

400+ downloadable SQL queries                               
Amazon USA   Amazon UK

Chapter 1 preview

 

PowerPivot/DAX, MDX, DMX, and SQL books have downloadable formulas and queries at McGraw-Hill site
   use Northwind for PowerPivot/DAX - Adventure Works for DMX, MDX, and SQL - optionally Contoso Retail for advanced DAX
      Northwind can be either SQL Server or Access or Excel (download from PowerPivot/DAX book at McGraw-Hill) or a data feed
 
Data Mining and Cubes for Traders (article in Stocks and Commodities magazine) PDF copy
Practical XMLA Queries (2012?)
 

To email SSAS/cube/data mining/PowerPivot/PerformancePoint questions go to Contact page


For useful BI web sites (including free PowerPivot for Excel and Data Mining Add-in for Excel downloads) go to Essential BI Links page