Table of Contents generated with DocToc

• Overview
  • Goals of this repository
  • Datasets and Query Details
  • Golden Dataset Methodology
    • Golden Dataset Diagram

• Documentation
• Scalability
• Cross department communication

• Service_Data
  • For service related reporting, feeds bulk of the reports in the Service Analytics app
• Bevi_data
  • Cleans and processes BEVI work orders, primarily for determining and forecasting truck rolls
• Labor_Compliance
  • Estimates hours worked per day based on gps trip data
• Fleet Data
  • efleet data
  • telogis (gps telematics data)
• zuora_data
  • Dataset for collections reporting
• Query Details

• Created using tabular editor
• All tables, columns, and measures are given descriptors
  • These descriptors populate the data dictionary
• This is incredibly important for others to understand the processes and for them to have a reference when they have questions
• Each PowerBI dataset will have one

• The Service Analytics PBI environment uses a modified version of the golden dataset
• Version history, commentary, and documentation for queires are captured in this github repository
• Additions, updates (optimizations etc.), and changes require a new branch and approval