by Jack Guarneri | Oct 12, 2023 | Uncategorized
This video from our sponsor PARIS Tech compares Microsoft Excel’s PivotTable capabilities with the pivot table in PowerExcel. PivotTables are recognized for their ability to organize data effectively, but they are primarily designed for single-user productivity...
by Jack Guarneri | Jul 31, 2023 | Business Analytics, Business Budgeting, Business Planning, Data Analysis, OLAP, OLAP and Excel, Spreadsheets, Uncategorized
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...
by Jack Guarneri | Jun 26, 2023 | Business Planning, Data Analysis, OLAP, OLAP and Excel, Predictive Analytics, Sports Analysis, Strategic Dashboards, Technology and Trends
OLAP cube (multi-dimensional database technology), traditionally associated with Finance and Accounting, can be applied to limitless fields of interest, demonstrating incredibly versatility in performing reporting, analytics and even planning tasks. It’s no wonder...
by Jack Guarneri | Sep 8, 2015 | Application/Data Integration, BI Solutions, BI Strategy, BI System, Data Management, PARIS Tech blog, Technology and Trends
A recent post on the PARIS Tech Blog, The Problem in the BI Market, highlights a few key facts/issues in the BI market. Some of these include disconnected applications, disconnected IT and front-end users, and slow processing times. Most interesting is the emphasis...
by Jack Guarneri | Dec 9, 2014 | Application/Data Integration, BI Solutions, BI Strategy, BI System, Big Data, Business Analytics, Business Intelligence Suite, Data Analysis, Data Management, Data Warehousing, OLAP, Technology and Trends
Some vendors have run from the four letters OLAP…and yet, articles continue to be published, and assertions made, that “analytical processing” is entering a new phase. There’s a new acronym in the market, HTAP, which stands for Hybrid Transactional/Analytical...