Forum Discussion
Revenue data good prediction analytics
Hi team,
anybody help Revenue data good prediction analytics
I HAve Revenue table With columns
Date,Fee_type,Fee_rate,Total_trasaction,Total_Amount
Here below is my sample date
What type of Prediction i will be create?
I didnt have knowdage in prediction(statistics)side
| Date | Fee_type | Fee_rate | Total_Trasaction | Total Amount |
| 22/08/2019 | A | 3 | 40 | 120 |
| 22/08/2019 | A | 3 | 20 | 60 |
| 22/08/2019 | A | 3 | 10 | 30 |
| 22/08/2019 | A | 3 | 25 | 75 |
| 22/08/2019 | A | 3 | 30 | 90 |
| 22/08/2019 | B | 5 | 5 | 25 |
| 22/08/2019 | B | 5 | 6 | 30 |
| 22/08/2019 | B | 5 | 8 | 40 |
| 22/08/2019 | B | 5 | 9 | 46 |
| 22/08/2019 | B | 5 | 20 | 100 |
| 23/08/2019 | A | 3 | 2 | 6 |
| 23/08/2019 | A | 3 | 9 | 21 |
| 23/08/2019 | A | 3 | 6 | 18 |
| 23/08/2019 | A | 3 | 22 | 66 |
| 23/08/2019 | A | 3 | 35 | 105 |
| 23/08/2019 | B | 5 | 30 | 150 |
| 23/08/2019 | B | 5 | 2 | 10 |
| 23/08/2019 | B | 5 | 4 | 20 |
| 23/08/2019 | B | 5 | 5 | 25 |
| 23/08/2019 | B | 5 | 3 | 15 |
Thanks
Shanvitha
3 Replies
- AnthonyTilleySolution Sage
Im sorry but your questions is not very discriptive.
to help answer your question please refer to the following article and try to include the details needed
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
- Greg_DecklerCommunity Champion
Well, you could turn ML loose on it. But, if you want it to be accurate, you would want to mash it up with external data that is relevant to your business. If you want to do it correctly, I would recommend a company called Prevedere. They have something like 3 million (mostly) publicly available datasets in their cloud-based system that they can run a correlation against your sales numbers in minutes and then provide you with a model that factors in these external influencers to provide you with predictions up to about 18 months in advance.
- v-diye-msftCommunity Support
Hi Anonymous
Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution. if not, please share more details about your question, we'd like to provide further support. thanks!
If you've fixed by your own, it would be much appreciated if you can share your solution here.