DAT Webinar - Admin/Admissions
Posted July 23, 2019
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 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. 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
Related articles
More from the Knowledge Base
Still have questions?
Live chat is staffed weekdays 8 am to 7 pm ET. Tickets get a response within one business day.
New to PCR Educator?
If you landed here from a search and want to see what PCR Educator can do, the demo is the fastest way in. Thirty minutes, no commitment.