The Wisconsin Department of Public Instruction has provided data on all public educational staff in the state each year since the 1994-1995 school year. However, the DPI releases this data in formats that are not conducive to analysis (including simple fixed-width text files until 2008). We have done the arduous ETL process on this data so you can analyze it, leveraging the full power of SQL.

We all anticipate the arrival of the post each day, but did you ever wonder in what order the mail gets delivered? The postal system is highly regimented, and routes are specified very precisely. The "carrier walk sequence" specifies the exact order of mail delivery within a specific carrier route. Now, you can truly see where the mail truck comes and goes before and after your mailbox!

Uses your data! Are you using Active Directory as your organization's punch clock? Curious how much time your corporate users spend logged in to their workstations? This simple but powerful tool can give you powerful insights to hold your employees or users accountable.

Uses your data! You can easily query all of your domain-joined machines to get OS and hardware specifications. Using PowerShell scripts that generate CSVs, this tool converts this data into tabular form.

About InterLinked Insights

InterLinked Insights takes real data and makes it accessible for your analysis. Often, this involves significant ETL (extract-transform-load) and preprocessing of data on the scale of millions of records and gigabytes of data. We allow users to leverage our tools to analyze this data as part of our commitment to bringing transparency to the abundance of data in circulation today.

This system was designed to enable reaching insights from data that is otherwise inaccessible or difficult to analyze. For example, many public records consist of simple fixed-width text files or CSV files. Without loading this into a database, it is almost impossible to make any meaningful sense of this data, and even then, disparate schemas throughout the years can make complex or extensive analysis very difficult. We load such data into our systems, "uniformize" the schema, and offer a frontend portal to our users to analyze this data and form their own insights.

All of our data is either produced internally or consists of public datasets or records (or is data that you supply, which we process and then immediately discard). In the case of public records, we do not own or modify the data, except to correct formatting errors. We simply load the data into our systems so it can be used for analysis. When possible, we also provide instructions on how you can transform these datasets so you can run the same analysis using your own resources.

This system is free and accessible to the general public. However, you must be a registered user in order to access our analytical tools.