Data Management
Categories
Articles on Data Management, Business Intelligence Strategies, Tips and Trends
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.
Scenario Maintenance – Analyzing the 2023 Rugby World Cup with OLAP Cube Technology
This is where OLAP technology can be especially helpful: we can demonstrate to ourselves how various scenarios generate different versions, all rooted in distinct assumptions. We can even consolidate all these assumptions into a single workbook, allowing us to work with these assumptions where the numbers exist or where actual calculations occur.
Dreamkillers-Analyzing the 2023 Rugby World Cup with OLAP Cube Technology
Unique perspectives can unveil insights that other technologies might not provide. In this case, I’ve employed OLAP to investigate a distinct facet of Rugby World Cup data—specifically, the concept of “dream killers.”
Retail OTB (Open to Buy) Planning with PowerExcel
OTB (Open-to-Buy) is a forward-looking metric based on future projections. In retail, it involves assessing current stock and estimating the exact amount of stock needed to achieve a predetermined target. It’s a blend of sales forecasting and stock planning, requiring accurate data and meticulous calculations.
Workforce Planning: Unleashing the Potential of PowerExcel Technology
In this article, Gareth Jones from PARIS Technologies discusses the challenges faced by companies when managing their payroll and workforce planning. Payroll planning is crucial for businesses, but it is often difficult to optimize due to the limitations of...
Analyzing the 2023 Rugby World Cup with OLAP Cube Technology
In this article, we explore some “scenario planning” capabilities of cube technology by delving into the world of sports, specifically for the 2023 Rugby World Cup tournament. Using our product’s analytical tool (the front end you will see is PARIS Tech’s PowerExcel; the back end, Olation), we’ll examine historical data, team performances, “dream-killers,” and make predictions for the upcoming competition
Infographic: 5 Signs You are in Excel Hell
Check out this cool infographic! Submitted to OLAP.com by the folks at PARIS Technologies. They’ve mapped here 5 warning signs that you and your professional team are living in Excel Hell.
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