Working With Pivot Tables

Working With Pivot Tables

Pivot table field list that contains BI4Dynamics dimensions and measures. Attributes are automatically positioned in pivot table rows and columns by dragging and dropping.

Sales over Years

Sales over years

This dashboard includes KPIs in sales area, like Net Sales, Profit, Profit in %, Gross Sales, Sales Discount in % and Net Sales YTD Index. Sales over Years dashboard includes also Net Sales Rolling and Profit Rolling measure for 3, 6 and 12 months.

Sales - Top 30 Customer Table Report

Sales – Top 30 customer table Report

That’s how everyone in your organisation should analyse sales data. Top 20 customers table includes Net Sales, YTD Indexes, Profit and Sales Discount in absolute value and in percentage.

Sales Delivery Performance Dashboard

Sales Delivery Performance Dashboard

Track Sales Delivery Performance based on difference between Shipment date and one of following dates: Planned Delivery / Planned Shipment / Promised Delivery / Requested Delivery.

Sales Delivery Performance Table

Sales Delivery Performance Table

Users can adopt the view by changing Item Category Group and Year slicer to see delivery performance measured by Promised Delivery Date with rich selection of measures.

Sales YTD (Year-to-Date) Overview

Sales YTD (Year-to-Date) Overview

Sales analysis isn’t complete without Year-to-Date selection of measures. This table enables the
view of Net Sales, Sales Invoiced Quantity and Profit.

Sales Orders and Sales Quotes

Sales Orders and Sales Quotes

This dashboard presents trend and actual numbers by years of Sales Quote Amount and Sales Order Amount. Snapshots are stored daily to BI4Dynamics Data Warehouse.

Receivables over Years

Receivables over Years

This overview shows most commonly used KPIs in receivables area, like Receivables Balance, Before Due and Overdue structure, Average Payment Terms, Late payments (Avg. Overdue), Receivables Turnover in Days and important sales measures.

Receivables Due Analysis over Years

Receivables Due Analysis over Years

Receivables structure over years provides information for Before Due and Overdue receivables in absolute numbers and percentages with conditional formatting.

Inventory Value by Aging Group

Inventory Value by Aging Group

Table on the left shows Aging structure buckets. Table on the right shows Inventory Aging by product for specific Aging bucket 1-2 years.

Inventory Aging

Inventory Aging

Graphical presentation of inventory aging buckets by Inventory value over months. Aging buckets can be easily adopted to client’s needs.

Finance Detailed Information by Document Level

Finance Detailed Information by Document Level

The most detailed level in all BI4Dynamics is document level. Docments are grouped by Year-Month group for more efficient work.

Finance Multi Company Profit and Loss Statement

Finance Multi Company Profit and Loss Statement

BI4Dynamics enables financial analysing over multiple companies, companies and currencies.

Purchase Top Vendors Dashboard over Years

Purchase Top Vendors Dashboard over Years

For a strategic overview we use the Top Vendors Dashboard which displays top 9 vendors by Purchase Amount.

Purchase Delivery Performance

Purchase Delivery Performance

With Purchase Delivery Performance we can track how our vendors are performing.

Manufacturing Work Center Anaysis

Manufacturing Work Center Anaysis

ork centre is defined (in NAV) as Machine or Resource. It can be grouped as a Work Center Group. This is an overview of Work Center quantity, cost and Capacity Index over quarters.

Job by Job Task

Job by Job Task

Jobs and Resources cube covers all important measures; Actual, Scheduled and Contracted Type of measures.

BI4Dynamics Profiler Dashboard

BI4Dynamics Profiler Dashboard

Profiler enables analyses of procedures. In this table you can see how many rows were created, changed and how many KB of disk space was needed by procedure.

BI4Dynamics Pofiler Snapshot Badge Table

BI4Dynamics Pofiler Snapshot Badge Table

On this table we see the data over badges that were processed.