1 / 45

Client Data Extraction & Analysis Tool

Easily extract and analyze client information from the system. Generate reports, graphs, and perform trend analysis. Assist in achieving strategic goals.

arceliaa
Download Presentation

Client Data Extraction & Analysis Tool

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. Data Extraction of Clients information from the System

  2. Check the Number of clients you have on the system.On the Client search screen

  3. Report Generator • Step One is to decide on either: • Meeting Date (Date in the Client Meetings Tab) or • Contact Date (Date of first Contact in client profile).

  4. Report Generator • Step Two Preview a Query and undertake an action (Print Labels, Text, Download, MailMerge that query) OR

  5. Report Generator • Step Two Analyse your clients using one of your 30 dropdown menus (Using the Analysis Menu field and the Analysis Button)

  6. You can print this report or copy this data into Excel to generate a graph • This report can also be generated using any combination of the 30 fields.

  7. Step Three • To Graph this data: • Highlight the data you need by moving your cursor over the information • Press Ctrl C (to copy)

  8. Open a new Excel worksheet • CTRL V to paste to information from the report • Adjust details in Excel if required -

  9. Ensure that the Information in Excel remains highlighted Click and follow the Chart Wizard Add in more columns of data to get trend analysis

  10. Highlight Graph in Excel Ctrl C to copy Open up your word document Ctrl V to paste it into your document

  11. Graphical Analysis • Extracting Data from the Graphs into Paint and then into a word document

  12. Generate your Graph • Press Prnt Scrn button on your keyboard • Open up paint (Start – All Programmes – Accessories - Paint) • Ctrl V – Paste

  13. Ctrl to copy the selected area Open up your word document Ctrl V to paste it into your document

  14. Data Extraction of Group Information from the System

  15. Data Extraction of General Public Information from the System

  16. Staff Appointment Tracking Staff Activities Quarterly Reports Meeting Analysis

  17. Staff Activity – Go to Staff Activity Tab Select Staff member Activity Search Link

  18. Meeting Analysis – Go to Reporting Tab Meeting Analysis Link Preview Report Button

  19. Texting Facility: Individual Report Generator

  20. Individual Texting Must allow Text for old clients –Tickbox& Update All new clients Default – YES Format of Number (no – or text)

  21. How the Guidance Information System can assist with Your Strategic Goals

More Related