Please use this article as a supplemental resource for this DAT Webinar


1. Intro link
    a.  The Data Analytics Tool (DAT) is a comprehensive system for creating on-the-fly filters, exports, dashboards, mail merges, emailing, queries and reports supporting advanced database concepts with left joins, logical conditions, aliasing, aggregates, pivots, predefined reports, parameterization, and flexible security access.
    b.  Difference between the DMT and the DAT link
    c. Connecting students to teachers link
        i.  Students taking classes from Teachers  link
        ii.  Students connected to Staff Households  link
2. Creating New DAT Query link
    a. Common tables link
        i. Student table link
        ii. Inquiry table link
        iii. Household table link
        iv. Search for a table or field link
        v. Student Actions table link
        vi. Student Attributes table link
        vii. Inquiry Action table link
        viii. Inquiry Attributes table link
    b. Find applicants applying for 9th grade or higher  link
        i. DAT Query - Step 1 - Choosing Initial Table inquiries link
        ii.  DAT Query - Step 1 - Selecting Display Fields link
        iii.  DAT Query - Step 1 - Adding Conditions link
    c. List of Inquiries Report  link
        i. DAT Query - Step 1 - Choosing Initial Table inquiries link
        ii. DAT Query - Step 1 - Selecting Display Fields link
        iii. DAT Results - Step 4 review results link
        iv. DAT Column Order - Step 3 link
        v. DAT Fields - Step 2 - Customizing Display Fields Appearance - rename fields link
        vi. DAT Query - Step 1 - Adding Conditions link
        vii. DAT Fields - Step 2 - Customizing Display Fields Appearance - Change display format link
        viii. DAT Query - Step 1 - Adding Conditions on a field that is not displayed link
        ix. DAT Parameterized Condition link
        x. DAT Functional Operator link
        xi. Adding multiple conditions link
            - Advanced AND / OR conditions link
    d. Students with Forms Actions  link
        i. DAT Query - Step 1 - Choosing Initial Table students link
        ii. DAT Query - Step 1 - Selecting Display Fields  link
        iii. DAT Query - Step 1 - Connecting Tables Student Actions for "Handbook Policy" link
        iv. DAT Query - Step 1 - Adding Conditions link
        v. DAT Query - Step 1 - Selecting Display Fields action date link
        vi. DAT Fields - Step 2 - Customizing Display Fields Appearance link
        vii. DAT Query - Step 1 - Connecting Tables Using "With or With Out" link
        viii. DAT Fields - Step 2 - Customizing Display Fields Appearance to change date display format link
        ix. DAT Query - Step 1 - Connecting Tables to the same table Student Actions for "Field Trip Permission" and "Photo Release" link
        x. DAT Query and DAT Filter Common Mistakes - Why are there more records now? Limit actions by academic year. link
    e. DAT Fields - Step 2 - Pivoting Inquiry counts by Academic Year link
        i. DAT Query - Step 1 - Choosing Initial Table inquiries and DAT Query - Step 1 - Selecting Display Fields link
        ii. DAT Query - Step 1 - Adding Conditions link
        iii. Add Multi-select condition on academic year link
        iv. DAT Fields - Step 2 - Pivoting link
        v. DAT Save - Step 6 link
        vi. Opening saved DAT Query link
3. Adding DAT Dashboard Element link
    a. Adding a new Data Analytics Grid widget link
    b. Select DAT Query to use link
    c. Adding a new Data Analytics Chart widget link
4. Mail Merging from DAT
    a. Create a student discipline report
        i. DAT Query - Step 1 - Choosing Initial Table students  link
        ii. DAT Query - Step 1 - Connecting Tables discipline  link
        iii. DAT Query - Step 1 - Selecting Display Fields discipline points  link
        iv. DAT Column Order - Step 3 link
        v. DAT Fields - Step 2 - Aggregating discipline points link
        vi. DAT Query and DAT Filter Common Mistakes Add a condition to limit by School Id link
        vii. DAT Results - Step 4  Individual records are different than the totals.  Why?  Default shows unique records. link
        viii. DAT Fields - Step 2 - Uniqueness link
        ix. DAT Fields - Step 2 - Aggregating discipline points again  link
    b. Creating DAT Mailmerge Template link
        i. Set up mail merge data source link
            - Download datasource header file link
            - Create MS Word mail merge document  link
            - Upload MS Word document to DAT link
        ii. Producing DAT Mailmerge Results link
PCR Educator K-12 School Information System is an online database engineered for independent and private schools to deliver the highest level of flexibility, unique experience, transparent communication and customized design. Being a complete cloud-based solution, PCR Educator system guarantees convenient access anytime, anywhere.