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
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.
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.
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.
Scenario Maintenance – Analyzing the 2023 Rugby World Cup with OLAP Cube Technology
At PARIS, you may have noticed that recently, we’ve added a touch of fun concerning “version maintenance” as a business idea by intertwining it with—of all things!—Rugby World Cup data. Now, in the context of the Rugby World Cup—which event is coming up quickly—the...
Dreamkillers – Analyzing the 2023 Rugby World Cup with OLAP Cube Technology
At PARIS, you may have noticed that recently, we’ve added a touch of fun with the upcoming Rugby World Cup. We’ve created a Rugby World Cup model with an array of versions, predicting diverse outcomes for matches at different stages of the event.
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.
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...
Workforce Planning: Unleashing the Potential of PowerExcel Technology
Welcome, readers! Today we embark on a journey into the realm of Financial Planning and Analysis (FP&A) to explore the critical subject of workforce or payroll planning. Join Gareth Jones from PARIS Technologies as he sheds light on the challenges faced by...
Towards a New Understanding of ‘Enterprise Reporting’
Like any valuable report, we should be able to draw a conclusion: any truly well-performing Enterprise Reporting System must score high marks vis-à-vis each of the 5 ideal attributes above. No shortcomings allowed among them, as any weakness undermines the full success of—if we can forgive the expression—the “enterprise of Enterprise Reporting.”
Your Data, The Cloud—and Excel
For many companies “the server room” is a thing of the long-ago past. Just like the onsite applications meant to run in the server room, all that server-installing and server maintenance has gone virtualized, up to the Cloud. Along with the applications and servers, so, too, have gone databases; the connectivity between systems, and; an enormous amount of stored data. Even daily work in Office applications has gone to the Cloud.