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 Dalia Fernandes | Dec 1, 2023 | Uncategorized
Discover Row-level Security in Excel with an innovative add-in from PARIS Technologies. This tool goes beyond basic security options, offering username/password or integrated Windows security for easy access to centralized databases. You can control user permissions...
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 Dalia Fernandes | Sep 25, 2023 | Business Planning, Data Analysis, OLAP, OLAP and Excel, Predictive Analytics, Sports Analysis, Strategic Dashboards, Technology and Trends, Uncategorized
If you’re a sports enthusiast with a penchant for rugby, then you’re in for a treat! PARIS Tech has recently joined forces with David Newton, an esteemed figure from Newton Carmen, a renowned Fractional CFO firm. Together, they’ve crafted an...
by Dalia Fernandes | Sep 14, 2023 | Business Analytics, Business Budgeting, Business Planning, Data Analysis, OLAP, OLAP and Excel, Spreadsheets, Uncategorized
Top-down and Bottom-up budgeting methods co-exist in most companies. What happens it that first the Finance team creates the budget from the bottom up, and then senior management delivers top-down directives. Meeting those directives requires adjustment, often...
by Dalia Fernandes | Aug 31, 2023 | Business Planning, Data Analysis, OLAP, OLAP and Excel, Predictive Analytics, Sports Analysis, Strategic Dashboards, Technology and Trends, Uncategorized
One of the more vexing things to contend with in a business model is “version maintenance.” How many plan versions should we keep? How can we codify certain drivers that result in various premises? What if we want to compare one scenario against another…or numerous...
