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

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…

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…

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 Car…

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 predetermin…