Data Ingestions pipeline for Tier I data

[ATMiddleton]

Issue Description

Create or update the ETL pipeline to ingest Tier 1 data from its source system into the Domo environment.

Tasks

• [x] Apply necessary transformations to the raw Tier 1 data to match the Domo schema and format.
• [ ] Modify the existing dashboard layout to incorporate the new Tier 1 data views, charts, and visualizations.
• [x] Work with stakeholders to define key metrics and performance indicators to be visualized on the dashboard for Tier 1 data.
• [ ] Conduct user testing with stakeholders to ensure the Tier 1 data meets their needs and the dashboard is user-friendly.
• [ ] Based on user testing feedback, make final adjustments to the dashboard, ensuring that it delivers business value and meets user expectations.
• [ ] Implement monitoring tools to track the health and performance of Tier 1 data ingestion and transformation processes.
• [ ] Establish automated data quality checks to ensure the integrity of the Tier 1 data.

Acceptance Criteria

• [x] Tier 1 data is successfully pulled from the source system into Domo.
• [ ] Successful integration of Tier 1 data into Domo with no performance issues.
• [x] Tier 1 data is successfully pulled from the source system into Domo.
• [ ] Tier 1 data is displayed on the dashboard in an organized and clear format.
• [ ] Charts for Tier 1 metrics are aligned with the overall design of the existing dashboard.
• [ ] Timely ingestion and transformation of Tier 1 data with accurate reporting.

• [ ] Data quality maintained with no unresolved issues related to Tier 1 data.

  How to configure this issue

• [ ] Attached to a Milestone (when will this be completed?)
• [ ] Attached to an Epic (what body of work is this a part of?)
• [ ] Labeled with Team (product support, analytics-insights, operations, service-design, Console-Services, tools-fe)
• [ ] Labeled with Practice Area (backend, frontend, devops, design, research, product, ia, qa, analytics, contact center, research, accessibility, content)
• [ ] Labeled with Type (bug, request, discovery, documentation, etc.)

[newworld2616]

• Salesforce report was created. for Tier 1.

• Analyzing the Tier 1 data.

• Next steps are pending.

[ATMiddleton]

All data is visible - the rest of the team will review and provide feedback.

@newworld2616 met with @UXCamG and @UXCamG will provide feedback on aesthetics.

[ATMiddleton]

@UXCamG approved aesthetics.