by jessicaotero | Oct 10, 2025 | Data Analysis, Data Management, Financial Modeling, FP&A, General BI and Data Management, Microsoft Excel, Planning, PowerAnalytics, PowerExcel, Reporting, Software, Solutions
You can turn your spreadsheet mess into an Excel database, and let us tell you why it is a power move. If your ERP or accounting system runs on SQL Server, you’re sitting on a goldmine of financial data! You can access that data with an analytical Excel...
by jackguarneri | Sep 21, 2022 | Business Analytics, Business Intelligence (BI), Data Analysis, Data Management, Finance and Banking, General BI and Data Management, Industry Focus, PowerExcel, Software
Moving from the Messy Middle to Digital Finance Transformation While not a generally accepted best practice, it is nearly universally true that Finance (and many other) professionals do a great amount of work in Microsoft Excel and then move data to a Business...
by sazmoodley | Mar 2, 2020 | Big Data, Business Analytics, Business Intelligence (BI), Data Analysis, Data Management, Olation
Table of Contents I. What is an In-memory Database? II. Properties of In-memory Database Systems III. Advantages of In-memory Database Systems IV. Benefits of In-memory Database in Analytics V. How to Leverage In-memory Database for Analytics and Business Intelligence...
by sazmoodley | Feb 11, 2020 | Budgeting, Business Intelligence (BI), Data Analysis, General BI and Data Management, Microsoft Excel
The budgeting and forecasting process for most organizations is long and tedious and occurs on an annual basis, at least. Companies try to do it more often to improve accuracy and aim to ultimately implement a procedure for continuous planning, rolling forecasts,...
by sazmoodley | Feb 7, 2020 | Budgeting, Data Analysis, Finance and Banking, Microsoft Excel
How 2 Persistent Conditions Define Budget Planning in ERPs There are 2 remarkably persistent conditions in the world of Finance Technology that concern budgeting and ERPs. It’s surprising, because the complexities that Finance departments must address have increased...
