Looking for a statistical analysis to identify abnormal behaviour in data. With dynamic dimensions.
A data has following dimensions
1. Date (1-DEC , 2-DEC … 25-DEC)
2. hour (0, 1, 2 …. 23)
3. type (website, app etc.)
With following measures
No. Of hits
We want a solution that can pick each dimension figure and try to identify anomalies
Pick each day and compare with other days (against each dimension) , hours and types
Pick each hour and compare with other hour, days and types
Pick each type and compare with other types, days and hour
Identify if the traffic trends and look for drops and increase systematically
This is just an example .. the number of dimensions/measures should be flexible/dynamic ,
24 freelancers are bidding on average $147 for this job
I can make it from excel, iam familiar with data trend, spike and anomalies , then I can show aggregation data between period, like wow, mom, wtd, mtd etc.