Schools Experience Analytics

Enhancing data for analytics

This repository contains some DDL that is used to generate database objects that are more-digestible by PowerBI, which doesn't support geography datatypes or arrays.

How does it work?

To concatenate all of the scripts into full.sql run the following command:

$ make

And how do I apply it to my freshly-imported Schools Experience database?

$ psql --host [your-host] --username [your-username] [your-database] < full.sql

This step is intended to be run as part of the automated analytics data refresh that happens nightly.

Newly-added scripts can just be dropped into the scripts directory, but please remember to run make before committing. The current version of the updater simply grabs the full.sql file from this repo.