CompareTrends - Metrics2

CompareTrends provides the ability to compare any metric to another metric with precision.  This type of analysis is usually done outside analytic systems in Excel.  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 on efficient HTML/5, C#, JavaScript, CSS and SQL (supports major databases).  To graph and see data, all rows of data must come to the Browser (raw data is shown below).  The screen below has data from 1980 to 2010 (31 periods).  The charts and tables below have been tested at 19,000 periods or rows for each X-Axis for both X and Y areas.  The charts and tables handle 19,000+ data points on the X-axis (Year is shown; however, this changes based on metric).  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.

Many companies have metrics in different systems with metric comparisons built in Excel for one-off comparisons (e.g., how is our Revenue trending compared to the Gross Domestic Product for our Industry).  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 Company metrics and the use of 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