The tag has no wiki summary.

learn more… | top users | synonyms

19
votes
10answers
6k views

Best practice or design patterns for retrieval of data for reporting and dashboards in a domain-rich application

First, I want to say this seems to be a neglected question/area, so if this question needs improvement, help me make this a great question that can benefit others! I'm looking for advice and help from ...
1
vote
3answers
5k views

How and when dimensions are filled in a data warehouse schema?

I'm reading Ralph Kimball's books and I'm currently exploring the following data warehouse schema. Are both dimension & fact tables populated during the data warehouse creation/update? How ...
4
votes
2answers
294 views

implementing dynamic query handler on historical data

Context: I have historical data about property (house) sales collected from various sources in a centralized/cloud data source (assume info collection is handled by a third party) Planning to ...