BIC: Optimizing Operations with Centralized Dashboards and Reports
![](https://cdn.prod.website-files.com/664e39be771831388fb2a15c/668ee19a5f3c435b972e599c_BIC%20Mockup%20%2B%20Techs%20%2B%20BG.png)
About the company
BIC is an international company whose products can be found across the globe. Known for their pens, lighters, and razors, BIC provides the highest quality essential everyday products and is the #1 brand for quality and affordability.
The challenge
BIC´s Group IT Services team needed to provide a more efficient and optimized service within the company. The Group IT Services team at BIC is responsible for assisting the company’s Centers of Excellence (COEs) with IT operational dashboards and reports that help them better monitor their service performance, optimize, and improve their respective service delivery to the business.
Our team at Tero by Nearsure worked directly with BIC’s Group IT Services team to go beyond the local and regional data and provide solutions that could centralize KPIs through updated dashboards and global reports, overseeing the information needed by COEs such as:
- SLA - Service Level Agreement
- Tickets response and resolution time
- Tickets backlog and aging
- Customer satisfaction
- Demand status
- Company assets
The solution
Tero by Nearsure's team focused on centralizing data and increasing the amount of information available, from a macro level referring to management issues, as well as from a micro-level of operational nature. The project included creating advanced and user-friendly reports in Power BI to retrieve information from various sources of origin, including Remedyforce, ServiceNow, Inventory Management (Snow Inventory), Active Directory and Excel.
Tero by Nearsure also helped the Group IT Services team to consolidate information on users and company assets which were key to having an efficient and standardized process in place for their IT daily operations. The solution consisted of building Power BI dashboards to enable data combination between three different systems that contained helpful information but were working independently up to the moment. Combining data from Active Directory, Office365, and Snow Inventory in the right way, brought more visibility around how to polish their work.
The results
![](https://cdn.prod.website-files.com/664e39be771831388fb2a15c/668e99cb2008fca693154ac5_icon-black-light-bolt.png)
Reduction of ticket aging.
![](https://cdn.prod.website-files.com/664e39be771831388fb2a15c/668e97d7515932d10e465b9b_icon-black-chart-arrow.png)
Increased visibility and efficiency in the daily operations of BIC Group's IT Services team.
![](https://cdn.prod.website-files.com/664e39be771831388fb2a15c/668e98a02cc1cd44c5cc728b_icon-black-diamond.png)
Significant and positive impact on the company's Centers of Excellence processes and performance.
Project highlights
- Dashboards and Reports
- Digitalization
- Integrations
Tech stack
- Power BI
- Office 365
- Active Directory