Mandates
Business Intelligence
Establishing a Business Intelligence Competency Center (BICC) using a roadmap
In this mandate, we knew that the company executives fully grasped the importance of business intelligence solutions and the gains they could take away from it.
We also knew that several business intelligence (BI) systems were implemented throughout the years. However, these systems appeared to be inconsistent and unprotected. Their architecture was also inconsistent because various technical teams had worked on it, therefore any developments were made in isolation. Company officials were unhappy and requested a prompt solution.
Our challenges
In this mandate, Larochelle’s challenge included tactfully requesting that all services experts identify gaps, document data governance, draft a communications plan, have a BI solutions strategic view as well as organize and prioritize projects. We also had to ensure information security and solutions architecture as well as evaluate the staff’s appropriate skills.
Larochelle devised a solution that included establishing a Business Intelligence Competency Center (BICC), management training at the BICC and identifying a BICC’s position within the company.
Larochelle prepared a roadmap to implement the BICC, which helped identify objectives and conditions for success, train managers and get their support, identify the BICC’s essential functions tailored to the business, establish and clarify everyone’s roles and responsibilities, create a culture of best practices and determine the effort and budget for success.
Larochelle’s added value
We offered to secure business intelligence at Larochelle Management Consulting to demonstrate our synergy. We clearly demonstrated our expertise by supporting managers. We provided strategic advice covering all the project’s aspects, both politically and organizationally, and ensured governance, communication and technology.
Integrating a business intelligence solution into the operational process
In this mandate, Larochelle Consulting Group was required to meet the specific needs of a major company’s customer service and quality control division. This division handled order processing, customer follow up, product quality for delivery, delivery deadlines, the quality of information throughout the order process as well as returns and repairs procedures.
For this task, the division’s employees were required to manually consolidate information from multiple non-integrated systems. This information was often duplicated, obsolete and outdated, which caused processing delays and errors.
Then, Larochelle developed a data warehouse that included relevant data from all operational systems. We had to make sure that erroneous or missing information could be updated using a Web interface. This data would then be reintegrated into the data warehouse in a central environment containing complete and reliable information.
Finally, all of this information would enable management to draw on the following substantial benefits:
- a complete representation of the client’s needs;
- a better way to trace orders throughout the order process;
- an improvement in customer satisfaction;
- an analyses outlining reasons for returns resulting in a proactive reminder process;
- an improvement in operational procedures.
Our challenges
Larochelle’s main challenges in this mandate were accessing information in several heterogeneous systems and the CRUD (Create, Read, Update, Delete) analysis on all important data. We were also required to define complex business rules relative to updating information in all existing systems.
Larochelle’s added value
We showed that business intelligence was only part of the solution, not an end in itself. Our consultants’ versatility and expertise also demonstrated the type of partnership we share with our clients. We clearly established that Larochelle Consulting Group mastered the client’s business need and offered a complete solution.
RSS