Matthew Felzke
Data Warehousing for Manufacturing Companies using Dynamics AX

Photo taken from Shutterstock

This article will detail the effects of a commercial data warehouse for manufacturing and distribution organizations utilizing Microsoft Dynamics AX for their financials.

Data is the rightful buzzword for this era of business, perhaps especially for manufacturing and distribution organizations trying to meet their roadmap goals.  As data continues to grow in size and significance, data warehousing becomes a related task for modern business.  Even if you know a thing or two about data warehouses, you might have some questions or curiosities about them and how they relate to your manufacturing and/or distribution analytical processes.  Who manages a data warehouse? Are they like anything besides an OLAP cube?  At what point should a manufacturing and/or distribution corporation install one?  Cloud or on-premise?  How do we set up a data warehouse?  As a manufacturing or distribution Microsoft Dynamics AX customer, you likely have at least one of these questions.  This article will do the work of answering some of the more frequently asked questions, so you can more clearly see how data warehousing can be a solution for data management objectives with Microsoft Dynamics AX.

Continue reading

Matthew Felzke
Building a Best-of-Breed Business Intelligence Solution for Sage 500

This article discusses independent software vendor tools that will turbo-charge data management and analyses for Sage 500 users wanting to build a best-of-breed solution.

Some Sage 500 users will probably always wonder why they would want or need to deploy independent software vendor (ISV) tool(s) on top of their accounting system.  This confusion is perhaps an obstacle for ISVs and a concern for some Sage 500 users.  There are a couple of clarifications that seem to organically come out of the conversation.  First, no ISV can create a tool that can be a solution for every single organizational hurdle.  A great example would be how competitive mobile device brands, like Apple or Android, provide their own native mapping applications, but still allow you to download an app from another manufacturer, which is similar to modern flexible enterprise resource planning (ERP) systems, like Sage 500.  Because every organization using Sage 500 has particular objectives, specific budgeting requirements, and rules, the accounting system vary in how effective it is for each company.  ISV technologies enable organizations to customize their data management and analytics.

Continue reading

Matthew Felzke
Financial Consolidations for Manufacturing & Distribution companies using Sage X3

This article will discuss the best options you have for financial reporting and consolidation solutions for your Sage X3 data management and analytical tasks.

There are plenty of Sage X3 users who are responsible for consolidating their parent company information from one or more manufacturing or distribution subsidiaries.  Combining financial data from more than one entity, at times with multiple currencies, can be a challenge if you don’t have a modern financial consolidation solution to supplement Sage X3 and any other ERP systems that your subsidiaries might use.  Data is only growing in size and significance to corporate decision-making, which is why more executives are seeking the best software to enable their business end users to aggregate information into a unified set of financial reports.  In this article, we’ll focus on your technology options for today’s intuitive, business user friendly financial consolidations with Sage X3.  If your manufacturing or distribution organization is rapidly growing, a high-powered reporting and consolidation software can simplify your Sage X3 implementation and give you more flexibility and power in your reporting process.

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