Data and Analytics Resources

Provide Confident Assurance to Your Organization

Internet Not Required: Interact Everywhere with IBM Active Reports

Hillsborough County Public Schools


Background

As the third largest school district in Florida and the eighth largest in the US, Hillsborough County Public Schools (HCPS) touts its high scores with 25 of 30 high schools earning A or B grades during the 2012 – 2013 academic year. Headquartered in Tampa, Florida with over 200,000 students and 250 school sites, HCPS includes urban, suburban and rural/agricultural areas and focuses their improvement projects on enhancing teacher quality and student achievement. Some of the recent projects included how to improve assistant principal and principal hiring, how to better prepare students for college, and how to choose the right teachers and resources for high-need schools.

HCPS knows that making fact-based decisions and the ability to measure performance accurately will boost teacher effectiveness and student achievement. That’s why HCPS turned to Convergence Consulting Group, an expert and trusted Business Intelligence partner, for a well-designed solution.

Challenge

Hillsborough County Public Schools was struggling to communicate current information as needed to all interested business parties, especially in meetings without network connectivity where it was impossible to run existing Cognos reports. Typically, all reports were printed and brought to meetings, where all interactivity was lost. They needed a solution that would:

  • Act interactively for all interested parties
  • Slice and dice by strategic objective owner
  • Summarize performance by strategic objective area or owner
  • Perform quickly, for on demand meeting support
  • Be viewed without connection to HCPS intranet or connection to existing Cognos BI implementation

Solution

CCG presented a three part solution for HBH:

First, a team of consultants was brought in to perform a comprehensive Assessment, Vision and Roadmap (AVR) to develop a strategic BI plan for HBH. CCG analyzed and detailed the current state of HBH’s data services and warehouses. CCG then performed executive workshops to interview key stakeholders and identify needs of the business users to formulate a unified future vision. The AVR resulted in an achievable roadmap of phased initiatives laid out for HBH to successfully fulfill that vision. Second, CCG worked with HBH to select the appropriate Business Intelligence toolset, based on their specific requirements (including ad-hoc analysis, dashboarding and scorecarding, predictive analytics, and mobile integration). MicroStrategy was determined as the best business intelligence platform for HBH, along with SQL Server on the database side.

Third and finally, CCG created a fully-functional proof-of-concept for HBH in MicroStrategy. This actionable POC immediately supported HBH’s investment decision and allowed them to quickly begin reaping the benefits of a realized business intelligence solution.

This solution set in place data quality processes such as address cleansing, integration of 3rd party demographic information and creation of a unified view of the customer from their various entry points, including web site registration, catalog orders, and points of sale (POS). It enabled customer segmentation by volume, regency, and frequency of purchase. This segmentation allowed for HBH’s marketing department to define consumer lists for targeted campaigns and promotions. CCG also created store and market performance dashboards that empowered end users with realtime information, allowing Managers to identify trends and outliers at the store level.

Download Case Study