Friday, July 1, 2022
Home Excel Strategies Excel-Friendly OLAP

Excel-Friendly OLAP

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.

Excel can be the key component of a powerful and inexpensive Business Intelligence (BI) system. Here are some ideas to get you started.

Excel Is Great for Business Intelligence!

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...

Latest Articles

How to Smooth Data by Using the TREND Function

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...
Two economists have introduced a new leading indicator, which predicts a recession soon. These Excel charts illustrate their insight. If they're correct, Excel users will be very busy in the months ahead.

Consumer Sentiment Suggests a 2022 Recession

In recent months, business websites have speculated about recessions and stagflation in 2022. These predictions could affect your Excel work significantly in the next few...
Your data can contain many important, hidden patterns. But simple transformations in Excel can help to reveal them—as this example illustrates.

Simple Transformations Can Reveal Hidden Patterns in Your Data

Excel users have at least two significant advantages over business professionals who rely on other analytical and reporting tools. First advantage: We Excel users can...
Advertisement