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