1 / 15

Users will need to complete three core steps to build a query: Define the population

Users will need to complete three core steps to build a query: Define the population Segment the population (optional) Select attributes. Service Level 3 users will be able to Benchmark their portfolios from this page. Click Get Started >> to continue. Page One in Define the population

marv
Download Presentation

Users will need to complete three core steps to build a query: Define the population

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Users will need to complete three core steps to build a query: • Define the population • Segment the population (optional) • Select attributes Service Level 3 users will be able to Benchmark their portfolios from this page Click Get Started >> to continue

  2. Page One in Define the population Select values for Time and View Select view: define how to aggregate the data1) Portfolio view: trades – de-duped2) Market view: consumers – all consumers* A Portfolio view will have impact to consumer type attributes later on Click Next >> to continue

  3. Page Two in Define the population Select values for Account type, condition and distinction • Note that the Active query build (AQB) menu is now populated with previously made selections • Titles are hyperlinked for easy navigation

  4. Page Two in Define the population Select values for Account type, condition and distinction Account distinction (new accounts): Narrow the base population to only those recently opened accounts, or use “New" as an attribute to measure open rates Click Next >> to continue

  5. Page Three in Define the population – Service Level 2 and 3 users only: Select values for Peer groups Peer selections are driven off of Account Type Click Next >> to continue Click Skip Segmentation >> to accept default selections and go straight to attributes OR

  6. Page One in Segment the population Select values for Geography Geographyselections include National, Regional, State or MSA Click Next >> to continue

  7. Page Two in Segment the population Select values for Score Score: select Score classifications or create unique score groupings using Score bands Narrow the base population to only those accounts in a specific risk segment, or use “Score classification" as an attribute to create score distributions Click Next >> to continue

  8. Final step: Select attributes Step 1: Attribute types available are determined by the View, Account type, Account condition, Account distinction and Score selections in the query build process Click Select attribute values >> to continue

  9. Final step: Select attributes Step 2: Attribute values are determined by the type of attribute selected and in some instances,the account type for Loan Amount and Balance amount values Click Review query >> to continue

  10. Review query • Name query • Save or Save & submit query Once all selections have been reviewed, name the query, which will also be the name of the associated report once it completes processing Click Save query >> to save it to the system for submission at another time OR Click Save & Submit >> to submit it for processing now

  11. After submitting a query for processing, the user will be navigated to the Thank you page To view the query in the active dashboard, select the Query & Report Management Dashboard link

  12. Use the page title links to navigate between activities Manage queries and reports from the Dashboard To view a query or a report, click into the title

  13. Review output results: Print, download or graph The “Graph it” button will display only for those grids with < or = to 120 cells, determined by the Time and Geography selections made in the query

  14. For Service Level 2 and 3 users, a list of Top 10 lenders is produced for each Account Type / Peer Group combination in the query Download>> or Print>> the results

  15. Review graphed output results: • Percentage values will always be on the Y axis • Time values will always be on the X axis • Bars will identify the geography Download>> or Print>> the graph

More Related