City of Salem at a Glance

Salem is the capital city of Oregon. The City of Salem IT Department provides technical infrastructure and solutions that allow the City’s staff to serve the community. Several functional groups maintain the City’s data and equipment resources within the Information Technology Department. The City of Salem was planning to improve and enhance the citizen experience by streamlining processes through technology with programming, databases, websites, and much more.

Challenges

• Advanced interactive dashboard representations of data was needed using simple user interfaces to help understand data more insightfully.
• To ease out month-end reporting tasks that were becoming stressful and frustrating.
• Reports that could be customized and KPIs monitored using more than one data source.
• To leverage the data to understand the conditions of the community.
• To keep track of the impact of data on current programs.
• Explore the opportunities to improve the service delivery process.
• To get a 360-degree view of all activities that could help identify issues, improve operations, increase sales, and in turn, increase revenue.

Goals

• Data Security and reducing the technology debt by not ever worrying about refreshes and/or upgrades
• Users should be able to use existing reporting formats
• Compatibility of reports with multiple output formats
• Users should be able to combine Data from Different Sources

Our Approach

• We began by understanding the needs at the user level
• We arrived at a compelling, clear, and definitive goal to create a roadmap for the City
• We suggested reporting tool SplashBI for the department to track its performance
• Our approach provided access to live, real-time, drillable data right in Excel
• Users could refresh entire financial packages with the click of a button and drill into the balances on the report

Benefits

• Employees don’t have to rely on outdated spreadsheets and can access simple-to-understand reports and dashboards.
• Reduced cost of maintenance by reducing technical debt.
• Centralized data at one system for the entire city.
• Access empowering those with no coding knowledge to dive deep into analysis.
• BI solution now maintained more thorough customer interaction records and provide a complete view of customer interactions.

6eTechnologies

6e Technologies is a Business Intelligence and Oracle Integration IT services firm with decades of experience with very complex Enterprise Systems. Founded and headquartered in Denver, Colorado. 6e is successfully providing Oracle support services to the Federal Government, Local Agencies, and several Fortune 500 companies.