Bridgei2i helps client save $300,000 on reporting costs and reduce time to insight
Company Size
1,000+
Region
- America
- Asia
Country
- India
- United States
Product
- Tableau
- Bridgei2i Analytics Solutions
Tech Stack
- Tableau
- Google Analytics
- MySQL
- MS Excel
- MS Access
- SharePoint
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Cost Savings
- Productivity Improvements
Technology Category
- Analytics & Modeling - Predictive Analytics
- Analytics & Modeling - Real Time Analytics
Applicable Functions
- Business Operation
- Sales & Marketing
Use Cases
- Real-Time Location System (RTLS)
Services
- Data Science Services
- System Integration
About The Customer
The customer is a global technology company that was struggling with fragmented and inconsistent market forecasting processes. The company relied on a global team to prepare the overall market forecast, which involved multiple static reports primarily delivered in Excel spreadsheets and .CSV files. However, since the insights were not region-specific, each regional team developed its own forecasts using local reports. This lack of a unified view of data across the organization created confusion around the true numbers. The company approached Bridgei2i to help improve its market forecasting processes and deliver a single version of truth for its market share/size forecasting.
The Challenge
The strategy team of a global technology company approached Bridgei2i to help improve its market forecasting processes. Historically, the client organization relied on a global team to prepare the overall market forecast. This involved multiple, static reports primarily delivered in Excel spreadsheets and .CSV files. And since the insights were not regionspecific, each regional team developed its own forecasts as well, using local reports. The lack of a unified view of data across the organization created confusion around the true numbers. The client asked Bridge i2i to build a solution—using 100MB of data— that would deliver a single version of truth for its market share/size forecasting.
The Solution
Bridgei2i suggested creating a master version of the market forecast report that would deliver intuitive, flexible insight into the data. Executives would be able to drill into the data, answering their specific questions and filtering views by parameters such as region or product line. A team of 30, including consultants from Bridgei2i, worked on the implementation. The implementation was carried out in two phases each spanning about 45 days. Bridgei2i accesses data from the client’s Web Portal, from where it can be downloaded in an Excel format. The data sources include Google Analytics, MySQL, Flat files, MS Excel as well as MS Access. The reports are developed and maintained within the client firewall with VPN access and the authentication is completed using Active Directory. Bridge i2i analyzes roughly 100-500M rows of data that using Tableau. Once the analysis is complete, Bridgei2i uploads the final report on SharePoint in the form of a Tableau Packaged Workbook. Client executives can then access required information using the Tableau Reader. The solution is extremely user-friendly, and works on more than 50 devices and across platforms such as iOS and Android.
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
Leading Tools Manufacturer Transforms Operations with IoT
Stanley Black & Decker required transparency of real-time overall equipment effectiveness and line productivity to reduce production line change over time.The goal was to to improve production to schedule, reduce actual labor costs and understanding the effects of shift changes and resource shifts from line to line.
Case Study
Jaguar Land Rover Speeds Order-to-Cash Cycle
At Jaguar Land Rover, vehicles physically move around the facility for testing, configuration setting, rework and rectification, leading to a longer search time to get each vehicle to its next process facility. The main goal is to minimize the vehicles' dwell time between end of line and the delivery chain which was previously a manually intensive process. Jaguar Land Rover's goal was to build on the success of an earlier RFID project and improve the efficiency of delivering vehicles to meet dealer orders.
Case Study
Improve Postal Mail and Package Delivery Company Efficiency and Service
Postal mail and package delivery company wanted to replace legacy yard management system, increase inbound and outbound yard velocity, improve priority parcel delivery time and accuracy, reduce workload and overtime, reduce driver detention and measure performance and utilization of yard resources.
Case Study
Hospital Management Solution
The Oncology Diagnosis and Treatment Center of Brasov wanted to give patients as much freedom to roam as possible, while at the same time ensuring optimal patient safety and security. The centre was in need of an adequate wireless voice communication and messaging solution that would give patients the confi dence that medical staff is always on call, and reduce stress levels of nurses and doctors when called in case of urgent need.
Case Study
Worker Tracking & Safety Monitoring in Construction
One of the main challenges facing the technology was to create a network within underground tunnels and another was to provide products that can withstand harsh working environment. The team used amplifiers to enhance bandwidth and Litum produced IP67-rated hardware that is durable for harsh working conditions.
Case Study
Samsonite Track&Go
Travellers spend their lives discovering new places and meeting new people from all around the world. It can be such a wonderful experience, but sometimes it can turn into a disaster when your luggage gets lost. In 2014 alone, more than 24 million pieces of baggage were lost. Fortunately, 95% of them were found and returned to their owners. However, that leaves more than 1 million items of baggage that have never been recovered.
