by Jack Guarneri | Dec 11, 2023 | Uncategorized
A data warehouse is a great thing in concept, and a wonderful thing in actuality! Who could argue with the concept: “a central repository for data integrated from various sources, organized for reporting and analysis.” Anyone who, in actuality, has worked in Business...
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...