DAT Query

The DAT Query is the core part of our Data Analytics Tool that allows you to create custom data sets.  You can then use these data sets for:

- DAT Dashboard Element 

- DAT - Printing Results

- DAT Multi-Action

DAT Query items can be categorized and shared with other users based on user roles.

Here is a comprehensive index of the articles for DAT:
DAT Query
--DAT Group
--DAT Dashboard Element
--DAT Chart
--DAT Grid
--DAT Query and DAT Filter Common Mistakes
--DAT Multi-Action
--DAT Calculated/Aggregate Field Condition
--Accessing DAT Query
--Creating New DAT Query
----DAT Query - Step 1
------DAT Query - Step 1 - Choosing Initial Table
------DAT Query - Step 1 - Adding Conditions
--------DAT Field Condition
----------DAT Operator
----------DAT Functional Operator
--------DAT Parameterized Condition
------DAT Query - Step 1 - Selecting Display Fields
--------DAT Display Field
--------DAT Key Id Field
------DAT Query - Step 1 - Connecting Tables
----DAT Fields - Step 2
------DAT Fields - Step 2 - Uniqueness
------DAT Fields - Step 2 - Customizing Display Fields Appearance
------DAT Fields - Step 2 - Sorting
------DAT Fields - Step 2 - Aggregating
------DAT Fields - Step 2 - Pivoting
------DAT Fields - Step 2 - Adding Calculated Field
------DAT Fields - Step 2 - Totaling
----DAT Column Order - Step 3 
----DAT Results - Step 4
------DAT - Printing Results
--------DAT - Creating Templates
--------DAT - Using Templates
----DAT Chart - Step 5
----DAT Save - Step 6
-DAT Diagrams
-DAT Webinar - Attendance
--DAT - Attendance Data Structure
--DAT - Lunch Choices Data Structure
--DAT - Check In / Check Out Data Structure
-DAT Webinar - Development Level I
--DAT - Development Data Structure
-DAT Webinar - Finance
--DAT - Finance AR Data Structure
--DAT - Finance AP Data Structure
--DAT - Finance AR Customer Statement Data Structure
-DAT Webinar - (Re) Enrollment
--DAT - (Re) Enrollment Data Structure
-DAT Webinar - Scheduling
--DAT - Scheduling Data Structure
-DAT - Admissions Evaluations Data Structure
-DAT - Admissions Inquiries Data Structure
-DAT - Admissions Inquiry Actions Data Structure
-DAT - Admissions Inquiry Action Types Data Structure


See also
DAT Fields - Step 2 - Customizing Display Fields Appearance    DAT - Admissions Inquiry Action Types Data Structure    DAT - Finance AR Customer Statement Data Structure    DAT - Admissions Inquiry Actions Data Structure    DAT Fields - Step 2 - Adding Calculated Field    DAT Query - Step 1 - Selecting Display Fields    DAT - Admissions Evaluations Data Structure    DAT Query - Step 1 - Choosing Initial Table    DAT - Admissions Inquiries Data Structure    DAT - Check In / Check Out Data Structure    DAT Calculated/Aggregate Field Condition    DAT Query and DAT Filter Common Mistakes    DAT - Common Student Tables: Households    DAT Query - Step 1 - Adding Conditions    DAT Query - Step 1 - Connecting Tables    DAT - Common Student Tables: Statuses    DAT - (Re) Enrollment Data Structure    DAT - Common Student Tables: Actions    DAT - Basic Student Data Structure    DAT - Lunch Choices Data Structure    CMS Widget - Simple Report Runner    DAT Fields - Step 2 - Aggregating    DAT Webinar - Development Level I    DAT - Development Data Structure    DAT Fields - Step 2 - Uniqueness    DAT - Attendance Data Structure    DAT - Finance AP Data Structure    DAT - Finance AR Data Structure    DAT - Scheduling Data Structure    DAT Fields - Step 2 - Pivoting    DAT Fields - Step 2 - Totaling    DAT Fields - Step 2 - Sorting    DAT Webinar - (Re) Enrollment    DAT Parameterized Condition    CMS Widget - Report Runner    DAT Column Order - Step 3    DAT Webinar - Development    DAT - Creating Templates    DAT Webinar - Attendance    DAT Webinar - Scheduling    DAT Functional Operator    Creating New DAT Query    DAT - Printing Results    DAT - Using Templates    DAT Dashboard Element    DAT Webinar - Finance    DAT Results - Step 4    Accessing DAT Query    DAT Field Condition    DAT Fields - Step 2    DAT Chart - Step 5    DAT Query - Step 1    DAT Display Field    DAT Save - Step 6    DAT Key Id Field    DAT Multi-Action    DAT Diagrams    DAT Operator    Lunch Choice    CMS Widget    DAT Filter    Evaluation    DAT Chart    DAT Group    DAT Grid    Action    User    DAT   
PCR Educator School Information System is an online database engineered for schools and universities to deliver the highest level of flexibility, unique experience, transparent communication and customized design.

Schedule Demo

Please, make sure that all required fields (marked with *) are completed.
    School Name *
    Relation to School *
    select
    Last Name *
    Your First Name *
    Your Email *
    Your Phone # *