CompareTrends - Metrics2

CompareTrends provides the ability to compare any metric or trend to another trend with precision.  Many companies have metrics in different systems with trend comparisons built in Excel for one-off comparisons (e.g., how is our Revenue trending compared to the Gross Domestic Product for our Industry).  Finding correlations and determaning trend growth becomes easy and quick with CompareTrends by providing business people a ready-to-use facility with all Company metrics included.    

In mathematics, a square is the result of multiplying a number by itself.  If your Company has 50 Metrics Internally and Externally, and you can compare those Metrics to each other, you have 2,500 comparison combinations (Mertics2 or 502).  This tool allows you compare any metric to other metrics to discover statistical trend direction and trend relationships.  The use case in this page has 1,300 Metrics squared or 1.69M comparisons times 135 Countries for a total number of comparison combinations equaling 228M+.

CompareTrends - Full Screen

This application is built with HTML/5, C#, JavaScript, CSS and SQL.  The screen below has data from 1980 to 2010 (31 periods).  The charts and tables below have been tested at 19,000+ periods (data points) for X-Axis values (could use seconds versus years).  The application can scale for web browser analysis.  All the calculations and computations are done in the database so only clean/aggergate data sets come to the browser (Big Data and Modern Data Science compatible).  Users can also copy raw data from the browser to perform additional analysis in Excel or other tools (see Raw Data below).

The screen below can be formatted and dropdown menus can be changed.  For example, dropdowns could be added for Zone, Region, District, Site and Product.  Dropdowns can have large lists of values for fine-grain analysis.

CompareTrends opens the door for Company Leadership, Management and Associates to compare trends for different Company numbers in a systematic way and with precision versus one-off comparisons.  This solution promotes centralized metrics and cross-comparing metrics with statistical techniques (Regression and Correlation) by Business People which promotes High-level Data Science work and Data-assisted Decisions.

Contact Us to learn more about CompareTrends

«Home Page