ERP Software Logo

Microsoft Dynamics vendors provide comparisons and opinions to professionals in the ERP/Accounting software selection process

 
 

Posts Tagged ‘Excel’

Put Your Dynamics GP Data to Work by Data Mining with Excel

Data Mining is the root task for deriving business intelligence from your warehouse of data. It defines the process of uncovering relationships, patterns and predictions from raw data using algorithms and other methods to display information in graphical and other easy-to-understand formats. There are multiple ways to do this, but data mining with Excel provides some […]

continue reading...

Web Financial Reporting for Microsoft Dynamics NAV

We’re happy to announce that the future of Business Intelligence (BI) – and particularly financial reporting – is here.  You don’t want to miss this.  I’m referring to the significant development of a complete tool that solves several business problems, with a focus on business user friendliness, powerful flexibility, and secure collaboration.  Allow me to […]

continue reading...

Web Budgeting 101 for Dynamics NAV

You might think you have read everything you might ever need to know about budgeting and forecasting.  We have blogged about how important it is to shop around and do your research to find the easiest to use, most intuitive and collaborative planning software.  We have discussed costs associated with implementation of planning tools, so […]

continue reading...

Budgeting and Forecasting 101 for Microsoft Dynamics

Planning for the financial future of your organization generally entails more than one moving part bringing actual financials and research for the upcoming year to make informed decisions on how to live within the company’s means in the next fiscal year – or for the remainder of this year.  Microsoft Dynamics customers can rest assured […]

continue reading...

BI Product Shopping at Dynamics GPUG Summit

The tradition of the Microsoft Dynamics Summit is upon us – this year, meeting in St. Louis the week of October 14th.  Participants from all over are coming together to network and come away with ways to enhance and upgrade their data management and analytics.  Dynamics user groups, like NAVUG, AXUG, CRMUG, and GPUG will […]

continue reading...

Modern Financial Reporting for Microsoft Dynamics NAV

Financial reporting is figuratively the popular kid in the school of Business Intelligence (BI) – and as the big man on campus, it continues to develop its A-list status by evolving for modern business demands.   Microsoft Dynamics NAV, as do most Enterprise Resource Planning (ERP) systems, offers a native financial report writer, called Report Designer.  […]

continue reading...

Power BI – Creating your First Data Model and KPI.

Part 3 of a 5 part series While PowerPivot isn't necessarily "new technology," businesses are trying to move towards it due to how Excel savvy end users can create their own reports without tying up IT resources. KPI's are just another addition to PowerPivot that allows users to visually analyze data across millions of rows. […]

continue reading...

Multi-year Budgets and Rolling Forecasts for Microsoft Dynamics NAV

Budgeting, planning, forecasting, modeling… I’m guessing these are not your favorite activities.  Most people we talk to about their budgeting processes get visibly frustrated just discussing it.  Planning for a whole year for an entire organization or even just a department, a project, or division can be aggravating, tedious, and overwhelming at times, depending on […]

continue reading...

Investing in a Budgeting Solution is also an Investment in Staff Morale

Who likes to sit down to endure a stream of several e-mails, research on unstable variables, and a consolidation of departmental, divisional data into a budget?  It might be because the process is somewhat naturally tedious, but it also could be related to the software budget managers are relying on to tackle the task.  Manual […]

continue reading...

F9 is Back at the Popular Table – or is it?

F9 was originally released in the second half of the 1980s – and developed as an add-in for DOS, but was soon converted for Microsoft Windows. This simple Excel add-in financial reporting tool it is experiencing a resurgence of popularity recently, according to talk amongst partners. This boomerang shift is perhaps due to a dissatisfaction […]

continue reading...
 

 
 
Live chat by BoldChat