Matthew Felzke
Business Intelligence for Dynamics SL

There are numerous Business Intelligence tools on the market to enhance Microsoft Dynamics SL.  This article will highlight key features and functions to consider when investing in a BI solution.

The Business Intelligence (BI) and Analytics solutions market continued to grow in 2013, up 8% to a total of $14.4 billion from 2012, according to Gartner.  It is a relatively gradual growth, but the development is steady – and it makes sense.  More than ever, analytics are informing corporate decision-makers how to best move the company forward from real-time, monthly, quarterly, project-specific, beyond the General Ledger (GL) and fiscal perspectives.   The corporate world is shifting from IT-managed reporting, budgeting, and data storage to business user friendly, powerful BI software that takes Enterprise Resource Planning systems like Microsoft Dynamics SL, to new heights of analysis and planning.

Microsoft Dynamics SL is an established accounting product, around for a couple decades and acquired by Microsoft in the early 2000’s.  There are approximately 12,000 customers around the globe, and that number will continue to grow under the Microsoft umbrella.  That all said, Dynamics SL users do not have their heads in the sand.  The growing world of BI solutions offer a variety of options to make the most of Dynamics SL through data analysis and planning for the future.  Namely, the BI marketplace offers reporting, budgeting, dashboards, and data storage options.  This article will discuss the feature and functionality offerings for Dynamics SL users in the current landscape of BI solutions.

Continue reading

Matthew Felzke
Live Reporting for Microsoft Dynamics vs. Data Warehouse and OLAP

Data integrations can be confusing, and they make a difference when picking the right BI tool.  This article will discuss the difference between live reporting for Microsoft Dynamics versus data warehouse or OLAP cube integrations.

Data, data, data.  These days, companies are swimming in it.  Transactional and operational information is a required aspect of conducting business these days – for many reasons, but perhaps, especially when it comes to making important decisions about the future of the company.  Business Intelligence (BI) involves analysis of enterprise data for understanding of trends and trajectories, successes and failures, as well as related planning or forecasting for the fiscal year.

Whether a company is using an OLAP cube or some sort of data warehouse, important company facts and figures, such as transactions, personnel information, and inventory, are used in Enterprise Resource Planning (ERP) systems and BI tools like financial report writers, budgeting solutions, and dashboards.  When selecting which BI tool to use, an important question arises pretty early in the selection process: is it more advantageous to integrate live to and from ERP systems like Microsoft Dynamics, Sage, Acumatica, or SAP Business One, or to integrate to a BI data storage option?

Continue reading