Matthew Felzke
Let’s Talk about OLAP Cubes

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?

Continue reading

Matthew Felzke
Data Warehousing for Not-for-Profit Intacct Users

In this article, we’ll continue discussing the impact of data warehouse solutions for not-for-profit organizations who are using the Intacct accounting system.

Some people might think that non-profits are functioning outside of the typical business model, but in reality, data is driving the same vital decision-making for not-for-profit organizations.  As non-profits do the hard work of staying on track with budgets, donors, grants, members, and so forth, a data warehouse can be really effective and efficient for your Business Intelligence (BI) processes.  With online analytical processing (OLAP) cubes being a common technology presence, the difference between OLAP cubes and data warehouses might seem confusing to you.  In this article, we’ll discuss the benefits of data warehousing for non-profit data management and analytics tasks using Intacct.

Continue reading

Matthew Felzke
Data Warehousing with Sage X3 for Manufacturing & Distribution

This article will explore the impact of a data warehouse solution for manufacturing and distribution companies using Sage X3 for data management and analytical processes.

Data continues to be the non-negotiable ingredient to decision-making, maybe especially for manufacturing and distribution companies trying to stay on track to achieve their goals.  With data growing in amount and importance, data warehouses are tangentially relevant in today’s business world.  If you’re anything like me, you have questions that sound a lot like who, what, when, where, why, and how – all related to data warehouses.  Who can manage a data warehouse?  What do they compare to / resemble?  When should a manufacturing and/or distribution company implement one?  Where are they hosted?  Why not an OLAP cube instead of a data warehouse?  How do we configure a data warehouse?  As a manufacturing or distribution Sage X3 user, you probably have one or more of these questions.  In this article, I’ll go about answering some of the frequent questions, so you can understand data warehousing as a solution and decide how to best meet your data management goals with Sage X3.

Continue reading

Matthew Felzke
Retail Data Warehousing for Microsoft Dynamics NAV

In this article, data warehousing will be discussed, both generally and specifically, for retail organizations who are looking to expand their Microsoft Dynamics NAV experience.

In the fast lane that is business today, maybe especially for retail companies, data is vital.  Since data drives decisions, retail organizations are making plans to stay on track and on budget with their customers, stores, vendors, management, etc. – and data warehousing can be really effective in organizing and empowering stronger Business Intelligence (BI) analytics.  Like most software, if you aren’t familiar with it, you likely have questions.  In this article, I’ll answer frequently asked questions about data warehouse solutions for retail companies using Microsoft Dynamics NAV.

Continue reading

Matthew Felzke
Financial Consolidation for Non-profits with Intacct

In this article, modern financial consolidation solutions will take center stage, particularly for multi-location Non-profit organizations using Intacct to manage parent company finances.

There is a population of non-profit Intacct customers who are overseeing the financials of their organization with multiple locations or entities.  Consolidating organizational information from more than one location, sometimes with diverse currencies, can be tedious without a premier financial consolidation solution.  Data continues to grow in size and significance in terms of decision-making.  More executives than ever are shopping for the right tool to allow their business end users to aggregate data into a set of financial statements or for summarized operational reports.  This article will zoom in on features and functionalities for the non-profit Intacct user who performs consolidations for monthly financials or annual budgets for the parent organization.

Continue reading

Matthew Felzke
Retail Data Warehousing for Microsoft Dynamics AX

This article covers data warehouse solutions, both in general and in specific for retail companies who are seeking to expand their Microsoft Dynamics AX analytics.

In today’s fast-paced business world, perhaps especially for retail corporations, data is essential.  Because data is driving decision-making, retail companies are strategizing to stay on budget and on track with their stores, customers, vendors, managers, and so on – and a data warehouse can be really impactful in supporting Business Intelligence (BI) analyses.  As with most technology, if you aren’t already using a modern offering, you probably have questions.  This article will go about answering the most common questions you might have about data warehousing with Microsoft Dynamics AX for your retail company.

Continue reading

Matthew Felzke
Data Warehousing for Professional Services with Acumatica

This article covers data warehousing, both generally and more specifically for Professional Services organizations who are looking to expand their Acumatica analytics.

In the business culture of today, maybe particularly for Professional Services companies, data is king.  Since data drives decision-making, and Professional Services teams are working smartly to stay on track and on budget with clients, projects, vendors, and so forth, data warehousing can be really effective to support Business Intelligence (BI) analytical tasks.  When I first learned about a data warehouse as a solution, I had questions, so you might as well.  In this article, I’ll go about providing the answers you need about data warehousing with Acumatica for your Professional Services organization.

Continue reading

Matthew Felzke
Data Warehousing with Intacct for Non-profit Organizations

This article will discuss data warehouses, both in general and specifically for non-profit organizations, who are seeking to expand their Intacct analytical processes.

In the world of business today, data is everywhere, perhaps especially for non-profit organizations.  Because data informs decision-making, and non-profits are working hard to stay on budget and/or on track with donors, grants, members, and so on, data warehouses can be really impactful to Business Intelligence (BI) processes.  I know I had questions about data warehousing when I first heard of the product category, so you might, too.  This article will aim to provide you the answers to general and specific questions about data warehouses for managing and analyzing your non-profit data with Intacct.

Continue reading

Matthew Felzke
Data Warehouse Solutions for Intacct

In this article, data warehouses will be the focus, so you know what to look for in a BI data storage solution for the benefit of your Intacct experience.

Everywhere you look in the business world, data.  Because of data’s significant role in corporate decision-making, data warehouses have become a heavy-hitting tool for companies today.  In my first interaction with the concept of data warehousing, I had some questions, from basic to logistical, so I’m assuming you feel the same.  How do you manage a data warehouse?  Can I hold the product in my hands?  How does deployment happen?  And why a data warehouse in the first place?  If you have these questions or more Intacct-specific curiosities regarding data warehouses, this article will hopefully provide you with the answers you seek, so you can envision how a data warehouse solution can assist you in Intacct data management and analysis tasks.

Continue reading

Matthew Felzke
Data Warehouse and OLAP Cube-based Reporting for Microsoft Dynamics

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.

Continue reading