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
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
Sign In
Demo
School CRM
Blog
DAT Webinar - Admin/Admissions
DAT Webinar - Admin/Admissions
DAT Webinar - Admin/Admissions
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, 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 Household
s
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 Action
s table
link
vi. Student
Attribute
s table
link
vii. Inquiry
Action
table
link
viii. Inquiry
Attribute
s 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
Action
s
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 Action
s 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 Action
s 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. Printing 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.
DAT - Creating Templates
link
i. Set up data source
link
- Download datasource header file
link
- Create MS Word mail merge document
link
- Upload MS Word document to
DAT
link
ii.
DAT - Using Templates
link
See also
DAT Fields - Step 2 - Customizing Display Fields Appearance
DAT Query - Step 1 - Selecting Display Fields
DAT Query - Step 1 - Choosing Initial Table
DAT Query and DAT Filter Common Mistakes
DAT Query - Step 1 - Adding Conditions
DAT Query - Step 1 - Connecting Tables
DAT Fields - Step 2 - Aggregating
DAT Fields - Step 2 - Uniqueness
DAT Fields - Step 2 - Pivoting
DAT Parameterized Condition
DAT Column Order - Step 3
DAT - Creating Templates
DAT Functional Operator
Creating New DAT Query
DAT - Using Templates
DAT Dashboard Element
DAT Results - Step 4
DAT Fields - Step 2
DAT Query - Step 1
DAT Save - Step 6
Staff Household
Student Action
DAT Filter
Attribute
DAT Query
Action
Staff
DAT
Linkedin
301-947-7380
sales@pcreducator.com
Schedule Demo
Please, make sure that all required fields (marked with *) are completed.
School Name
*
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
*
Your First Name
*
Your Email
*
Your Phone #
*
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.