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"4
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"4 -
@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
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 467 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 173 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive