Download PDF
Los Angeles County Uses WebFOCUS to Manage Compensation for 100,000 Employees
Technology Category
- Analytics & Modeling - Real Time Analytics
- Application Infrastructure & Middleware - Data Visualization
Applicable Industries
- Cities & Municipalities
Applicable Functions
- Human Resources
Use Cases
- Predictive Quality Analytics
- Real-Time Location System (RTLS)
Services
- Data Science Services
- System Integration
The Challenge
The County of Los Angeles, one of the largest regional governments in North America, faced a significant challenge in managing the compensation and benefits for its approximately 100,000 employees. The county’s previous reporting tools required nightly data dumps and custom coding, which limited analysts’ ability to respond quickly to requests for information. This was particularly problematic when dealing with labor negotiations with state and national labor unions, which represent approximately 80 percent of the county’s workforce. The county needed a more efficient and effective way to extract, analyze, and visualize the immense amount of data involved in managing employee compensation and benefits.
About The Customer
The County of Los Angeles is one of the largest regional governments in North America, with approximately 100,000 employees serving a population of more than 10 million residents. The county’s Chief Executive Office’s (CEO’s) Compensation Section, led by Manager Napoleon Valera, is responsible for all aspects of employee salaries and benefits. His team conducts targeted research and makes recommendations to the County Board of Supervisors about everything from cost-of-living increases to union labor negotiations. The county’s compensation analysts regularly use WebFOCUS to explore salary and benefit scenarios, such as calculating the impact of offering a three percent bonus to a certain group or category of employees.
The Solution
The county worked with Information Builders to create a self-service analytics environment that replaces manual, overnight data dumps with real-time queries and interactive dashboards, charts, and graphs. The county used WebFOCUS to build an analytics portal that empowers people to access, visualize, and analyze data directly – without custom programming. Authorized users select and filter data based on department, bargaining unit, classification, salary range, overtime, and many other variables. The data can be output in multiple formats to computers, tablets, and phones, as well as loaded into Microsoft Excel for further analysis. This menu-driven analytics portal includes dashboards and parameterized display forms for querying the data in a simple, straightforward way. Information Builders Professional Services helped the county develop this expansive analytics environment and mentored the county’s analysts to create additional analytics assets on their own.
Operational Impact
Quantitative Benefit
Related Case Studies.
Case Study
Turning A Stadium Into A Smart Building
Honeywell created what it called the “intelligent system” for the National Stadium in Beijing, China, turning the venue for the opening and closing events at the 2008 Summer Olympics into a “smart building.” Designed by highly controversial artist Ai Weiwei, the “Bird’s Nest” remains one of the most impressive feats of stadium architecture in the world. The 250,000 square meter structure housed more than 100,000 athletes and spectators at a time. To accommodate such capacity, China turned to Honeywell’s EBI Integrated Building Management System to create an integrated “intelligent system” for improved building security, safety and energy efficiency.
.png)
Case Study
Smart Street Light Network (Copenhagen)
Key stakeholders are taking a comprehensive approach to rethinking smart city innovation. City leaders have collaborated through partnerships involving government, research institutions and solution providers. The Copenhagen Solutions Lab is one of the leading organizations at the forefront of this movement. By bringing together manufacturers with municipal buyers, the Copenhagen Solutions Lab has catalyzed the development and deployment of next-generation smart city innovations. Copenhagen is leveraging this unique approach to accelerate the implementation of smart city solutions. One of the primary focus areas is LED street lighting.
Case Study
Buoy Status Monitoring with LoRa
The Netherlands are well-known for their inland waterways, canals, sluices and of course port activities. The Dutch Ministry of Infrastructure indicates that there are thousands of buoys and fixed items in and near water environments that would profit from IoT monitoring. One of the problems with buoys for example, is that they get hit by ships and the anchor cable breaks. Without connectivity, it takes quite some time to find out that something has happened with that buoy. Not to mention the costs of renting a boat to go to the buoy to fix it. Another important issue, is that there is no real-time monitoring of the buoys at this moment. Only by physically visiting the object on the water, one gains insight in its status.
Case Study
China Mobile Smart Parking
Smart Parking, powered by NB-IoT technology, is making it easier for drivers to find free parking spots. Cities can better manage their parking assets and maximize the revenue available to them as a result. Drivers searching for parking create congestion and pollution by circling and hunting for available parking. Smart Parking services are able to significantly ease these problems by guiding a driver directly to a parking space.
Case Study
Barcelona Case Study
Barcelona’s heavy traffic and its associated high levels of pollution were the primary factors that motivated some companies and universities to work on strategies for improving traffic in the city centre. Bitcarrier is one of the technologies involved in the In4Mo Project, whose main objective is to develop the applications that form the core of smart mobility, one of the fundamental pillars of the smart city concept.
