Download PDF
New BI System Improves Operational Performance for Active Community
Technology Category
- Analytics & Modeling - Real Time Analytics
- Application Infrastructure & Middleware - Data Exchange & Integration
Applicable Industries
- Cities & Municipalities
Applicable Functions
- Business Operation
Use Cases
- Process Control & Optimization
- Real-Time Location System (RTLS)
Services
- Software Design & Engineering Services
- System Integration
The Challenge
Addison, Texas, a bustling town with a thriving business community, was faced with budget reductions and the challenge of managing its growing community with fluctuating and limited resources. The city's top managers and council members needed a clearer view into the financial and operational performance metrics of the city. They required real-time metrics about factors that affect Addison’s solvency, such as adhering to budgets and maintaining visibility into public safety issues, public works activities, economic development issues, the activities of the courts, and the myriad proceedings that impact the town and ensure its viability.
About The Customer
Located just 13 miles north of Dallas, Texas, Addison is a bustling town with a thriving business community. The residential population of 14,000 swells to more than 100,000 during business hours as commuters arrive from Dallas to work at major corporations such as Mary Kay, Dresser, and Zurich America. The city prides itself on being a self-supporting organization, but the IT department had a long list of items that needed to be addressed. Effective data mining and the need for real-time data disbursement to stakeholders were paramount. The city needed information management tools to monitor budgeting and other financial requirements, security, system integration, coding, application creation, and work site management. High on the list was performance indicators to justify spending across departments.
The Solution
Addison implemented Information Builders’ WebFOCUS Performance Management Framework (PMF) to create a business intelligence (BI) system that permits various agencies to view project data through dashboards, strategic scorecards, and user-friendly interactive reports. WebFOCUS PMF reveals the financial and operational performance metrics of the town and the trends that affect its administration. Every department uses WebFOCUS to define the scope of key projects, establish budgets, and develop timelines and deliverables. They can work with information in the format that best suits their needs – with very little involvement required from IT. With help from Information Builders Professional Services, the IT team used WebFOCUS PMF to pull financial, operational, and performance data on city projects from a Microsoft SQL Server data warehouse and presents it through interactive dashboards and reports.
Operational Impact
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.
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.