Data Model
Data model is a model that organizes data and the relationships of data elements so that the data is ready-to-use and meaningful for every user who needs a report.
- Any time we organize tables and/or query and join them, we are building a data model
- person who accesses the report will not need to organize the data themselves
- can build a query (data model) and save it as a View
- can then leverage this View when using tools like Power BI or Tableau for reporting
- eliminates the need to use the data prep tools in these applications
- can use a hard-coded filter in the query to only process what data is needed up front