Overview
MS SQL Server Analysis Services (SSAS) is the University’s data modeling platform used to develop and manage the data models that power Power BI (PBI) reports and dashboards. This service provides a centralized, governed source of truth for institutional analytics, ensuring consistency, accuracy, and performance in business intelligence reporting.
Key Features
- Enterprise Data Modeling: Develops structured, reusable data models for institutional reporting and analytics.
- Power BI Integration: Serves as the primary data source for Power BI reports and dashboards.
- Centralized Data Governance: Ensures consistent definitions, calculations, and metrics across reports.
- Performance Optimization: Enhances query performance and scalability for large datasets.
- Secure Data Access: Implements role-based security to control access to sensitive data.
Benefits
- Single Source of Truth: Provides standardized, trusted data models for all institutional Power BI reporting.
- Improved Report Consistency: Ensures metrics and calculations remain uniform across dashboards and reports.
- Enhanced Performance: Delivers fast, reliable analytics even with complex or large-scale data.
- Stronger Data Governance: Maintains control, quality, and security of institutional reporting data.
- Scalable Analytics Foundation: Supports expanding data and reporting needs across the University.
Available to
SSAS services are available to ITS data teams and University departments publishing Power BI reports and dashboards that rely on institutional data models.
Cost
This service is provided as part of institutional data and analytics infrastructure. Additional costs may apply for expanded capacity or specialized development needs.*
*Questions regarding access, eligibility, or pricing, please contact the ITS Service Desk*