Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

10
  • the database is not only for reporting. As an example: the database will store wich pieces compose a CAR . Each model of car will have their own set of pieces, each one with its price, provider, etc etc. We want to query that data for generating budgets with one click. The budgets should query price of each item, also apply some disccounts based on some calculations of other facts like driver experience, accidents, relations with providers etc (huge etc). Do you think that fits a data wharehouse? Commented May 16, 2018 at 12:50
  • hmm it could do "budget" is an odd word to use if you mean "the cost of a single car assembled from these parts" Commented May 16, 2018 at 13:21
  • yes , you are right with the meaning of budget Commented May 16, 2018 at 13:22
  • if you mean "the average cost of cars by model calculated by summing the part cost from various suppliers, broken down per month" then yes definitely Commented May 16, 2018 at 13:22
  • No, we want the budget to be generated for a new car driver with the actual data (not historical, or reports, just the active data today) . Reporting is another piece of the app. But main work will be to analize and provide an instant budget Commented May 16, 2018 at 13:25