Rather than presenting your data as tables, OLAP presents your data as multidimensional cubes. Excel-friendly OLAP products support worksheet functions that allow you to read data from—and WRITE data to—cubes in memory that are saved on a server.
With the right access to data, Excel can become an outstanding Business Intelligence (BI) system.Business Intelligence (BI) is the systematic use of information about...
(Originally published in Inc Magazine.)What typically tops the list of worries of the chief executive officers of fast growing companies? Financing that growth, according...
Years ago, I read that Prof. William S. Cleveland had suggested that data could be smoothed by calculating a centered trendline through adjacent data—a...