Browse by Tags

Cooking With CUBEs

Published Sun, Dec 16 2012 22:31 | Bob Phillips

As we should all know by now, PowerPivot provides Excel with a powerful way to harness data from one or more sources, and to do further analysis on that data within familiar pivot tables. Furthermore, because PowerPivot is creating an in-memory cube of...

Filed under: Excel 2007, cube, OLAP, Excel 2010, formulas, PowerPivot, dynamic, Slicer, Data Analysis

Cutting Edge BI

Published Tue, Apr 27 2010 10:53 | Bob Phillips

I went to the SQL Server 2008 R2 launch in London on 15th April 2010 (a while ago I know, but I have been away for a week :-)). I am not a SQL Server DBA or anything such, I went specifically for the BI sessions, PowerPivot and Reporting Services. I have...

Filed under: Excel, cube, OLAP, BI, proteomics

Cycling Through The Fog

Published Thu, Jan 7 2010 13:19 | Bob Phillips

Dynamic Analysis Excel 2007 provides the capability to have a pivot table connected to an OLAP cube. Furthermore, detailed analysis can be built by using various CUBE functions. One of the great things about Excel 2007 pivots and CUBE functions is that...

Filed under: 2007, VBA, Excelxcel, cube, OLAP, AS