Time Tracking Data Model

Overview of the QuickBooks Time Tracking Data Model

The Time Tracking data model is unique in that it assigns several rate options, and includes these calculations:

• Item Rate - based strictly upon the service item sales price
• Billing Rate - based upon item and billing rate assigned to the vendor/employee performing the job
• Price Level Rate - based upon item and price level assigned to the customer:job

Calculations:

• Item Rate * Qty
• Billing Rate * Qty
• Price Level * Qty

Time is measured in minutes.

Features

• Over 300 available fields
• 15 Measures including 12 not available in any QuickBooks report
• 186 Additional DAX measures for Power/Pivot and Power BI
• Time Tracking Records

Output Examples

Schema

AVAILABLE FIELDS	DIMENSION DETAIL LINKS
	Dates and Calendar Dimensions: Transaction Date Job End Date Job Projected End Date Job Start Date More Info on Calendars
	Document Based Dimensions:  Line Attributes
	List Based Dimensions:  Class Company Customer Customer Rep Employee Job Job Rep Other Name Payroll Item Service Item Source Name Vendor
	Linked Information:  NONE

Additional DAX Measures for PowerPivot and Power BI