CPD Data README

Quick Start

What the project does

teacher-cpd-dataform is where event data from DfE Teacher Continuing Professional Development (CPD) is streamed to BigQuery using DfE-Digital/dfe-analytics (https://github.com/DFE-Digital/dfe-analytics).

This event data is then managed by DfE-Digital/dfe-analytics-dataform (https://github.com/DFE-Digital/dfe-analytics-dataform) to create analytics tables for use by the CPD cross-programme data team.

This Creates a centralised repository for all data relevant to analytics within CPD. This helps with everything from drawing insights across NPQ and ECF to improving the quality of Looker Studio dashboards.

How users can get started with the project

Steps for setting up a BigQuery account and access to Looker Studio: How to get access to Looker Studio dashboards and Google BigQuery.docx

Where users can get help with your project

For help understanding dfe-analytics and dfe-analytics-dataform, please reach out to Steven Legg or check the DfE Analytics dataform package ReadMe

For help understanding the tables and data model streamed into BigQuery, please reach out to Emma Harvey and Emilio Campa

Who maintains and contributes to the project

Emma Harvey and Emilio Campa

How-To Guides

Mart Creation

https://github.com/DFE-Digital/teacher-cpd-dataform/blob/master/how_to_guides/how_to_guide_mart.md

PAT Creation

https://github.com/DFE-Digital/teacher-cpd-dataform/blob/master/how_to_guides/how_to_guide_pat_creation.md

Service Account Creation

https://educationgovuk.sharepoint.com/:w:/r/sites/TeacherServices/Shared%20Documents/Teacher%20Services%20Analysts/1.%20Good%20practices/1.%20How%20to%20guides/Managing%20Service%20Account%20access%20to%20BigQuery%20Projects.docx?d=we76b498881ce5784c877c4f179a3301b&csf=1&web=1&e=8zyUUM

TAD Access Guide

https://github.com/DFE-Digital/teacher-cpd-dataform/blob/67bf8ebbc5b113d59b66a4aa45374987a3add284/how_to_guides/how_to_guide_tad_%20bq_access.md

Reference

Best Practice

Mart Creation

https://github.com/DFE-Digital/teacher-cpd-dataform/blob/master/reference/best_practice/best_practice_mart.md

Data Models

CPD Service Data Model

https://github.com/DFE-Digital/teacher-cpd-dataform/blob/master/Explanation/data_models/cpd_service_data_model.md

CPD Data Team Structural Logic Heirarchy

https://github.com/DFE-Digital/teacher-cpd-dataform/blob/master/Explanation/data_models/cpd_data_data_heirarchy.md