This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| wiki:ai:affirm [2026/05/15 16:17] – sramasamy | wiki:ai:affirm [2026/05/18 11:29] (current) – sramasamy | ||
|---|---|---|---|
| Line 19: | Line 19: | ||
| - [[# | - [[# | ||
| - [[# | - [[# | ||
| - | - [[#8_exporting_delivering_the_report|Exporting & Delivering the Report]] | + | - [[#8_Support Details| Affirm Support Details]] |
| - | - [[# | + | |
| - | - [[# | + | |
| - | - [[# | + | |
| - | - [[# | + | |
| ---- | ---- | ||
| Line 205: | Line 200: | ||
| < | < | ||
| - | ==== 7.7 Review the Rendered Report ==== | + | ==== 6.7 Review the Rendered Report ==== |
| - Wait for all visuals on every report page to finish rendering. The status bar should display **Updated**. | - Wait for all visuals on every report page to finish rendering. The status bar should display **Updated**. | ||
| Line 211: | Line 206: | ||
| - Visually confirm: (a) date range in the cover matches the requested window, (b) organization name is correct, (c) selected evaluators and methods appear on the details pages. | - Visually confirm: (a) date range in the cover matches the requested window, (b) organization name is correct, (c) selected evaluators and methods appear on the details pages. | ||
| - | ==== 7.8 Export the Report ==== | + | ==== 6.8 Export the Report ==== |
| - Click the **download / export** icon in the top toolbar (highlighted in red in Figure 13 below). | - Click the **download / export** icon in the top toolbar (highlighted in red in Figure 13 below). | ||
| Line 218: | Line 213: | ||
| - Save the file using the naming convention defined in Section 9. | - Save the file using the naming convention defined in Section 9. | ||
| - | {{:affirm:affirm_perf_export.png?700|Figure 13. Export the report.}} | + | {{ :wiki:ai:pic13.png?600 |}} |
| - | //Figure 13. Export the report — the export icon is highlighted at the top-right of the toolbar.// | + | |
| - | ===== 8. Procedure — Generate AI Health Report ===== | + | ===== 7. Procedure — Generate AI Health Report ===== |
| The AI Health Report shares the Organization / AI Asset / Evaluator / Date filter pattern with the Performance Report, plus two additional filters specific to health monitoring: **Trending Days** and **is_normalized**. | The AI Health Report shares the Organization / AI Asset / Evaluator / Date filter pattern with the Performance Report, plus two additional filters specific to health monitoring: **Trending Days** and **is_normalized**. | ||
| - | ==== 8.1 Open the Report ==== | + | ==== 7.1 Open the Report ==== |
| - From the Power BI Home page (after Section 6), click **AI Health Report - CDW**. | - From the Power BI Home page (after Section 6), click **AI Health Report - CDW**. | ||
| - The report opens on the **Cover** page with the Filters pane on the right. | - The report opens on the **Cover** page with the Filters pane on the right. | ||
| - | ==== 8.2 Apply Common Filters ==== | + | ==== 7.2 Apply Common Filters ==== |
| Apply the following filters in order, using the same procedures as for the AI Monitoring Performance Report: | Apply the following filters in order, using the same procedures as for the AI Monitoring Performance Report: | ||
| - | * **Organization** (or Organization(s)) — see Section | + | * **Organization** (or Organization(s)) — see Section |
| - | * **AI Asset** (or AI Asset(s)) — see Section | + | * **AI Asset** (or AI Asset(s)) — see Section |
| - | * **Evaluators** — see Section | + | * **Evaluators** — see Section |
| - | * **Report Date Range** — see Section | + | * **Report Date Range** — see Section |
| - | ==== 8.3 Set Trending Days ==== | + | ==== 7.3 Set Trending Days ==== |
| - | **Trending Days** defines the lookback window used to compute the **Trend %** column shown in the AI Health Snapshots table. The default value is 7. | + | **Trending Days** defines the lookback window used to compute the **Trend %** column shown in the AI Health Snapshots table. The default value is 0. |
| - Expand **Trending Days** in the Filters pane. | - Expand **Trending Days** in the Filters pane. | ||
| Line 249: | Line 243: | ||
| - Click **Apply filter**. | - Click **Apply filter**. | ||
| - | {{:affirm:affirm_filter_trending_days.png?350|Figure 14. Trending Days.}} | + | {{ :wiki:ai:pic14.png?400 |}} |
| - | //Figure 14. Trending Days — set to 7 for a weekly trend window.// | + | |
| < | < | ||
| - | ==== 8.4 Set is_normalized ==== | + | ==== 7.4 Set is_normalized ==== |
| **is_normalized** determines whether the **Actual Normalized Score** column on the AI Health Snapshots page uses normalized values. | **is_normalized** determines whether the **Actual Normalized Score** column on the AI Health Snapshots page uses normalized values. | ||
| Line 261: | Line 254: | ||
| - Tick **True** to show normalized scores, **False** to show raw scores, or both for comparison. | - Tick **True** to show normalized scores, **False** to show raw scores, or both for comparison. | ||
| - | {{:affirm:affirm_filter_is_normalized.png?300|Figure 15. is_normalized filter.}} | + | {{ :wiki:ai:pic15.png?400 |}} |
| - | //Figure 15. is_normalized — choose True, False, or both.// | + | |
| < | < | ||
| - | ==== 8.5 Review the AI Health Snapshots Table ==== | + | ==== 7.5 Review the AI Health Snapshots Table ==== |
| Navigate to the **2- AI Health Snapshots** page. The table shows one row per Evaluator × Method × Data Type combination. | Navigate to the **2- AI Health Snapshots** page. The table shows one row per Evaluator × Method × Data Type combination. | ||
| - | {{:affirm:affirm_health_snapshots.png?700|Figure 16. AI Health Snapshots.}} | + | {{ :wiki:ai:pic16.png?400 |}} |
| - | //Figure 16. AI Health Snapshots — example output for AI Asset ' | + | |
| Columns to verify: | Columns to verify: | ||
| Line 282: | Line 273: | ||
| * **Trend % (N Day(s))** — directional change vs. baseline. Green up-arrow indicates improvement; | * **Trend % (N Day(s))** — directional change vs. baseline. Green up-arrow indicates improvement; | ||
| - | ==== 8.6 Review the Cover and Evaluator Group Pages ==== | ||
| - | - Confirm | + | ==== 7.6 Export |
| - | - Page through **3- Evaluator_Group 1** to **17- Evaluator_Group 15** to verify each evaluator group renders without errors. | + | |
| - | {{: | + | Follow the same export procedure as Section 6.8. PDF is the default delivery format unless the requestor specifies otherwise. |
| - | //Figure 17. AI Health Report — Cover page with full filter pane (Organization, | + | |
| - | ==== 8.7 Export the Report | + | ==== 8. Affirm Support Details |
| + | Following are the details of Affirm support, in case of any Power BI Access Issue or Technical issue. | ||
| + | * **Teams Channel:** CDW AFFIRM Support Chat | ||
| - | Follow the same export procedure as Section 7.8. PDF is the default delivery format unless the requestor specifies otherwise. | ||
| - | ===== 9. Exporting & Delivering the Report ===== | ||
| - | |||
| - | ==== 9.1 File Naming Convention ==== | ||
| - | |||
| - | Use the following pattern for every exported file: | ||
| - | |||
| - | < | ||
| - | |||
| - | **Example: | ||
| - | |||
| - | * Use ISO date format (YYYY-MM-DD) for sortability. | ||
| - | * Increment the version (v1, v2, …) only when re-exporting the same report for the same period. | ||
| - | * Avoid spaces and special characters in file names. | ||
| - | |||
| - | ==== 9.2 Storage Location ==== | ||
| - | |||
| - | * Save the exported file to the shared client delivery folder under the client' | ||
| - | * Do not store exported reports on personal drives or local desktops. | ||
| - | |||
| - | ==== 9.3 Delivery ==== | ||
| - | |||
| - | - Hand the file to the Reviewer / QA along with a link to the original report request. | ||
| - | - After Reviewer sign-off, Client Delivery sends the report to the client via the agreed channel (secure email, client portal, etc.). | ||
| - | - Log delivery in the request ticket: file path, delivery date, recipient. | ||
| - | |||
| - | ===== 10. Validation Checklist (Before Sending to Client) ===== | ||
| - | |||
| - | The Reviewer must check every item below before approving the report for delivery. Do not skip items even if they look obvious. | ||
| - | |||
| - | ^ ✓ ^ Check Item ^ | ||
| - | | ☐ | You are in the **Synergist Technologies, | ||
| - | | ☐ | Exactly **one** Organization is selected, and it matches the ticket. | | ||
| - | | ☐ | The Date / Date Range shown on the Cover page matches the requested period. | | ||
| - | | ☐ | AI Asset(s) selected match the ticket. | | ||
| - | | ☐ | Evaluators and Methods selected match the ticket. | | ||
| - | | ☐ | All report pages have rendered fully — no " | ||
| - | | ☐ | AI Health only: Trending Days value and is_normalized selection match the ticket. | | ||
| - | | ☐ | No filter warning banner (e.g., " | ||
| - | | ☐ | Exported file opens cleanly in the target application (Adobe Reader / PowerPoint / Excel). | | ||
| - | | ☐ | File name follows the convention in Section 9.1. | | ||
| - | | ☐ | File has been saved to the client delivery folder, not to a personal drive. | | ||
| - | |||
| - | ===== 11. Troubleshooting ===== | ||
| - | |||
| - | ^ Symptom ^ Resolution ^ | ||
| - | | Power BI link opens but the report is not visible. | Confirm you switched to **Synergist Technologies, | ||
| - | | Filters pane is empty or missing. | Click the **Filters** chevron (>) on the right edge of the report canvas. If still missing, hard-refresh the browser with **Ctrl+F5**. | | ||
| - | | Date filter shows no data. | The selected date range may be outside the dataset' | ||
| - | | Trend % column shows blanks. | Trending Days is greater than the date range. Reduce Trending Days or extend the date range so the baseline window fits inside the dataset. | | ||
| - | | Export to PDF cuts off the right edge. | Open the report' | ||
| - | | " | ||
| - | | Report shows different data on refresh. | The underlying dataset was refreshed between renderings. Note the **Data updated** timestamp in the file name suffix so the delivered file is reproducible. | | ||
| - | | Multiple organizations appear selected. | **Stop.** Clear all filters using the eraser icon at the top of the Filters pane, then re-apply Section 7.3 carefully. Do not export until exactly one organization is selected. | | ||
| - | |||
| - | ===== 12. Recommended Practices & Tips ===== | ||
| - | |||
| - | * Always **clear all filters** (using the eraser icon at the top of the Filters pane) before starting a new client' | ||
| - | * Apply filters in the order listed in this SOP — Date → Organization → AI Asset → Evaluator → Method — to minimize report re-renders and to keep an auditable trail. | ||
| - | * Take a screenshot of the Filters pane before exporting. Attach it to the request ticket as evidence of the filter set used. | ||
| - | * If the requestor is unclear about Evaluator or Method, default to **Select all** and discuss the resulting report with them, rather than guessing. | ||
| - | * Lock the date range with explicit start/end dates when delivering to a client. Avoid **Relative date** for client deliverables — relative filters produce different numbers on re-run. | ||
| - | * Use **Relative date** for internal recurring monitoring views where the most recent data is wanted on each open. | ||
| - | * Run the report twice in two browser windows when verifying parity (e.g., comparing two date ranges). Use Edge in one window and Chrome in another to detect any browser-specific rendering issues. | ||
| - | * Document any filter combination that produces unexpected results and escalate to Data Engineering with a screenshot and the exact filter set. | ||
| - | * Never share screenshots or exported reports outside the agreed delivery channel. Both reports contain client-confidential AI performance data. | ||
| - | |||
| - | ===== 13. Revision History ===== | ||
| - | |||
| - | ^ Version ^ Date ^ Author | ||
| - | | 1.0 | Prior to 2026 | Reporting Ops | Initial draft of the Affirm Power BI report generation procedure. | | ||
| - | | 2.0 | 15 May 2026 | Reporting Ops (Enhanced) | ||
| - | |||
| - | ---- | ||
| - | //Powered by Synergist Technology | ||