Best Practices
Articles on Best Practices in OLAP, Business Intelligence, Planning and Forecasting.
Best Practices
OLAP & BI Solutions
Data management
Finance and Business Use Cases
Dashboards
Predictive Analytics
Subscribe
Get the latest on OLAP and Business Intelligence straight in your inbox.
27 Opinions and the Future of Excel
“Excel is one of those applications that the business world cannot live without.” So says one of 27 Excel experts commenting on Microsoft’s Power BI Suite and its effect on the great wide world of spreadsheet users. As Excel lovers, we couldn’t agree more! There’s a...
The Problem and Solution in the BI Market
A recent post on the PARIS Tech Blog, The Problem in the BI Market, highlights a few key facts/issues in the BI market. Some of these include disconnected applications, disconnected IT and front-end users, and slow processing times. Most interesting is the emphasis...
Advice for CFOs: Invest in New Technology
"Top Technology Trends for Today's CFO's" is another insightful post from a blogger we frequently feature, Timo Elliott. In it he admits that the CFO relationship with the CEO and other business executives leaves something to be desired. He recommends that CFOs...
Business Intelligence Evolves to Serve Users
Business data and BI software are currently beginning a new phase of evolution. In this new phase, users of business data will be able to collaborate and connect with other colleagues and team members without multiple spreadsheets and laborious processes. The BI user...
How to Set Up a Pivot Table as a Spreadsheet Database
Pivot Tables aren't merely a way to interact with your data. You also can use them as a rich source of data for regular reports and analyses...without using the weak function, GETPIVOTDATA. by Charley Kyd, MBA Microsoft Excel MVP You can use a Pivot Table as a...
Fast Data: How to Gain Insights from Big Data
In this Forbes.com article, Making Big Data Fast, Howard Baldwin makes a great point about data needing to be FAST in order to deliver value. Big data has a historical focus, whereas Fast Data seeks to enable action. For us at OLAP.com, we have seen "fast" as an...
Learn OLAP
Resources
Types of OLAP Systems
MOLAP, ROLAP, HOLAP... what's the difference? And modern OLAP for this century.
History of OLAP and BI
Learn about the history of OLAP technology with this comprehensive inforgraphic