Posts

This article is going to tackle OLAP cubes as a solution concept for Business Intelligence processes, within the context of other BI data store options.

Let’s do it – let’s talk about OLAP cubes.  With the amount of data only growing, exponentially for some, Business Intelligence (BI) data stores are becoming more and more prevalent – and are sensible ways for modern organizations, companies, and corporations to access, store, and organize company data for financial reports, budgets, and dashboards, as well as financial consolidations.  Whether you’re relying on a data mart, data warehouse, or an OLAP cube, your data queries won’t slow down the Enterprise Resource Planning (ERP) system, and you can grab multiple types of data to enrich and broaden your analyses.  But this article will specifically zoom in on OLAP cubes.  Who manages them?  What are they? When do OLAP cubes come into play?  Where are they staged? Why would you choose an OLAP cube over another BI data store?
Read more

How you access your data can determine the speed and efficacy you can achieve in your financial reporting processes.  This article will discuss data warehouse and OLAP cube based reporting.

Data is driving decision-making at all levels because data continues to grow in size and significance.  Logging, storing, and evaluating data has become a big part of the business culture today.  In order to produce rich, helpful financial reports for an analysis of a company’s opportunities and challenges, you will have to routinely store, access, and manage your data.  Because of this reality, you might feel overwhelmed your technology options for storing your data.  You have a few options, but they vary in functionality, and one might be better for your company than another, depending on what analysis goals you are trying to achieve.  This article will explore data warehouse and OLAP cube based reporting.
Read more

Data integrations can be confusing, and they make a difference when picking the right BI tool.  This article will discuss the difference between live reporting for Microsoft Dynamics versus data warehouse or OLAP cube integrations.

Data, data, data.  These days, companies are swimming in it.  Transactional and operational information is a required aspect of conducting business these days – for many reasons, but perhaps, especially when it comes to making important decisions about the future of the company.  Business Intelligence (BI) involves analysis of enterprise data for understanding of trends and trajectories, successes and failures, as well as related planning or forecasting for the fiscal year.

Whether a company is using an OLAP cube or some sort of data warehouse, important company facts and figures, such as transactions, personnel information, and inventory, are used in Enterprise Resource Planning (ERP) systems and BI tools like financial report writers, budgeting solutions, and dashboards.  When selecting which BI tool to use, an important question arises pretty early in the selection process: is it more advantageous to integrate live to and from ERP systems like Microsoft Dynamics, Sage, Acumatica, or SAP Business One, or to integrate to a BI data storage option?
Read more