The client is a utility that serves the Greater Philadelphia region by providing integrated water, wastewater, and storm water services. The utility's primary mission is to plan for, operate, and maintain both the infrastructure and the organization necessary to purvey high quality drinking water, provide an adequate and reliable water supply for all household, commercial, and community needs, and sustain and enhance the region's watersheds and quality of life by managing wastewater and storm water effectively while being good stewards of the environment.

The Client was found to be noncompliant with the CleanWater Act and entered into an agreement with the Environmental Protection Agency by submitting a 25-year plan to protect and enhance waterways by managing storm water through innovative green infrastructure. To fulfill this regulatory obligation, information stored in several existing databases must be integrated into a comprehensive tracking system to eliminate the manual intervention currently required to process the data and to coordinate amongst the disparate data sources.

Services Performed by Data-Core:

  • Analyzed, designed and implemented a comprehensive business intelligence and analytics solution framework
  • Performed the provisioning, installing and configuring of the software Solution Technology Stack on the MS Azure cloud infrastructure

Additional Services Performed:

  • Developed the software to accept data feeds from multiple data sources such as SQL Server, ArcGIS, Mainframe, etc.
  • Extracted, Transformed and Loaded all the data provided by the Client from multiple data sources
  • Built multidimensional cubes based on the data
  • Built reports and KPI dashboards using Dundas BI

Technologies used by Data-Core

  • Microsoft Azure for cloud to host Virtualized Windows Server for SQL Server, Dundas BI Application & IIS Server
  • Microsoft Enterprise SQL Server:
    • SSIS for ETL
    • SSAS for data mining and building multidimensional cubes
    • SSAS for predictive analytics
  • Bing Maps for displaying GIS data
  • Dundas BI
    • Front End User Interface
    • Reporting
    • KPI Dash-boarding

Data-Core Systems has successfully developed a self-service Business Intelligence & Data Warehousing tool that examines the historical, current, and predictive views of data tracked from multiple organizations as part of the Client's 25-year plan. This tool will assist users in streamlining the reporting process and identifying issues, opportunities, and trends associated with internal program targets. This System will give program managers the ability to develop meaningful data driven strategies. Future phases will expand the data analytics capabilities and include the public reporting components of the project.