×
Type in a topic service or offering and then hit Enter to search
Helping Infuse

Helping Infuse a Culture of data Democratization and Data-Driven Decision Making Through an Enterprise-Wide Analytics Platform

About The Client

A wholly owned subsidiary of a diversified Indian conglomerate, our customer is an established market leader in lifestyle electrical solutions and consumer durables. The brand portfolio includes a wide range of products as in Fans, Home Appliances, Switchgears, and Lighting etc.

With a workforce of 1000+ employees aligned to the four lines of businesses, the customer has a large network of suppliers, distributors and dealers across the country.

Overview

The Indian Consumers Durable industry, already facing tough head on competition from the affordable and low-priced Chinese products, is dealing with immense pressure in terms of cost and margin. The reputed brands have to put up with the situation where consumers are increasingly getting attracted towards the lucrative yet low-quality manufacturers.

Untouched with these external market forces, our customer’s day to day operations have heavy reliance on supply chain, logistics and production operations and the aligned workforce. Due to lack of automation and unwanted dependencies on manual processes, it was challenging to keep a finger on the pulse of important business metrics in near real-time.

The enterprise strategy and planning led to a decision to implement an Enterprise-wide analytics solution. The customer evaluated different business intelligence (BI) platforms and service providers. With extensive evaluation,they chose Qlik as their BI platform and Polestar Solutions as the implementation partner.

Client Speaks

In September 2019, we completed 2 years of our partnership with Polestar. I use the term, “Partner” because Polestar has turned out to be much more than just a software implementer. Their approach has consistently been to generate maximum value for our business through their implementations. The best thing about working with Polestar is their understanding of the business processes and business needs. They always give a fair idea about the timelines of implementation and deliver on their words. Their successful implementation on Qlik platform has prompted us to seek their services for different functions and business units

Program Manager-Digital Think Tank

Underlying Situation Analysis

The existing processes and systems – across Sales, Supply Chain, Production operations, Logistics and HR – were enough merely to keep up with ongoing business needs. But, in the hindsight, management realized that there was a dire need to transform the ways of working to underpin the next wave of growth in alignment with the company’s vision.

The supply chain process stretched from manufacturing plants to the customers. Although, owing to multiple data sources such as ERP, Excel, etc. and lack of automation, it was challenging to have an integrated and unified analytics and reporting. The inventory report was not doing the quantity conversion basis on UoM which ultimately gave a wrong picture and resulted in mismatch with the physical inventory in warehouses. The AR report in ERP resulted in inconsistent views as there was no provision to enter manual adjustments. Additionally, collating the data for HR was a challenge. A system was needed that could generate dynamic reports like hiring vs attrition, sales-target achievement, flag overdue tasks and provide insights to retain talent.

The situation diagnosis brought out a few aspects that required immediate attention. All in all, challenges could be summarized as below:

  • icon

    Data resided in multiple disparate systems resulting in silos

  • icon

    Absence of a comprehensive and integrated Analytics covering end-to-end supply chain process and sales

  • icon

    Limited means to keep a real-time tab on performance, demand etc.

  • icon

    Substantial reliance on manual interventions and lack of automation

  • icon

    Effort-intensive maintenance of data in excels

  • icon

    Limited view into historical trends and changes

Post Discovery, the Qlik experts at Polestar worked closely with the business and IT stakeholders to design data models and implement an inter-connected data integration platform touching all possible sources. Each implementation was checked with the business teams to develop a system to optimize their day-to-day interaction with the solution.

The modules delivered - Sales, HR, Branding, Finance, Manufacturing, Logistics, Services. A Qlik-based analytics solution was delivered to help the users identify areas where value needs to be added or unnecessary overheads to be removed/optimized.

Below is the summary of the Key Solutions that we delivered along with the immediate benefits:

The Solution Implementation And The Benefits

The answer to the situation lied in establishing an all-encompassing enterprise-wide Analytics and BI platform that could address the business complexities and enable a data-driven decision-support system. Which required relooking at the data assets holistically across the 4 business lines - Switch Gears, Fans, Lighting and Appliances.

Polestar, in close coordination with the customer’ stakeholders and Qlik, took a big bang approach. Internalizing the customer’s needs, Polestar’s solution was based on two principles - Data Democratization and Insights-Infused Data Management.

In line with the customer’s vision, and keeping in view the complexity arising due to disparate business needs from 4 different business lines, Polestar took a Hybrid execution approach. A hybrid approach was imperative as it was necessary to not just address discrete needs of the individual lines of business - but also have enterprise view and bring out data synergies across lines of businesses. ‘Diversification within a Cohesive and Unified Set-up’ was our guiding principle.

Commencing with a Business Discovery Phase, the execution phase was to implement data management and analytics solutions in an agile fashion with some quick deliverables so the users always know their requirements are captured

Commencing with a Six-Week Business Discovery Phase

We, at Polestar, realized that a successful discovery phase is a key to success. Here is how we handled it:

  • icon

    Aligning an average of XX business stakeholders from each business line and IT

  • icon

    Deploying business analysis and SMEs adept in consumers durable domain

  • icon

    Setting a pre-prepared list of right questions around processes, people and technology

  • icon

    Conduction multiple workshops with individual business lines and eliciting the business requirements around reporting, dashboarding and data sources

  • icon

    A blueprinting exercise that included development and validation of various scorecards, priorities and dashboard wireframes

  • icon

    Leveraging our in-house Knowledge eXchange (KX) portal

  • icon

    At the end of the discovery, we had a signed off Software Requirement Specification (SRS), which included:

    • Finalized KPIs at both levels – enterprise and the four departments
    • Low-fidelity wireframes of dashboards
    • Data dictionary along with high-level business logic
    • An end-to-end data integration landscape

Post Discovery, the Qlik experts at Polestar worked closely with the business and IT stakeholders to design data models and implement an inter-connected data integration platform touching all possible sources. Each implementation was checked with the business teams to develop a system to optimize their day-to-day interaction with the solution.

The modules delivered - Sales, HR, Branding, Finance, Manufacturing, Logistics, Services. A Qlik-based analytics solution was delivered to help the users identify areas where value needs to be added or unnecessary overheads to be removed/optimized.

Below is the summary of the Key Solutions that we delivered along with the immediate benefits:

Lastly, a strong governance mechanism was set up to ensure timely delivery and proactive mitigations of risks. A steering committee was formed to resolve any kind of disputes related to project deviation or scope creep.

Business Outcomes

A holistic view across the business was established and the data from disparate systems (like ERP, SFA, etc.) when put together help in day-to-day planning as well as in long term goal setting.

The BI tool became a go-to platform for all the reviews – Individual, Team and Board reviews. A collaborative effort ensured that every unique business in the company understood how other businesses are handling the common problems. This helped them get a cue for the solutions to their problems.

Put together, the solution resulted into following business outcomes for our customer:

Key Impacts

More Case Studies

Interested In Learning More
About Our Service Offerings?


Copyright © 2021 Polestar Solutions and Services India Pvt. Ltd, All Rights Reserved.