Predictive Analytics Braindump

Owned by Helen Williams
Dec 01, 2023
2 min read

 

Email from Linda Snell 11/30/2023:

He [Chris Sedore] has a specific vision that analytics - other than transactional processing - do not necessarily belong in Slate long term.  He would like us to get to a point where predictive analytics (including enrollment success and other data not housed in Slate) are offered as a service to schools.  He would like you two to be the architects of building out that vision/work in Tableau.  Note this is a long-term goal and one that he would be willing to entertain vendor support to design and build.

 

SCD - Slowly Changing Dimensions

Slowly changing dimensions refer to how data in your data warehouse changes over time. Slowly changing dimensions have the same natural key but other data columns that may or may not change over time depending on the type of dimensions that it is. 

Slowly changing dimensions are important in data analytics to track how a record is changing over time. The way the database is designed directly reflects whether historical attributes can be tracked or not, determining different metrics available for the business to use. 

Slowly Changing Dimensions (SCD): 4 Types & How to Implement

 

  1. Standardization

  2. Data integrity

  3. Transparency!! (Can see the reporting datapoints in a tab or dashboard)