I have a fundamental problem for the implementation of my company's data warehouse. My company's business is delivering customers' orders, and on days when stores have promotions, we have a severe shortage of drivers to deliver packages. What solution do you suggest to predict and prevent this issue? I have designed a hierarchical dimension for days and hours, but stores run promotions when their sales are low. Please guide me to solve this problem. If you need more information, please let me know
-
I think we definitely we need more information, this doesn't sound like a database problem as it stands. You can start by adding your schema and some example data to the post. Also, please elaborate from a database / technological perspective, why "on days when stores have promotions, we have a severe shortage of drivers to deliver packages" occurs.– J.D.Aug 3 at 17:37
Add a comment
|