Products
Admissions & Enrollment
After School Activities
API
Cafeteria & POS
School CRM
Data Analytics & AI
CMS
Donations
Enrollment Management System
Financial Aid Management
Finance & Accounting
Fundraising
Point of Sale
Scheduling
Student Information System
Summer School & Summer Camp
Solutions
K-12 Private and Independent Schools
K-12 Public Schools
Colleges & Universities
Medical Schools
Vocational and Technical Schools
International Schools
Dance and Theater Schools
Youth Programs
Why PCR Educator
Team
Knowledge Base
FAQ
Training and Support
School Portal
Customer Portal
PCR independent school management solution and website
Products
Admissions & Enrollment
After School Activities
API
Cafeteria & POS
School CRM
Data Analytics & AI
CMS
Donations
Enrollment Management System
Financial Aid Management
Finance & Accounting
Fundraising
Point of Sale
Scheduling
Student Information System
Summer School & Summer Camp
Solutions
K-12 Private and Independent Schools
K-12 Public Schools
Colleges & Universities
Medical Schools
Vocational and Technical Schools
International Schools
Dance and Theater Schools
Youth Programs
Why PCR Educator
Team
Knowledge Base
FAQ
Training and Support
School Portal
Customer Portal
Sign In
Demo
School CRM
Blog
DAT Query
DAT Query
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
-
DAT - Basic Student Data Structure
--
DAT - Common Student Tables: Actions
--
DAT - Common Student Tables: Households
--
DAT - Common Student Tables: Statuses
-
CMS Widget - Report Runner
-
CMS Widget - Simple Report Runner
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
Linkedin
301-947-7380
sales@pcreducator.com
Schedule Demo
Please, make sure that all required fields (marked with *) are completed.
School Name
Please Enter a Maximum of 100 Characters.
*
Relation to School
*
select
Administration - Database Manager
Administration - Head of School
Administration - Registrar
Development - Director of Development
Finance - Business Manager
Finance - CFO
IT - Director of Technology
Other - Parent
Other - Staff
Other - Volunteer
Last Name
Please Enter a Maximum of 30 Characters.
*
Your First Name
Please Enter a Maximum of 20 Characters.
*
Your Email
Invalid Email
Please Enter a Maximum of 100 Characters.
*
Your Phone #
Please Enter a Maximum of 20 Characters.
*
Household
User
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.