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
Data Warehousing for Professional Services with Dynamics AX

In this article, data warehouses for Professional Services organizations will take center stage, with a focus on expanding Microsoft Dynamics AX analytical processes.

Data is increasingly more important in today’s business world, perhaps especially for Professional Services organizations.  As data informs decision-making at all levels, Professional Services organizations are striving to stay on budget and on track with projects, vendors, clients, and so forth, a data warehouse can be positively impactful in supporting Business Intelligence (BI) analyses.  If you’re new to data warehousing as a solution, you might have some questions.  This article will go about answering your questions about data warehousing as a Professional Services organization using Microsoft Dynamics AX.

Continue reading

Matthew Felzke
Useful Business Intelligence Add-on Products for Intacct

Independent software vendor (ISV) tools expand and streamline data management and analytics for Intacct users building best-of-breed Business Intelligence (BI) solutions.

One question that sometimes comes up in conversations with Intacct customers is related to confusion as to why you might need to deploy ISV tool(s) on top of the accounting system.  This is a small hurdle for ISVs as the confusion seems to quickly dissipate for the Intacct community.  First of all, no software solution, even as great as Intacct has proven to be, can answer to every single business-related analytical hurdle for every company.  A perfect example would be Apple offering their own native Maps applications on their iPhones, but still allowing consumers to install the Google Maps app, just as any modern flexible enterprise resource planning (ERP) system, like Intacct, does.  Because every organization who utilizes Intacct has particular objectives, specific planning needs and rules, the accounting system will differ in how sufficient of a solution it is for each corporation.  ISVs provide businesses the capability to customize their data management and analytics.

Continue reading

Matthew Felzke
Professional Services Reporting with Microsoft Dynamics SL

This article will discuss financial and operational reporting options for Professional Services organizations using Microsoft Dynamics SL, so you can invest in the right software for your team.

In the modern business culture, perhaps especially for Professional Services organizations, a powerful, user friendly report writer is essential to staying competitive in your sector, navigating the ebbs and flows of the economy through smarter decision-making, so you’re continuing to evolve as a business and a brand.  In this article, I’ll lay out some of your options for today’s quality financial and operational reporting solutions, zooming in on features and functionalities, so you can make the best investment to expand your Microsoft Dynamics SL analytics as a Professional Services organization.

Continue reading

Matthew Felzke
Data Warehousing with Dynamics GP for Professional Sports Teams

Data warehousing is a powerful way for Professional Sports Teams using Microsoft Dynamics GP to manage diverse data types and produce richer financial reports.

Nowadays, the amount of data you are working with can be massive, maybe especially for professional sports teams.  Since data correlates directly to advertising, performance, profit, and so on, data warehousing can assist professional sports teams in staying on budget and on track with owners, players, administrative staff and the finance team.  Maybe you’re not that familiar with a data warehouse solution, so you have several questions.  This article will aim to offer answers that speak to your questions, so you can better understand how data warehousing can expand professional sports team data management and analytics from Microsoft Dynamics GP and additional data sources.

Continue reading

Matthew Felzke
Data Warehousing for Not-for-Profit Organizations using Dynamics GP

In this article, we’ll continue discussing data warehousing, generally and particularly, for not-for-profit organizations that are hoping to develop their Microsoft Dynamics GP experience.

In modern business, data is ubiquitous, perhaps particularly for not-for-profits (NFPs).  Since data directly supports decision-making, with NFP organizations actively working to remain on budget and/or on track with members, donors, grants and so forth, data warehousing can be helpful to your Business Intelligence (BI) tasks.  If you’re anything like I was when I first heard of a data warehouse solution, you probably have questions.  The goal for this article is to deliver the answers for NFP teams to understand how a data warehouse can improve management and analyses of your information from Microsoft Dynamics GP and other data sources.

Continue reading

Matthew Felzke
Financial Reporting for Professional Services with Microsoft Dynamics AX

In this article, financial reporting solutions for Professional Services organizations utilizing Microsoft Dynamics AX will take center stage, so you can make the best software investment.

In today’s business world, maybe particularly for Professional Services organizations, a modern, dynamic financial reporting tool is vital to remaining competitive in your industry, making decisions to maneuver through the ups and downs of the economy, while developing the business and your brand.  This article will focus on the best financial report writers today, discussing the premier features and functionalities, so you can invest in the best reporting tool to expand your Professional Services organization’s Microsoft Dynamics AX experience.

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 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