The Chicago Public Schools Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Chicago Public Schools Business Intelligence Interview Guide

Getting ready for an Business Intelligence interview at Chicago Public Schools? The Chicago Public Schools Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Chicago Public Schools Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Chicago Public Schools.</li>
<li>Practice real Chicago Public Schools Business Intelligence interview questions.</li>
</ul>
Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Chicago Public Schools Business Intelligence interview.


Getting ready for an Business Intelligence interview at Chicago Public Schools? The Chicago Public Schools Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Chicago Public Schools Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Chicago Public Schools.
- Practice real Chicago Public Schools Business Intelligence interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Chicago Public Schools Business Intelligence interview.
        

Overview

Chicago Public Schools Business Intelligence Salary

We've gathered this data from parsing thousands of interview experiences sourced from members.

We've gathered this data from parsing thousands of interview experiences sourced from members.

Chicago Public Schools Business Intelligence Interview Process

We’re given a table of bank transactions with three columns, <code>user_id</code>, a deposit or withdrawal value (determined if the value is positive or negative), and <code>created_at</code> time for each transaction.

Write a query to get the total three-day rolling average for deposits by day.

Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout

Example:

Input:

<code>bank_transactions</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>transaction_value</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>dt</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>rolling_three_day</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>

Rolling Bank Transactions

Write a query to identify customers who placed more than three transactions each in both 2019 and 2020.

Example:

Input:

<code>transactions</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>product_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>quantity</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<code>users</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
 
Output:

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>customer_name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>

Which of the following queries will return a list of customers and the total amount they have spent on orders?

Which of the following queries will return a list of customers and the total amount they have spent on orders?

Customer Orders

Write a query to identify the manager with the biggest team size.

You may assume there is only one manager with the largest team size.

Example:

Input:

<code>employees</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>manager_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<code>managers</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>team</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>manager</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>team_size</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>

Manager Team Sizes

Chicago Public Schools Business Intelligence Interview Questions

Chicago Public Schools (CPS) is one of the largest school districts in the United States, serving over 320,000 students in 600+ schools and employing nearly 40,000 people, most of them teachers. CPS has set ambitious goals to ensure that every student, in every school and every neighborhood, has access to a world-class learning experience that prepares each for success in college, career, and civic life. In order to fulfill this mission, we make three commitments to our students, their families, and all Chicagoans: academic progress, financial stability, and integrity. Six core values are embedded within these commitments - student-centered, whole child, equity, academic excellence, community partnership, and continuous learning. The Office for Students with Disabilities (OSD) provides the tools and resources to ensure that all diverse learners receive a high-quality public education that prepares students for success. OSD is responsible for student evaluations, creating and monitoring Individualized Education Programs (IEPs), and working with schools, staff, and families to fulfill these plans toward greater student development and achievement. A critical area within the Office is to provide financial and operational support to schools, networks, and central office departments, including but not limited to the allocation of special education resources to CPS schools so that every child is provided with the services outlined by a student's IEP. Job Summary: The Data Analyst will support OSD units in the collection, analysis, reporting, and interpretation of data to facilitate informed decision-making, identify trends, ensure that Diverse Learner outcomes are monitored, and to support the continuous improvement of OSD programs and services. Reporting to the Director, Data Management, the Data Analyst will use data to drive progress toward District priority and goals. The Data Analyst will be held accountable for the following responsibilities: <ul><li>Proficiently analyze, manipulate and transform complex datasets from multiple sources using analysis tools such as SAS, SQL, Python, or R to extract meaningful insights</li><li>Apply statistical techniques to analyze data distributions, correlations, and trends, contributing to the development of robust analytical models</li><li>Evaluate data for structural integrity and consistencyCreate and customize reports tailored to departmental needs, ensuring clarity and relevance in communicating key performance indicators; summarize metrics and produce visualizations for key stakeholders</li><li>Utilize data visualization techniques to present findings in an easily digestible and visually compelling manner, aiding departmental stakeholders in understanding complex datasets</li><li>Identify trends and patterns in data, offering valuable insights to support strategic decision-making within the portfolio of departments</li><li>Conduct root cause analysis to uncover the underlying factors contributing to observed trends, providing valuable context for decision-makers</li><li>Follow established department and district-wide processes to ensure the quality, integrity and reliability of data used for analysis</li><li>Collaborate with business and subject matter experts to identify additional data needs</li><li>Ensure data quality and integrity across Offices</li><li>Compile, manipulate, and analyze data using appropriate statistical techniques</li><li>Participate in the District's Data Analyst User Group</li><li>Perform related duties as required</li></ul> Other Requirements: <ul><li>Must work with approved enterprise analytic toolsets (SAS or SQL)</li><li>Adhere to a set of guiding principles for analytic practice as established by the Data Governance Council</li></ul> In order to be successful and achieve the above responsibilities, the OSD Data Analyst must possess the following qualifications: Education Required: <ul><li>Bachelor's degree from an accredited college or university is required; focus in statistics, business, economics, or a related field requiring quantitative coursework, preferred</li><li>Master's degree in a quantitative field of study (e.g., data science), preferred</li></ul> Experience Required: <ul><li>Minimum of two (2) years of professional experience in a relevant field and a role requiring data analysis skills, including experience writing code with data analytic tools (SAS, R, SPSS, STATA, etc) is required. Up to 1 year of full-time, data-related internship experience may be considered against this requirement<ul><li>Minimum of one (1) year of the above professional experience may be considered in combination with a master's degree in a quantitative field of study (E.g., data science, economics)</li></ul></li><li>One (1) or more years of experience as a business analyst or systems analyst, preferred </li></ul> Knowledge, Skills and Abilities: <ul><li>Ability to use or learn SAS or SQL required</li><li>Advanced knowledge of Excel and gSuite applications</li><li>Exceptional verbal and written communication, organizational, and problem-solving skills</li><li>Strong attention to detail and data quality assurance</li><li>Ability to deliver high-quality results in a fast-paced environment, respond promptly to multiple constituencies, and meet established deadlines</li><li>Capable of success both working independently with general guidance and as a collaborative member of a team</li><li>Capable of coordinating efforts and facilitating collaboration with a variety of individuals whose priorities may differ</li><li>Ability to establish priorities and effectively manage time to complete multiple activities or projects concurrently</li><li>Ability to work in a cross-functional team with technical and non-technical personnel from a variety of departments</li><li>Ability to probe and derive the correct technical requirements from a non-technical customer for a particular data-related question</li><li>Flexibility to meet changing departmental needs and priorities</li><li>Ability to work on multiple projects simultaneously</li><li>Capable of adhering to a high level of professionalism at all times across professional interactions</li></ul> Conditions of Employment As a condition of employment with the Chicago Public Schools (CPS), employees are required to: <ul><li>Establish/Maintain Chicago Residency - Employees are required to live within the geographic boundaries of the City of Chicago within six months of their CPS hire date and maintain residency throughout their employment with the district. The Chicago residency requirement does not apply to temporary/part-time positions, however, all CPS employees must be residents of Illinois.</li><li>Be Fully Vaccinated Against COVID-19 - Unless approved for a medical or religious exemption, all employees are required to be up-to-date on COVID-19 vaccinations, including boosters, and to submit proof of vaccination to the district within 30 days of hire. "Up-to-date" on vaccination is defined as being at least two weeks past all primary vaccine doses and any applicable boosters. </li></ul>

Chicago Public Schools Business Intelligence Interview Guide

Overview

Chicago Public Schools Business Intelligence Salary

Chicago Public Schools Business Intelligence Interview Process

Chicago Public Schools Business Intelligence Interview Questions

Chicago Public Schools Business Intelligence Jobs