May 2021: On behalf of the Ed-Fi community, we are pleased to announce the release Analytics Middle Tier v2.4. For more details see What's New.
The Analytics Middle Tier is a set of denormalized analytics views over the database tables backing an Ed-Fi ODS / API, satisfying the user story:
As a district data analyst, I want to build intelligent reporting on the Ed-Fi ODS with minimal learning curve and low risk of breaking changes, so that I can deliver timely data to educators and administrators.
These views form the basis of the Power BI and AWS QuickSight Starter Kits in the Ed-Fi Exchange, and are suitable for use in a wide range of downstream applications.
System administrators install the Analytics Middle Tier into an Ed-Fi ODS database using a command-line utility. Every version of the utility builds on prior releases by migrating the analytics views to the current release, without having to uninstall (though v2.0.0 requires an uninstall of v1.x, if present). The product contains a number of use-case specific collections that are installed as optional components. After install, the system administrator must perform some manual steps to customize the system to the distinct implementation details.
The Analytics Middle Tier contains a core collection of views and a number of use case-specific collections. The Analytics Middle Tier views are a simple representation the Ed-Fi Data Standard, which support a seamless bridge from one version of the Data Standard to the next. The work to simplify and bridge standards comes at cost, however: data analysts and programmers using these views need to understand both their utility and their limitations, or else risk confusion and/or misleading analyses.