Overview

the data warehouse provides access to simplified, curated datasets designed for reporting and analysis it allows institutions to work with their data without needing to understand complex database structures or relationships ampeducator contains many interconnected tables that are optimized for system performance, not reporting the data warehouse restructures this information into a smaller set of clean, flattened datasets these datasets combine the most relevant information into a single place, removing the need for complex joins and making reporting significantly easier available data the data warehouse includes datasets across key areas of the system, such as students, admissions, courses, programs, instructors, sessions, enrollments, grades, attendance, and student account activity each dataset is designed to include commonly used fields, making it easier to build reports and analyze data without additional setup data updates data is securely extracted from the ampeducator system and transformed into structured datasets designed for reporting these datasets are separated from the live application environment and are updated daily this ensures consistent performance, reliable reporting, and minimal impact on day to day system usage using the data warehouse the data warehouse can be used both within the platform and with external tools within ampeducator, these datasets are available in report builder once the feature is enabled, allowing users to create reports using clean, structured data for more advanced reporting, the data warehouse can also be connected to external tools such as microsoft power bi or amazon athena access the data warehouse is available as an add on feature to enable access or learn more, please contact mailto\ support\@ampeducator com next steps continue to the next article to explore the available datasets docid\ wnunql02lsdb1o7g a8qz you can also explore docid 2hwk9jckeqa3xs21to1ru docid\ j0tpcbbrvjek6oeh6p4en