What is QlikBAM?

Qlik (pronounced “click”) is the School District of Philadelphia’s new Business Intelligence (BI) dashboarding software.

Qlik Benchmarking, Analytics & Management (QlikBAM) is a suite of interactive dashboards that allow School and District Leaders to track progress at the School, Network, and District levels.

What is the difference between QlikBAM, Infinite Campus, and SchoolNet? When should I use each?

Data do NOT match across systems because the systems show different groups, at different time periods, for different purposes. See the table below to learn more about how these three data sources differ.

Data SystemPurpose/UseHow often is the data refreshed?Who does it show data for?Can authorized users see student names?
Infinite Campus (IC)Student Information and data-entryThroughout the day as new data is enteredStudents enrolled TODAYYes
SchoolNetInstructional management and curriculum engineNightlyStudents enrolled YESTERDAYYes
QlikBAM DashboardsPerformance management, Progress monitoring, Trend anyalsesMonthly or by testing/grade cycleStudents who meet the accountability threshold per metricNo

What data is currently in QlikBAM?

See the table below to learn more about the data that is available in Qlik

Dashboard NameData DescriptionData Source(s)When is the data refreshed?
Average Growth Index (AGI)AGI values associated with the most recent SPR reportState PVAAS filesAnnually (Winter)
BenchmarksBenchmark tests by subject, cycle, and yearBenchmark Test filesFew weeks after close of each testing cycle
Climate MattersAttendance, Truancy, Suspension, and Serious Incident dataIC and SIMSMonthly (first week of month)
Course Marks & CreditsCourse marks, credit accumulation, and progress toward on-time grade promotion/graduationIC Grades and CreditsFew weeks after close of each grading cycle
District Wide SurveysSurvey data at the question and construct level for District and Charter students, parent & guardians, teachers and principalsDistrict-wide survey filesAnnually (early Fall)
EnrollmentOctober 1 Snapshot of student enrollment for District, Charter, and Alternative schoolsIC EnrollmentAnnually (early Fall)
PSSA & KeystonePSSA/Keystone results by subject and yearState Test filesAnnually (Summer)
Reading LevelsAimsweb, Independent Reading Growth, and Instructional Reading LevelsAimsweb and IC GradesFew weeks after close of each testing/grading cycle
School Progress Report (SPR)SPR overall, domain, and metric performance by yearSPR master filesAnnually (Winter)

How do I access QlikBAM?

If you are an authorized user, follow these easy steps:

  1. Log into your SDP Employee Portal
  2. Click on the Qlik BAM icon to launch the Hub
  3. Click on the “Academics and Climate” stream on the left-hand side
  4. Click the application you’d like to open

How do I use QlikBAM?

We have developed a training “Story” for you in the Climate Matters app. Follow these steps:

  1. Open the Climate Matters app from the QlikBAM Hub
  2. Click on “Stories”
  3. Click on “QlikBAM Overview (Climate App)” to launch the training “Story”
  4. Navigate through the slides using your arrow keys or by swiping on a touchscreen

The table below provides a Glossary of common terms used in QlikBAM

AppA Qlik application, composed of sheets, stories, and Bookmarks.
HubA directory display of all of your QlikBAM applications.
SheetA single, interactive page of a Qlik application.
StoryA presentation, which can use interactive data.
BookmarkA way to save a current view on a sheet with your filters.
DimensionAn attribute of an individual or school (or other category) in the data. For example, a student’s test score or a school’s learning network.
MeasureA value calculated in Qlik. Typically used to summarize a dimension, such as the average test score within a Learning Network.
Alternate Measure or DimensionIn some chart (e.g., scatter plots), you may change what is being displayed. Look for a 🔻 symbol, and click to change the measure or dimension.
Filter (verb)To narrow the data you want to review to specific groups, time periods, schools, etc.
Filter PaneA Qlik tool that allows you to select filter values of interest.
Filter SelectionsYour current selections using filtering tools (like the filter pane). These are displayed in a dark gray bar across the top of the QlikBAM app.
VisualizationA tool for analyzing data; includes charts (e.g., bar charts, scatter plots), tables, and numerical representations.
Combo ChartA common type of chart that can represent data as a combination of bars, lines, and circles. The x-axis (horizontal) typically displays a dimension, while the y-axis (vertical) typically displays a measure of that dimension.
KPIKey Performance Indicator. A visualization that shows a high-level summary of important measures of performance. You can find KPI’s on every Overview Sheet within a QlikBAM app.
Drill-down DimensionIn some visualizations, data can be displayed at multiple levels, depending on what is selected.