Oct 13 2021 07:24 AM
Oct 13 2021 07:24 AM
I have found a way to automatically develop statistically significant time series segments within Excel for visualizing trends over time. Let's say you have 100,000 customers for which you have sales data in every month this year: January-December. Normally, we just create a simple line graph to plot the trend in overall sales for each month among customers. However, I've developed a template that will first analyze your data and group customers based on their sales pattern over the past 12 months. So, instead of just one line, there may be 5 lines on your graph: each one representing a group (statistically significant time series segment) of customers and their behaviour over the past 12 months. My template seems works to very well.
Oct 14 2021 02:21 PM
are you going to share it with the community?
what if the organization has a pig farmer client and a software development client, you're saying your tool can compare bacon sales and software subscription/sales and do the same for both based on the sales trend? Wow that's awesome do share your tool
Oct 14 2021 02:41 PM - last edited on Dec 14 2021 10:08 AM by Eric Starker
Yes. Let's say your pig farmer client has monthly sales January-December for, let's say, 100,000 customers. When you click a button, my template's algorithm sifts through each month and, in the end, there are 6 time series segments in terms of sales among customers. Now, let's say you take monthly sales data for 100,000 customers of your second client, the software development client, and, you click a button on my template: there may be only 3 time series segments in terms of sales among customers. So, when you compare trends pig client vs. software development client, then, you may see completely different patterns or, perhaps, there may even be some similar ones. I have not yet posted it in my store, however, I do have a free trial template you can try on one column of data to see how each column is analyzed by my template's algorithm before doing the final time series pattern analysis.
Oct 15 2021 05:38 AM