When working with sales data it is often required to calculate values against a certain benchmark. If available, using budgets is certainly the best option. In many situations this is however not an option since even the best managed budgets cannot be [..]Weiterlesen
Today’s post is about a customer project that we worked on the other day. We were asked to provide a dynamic and flexible way to report on inventory and sales performance. We will explain the solution from top to down – starting with a screenshot [..]Weiterlesen
In December 2013 we wrote about the new business area in Power Pivot that we cover for Dynamics NAV customers: sales & receivables.
Since reporting on receivables requires some steps in Power Pivot and DAX that are not very intuitive and obvious, [..]Weiterlesen
Tableau and Microsoft Dynamics NAV are a great combination – NAV stores in depth data about business – Tableau visualizes that data to provide great insights.
This post shows a simple example: an overview of a business (in this case Cronus International [..]Weiterlesen
Today we are blogging about how to report on sales correlations between different products in NAV. This type of analysis is well known in popular online-shops such as Amazon that create product suggestions and can be used for cross-selling, upselling [..]Weiterlesen
Today we are writing about how to create geographic reports in Excel based on NAV’s data. We are using NAV 2013 as the data source. In order to focus on the geography we are using a very simple model. We are just creating a report on the sales of Cronus [..]Weiterlesen
NAVBI provides a feature to jump to NAV from the drillthrough-list of certain data models:
NAV 2009 RTC or NAV 2013 will open a filtered list for that document.
We extended this feature in our current NAVBI-release to allow links to any NAV-Page. [..]Weiterlesen
Wouldn't it be nice to to easily report on NAV data across companies? To use the company as just another dimension to slice the data by? Today's blog post explains how to use Power BI in combination with NAV to create reports such as this one:
Today’s posting is about using NAV to manage all your Power Pivot files. As you may know, Sharepoint and Power Pivot are a great combination: they allow to automate the data refresh, permissions may be managed in Sharepoint groups, and reports may be [..]Weiterlesen
Today’s blog post is about using NAV 2013’s new capability to publish Pages and Queries as OData-Feeds in order to analyse NAV’s data in Excel.
As explained here both Pages and Query object in NAV can be published as Web Services. Microsoft used [..]Weiterlesen