Overview
the ampeducator data warehouse gives your institution direct access to your reporting data using industry standard analytics tools instead of relying solely on built in reports, you can connect directly to your data using sql, create dashboards in power bi or tableau, or download csv files for analysis in your preferred software the data warehouse is designed for institutions that require deeper reporting, business intelligence, or custom analytics beyond what standard reports provide why use the data warehouse? the data warehouse allows your institution to create custom sql queries build dashboards in power bi, tableau, or other bi platforms download nightly csv exports combine ampeducator data with other institutional data sources perform advanced reporting and analytics access curated reporting tables optimized for analysis unlike the live operational database, the data warehouse is specifically designed for reporting data is organized into a set of curated tables that are easier to query and optimized for analytics enabling the data warehouse the data warehouse is available as an optional add on and must be enabled for your institution once enabled, ampeducator automatically creates your institution's secure data warehouse environment generates your unique access credentials configures nightly data exports makes your reporting data available for sql queries and csv downloads note after the data warehouse is first enabled, data will not be immediately available the initial export is generated during the next overnight processing cycle accessing the data warehouse once enabled, navigate to reports → data warehouse from this page you can view your connection credentials access sql connection details (amazon athena) access csv download credentials (amazon s3) view setup instructions for supported software copy credentials directly into your reporting tools two ways to access your data the data warehouse supports two methods of accessing your institution's data sql queries (recommended) connect directly using amazon athena with any compatible sql client or business intelligence platform common tools include dbeaver power bi tableau microsoft excel python any jdbc or odbc compatible software this option is ideal for interactive reporting, dashboards, and custom analytics csv downloads if you prefer working with files instead of sql, the data warehouse also exports your reporting tables as csv files every night these files can be downloaded directly from secure cloud storage and imported into virtually any reporting or analytics application what's included? the data warehouse currently contains 17 curated reporting tables covering areas including students prospects programs courses enrolments attendance grades financials instructors student activity rather than exposing every table from the live database, the data warehouse focuses on the information most commonly required for reporting and business intelligence, making it significantly easier to work with next steps once your data warehouse has been enabled, you may wish to continue with the following guides tables docid\ wnunql02lsdb1o7g a8qz — learn about each available reporting table example queries docid 2hwk9jckeqa3xs21to1ru — see common sql examples and reporting scenarios connecting to bi tools docid\ j0tpcbbrvjek6oeh6p4en — connect power bi, tableau, dbeaver, python, and more