Bridgei2i helps client save $300,000 on reporting costs and reduce time to insight

• 分析与建模 - 预测分析
• 分析与建模 - 实时分析

• 商业运营
• 销售与市场营销

• 实时定位系统 (RTLS)

• 数据科学服务
• 系统集成

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 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.

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.

• The client earlier spent approximately $300,000 per year on various analyst reports specific to each region. With the implementation in place, the investment in the entire market forecasting process has been cut down drastically, to 1/10th of the original amount.
• The time taken to produce the market forecasting reports has been cut down by ten days per quarter.
• Overall, Bridgei2i’s solution using Tableau has been able to show a drastic improvement in the market share process for its client.

• Reduced report development time by ten days per quarter
• Cut market forecasting investment down to 1/10th the original amount
• Saved an estimated $300,000 on analyst reports