Building blocks of a report Data The data is brought in from different sources such as KeyedIn or Dynamics. This is then transformed and cleaned to a format which can be used in a report and looks like a table. Data must be in the correct format to work in further calculations down the line, such as showing dates as date format rather than integers. ModelThe model is the collection of different tables from different data sources and how they are related, for instance connecting Dynamics table opportunities to the KeyedIn report with the actual hours worked. FiltersFilters are necessary to give a picture of a subset of the data and works similar to how you might use it in Excel. Measures and calculated columns Calculated columns are a calculation that use the existing data from the model to create a new field, which is calculated on a row-by-row basis. Measures work similarly, but are dynamic and calculate based on the categories you set for it, such as by group or for a certain date. It is completely flexible to what you put it against. VisualsThese are the charts and tables that are visible on the report and pull data, measures, or calculated columns from the model.