Tracking defects, issues, and feature requests is a critical component of any software development and quality control process.The earlier and quicker bugs are resolved, the lower your development cost and the higher your product quality.
Here is a dashboard screenshot for “TestTrack Pro”
Behind the Scenes SQL for the dashboard
Following are sample queries used in our dashboard. […]
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, Project Management, Purchasing, Quoting, Supply Chain, 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, Project Management, Purchasing, Quoting, Supply Chain, 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, Project Management, Purchasing, Quoting, Supply Chain, 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, Project Management, Purchasing, Quoting, Supply Chain, Trader, Transport, Tutorials, Widget, desktop, sales, service
The business of software is a different beast altogether. Companies like Oracle and Microsoft fall into this category of Software business.
These giants have their own established ways to monitor and track their KPIs and we are not focusing on them.
What about that small software company that creates a small Excel based add-ons?
What about the company […]
Product Lifecycle Management KPI Listing
Change Order Cycle Time
Average days open for change orders closed in selected period
Cost of Goods Sold
Cost of Goods Sold (from cost management)
Inventory Value (2)
Inventory Value (by product category)
Manufacturing Steps
Number of routing steps
New Change Orders
Number of change orders created
New Service Requests
Service requests created (not including reopened requests)
Open Change Orders
Number of change orders […]
Product Lifecycle Management KPI Listing
Responses
Responses to marketing campaigns / events
Revenue per Lead
Revenue per lead (for leads generated from marketing activities)
Won Opportunity Amount
Value of opportunities generated from marketing activity and marked “won” in selected period
Active Service Contracts Balance
The value of active service contract lines on as-of date
BOM Levels
Number of bill of material levels
Booked Order Value (2)
Booked […]
