Rodney Matejek
Repoting Analyst | Data Analyst | Technical Writer| SQL Developer
Creating simple solutions from complex business requirements
Hover over the images to see descriptions of this presentation. Click the images for a larger view.
Behavior Reporting for the Kentucky Department of Education (KDE)
This overview shows that for the behavior report to be developed, we need to collect the data, verify the elements with all of the school districts, and then format it for the annual report.
This chart shows how data concerning the school, the district, the student, and the behavior event is extracted. It also shows that there are elements that are translated from code into plain text using the data dictionary that comes with the Infinite Campus product.
This flowchart shows where in the database we will be collecting the data, how we join the tables, what keys are used to join the individual tables, and any predicates that qualify the data.
What you see here is an example of the work that I had done for the Kentucky Department of Education. This shows the development for an annual report the statistics of behavior events in each school for each district.
This picture shows the relationship between all the tables where relevant data was extracted from, and then transformed into meaningful data for reporting purposes.
This entity relationship drawing shows how I developed a source map for the elements mostly for my own purposes. This helps me keep in mind where the data comes from, and how we can reach it. The words between the entities are the keys that link the tables together. Dotted line comments are the predicates used in the where statement.