Example of Bridgei2i's market forecasting visualization
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. This information would be used by 900 executives working in roles such as strategy, sales planning, marketing strategy, product management from departments including Global Strategy, Marketing and regional country level Marketing. Because all of these executives would have different questions of the data, the solution would need to allow custom drill-downs at each level of the product/region/business unit.
Customized insight—built with Tableau
Bridgei2i has been successful in delivering business solutions in 12+ projects using Tableau. It has deep expertise as well as knowledge of visualization within the organization. The team chose Tableau for this project mainly due to the software’s ease of use and ability to customize reports on a regional/product level as required by different business users.
For this project, 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.
Bridgei2i is now closely tracking utilization and working on fine-tuning content for its client.