The Zone Data Portal serves as a centralized hub for managing configuration, metadata, and schemas for the Zone Data Warehouse and ZoneReporting clients. Designed to empower clients and partners, the portal facilitates self-service capabilities for ETL, Modeling, and BI Report Management.
By unifying the ETL, Data Warehouse, and BI reports layers in a seamless interface, the Zone Data Portal fosters a cohesive ecosystem for data management, transformation, and visualization.
The Zone Data Portal aims to become the ultimate one-stop-shop for data insights. Users will:
- Gain a unified view of all data sources.
- Understand and relate datasets seamlessly.
- Effortlessly merge data sources into cohesive, actionable reports.
With Zone Data Portal as its UI gateway, you will be empowered redefine how you manage, transform, and leverage your data.
Core Features:
1. Support Management
End-to-End Data Visibility:
- View the entire data pipeline, from raw data ingestion to final reports.
- Identify data sources and understand their relationships.
Enhanced Troubleshooting:
- Trace report issues back to specific ETL stages.
- Access detailed logs for all refresh activities, including start/completion times, schedules, warnings, and errors.
2. User Management
Role-Based Access Control (Admin, Write, Read) to users for security and functionality:
-
- Admin Role: Manage organizational users and permissions.
- Write Role: Modify ETL configurations, schemas, and views.
- Read Role: View system configurations and reports without modification access.
Enhanced Security:
- Restrict access based on roles to ensure data integrity and compliance.
3. Support Management
Notification Customization:
- Define and manage email notifications for refresh statuses, errors, and scheduled tasks.
- Configure organizational settings, such as customer names and preferences.
4. ETL Management
Configuration Editing: Adjust ETL settings, schedules, and metadata.
Data Load Management: Define file processing rules, including raw data folder configurations and Power BI integration.
Task Management: Schedule and manage specific ETL tasks and workflows.
5. Table Schema Management
- Modify schemas, field names, data types, and other metadata.
- Ensure alignment with business requirements and data standards.
6. View Management
- Create and edit data views to support diverse analytical needs.
7. Dataset Management
- Manage tables and views included in datasets.
8. BI Reports Management
Power BI Integration