Forecasting best practices
Hi could you please share some best practices of forecasting?
Best Answer
-
At a high level, here are a couple of tips that I find helpful.
First, look at your actual transactional data to see what dimensions are important to you. Once you determine the actual dimensions that are of value, create a forecast sheet that includes those dimensions. Just remember, the more detailed you are with dimensions the more lines of data will be required in your forecast. However an hour or two of pre-work when setting the forecast can allow for much more detailed tracking throughout the year.
Second, make sure the metric and dimension names in the forecast align with those in your actual data. Without that, it is much harder to set up cards to show comparisons.
Third, we often place the forcecast data in a Domo online form, so it can be accessed and updated as needed.
Lastly, coming up with the forecast numbers is a bit of art and science. Obviously a good place to start is with prior history. But internal initiatives, market conditions, and other changes will affect future performance.
If you have more specific questions, feel free to post.
I work for Domo.
**Say "Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as "Accepted Solution"5
Answers
-
Did you have any particular aspects of forecasting you were most curious about?
"When I have money, I buy books. When I have no money, I buy food." - Erasmus of Rotterdam1 -
What are you using as your CRM?
0 -
At a high level, here are a couple of tips that I find helpful.
First, look at your actual transactional data to see what dimensions are important to you. Once you determine the actual dimensions that are of value, create a forecast sheet that includes those dimensions. Just remember, the more detailed you are with dimensions the more lines of data will be required in your forecast. However an hour or two of pre-work when setting the forecast can allow for much more detailed tracking throughout the year.
Second, make sure the metric and dimension names in the forecast align with those in your actual data. Without that, it is much harder to set up cards to show comparisons.
Third, we often place the forcecast data in a Domo online form, so it can be accessed and updated as needed.
Lastly, coming up with the forecast numbers is a bit of art and science. Obviously a good place to start is with prior history. But internal initiatives, market conditions, and other changes will affect future performance.
If you have more specific questions, feel free to post.
I work for Domo.
**Say "Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as "Accepted Solution"5 -
@jeaninejiang did any of the above replies help you? If so please mark the correct reply by clicking on "Accept as Solution".
Thanks!
Dani
1 -
the replies are helpful, but is there a location to see examples or use cases to use as references?
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 623 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 690 Automate
- 177 Apps
- 455 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive