Business Intelligence and Data Analytics Blog

Information and Discussions on Business Intelligence, Data Analysis, and Management featuring: Strategies, Best Practices, PARIS Product Tips and News

Transform Collaboration in Excel by adding Row-Level Security

Transform Collaboration in Excel by adding Row-Level Security

 Hey there, Finance and data security gurus. Today, we're talking about Excel and discovering a feature that's majorly undervalued.  That feature is row-level security. While Excel may not boast robust enterprise-level security on its own, we've got a nifty solution...

read more
Unlocking the Games: The Power of OLAP Cubes in Sports Analysis

Unlocking the Games: The Power of OLAP Cubes in Sports Analysis

PARIS Tech and partner David Newton from Newton Carmen have collaborated to create an OLAP model for analysing the 2023 Rugby World Cup.   Using this data model, full of every Rubgy stat imaginable, we’ve run a video series of over20 different scenarios.  Turns out we...

read more
Pivot Table vs. PowerExcel Pivot

Pivot Table vs. PowerExcel Pivot

If you’ve built your models in Excel, this becomes very difficult. You need to go down to the bottom, change some assumptions, roll it all up, and check if you have the number that management wants. If you don’t, you must go down to the bottom again and start over until you roll it all up again. In some organizations, this sort of circular process can take months; it’s expensive, time-consuming, and demoralizing.

read more
Top-Down Bottom-Up Budgeting with PowerExcel

Top-Down Bottom-Up Budgeting with PowerExcel

If you’ve built your models in Excel, this becomes very difficult. You need to go down to the bottom, change some assumptions, roll it all up, and check if you have the number that management wants. If you don’t, you must go down to the bottom again and start over until you roll it all up again. In some organizations, this sort of circular process can take months; it’s expensive, time-consuming, and demoralizing.

read more
Video Series: 2023 Rugby World Cup Predictor

Video Series: 2023 Rugby World Cup Predictor

If you are a rugby fan , You have to check out the Rugby World Cup Predictor video series! Built in collaboration with our Partner and Finance expert, David Newton of Newton Carmen, we’ve created a cool Rugby World Cup Predictor model. 

read more
Retail OTB (Open to Buy) Planning with PowerExcel

Retail OTB (Open to Buy) Planning with PowerExcel

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

read more
Analyzing the 2023 Rugby World Cup with Cube Technology

Analyzing the 2023 Rugby World Cup with Cube Technology

If you like sports analysis and rugby, this one is for you!  The OLAP.com blog recently published an article discussing the use of OLAP cube technology in analyzing and predicting outcomes for the 2023 Rugby World Cup.   Cube technology or “OLAP” is a...

read more