City of Austin Enhances Financial and Operational Efficiency with MicroStrategy BI Solution
Company Size
1,000+
Region
- America
Country
- United States
Product
- MicroStrategy
- Visual Insight
- MicroStrategy Mobile
Tech Stack
- Business Intelligence (BI)
- Data Visualization
- Mobile BI
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Cost Savings
- Customer Satisfaction
- Employee Satisfaction
- Innovation Output
- Productivity Improvements
Technology Category
- Analytics & Modeling - Predictive Analytics
- Application Infrastructure & Middleware - Data Visualization
- Functional Applications - Remote Monitoring & Control Systems
Applicable Industries
- Cities & Municipalities
Applicable Functions
- Business Operation
- Quality Assurance
Services
- Software Design & Engineering Services
- System Integration
- Training
About The Customer
The City of Austin, known as the Live Music Capital of the World, is the seat of Texas state government and home to the University of Texas. With a fast-growing population of about 800,000, it is the 11th most populous city in the United States. Austin is a community of unparalleled creativity and progressivism, making it a technologically savvy city with a focus on cost-effective innovation. The city’s Financial Services Department is responsible for managing the city’s financial operations, including budgeting, capital expenditure, and finance applications. The department aims to foster visibility and efficiency through highly intuitive ad hoc reporting and a unified business intelligence platform.
The Challenge
In 2012, the City of Austin’s Financial Services Department received national recognition for an integrated financial portal that provided citizens and staff access to detailed information about the city’s financial operations. Despite this, internal users struggled to access the data they needed. The city’s databases consisted of a combination of home-grown ERP systems and other custom applications, making the process of integrating data for ad hoc reporting extremely time-consuming. This redundancy in user requests for similar types of reports caused the IT department to shift their focus from systems management to answering specific user questions. Every departmental group was attempting to do BI on their own, which was costly from both a maintenance and service perspective. The City of Austin decided it was necessary to look into purchasing an existing off-the-shelf analytics platform.
The Solution
The City of Austin’s financial department began the rigorous process of procuring a new BI solution with a corporate-wide vision in mind. After bringing together key players from each departmental group, the city determined its critical BI requirements to be ease of use for business users, ease of deployment, and holistic functionality. They chose MicroStrategy for its organically grown architecture, which required little to no back-end development and fewer resources. With MicroStrategy, the City of Austin has a standard reporting platform providing citywide data integrity as all reports are created accessing the same data sets and definitions. Through the use of MicroStrategy’s visual data discovery tool, Visual Insight, the organization has been able to push ad hoc reporting down into the workforce. Users are now empowered to quickly and easily satisfy their own reporting needs, freeing the IT department to focus on more value-added work. The city is also experimenting with MicroStrategy Mobile functionality in the field to collect code compliance infraction data on properties.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
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.
