Finance & Business Use Cases
Categories
Applications of OLAP and Business Intelligence in Finance and Business
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.
Create Variable-Length, Dynamic Reports Linked to Excel Tables
When you change a criteria value in a cell, Excel can use formulas and conditional formatting to expand or contract your report automatically, without macros. Here's how. by Charley Kyd, MBA Microsoft Excel MVP Excel Tables are a powerful feature introduced in Excel...
5 Essential Components of a Data Strategy
Building a comprehensive data strategy for your organization can be a daunting task. Where do you start, and how do you put all the proper pieces in place for a suitable strategy to bring value to your company from data? The key is to ensure that the strategy focuses...
Four Ways to Leverage BI for Executive-Level Reporting
Businesses today have an increasing volume of sales performance data available from multiple sources. While most companies understand the potential value of this data, many struggle to turn it into actionable insights--especially at the executive level. Why? Because...
What makes a data visualization memorable?
It’s easy to spot a “bad” data visualization—one packed with too much text, excessive ornamentation, gaudy colors, and clip art. Design guru Edward Tufte derided such decorations as redundant at best, useless at worst, labeling them “chart junk.” Yet a debate still...
How analytics can help communities visualize the future
An urban development initiative in Austin, Texas is using enormous amounts of data pulled from various agencies to create astonishing 3D simulations of what communities would look like based on certain assumptions and inputs contributed not only by engineers and city...
Avoid Screwing Up Predictive Analytic Projects
Whether you're new to predictive analytics or have a few projects under your belt, it's all too easy to make gaffes. "The vast majority of analytic projects are riddled with mistakes," says John Elder, CEO at data mining firm Elder Research. Most of those aren't fatal...
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