Skip to content

darrynv/da-demand

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 

Repository files navigation

Data Analytics Process Flow

This document outlines the complete data analytics process flow from initial business request through to BAU support.

Table of Contents

Process Overview

The Data Analytics process consists of three major phases:

  1. Requirements & Design Phase: Capturing business needs and defining technical specifications
  2. Build & Test Phase: Developing, integrating, and validating the solution
  3. Release Phase: Deploying to production, providing warranty support, and transitioning to BAU
%%{init: {'theme': 'neutral'}}%%
flowchart LR
    A[Requirements & Design] --> B[Build & Test]
    B --> C[Release]
    
    classDef nsw fill:#7CBAD8,stroke:#5A9BC0,color:#333333,stroke-width:1px
    class A,B,C nsw
Loading

Key Stakeholders

  • Business Requestor (BR): Initiates requests and provides business requirements
  • Demand Manager (DM): Manages incoming business requests
  • Business Relationship Manager (BRM): Prioritizes requests and assigns resources
  • Business Analyst (BA): Gathers requirements and creates specifications
  • Delivery Manager (DLM): Manages resource allocation and project delivery
  • Data Engineer (DE): Designs and implements technical solutions
  • Release Manager (RM): Coordinates deployment activities
  • Ops Manager (OPS): Oversees operational aspects
  • Support Team (SUPP): Provides ongoing support after release
%%{init: {'theme': 'base', 'themeVariables': { 'primaryColor': '#004990', 'primaryTextColor': '#fff', 'primaryBorderColor': '#1B3F72', 'lineColor': '#004990', 'secondaryColor': '#c9d7e4', 'tertiaryColor': '#f9f9f9' }}}%%
flowchart LR
    BR([Business Requestor])
    DM([Demand Manager])
    BRM([Business Relationship Manager])
    BA([Business Analyst])
    DLM([Delivery Manager])
    DE([Data Engineer])
    RM([Release Manager])
    OPS([Ops Manager])
    SUPP([Support Team])
    
    BR --- DM
    DM --- BRM
    BRM --- BA
    BA --- DLM
    DLM --- DE
    DE --- RM
    RM --- OPS
    OPS --- SUPP
    
    classDef business fill:#9f6,stroke:#333,stroke-width:2px
    classDef management fill:#bbf,stroke:#333,stroke-width:2px
    classDef technical fill:#f9f,stroke:#333,stroke-width:2px
    classDef operations fill:#c9d7e4,stroke:#333,stroke-width:2px
    
    class BR business
    class DM,BRM management
    class BA management
    class DLM,DE,RM technical
    class OPS,SUPP operations
Loading

Requirements & Design Phase

Stage 1: Demand

Process Flow:

  1. Start → Business Requestor identifies business need
  2. Business Requestor creates formal Request
  3. Request is sent to both Demand Manager and Business Relationship Manager
  4. Demand Manager creates Demand ticket
  5. Business Relationship Manager performs prioritization and assigns BA
  6. Output: Demand ticket → Finish
%%{init: {'theme': 'base', 'themeVariables': { 'primaryColor': '#004990', 'primaryTextColor': '#fff', 'primaryBorderColor': '#1B3F72', 'lineColor': '#004990', 'secondaryColor': '#c9d7e4', 'tertiaryColor': '#f9f9f9' }}}%%
flowchart TB
    START((Start)) --> BR[Business Requestor]
    BR -->|business need| REQ[Request]
    REQ --> DM[Demand Manager]
    REQ --> BRM[Business Relationship Manager]
    DM --> DMTICKET[Demand ticket]
    BRM -->|prioritisation, assign BA| DMTICKET
    DMTICKET --> FINISH((Finish))
    
    classDef startpoint fill:#ffff00,stroke:#AC9F3C,color:#000,stroke-width:2px
    classDef endpoint fill:#ffff00,stroke:#AC9F3C,color:#000,stroke-width:2px
    classDef business fill:#9f6,stroke:#333,stroke-width:2px
    classDef management fill:#bbf,stroke:#333,stroke-width:2px
    classDef output fill:#f96,stroke:#333,stroke-width:2px
    
    class START,FINISH startpoint
    class BR business
    class DM,BRM management
    class REQ,DMTICKET output
Loading

Key Participants:

  • Business Requestor
  • Demand Manager
  • Business Relationship Manager

Key Deliverables:

  • Request documentation
  • Demand ticket

Stage 2: Requirements

Process Flow:

  1. Start ← Demand ticket (input)
  2. Business Analyst drives requirements workshops
    • Business Requestor provides requirements
    • Data Engineer provides data sources and ingestion details
    • BAU Support provides data sources and existing views
  3. Business Analyst creates:
    • Business Requirements Document (BRD)
    • User Stories
  4. Business Requestor reviews and signs off on BRD
  5. Data Engineer reviews BRD
  6. BRD leads to:
    • Measure Business Rules
    • Report Specifications
  7. Delivery Manager receives BRD pending signoff status
  8. Delivery Manager estimates time and effort
  9. Outputs: DevOps ticket, User Stories → Finish
%%{init: {'theme': 'base', 'themeVariables': { 'primaryColor': '#004990', 'primaryTextColor': '#fff', 'primaryBorderColor': '#1B3F72', 'lineColor': '#004990', 'secondaryColor': '#c9d7e4', 'tertiaryColor': '#f9f9f9' }}}%%
flowchart TB
    START((Start)) --> DMTICKET[Demand ticket]
    DMTICKET --> BA[Business Analyst]
    BA -->|drives| WORKSHOP((Requirements Workshop))
    BR[Business Requestor] -->|requirements| WORKSHOP
    DE[Data Engineer] -->|data sources, ingestion| WORKSHOP
    SUPP[BAU Support] -->|data sources, views| WORKSHOP
    
    WORKSHOP --> BRD[Business Requirements Document]
    BR -.->|review, signoff| BRD
    DE -.->|review| BRD
    BA --> BRD
    BA -->|authors| USER[User Stories]
    
    BRD --> MEASURE[Measure Business Rules]
    BRD --> REPSPEC[Report Specifications]
    BRD -.->|pending signoff status| DLM[Delivery Manager]
    DLM -->|time and effort| DEVOPS[DevOps ticket]
    
    DEVOPS --> FINISH((Finish))
    USER --> FINISH
    
    classDef startpoint fill:#ffff00,stroke:#AC9F3C,color:#000,stroke-width:2px
    classDef endpoint fill:#ffff00,stroke:#AC9F3C,color:#000,stroke-width:2px
    classDef business fill:#9f6,stroke:#333,stroke-width:2px
    classDef management fill:#bbf,stroke:#333,stroke-width:2px
    classDef technical fill:#f9f,stroke:#333,stroke-width:2px
    classDef output fill:#f96,stroke:#333,stroke-width:2px
    classDef workshop fill:#fff,stroke:#333,stroke-width:2px
    
    class START,FINISH startpoint
    class BR business
    class BA management
    class DLM,DE technical
    class SUPP technical
    class DMTICKET,BRD,MEASURE,REPSPEC,USER,DEVOPS output
    class WORKSHOP workshop
Loading

Key Participants:

  • Business Analyst
  • Business Requestor
  • Data Engineer
  • BAU Support
  • Delivery Manager

Key Deliverables:

  • Business Requirements Document
  • Measure Business Rules
  • Report Specifications
  • User Stories
  • DevOps ticket

Stage 3: Technical Feasibility

Process Flow:

  1. Start ← DevOps ticket, BRD, User Stories (inputs)
  2. Data Engineer drives technical sessions
  3. Technical Solution Design (TSD) is created
  4. Business Analyst reviews TSD
  5. Ops Manager reviews TSD
  6. TSD pending signoff is sent to Delivery Manager
  7. Delivery Manager performs BI backlog prioritization and estimates
  8. Output: Updated DevOps ticket → Finish
%%{init: {'theme': 'base', 'themeVariables': { 'primaryColor': '#004990', 'primaryTextColor': '#fff', 'primaryBorderColor': '#1B3F72', 'lineColor': '#004990', 'secondaryColor': '#c9d7e4', 'tertiaryColor': '#f9f9f9' }}}%%
flowchart TB
    START((Start)) --> DEVOPS[DevOps ticket]
    BRD[Business Requirements Document] -->|input| START
    USER[User Stories] -->|input| START
    
    DEVOPS --> DE[Data Engineer]
    DE -->|drives| TECHSESSIONS((Tech Sessions))
    TECHSESSIONS --> TSD[Technical Solution Design]
    
    BA[Business Analyst] -.->|review| TSD
    OPS[Ops Manager] -.->|review| TSD
    TSD -.->|pending signoff| DLM[Delivery Manager]
    DLM -->|BI backlog prioritisation, estimates| DEVOPS_OUT[DevOps ticket]
    DEVOPS_OUT --> FINISH((Finish))
    
    classDef startpoint fill:#ffff00,stroke:#AC9F3C,color:#000,stroke-width:2px
    classDef endpoint fill:#ffff00,stroke:#AC9F3C,color:#000,stroke-width:2px
    classDef management fill:#bbf,stroke:#333,stroke-width:2px
    classDef technical fill:#f9f,stroke:#333,stroke-width:2px
    classDef operations fill:#c9d7e4,stroke:#333,stroke-width:2px
    classDef output fill:#f96,stroke:#333,stroke-width:2px
    classDef session fill:#fff,stroke:#333,stroke-width:2px
    
    class START,FINISH startpoint
    class BA management
    class DLM,DE technical
    class OPS operations
    class BRD,USER,DEVOPS,DEVOPS_OUT,TSD output
    class TECHSESSIONS session
Loading

Key Participants:

  • Data Engineer
  • Business Analyst
  • Ops Manager
  • Delivery Manager

Key Deliverables:

  • Technical Solution Design (TSD)
  • Updated DevOps ticket

Build & Test Phase

Stage 4: Agile Build

Process Flow:

  1. Start ← Technical Solution Design, Measure Business Rules, Report Specifications, DevOps ticket (inputs)
  2. Data Engineer drives iterative build, unit testing, and showcases
  3. Business Analyst drives showcase sessions
  4. Business Requestor reviews showcase outputs
  5. Feedback and changes are incorporated into the build
  6. Data Engineer completes build for signoff
  7. Output: Updated DevOps ticket → Finish
%%{init: {'theme': 'base', 'themeVariables': { 'primaryColor': '#004990', 'primaryTextColor': '#fff', 'primaryBorderColor': '#1B3F72', 'lineColor': '#004990', 'secondaryColor': '#c9d7e4', 'tertiaryColor': '#f9f9f9' }}}%%
flowchart TB
    START((Start)) --> TSD[Technical Solution Design]
    MEASURE[Measure Business Rules] -->|input| START
    REPSPEC[Report Specifications] -->|input| START
    DEVOPS[DevOps ticket] -->|input| START
    
    TSD --> DE[Data Engineer]
    DE -->|drives| BUILD((Iterative Build, Unit Test, Showcase))
    BUILD -->|showcase| BA[Business Analyst]
    BA -->|drives| SHOWCASE((Showcase))
    BR[Business Requestor] -.->|review| SHOWCASE
    SHOWCASE -->|feedback, changes| BUILD
    BUILD -->|build signoff| DEVOPS_OUT[DevOps ticket]
    DEVOPS_OUT --> FINISH((Finish))
    
    classDef startpoint fill:#ffff00,stroke:#AC9F3C,color:#000,stroke-width:2px
    classDef endpoint fill:#ffff00,stroke:#AC9F3C,color:#000,stroke-width:2px
    classDef business fill:#9f6,stroke:#333,stroke-width:2px
    classDef management fill:#bbf,stroke:#333,stroke-width:2px
    classDef technical fill:#f9f,stroke:#333,stroke-width:2px
    classDef output fill:#f96,stroke:#333,stroke-width:2px
    classDef session fill:#fff,stroke:#333,stroke-width:2px
    
    class START,FINISH startpoint
    class BR business
    class BA management
    class DE technical
    class TSD,MEASURE,REPSPEC,DEVOPS,DEVOPS_OUT output
    class BUILD,SHOWCASE session
Loading

Key Participants:

  • Data Engineer
  • Business Analyst
  • Business Requestor

Key Deliverables:

  • Working solution components
  • Updated DevOps ticket with build signoff

Stage 5: SIT (System Integration Testing)

Process Flow:

  1. Start ← DevOps ticket, Technical Solution Design (inputs)
  2. Data Engineer creates SIT Plan
  3. Data Engineer performs Systems Integration Testing
  4. SIT results pending signoff are sent to Delivery Manager
  5. Delivery Manager provides SIT signoff
  6. Output: Updated DevOps ticket → Finish
%%{init: {'theme': 'base', 'themeVariables': { 'primaryColor': '#004990', 'primaryTextColor': '#fff', 'primaryBorderColor': '#1B3F72', 'lineColor': '#004990', 'secondaryColor': '#c9d7e4', 'tertiaryColor': '#f9f9f9' }}}%%
flowchart TB
    START((Start)) --> DEVOPS[DevOps ticket]
    TSD[Technical Solution Design] -->|input| START
    
    DEVOPS --> DE[Data Engineer]
    DE --> SITPLAN[SIT Plan]
    DE --> SIT((SIT Systems Integration Testing))
    SITPLAN --> SIT
    
    SIT -.->|pending signoff| DLM[Delivery Manager]
    DLM -->|SIT signoff| DEVOPS_OUT[DevOps ticket]
    DEVOPS_OUT --> FINISH((Finish))
    
    classDef startpoint fill:#ffff00,stroke:#AC9F3C,color:#000,stroke-width:2px
    classDef endpoint fill:#ffff00,stroke:#AC9F3C,color:#000,stroke-width:2px
    classDef technical fill:#f9f,stroke:#333,stroke-width:2px
    classDef output fill:#f96,stroke:#333,stroke-width:2px
    classDef session fill:#fff,stroke:#333,stroke-width:2px
    
    class START,FINISH startpoint
    class DLM,DE technical
    class TSD,DEVOPS,DEVOPS_OUT,SITPLAN output
    class SIT session
Loading

Key Participants:

  • Data Engineer
  • Delivery Manager

Key Deliverables:

  • SIT Plan
  • SIT test results
  • Updated DevOps ticket with SIT signoff

Stage 6: UAT (User Acceptance Testing)

Process Flow:

  1. Start ← DevOps ticket, Business Requirements Document, User Stories (inputs)
  2. Business Analyst drives UAT planning
    • Business Requestor participates in planning
    • Data Engineer plans UAT environment
  3. Business Analyst authors UAT Plan
  4. Business Requestor authors Test Cases
  5. Business Analyst authors Test Execution Steps
  6. Business Requestor reviews and signs off on UAT Plan
  7. UAT execution begins:
    • Business Requestor performs testing
    • Business Analyst manages UAT, triage, and reporting
    • Data Engineer provides UAT support, fixes, and triage
  8. Business Analyst authors daily UAT Status Reports
  9. UAT results are provided to Delivery Manager
  10. Business Requestor provides UAT signoff
  11. Delivery Manager updates DevOps ticket pending UAT signoff
  12. Output: Updated DevOps ticket → Finish
%%{init: {'theme': 'base', 'themeVariables': { 'primaryColor': '#004990', 'primaryTextColor': '#fff', 'primaryBorderColor': '#1B3F72', 'lineColor': '#004990', 'secondaryColor': '#c9d7e4', 'tertiaryColor': '#f9f9f9' }}}%%
flowchart TB
    START((Start)) --> DEVOPS[DevOps ticket]
    BRD[Business Requirements Document] -->|input| START
    USER[User Stories] -->|input| START
    
    DEVOPS --> BA[Business Analyst]
    BA -->|drives| UATPLAN_SESS((UAT Planning))
    BR[Business Requestor] --> UATPLAN_SESS
    BA -->|authors| UATPLAN[UAT Plan]
    
    BR -->|authors| TESTCASE[Test Cases]
    BA -->|authors| TESTSTEPS[Test Execution Steps]
    DE[Data Engineer] -.->|UAT environment plan| UATPLAN_SESS
    BR -.->|review, signoff| UATPLAN
    
    UATPLAN --> UAT((UAT User Acceptance Testing))
    TESTCASE --> UAT
    TESTSTEPS --> UAT
    
    BA -->|manage UAT, triage, reporting| UAT
    BR -->|performs testing| UAT
    DE -->|UAT support, fixes, triage| UAT
    
    UAT --> STATUS[UAT Status Report]
    BA -->|authors| STATUS
    
    UAT --> DLM[Delivery Manager]
    BR -->|UAT signoff| DEVOPS_OUT[DevOps ticket]
    DLM -->|pending UAT signoff| DEVOPS_OUT
    DEVOPS_OUT --> FINISH((Finish))
    
    classDef startpoint fill:#ffff00,stroke:#AC9F3C,color:#000,stroke-width:2px
    classDef endpoint fill:#ffff00,stroke:#AC9F3C,color:#000,stroke-width:2px
    classDef business fill:#9f6,stroke:#333,stroke-width:2px
    classDef management fill:#bbf,stroke:#333,stroke-width:2px
    classDef technical fill:#f9f,stroke:#333,stroke-width:2px
    classDef output fill:#f96,stroke:#333,stroke-width:2px
    classDef session fill:#fff,stroke:#333,stroke-width:2px
    
    class START,FINISH startpoint
    class BR business
    class BA management
    class DLM,DE technical
    class BRD,USER,DEVOPS,DEVOPS_OUT,UATPLAN,TESTCASE,TESTSTEPS,STATUS output
    class UATPLAN_SESS,UAT session
Loading

Key Participants:

  • Business Analyst
  • Business Requestor
  • Data Engineer
  • Delivery Manager

Key Deliverables:

  • UAT Plan
  • Test Cases
  • Test Execution Steps
  • UAT Status Reports
  • Updated DevOps ticket with UAT signoff

Release Phase

Stage 7: Deployment

Process Flow:

  1. Start ← DevOps ticket (input)
  2. Data Engineer packages release
  3. Release Manager drives deployment
  4. Business Analyst creates:
    • Training materials
    • User guides
  5. Business Analyst conducts training for Business Requestor
  6. Business Requestor receives User Guides
  7. Release Manager and Data Engineer author Release Notes
  8. Ops Manager and Support review Release Notes
  9. Release Manager creates Change Request
  10. Business Relationship Manager creates Change Communications
  11. Business Requestor performs Change Readiness activities
  12. Delivery Manager confirms deployment completion
  13. Output: Updated DevOps ticket → Finish
%%{init: {'theme': 'base', 'themeVariables': { 'primaryColor': '#004990', 'primaryTextColor': '#fff', 'primaryBorderColor': '#1B3F72', 'lineColor': '#004990', 'secondaryColor': '#c9d7e4', 'tertiaryColor': '#f9f9f9' }}}%%
flowchart TB
    START((Start)) --> DEVOPS[DevOps ticket]
    DEVOPS --> BA[Business Analyst]
    DEVOPS --> DE[Data Engineer]
    DEVOPS --> RM[Release Manager]
    
    DE -->|packages release| PACKAGE((Package Release))
    BA --> TRAINING[Training Material]
    BA --> USERGUIDE[User Guides]
    BA -->|drives| TRAIN_SESS((Training))
    
    TRAINING --> TRAIN_SESS
    USERGUIDE --> BR[Business Requestor]
    BR --> TRAIN_SESS
    
    DE -->|author| RELNOTES[Release Notes]
    OPS[Ops Manager] -->|review| RELNOTES
    SUPP[Support] -->|review| RELNOTES
    RM -->|author| RELNOTES
    
    RM --> PACKAGE
    RM --> CR[Change Request]
    BRM[Business Relationship Manager] --> CHGCOMM[Change Communications]
    CHGCOMM --> BR
    BR --> CHGREADY((Change Readiness))
    
    PACKAGE --> DLM[Delivery Manager]
    DLM -->|deployment complete| DEVOPS_OUT[DevOps ticket]
    DEVOPS_OUT --> FINISH((Finish))
    
    classDef startpoint fill:#ffff00,stroke:#AC9F3C,color:#000,stroke-width:2px
    classDef endpoint fill:#ffff00,stroke:#AC9F3C,color:#000,stroke-width:2px
    classDef business fill:#9f6,stroke:#333,stroke-width:2px
    classDef management fill:#bbf,stroke:#333,stroke-width:2px
    classDef technical fill:#f9f,stroke:#333,stroke-width:2px
    classDef operations fill:#c9d7e4,stroke:#333,stroke-width:2px
    classDef output fill:#f96,stroke:#333,stroke-width:2px
    classDef session fill:#fff,stroke:#333,stroke-width:2px
    
    class START,FINISH startpoint
    class BR business
    class BA,BRM management
    class DLM,DE,RM technical
    class OPS,SUPP operations
    class DEVOPS,DEVOPS_OUT,TRAINING,USERGUIDE,RELNOTES,CR,CHGCOMM output
    class PACKAGE,TRAIN_SESS,CHGREADY session
Loading

Key Participants:

  • Data Engineer
  • Release Manager
  • Business Analyst
  • Business Requestor
  • Ops Manager
  • Support Team
  • Business Relationship Manager
  • Delivery Manager

Key Deliverables:

  • Packaged release
  • Training materials
  • User guides
  • Release notes
  • Change request
  • Change communications
  • Updated DevOps ticket

Stage 8: Warranty

Process Flow:

  1. Start ← DevOps ticket, Release Notes, Change Request (inputs)
  2. Release Manager manages warranty support
  3. Data Engineer provides bug fixes during warranty period
  4. Warranty completion is confirmed by Delivery Manager
  5. Output: Updated DevOps ticket → Finish
%%{init: {'theme': 'base', 'themeVariables': { 'primaryColor': '#004990', 'primaryTextColor': '#fff', 'primaryBorderColor': '#1B3F72', 'lineColor': '#004990', 'secondaryColor': '#c9d7e4', 'tertiaryColor': '#f9f9f9' }}}%%
flowchart TB
    START((Start)) --> DEVOPS[DevOps ticket]
    RELNOTES[Release Notes] -->|input| START
    CR[Change Request] -->|input| START
    
    DEVOPS --> RM[Release Manager]
    RM -->|manage warranty support| WARRANTY((Warranty Period))
    DE[Data Engineer] -->|bug fixes| WARRANTY
    
    WARRANTY --> DLM[Delivery Manager]
    DLM -->|DevOps completed| DEVOPS_OUT[DevOps ticket]
    DEVOPS_OUT --> FINISH((Finish))
    
    classDef startpoint fill:#ffff00,stroke:#AC9F3C,color:#000,stroke-width:2px
    classDef endpoint fill:#ffff00,stroke:#AC9F3C,color:#000,stroke-width:2px
    classDef technical fill:#f9f,stroke:#333,stroke-width:2px
    classDef output fill:#f96,stroke:#333,stroke-width:2px
    classDef session fill:#fff,stroke:#333,stroke-width:2px
    
    class START,FINISH startpoint
    class DLM,DE,RM technical
    class DEVOPS,DEVOPS_OUT,RELNOTES,CR output
    class WARRANTY session
Loading

Key Participants:

  • Release Manager
  • Data Engineer
  • Delivery Manager

Key Deliverables:

  • Bug fixes
  • Updated DevOps ticket with warranty completion

Stage 9: BAU Support

Process Flow:

  1. Start ← Release Notes (input)
  2. Support Team provides BAU support and bug fixes
  3. Ops Manager manages BAU operations
  4. Finish
%%{init: {'theme': 'base', 'themeVariables': { 'primaryColor': '#004990', 'primaryTextColor': '#fff', 'primaryBorderColor': '#1B3F72', 'lineColor': '#004990', 'secondaryColor': '#c9d7e4', 'tertiaryColor': '#f9f9f9' }}}%%
flowchart TB
    START((Start)) --> RELNOTES[Release Notes]
    RELNOTES --> SUPP[Support Team]
    SUPP -->|BAU support, bug fixes| SUPPORT((BAU Support))
    OPS[Ops Manager] -->|manage BAU operations| SUPPORT
    SUPPORT --> FINISH((Finish))
    
    classDef startpoint fill:#ffff00,stroke:#AC9F3C,color:#000,stroke-width:2px
    classDef endpoint fill:#ffff00,stroke:#AC9F3C,color:#000,stroke-width:2px
    classDef operations fill:#c9d7e4,stroke:#333,stroke-width:2px
    classDef output fill:#f96,stroke:#333,stroke-width:2px
    classDef session fill:#fff,stroke:#333,stroke-width:2px
    
    class START,FINISH startpoint
    class OPS,SUPP operations
    class RELNOTES output
    class SUPPORT session
Loading

Key Participants:

  • Support Team
  • Ops Manager

Key Deliverables:

  • Ongoing support
  • Bug fixes

About

Data Analytics Demand Process

Resources

Stars

0 stars

Watchers

1 watching

Forks

Releases

No releases published

Packages

 
 
 

Contributors