top of page

DATA & ANALYTICS| PRODUCT & PROGRAM MANAGEMENT

Anchor 6
q360 logo.png

Q360

Global QUALITY DATA & ANALYTICS

The Challenge

  • Siloed & Static Reporting, and lack of Global KPIs 

  • No Single Version of Truth

  • Time-consuming & Expensive

  • Reactive Analysis/Actions

  • Limited Global Visibility

  • Budget Constraints

  • Multiple Legacy Solutions

The Approach

STRATEGY & VISION - Aligned with Corporate & Supply Chain Business Objectives to enable a 360 Self-Service BI & Analytics Platform

INSIGHT GENERATION - Start wit Quick wins, Build Strong Foundations & Accelerate Time-to-Insight 

DESIGN & DELIVERY - Hybrid-Agile Methodology to generate quarterly ROI, lean teams for cost-optimization and use to templates & data storytelling techniques

CHANGE MANAGEMENT - User adoption & Training to improve analytics competency and enable self-service

product quality.png

The Outcome

Superior Product Quality  & High Customer Satisfaction

operation effi.png

Improved Operational Efficiencies & Talent/Resource Utilization

risk.png

Risk Mitigation - Compliance with regulation & data integrity

democratize.png

Data-informed Decision Making - Democratized Data & Real-time information

single version.png

Single Version of Truth & Global Visibility

STRATEGY + VISION + ROADMAP

STRATEGY & VISION

Roadmap + Budgeting + Branding + Platform Selection

Q360 Vision + Objectives + Capabilities + Outcomes

analytics vision

Q360 High Level Product Features

data analytics platform

Q360 Strategy

Analytics strategy

Q360 Product Roadmap

High Level Roadmap

  • Reimagined how people across Enterprise access and use information to improve data-informed decision making and achieve strategic goals

  • Accelerated "Time to Value" by taking a Holistic approach, consolidating data sets and iteration

  • Focused on a  Consumer/Consumer-centric vision

  • Planned 3-year Road-map to achieve strategic goals

  • Built towards a one-stop-shop App to enable self-service

Anchor 7

INSIGHTS GENERATION

INSIGHT GENERATION

Accelerated Time-to-Value

Actionable Information

BI Tools: Tableau, PowerBI, SQL SSIS, Alteryx, SharePoint, SAP, MS Azure

  • Improved 25+ Key Performance Metrics across Quality, Manufacturing, Planning

  • Generated 13+ Dashboards with actionable insights to highlight key trends and top drivers 

  • Producivity savings of 7500+ hours annually

PROJECT SPOTLIGHT # 1

BLOCKED INVENTORY ANALYTICS

PROJECT SPOTLIGHT # 2

RIGHT FIRST TIME (RFT) ANALYTICS

PROJECT SPOTLIGHT # 3

GLOBAL QUALITY INSPECTION TURNAROUND TIME

ADDITIONAL KPIs, REPORTS & DASHBOARD PROJECTS

  • Quality- Cost of Quality, Defects, Plant, R&D, Brand Quality, Audit Management, Compliance​

  • Consumer Complaints analysis - Customer satisfaction, Sentiment analysis, Returns

  • Sales, Inventory &Operations Planning (SI&OP) Analytics - Inventory Turns, Excess & Obsolete, % Margin

  • Procurement/Sourcing Analytics - Supplier Scorecards, Spend Analyzer, Procurement Performance, Risk & Compliance

  • Manufacturing Analytics - Capacity Utilization, Overall Equipment Effectiveness (OEE), Scrap Rework

  • Planning - Forecast Accuracy, Days of Supply

  • Distribution Analytics - On Time in Full (OTIF), Inventory Accuracy

  • Customer Segmentation Analysis

PROJECT # 1: GLOBAL BLOCKED INVENTORY ANALYTICS

WHAT IS IT?

Stock that is unusable and cannot be classed as unrestricted stock. This stock is “not available” and cannot be planned. Blocked status typically indicates that the stock has been rejected due to expiration or failed inspection (quality reasons).

BENEFITS

  • Working Capital Reduction

  • Productivity Improvement – 50+ hours a month spent by various teams

  • Information Visibility: Outdated information with report sent out once a month

  • Improved collaboration, ease of use and actionable insights – via Material Review Boards

INSIGHTS

  • Blocked Stock distribution across network

  • Focus areas by Region/ Plant/Brand/Category to help expedite the blocked stock process flow – Material Review Board

  • Trends & Top Drivers

  • Improvement opportunities quantification & prioritization

​

DELIVERY

  • Delivery time: 9 weeks

  • Technology used: Tableau Desktop, Tableau Server, Tableau Prep, SQL Server, SAP ECC

  • Cost: $60K

  • Delivery Team:  3 members  Director, Dashboard Developer, Backend Developer 

​

ADOPTION

Quality - Site, Warehouse, Brand, Supplier, QC Labs , Material Management, Manufacturing, GBSC, Planning, CI, SC Finance​

​

Active Users: 200+

Avg # of hits per week: 75

Regions: AMERICAS | EMEA | UK | TR | APAC

​

Blocked stock landing page

Landing Page - using BIDS storyboard

Material Review Board

MRB Dashboard - used in Operational Reviews

PROJECT # 2: GLOBAL RIGHT FIRST TIME (RFT) 

RFT hd.jpg

  • Improved manufacturing efficiency to reduce rework and destruction costs

  • Enabled Global visibility and KPI Standardization including 24x7 access to key metrics

  • Executive leadership utilizing dashboard to drive accountability

  • Optimized resource and talent utilization

  • Developed & Delivered in 5 weeks

PROJECT # 3: GLOBAL INSPECTION TURNAROUND (TaT) TIME

Anchor 1

  • First Dashboard to provide Global Turnaround Time analytics for all manufacturing sites and Quality Control (QC) labs

  • Self-serve capability for all functional stakeholders to access status updates for Inspection samples

  • Improved Turnaround times at multiple sites saving ~$250K/year

  • Laid data foundation for future releases including QC short term scheduling, scenario planning & capacity planning

Inspection Sample Turnaround Time
Global Inspection Time

DESIGN + DELIVERY

DESIGN & DELIVERY

Hybrid Agile+ Lean Team + Tools & Templates+ Data Storytelling 

  • ROI generation with quarterly releases utilizing best practices,templates and data storytelling

  • 13+ Dashboards in 9 months for $200K

  • Hybrid-Agile Methodology adapted from BIBrainz.com

  • Templates: Stakeholder analysis, Project One-pager, KPI identification

  • Datastorytelling: Storyboard from BIbrainz.com

8-12 week releases

New Projects + Iterations + Quick Wins + Bug Fixes + Operational Support

Templates: Project 1-pager, Stakeholder analysis, KPI, Storyboard

planning.png

  • Leadership Approval

  • Kick-Off

  • Stakeholder identification

  • Resource Plan

PLANNING

1-2 weeks

SCOPING

1-2 weeks

scoping.png

  • User Workshops

  • KPI Identification

  • Data Sources

  • Wireframes

SCOPING

1-2 weeks

analytics on fire.png
prototype.png

PROTOTYPE + DEV

3-4 weeks

  • Data Extraction

  • Data Modeling

  • Prototype

  • Review Session(s)

PROTOTYPE + DEV

3-4 weeks

change mgt.png

BIZ READINESS

2-3 weeks

  • User Acceptance

  • Training

  • Launch

  • Hyper-care 

BIZ READINESS

2-3 weeks

Agile & Lean Project Delivery Roadmap *ILLUSTRATIVE*

Q1

Project 1

Quick Win 1

Quick Win 2

Q2

Project 1 Enhancements

Project 2

Quick Win 3

Quick Win 4

Q3

Project 2 Enhancements

Project 3

Quick Win 5

Quick Win 6

Q4

Project 3 Enhancements

Project 4

Quick Win 7

Quick Win 8

Change Management + Operational Support

CHANGE MANAGEMENT

Training + Office Hours + Workshops + Feedback

CHANGE MANAGEMENT

Anchor 9
DATA
LITERACY

Conducted Data Literacy workshops in North America, Europe, UK, Japan and China on these topics:

  • Why BI?

  • Data Literacy

  • What is a KPI?

  • Key BI Concepts

  • BI Methodology

USER
ADOPTION

On-boarded 300+ users across 30+ brands, 10+ business functions globally

  • Weekly Office hours

  • 1-stop shop Portal

  • Interactive Training 

  • Usage dashboard

  • User Survey

Q360 Data Literacy 101 Workshop

Q360%20Portal_edited.jpg

Q360 Communication Portal - Roadmap, Project Updates, Training Material, Key Dates, Quick Links, etc.

ACCOMPLISHMENTS

ACCOMPLISHMENTS

Cost Reduction, Talent Utilization, KPI Improvement, User Satisfaction

Q360 1 Pager Accomplishments 

User Survey - Satisfaction & Adoption

Q360 Accomplishments.jpg
q360 survey.jpg

I'd love to collaborate on your next project!

©2020 Ankush D'Souza. All rights reserved

bottom of page