Data Management
Categories
Articles on Data Management, Business Intelligence Strategies, Tips and Trends
Best Practices
OLAP & BI Solutions
Data management
Finance and Business Use Cases
Dashboards
Predictive Analytics
Subscribe
Get the latest on OLAP and Business Intelligence straight in your inbox.
Data Warehouse for Business Intelligence
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...
Transform Collaboration in Excel by adding Row-Level Security
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...
Unlocking the Games: The Power of OLAP Cubes in Sports Analysis
Rugby fans, prepare to be exhilarated! PARIS Tech has teamed up with David Newton, a luminary in the world of finance and the founder of Newton Carmen, a prestigious Fractional CFO firm. Together, they've fashioned something extraordinary - an OLAP model tailored...
Pivot Table vs. PowerExcel Pivot
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 and...
Rugby World Cup Series 2023 | Sports Analysis with OLAP Cube Technology
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 extraordinary sports analysis OLAP model tailored specifically for the upcoming Rugby World Cup.
Top-Down Bottom-Up Budgeting with PowerExcel
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 leading to a time-consuming and demoralizing cycle in Excel to complete the budget.
Learn OLAP
Resources
Types of OLAP Systems
MOLAP, ROLAP, HOLAP... what's the difference? And modern OLAP for this century.
History of OLAP and BI
Learn about the history of OLAP technology with this comprehensive inforgraphic