Read about the
Type - 1 approach
Type - 2 approach
Type - 3 approach
Type 4: This type defines the method of creating dashboard using Excel. The data and presentation is all part of the Excel file. This is the most popular approach as it is very easy and affordable to create dashboards. It is the least favourable […]
By DZ Editor
Also posted in Dashboard, Design Tips, Financials, Good, HR, Hospital, IT, KPI, Marketing, News, Product Life Cycle, Project Management, Purchasing, Quoting, Trader, Transport, Tutorials, Widget, desktop, sales, service
Read about the Type 2 Approach
Type 3: This category involves the use of some big vendor BI tool. These BI tools are quite comprehensive and come with tons of options to choose from. They provide ad-hoc reporting and easy dashboard creation options. Once installed and configured, there is often a need to define data layer […]
By DZ Editor
Also posted in Dashboard, Design Tips, Financials, Good, HR, Hospital, IT, KPI, Marketing, News, Product Life Cycle, Project Management, Purchasing, Quoting, Trader, Transport, Tutorials, Widget, desktop, sales, service
This is a continuation of the Dashboard Creation Methods
Type 2: This category involves the use of some Dashboard designing tool. You need to download and install the third party software and learn their basic steps in designing the dashboards. Most often the designing tools offer variety of connection methods to the various databases and write […]
By DZ Editor
Also posted in Dashboard, Design Tips, Financials, Good, HR, Hospital, IT, KPI, Marketing, News, Product Life Cycle, Project Management, Purchasing, Quoting, Trader, Transport, Tutorials, Widget, desktop, sales, service
Are you trying to build a Dashboard or a new Application?
Three are three types of Dashboard Solutions
Type 1: This category defines those tutorials where you built everything from scratch. You write your own SQL queries, database connection methods and create data files. Then you construct your own presentation layer by defining the html, XML and […]
By DZ Editor
Also posted in Dashboard, Design Tips, Financials, Good, HR, Hospital, IT, KPI, Marketing, News, Product Life Cycle, Project Management, Purchasing, Quoting, Trader, Transport, Tutorials, Widget, desktop, sales, service
Here is the list of KPIs/metrics on the dashboard
Inventory Value
Gross Adjustment rate
Accuracy Rate
Category Classification (funnel view)
Quantity by Inventory Cateogyr
Tags: dashboards, inventory dashboard, inventory kpis, funnel charts dashboard, funnel chartquickbooks,peachtree,sugarcrm,small business
Supply Chain KPI Listing
Product Revenue
Product sales revenue (not including service) recognized in selected period (based on AR invoice lines)
Product Revenue Backlog
Value of booked order lines less returns plus deferred revenue backlog (invoiced but not recognized)
Production Value
Value of WIP Completions into Inventory
Production to Plan Rate
Production Standard Value / Planned Standard Value
Receipt to Putaway
Time elapsed from Receipt […]
Supply Chain KPI Listing
Pick Exceptions Rate
Percent of Picks with Exceptions
Pick Release to Ship
Time elapsed from Pick Release to Ship Confirm
Planned Inventory Turns
Planned Cost of Goods Sold / Planned Inventory Value
Planned Margin
Planned Revenue - Planned Costs
Planned Margin Percent
Planned Margin / Planned Revenue
Planned On-Time Shipment
Planned service level (percent of shipments shipped on time)
Planned Resource Utilization
Planned Resource Usage […]
Supply Chain KPI Listing
Annualized Inventory Turns
Annualized COGS / Average Daily Inventory Value
Backlog Value
Value of open, not yet fulfilled, booked order lines
Book To Fulfill Ratio
Booked Order Value / Fulfilled Value
Book to Ship Days
Average of shipped date - firmed date (booked date used if no firmed date)
Booked Order Value
Booked order line value (not including returns or […]
