Matthew Felzke
Retail Reporting with Microsoft Dynamics NAV

If you are a retail company and use Microsoft Dynamics NAV as your accounting system, this article will discuss modern, powerful financial reporting software options.

Financial reporting is perhaps the cornerstone of Business Intelligence (BI) analyses as they quantify a company’s financial health in what should be an easily digestible set of operational and financial reports.  Business is moving so fast these days, and Retail is exactly the same.  Accounting systems, like Microsoft Dynamics NAV, usually provide built-in financial reporting functionality.  But with consumer demands for complex, richer data analyses – and reporting that is specific to your industry – the native report designer is typically subpar for end user objectives.  In this article, we’ll explore independent software vendor (ISV) offerings for dynamic, easy-to-use, and modern financial tools that provide Retail companies the analytics they require to make informed decisions about the future.

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
Useful Business Intelligence Add-on Products for SAP Business One

This article will discuss the third party offerings that will expand data management and analytics for SAP B1 users seeking best-of-breed corporate performance management.

A question I run into regularly has to do with SAP Business One users wondering why you might need to implement independent software vendor (ISV) software in addition to the accounting system.  It is always interesting to discuss this concern, maybe as a hurdle for ISVs, but a legitimate confusion for some SAP B1 customers.  A couple recurring clarifications tend to naturally surface.  Firstly, no software manufacturer can produce a technology that solves every single organizational problem.  For example, Apple iPhones offer the built-in Maps application, but still allow users to download Google Maps, just like any of today’s flexible accounting systems, like SAP B1.  Since every company who uses SAP B1 has specific goals, particular budgeting requisites, and rules, the enterprise resource planning (ERP) system will vary in effectiveness for each organization.  ISVs offer corporations the ability to personalize their data management and analyses.

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
Financial Reporting with Dynamics AX for Retail Companies

If you’re part of a Retail organization’s finance team and you’re using Microsoft Dynamics AX for your accounting processes, this article is for you, discussing your financial reporting software options.

Financial reporting is arguably the centerpiece of Business Intelligence (BI) analytics as they summarize the financial health of an organization in a hopefully easy-to-read set of financial and operational statements.  Business is moving at quite a rapid pace today, and Retail is no different.  Enterprise resource planning (ERP) systems, like Microsoft Dynamics AX, typically offer financial reporting functionality built right into the program.  However, with the need for more complex, robust data analytics – and now, industry-specific reporting – the native report writing usually falls short of consumer needs.  This article will discuss your third party options for modern, powerful, and business user friendly financial reporting solutions, offering Retail organizations the information they need to make stronger decisions about the future of their company.

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