Matt Felzke
Data Warehouse and OLAP Cubes for Microsoft Dynamics NAV

Business intelligence data stores can be a foundation for your data management and analysis workflow.  This article will discuss options for Microsoft Dynamics users.

Today’s corporate decision-making is all about data: operations, transactions, and more that a company manages and analyzes to understand the best way to move forward competitively.  Keeping and utilizing data is more than a breadcrumb trail or a narrative of where a company has been – it helps to formulate the future.  But without a proper education on Business Intelligence (BI) data stores, understanding your options can be challenging.  There are just a few options, but they are distinct in functionality, and based on your particular needs within and around your Microsoft Dynamics NAV experience, one data store might be the only option you and your team can manage.  This article will discuss the top two options for data storage for implementation with Dynamics NAV: OLAP Cubes versus Data Warehouse.

Continue reading

Matt Felzke
Focus 2014 – A Recap of Solver’s Annual User Conference

Solver, Inc. hosted their Annual User Conference, Focus, in sunny Marina del Rey, and it was a huge success, with a bigger registration and more info-packed sessions than last year.

As a first time participant in Solver’s annual user conference, Focus, held in Marina del Rey, California, I am pleased to report that it was a huge success.  Partners and customers alike turned out in record numbers to sell out the conference.  Focus 2014 was truly bigger and better than last year in another way: the Solver team added a whole day of sessions dedicated to partner enablement to discuss sales, marketing, and the roadmap for the future of BI360.  My favorite part of the experience was the sense of community built through the networking nature of the conference.  Partners and customers were able to connect and put faces to names and e-mail addresses, with each other as well as with the Solver team.

Continue reading

Matt Felzke
Financial Reporting and Consolidations for Microsoft Dynamics NAV

This article will explore the options you have for powerful, ultra-modern financial reporting functionality to accelerate your Microsoft Dynamics NAV experience.

As arguably the most popular facet of Business Intelligence, financial reporting continues to evolve for the modern business world.  Microsoft Dynamics NAV users are probably aware that, like most accounting systems, NAV offers a built-in report designer, simply called Report Designer.  While some organizations can effectively analyze the data they manage and analyze to make decisions by using Report Designer, the tool is limited in its efficacy for most companies of a healthy size.  This article will discuss and zoom in on the options you have for powerful, modern financial reporting for Dynamics NAV, with a specific focus on key feature and functionality considerations you should evaluate before investing in a solution.

Continue reading

Matt Felzke
Best Report Writers for Microsoft Dynamics SL

This article will discuss your financial reporting options, so you can have a head start in picking the best report writer that enhances your Dynamics SL experience for you and your team.

A modern, dynamic financial report writer is nearly a necessity for any organization that intends to stay competitive in the marketplace, navigating economic shifts and developing their brand by making data-driven decisions.  This article will discuss financial reporting solutions, with a focus on their features and functionalities, so you can have a head start in finding the right report writer for your Microsoft Dynamics SL experience.

Continue reading

Matt Felzke
Replacing XL Reporter with Modern Reporting Tools for SAP Business One

If you are looking for a true upgrade to XL Reporter (XLR), this article will compare a few alternative solutions with the goal of highlighting important features and functionalities for your SAP B1 financial reporting experience.

I keep running into SAP Business One (SAP B1) customers as I spend more time in the world of Business Intelligence.  While the population of SAP B1 users is somewhat small in comparison to other popular accounting systems, it is a passionate group that is steadily growing.  And right now, as SAP has retired the trusted Excel-based financial reporting tool, XL Reporter (XLR), this community of customers is at a crossroads.

Continue reading

Matt Felzke
Financial Reporting, Budgeting and Dashboard Tools for Acumatica

It is important to understand the BI offerings on the market today to boost your reporting, budgeting, and dashboard functionality with Acumatica.  This article will explore your options, so you can pick the tool that is best for your company.

In a recent report by Gartner, the marketplace for Business Intelligence (BI) and Analytics solutions grew 8% in 2013 to a total of $14.4 billion from 2012.  Arguably, this is a gradual growth, but steady nonetheless, which makes good sense.  If you look at the amount of data you and your team manages and analyzes to make better decisions faster in an effort to stay competitive, you would have to agree that real-time or near-real-time, monthly, quarterly, annual, and sub ledger analytics are necessary.  Moreover, the business world is moving away from IT-managed BI solutions to easy-to-use, modern, and powerful reporting, budgeting, dashboards solutions that enhance your Acumatica experience.  This article will discuss the features and functionalities of third party products for Acumatica users in the current BI software marketplace.

Continue reading

Matt Felzke
Dashboards for SAP Business One

There are plenty of functionality and flexibility aspects to consider when selecting a powerful, business user friendly dashboard solution for your SAP Business One experience.  This article will explore your options, so you know what to look for in the best data visualization solution for you and your team.

Dashboards are the number one solution in the Business Intelligence (BI) marketplace: old news?  Not quite. Gartner’s 2013 study on Financial Executive International CFO Technology reported that dashboards, scorecards, and performance management solutions are CFOs’ number one priority.  The fast pace of today’s business world insists that you and your team have easy-to-use, flexible access to data that drives key decision-making.  Data visualizations of company information, like dashboards, are the answer to that need. Continue reading

Matt Felzke
Comparison of Budgeting Tools for Dynamics GP

Using the framework of key features to shop for, like ease of use, budget workflow, and security, this article will compare budgeting and forecasting options for Microsoft Dynamics GP.

Budgeting requires multiple departments entities bringing transactional data together, as well as research, to forecast what will financially manifest in the coming year, regarding revenue, expenses, and other important items. For Microsoft Dynamics GP users, there is an abundance of options for budgeting and forecasting, including manual, homegrown spreadsheets, GP budgeting input, an accelerated Excel add-in tool, or proprietary interfaced software. In this article, I’m going to zoom in on your budgeting software options for Dynamics GP, so you can get a better understanding of the best route for you and your team.

Since you are looking for a solution that business users can utilize, I always think it’s smart to lay out the most important features to look for in a product.  Even if you are the only who will be using the budgeting tool with Dynamics GP, it should be first and foremost easy to use.  I cannot think of one person who gets excited to put together a budget, so the task should be as easy as possible, regarding the user friendliness for non-IT professionals.  In particular, you should be looking for a solution that streamlines the process with accounting and business logic and reusable budgeting templates, amongst other functionalities.  Given the collaborative nature of budgeting, streamlining is a must.

Continue reading

Matt Felzke
Best Budgeting Solutions for Microsoft Dynamics SL

Third party budgeting options for Dynamics SL are empowering CFOs and budget managers to effectively and dynamically plan for organizational and departmental growth, through secure and simple collaboration.  This article will discuss elements to consider when shopping for the best budgeting tool for your team.

I think it is safe to say that budgeting for a business is a task most would prefer to avoid.  Maybe this has something to do with the tedious nature of the tools available to budget managers.  Excel spreadsheets that are formatted into a budget might be okay for household planning, perhaps for a smaller company’s budget, due to the relatively small set of data, but growing corporations using Microsoft Dynamics SL are taking notice of the benefits of a third party budgeting solution to enhance their accounting and finance objectives.  Some of today’s more modern solutions streamline the process of budgeting by empowering contributors through secure collaboration.  Planning and managing profit and loss, employee budgets, project budgets, and other areas of a business is a necessary task so that corporation leaders can operate within their financial means, ensuring progress.

Continue reading

Matt Felzke
Automated Budgeting and Reporting for Microsoft Dynamics NAV

Automation is the functionality that makes all modern BI features that much more valuable.  This article will discuss automated budgeting and reporting for Dynamics NAV as a way to more efficiently analyze company data, so you can get to the other tasks on your plate.

Articles about reporting and budgeting for Microsoft Dynamics NAV are all over the place – in print, on LinkedIn, in search results.  In fact, I have written about reporting and budgeting, specifically for Dynamics NAV, on this blog before.  I would imagine that someone who reads these articles might have a subconscious response to the authors: “Maybe you think that generating reports and putting together budgets – and reading about them – is all I do for a living.”  If this is the case, I understand the sentiment.

Continue reading