iDashData, built using the same framework already available in iDashStocks, allows you to import custom data from a webserver in csv format. Any daily, numeric data can be imported and analyzed using the functionality also in iDashData (see below for screen shots). This is an example of the format of the csv file:
Product A,2010-01-01,1
Product A,2010-01-02,2
Product A,2010-01-03,3
Product A,2010-01-04,4
Product A,2010-01-05,5
Product B,2010-01-01,1
Product B,2010-01-02,2
Product B,2010-01-03,3
Product B,2010-01-04,4
Product B,2010-01-05,5
Where the first column is the name of your data, in this case Product A and Product B. The second column is the date of the data. The last column is your data. In this example, this would represent number of units sold.
The data can be imported on a schedule you set, and you can choose to have all the data loaded completely, if your csv file contained the entire database of data you wanted to import. Or you can have it load only new data. For example, if you wanted to create the csv file with only new entries per day. In the example above, each day the csv file would contain two lines: one for Product A's previous day sales and one for Product B's previous day sales.
All of the data analysis tools available in iDashStocks is also available in iDashData; you can compare metrics in charts, set goals or KPI's, review trends in data using the accelerometer to change the scale, etc.
You could even group metrics together. For example, if you had 10 products that you imported, you could group each product by a category or region it was sold in, and use these categories to look for trends.
Try it out, and let us know what you think!
No comments:
Post a Comment