Mitigating Spreadsheet Risk in Complex Multi-Dimensional Models in Excel

02/05/2018
by   Steve Litt, et al.
0

Microsoft Excel is the most ubiquitous analytical tool ever built. Companies around the world leverage it for its power, flexibility and ease of use. However, spreadsheets are manually intensive and prone to error, making it difficult for companies to control spreadsheet risk. The following solution is designed to mitigate spreadsheet risk for a set of problems commonly addressed in a spreadsheet defined as "complex multi-dimensional models". "Complex" referring to certain types of applications that require functionality such as sophisticated algorithms, challenging hierarchies and database write-back (i.e. planning, forecasting, etc.) and "multi-dimensional" referring to providing capabilities such as reporting, data input forms and ad hoc analysis on the different attributes associated with the resulting model. The solution is defined as a "PivotModel" because it works similarly to a PivotTable but is designed to leverage the robust capabilities of the Microsoft Excel platform.

READ FULL TEXT
POST COMMENT

Comments

There are no comments yet.

Authors

page 1

page 11

10/13/2021

Spectral-norm risk rates for multi-taper estimation of Gaussian processes

We consider the estimation of the covariance of a stationary Gaussian pr...
03/17/2020

Multi-dimensional Skyline Query to Find Best Shopping Mall for Customers

This paper presents a new application for multi-dimensional Skyline quer...
12/03/2019

Learning Multi-dimensional Indexes

Scanning and filtering over multi-dimensional tables are key operations ...
02/25/2019

Utility Mining Across Multi-Dimensional Sequences

Knowledge extraction from database is the fundamental task in database a...
04/29/2019

Partially Ordered Statistics Demapping for Multi-Dimensional Modulation Formats

We propose a very low-complexity and high-performance algorithm for soft...
04/23/2019

A Flexible Framework for Parallel Multi-Dimensional DFTs

Multi-dimensional discrete Fourier transforms (DFT) are typically decomp...
05/31/2021

Semi-orthogonal Embedding for Efficient Unsupervised Anomaly Segmentation

We present the efficiency of semi-orthogonal embedding for unsupervised ...
This week in AI

Get the week's most popular data science and artificial intelligence research sent straight to your inbox every Saturday.