SI UPDATE TO DATAMART
Process Overview
| Field | Description |
|---|---|
| Process Name | SI Update to DataMart |
| Segment | GSC |
| Process Family | Lenovo India |
| Process User(s) | Wyzmindz solutions pvt ltd |
| Process Purpose | This report is instrumental in providing actionable insights, tracking performance, and supporting Lenovo’s sales strategies |
Version Tag
| Field | Description |
|---|---|
| Version Tag | V 1.0 |
| Prepared By | Sushruth Vasista |
| Date of Update/Revision | 22-01-2024 |
| Reviewed by | Vishwanath Mosale |
| Approved by | Vishwanath Mosale |
| Revision Details | SOP Document Creation |
Distribution & Access List
| Designation | Read | Write | Approval |
|---|---|---|---|
| Analyst | Yes | No | No |
| Team Lead | Yes | Yes | No |
| Manager | Yes | Yes | Yes |
1.1 Purpose
The purpose of this process is to define a standardized process for preparing, processing, and uploading quarterly coverage data into the Data Mart system for updating the SI Historical QW to ensure accuracy and consistency.
1.2 Scope
- Geographic Scope: India.
- Business Segment: GSC
- Process Frequency: Daily
- File preparation
- Data processing using Python scripts
- Data validation and cleanup
- Upload to Data Mart
1.3 Business/Segment Overview
This process supports data reporting and analytics functions by ensuring that accurate quarterly coverage data is available in the Data Mart for downstream reporting, dashboards, and business insights.
1.4 Responsibility and authority
- Analyst : Goutham P
- Process Owner : Jeevitha
- Process Manager : Navaneeth & Dayanand
- Approval Authority : Vishwanath Mosale
1.5 Escalation matrix: (Wyzmindz and Lenovo)
Escalation Matrix – WyzMindz Solutions Pvt Ltd India
| Level | Name | Designation | Email ID |
|---|---|---|---|
| 1 | Sushruth Vasista | Manager | sushruth.vasista@wyzmindz.com |
| 2 | Vishwanath Mosale | Director | Vishwanath.mosale@wyzmindz.com |
Escalation Matrix – Lenovo India Pvt Ltd
| Level | Name | Designation | Email ID |
|---|---|---|---|
| 1 | Debashish | CONS Ops Head | dbhadra@lenovo.com |
| 2 | Saurabh Agarwal | Ops Director | ASAURABH@lenovo.com |
1.6 RACI Matrix
RACI Matrix – WyzMindz Solutions Pvt Ltd India
| Report / Process | Responsible | Accountable | Consultation | Informed |
|---|---|---|---|---|
| SI Update to Data Mart | Goutham P | Goutham P | Navaneeth | Lenovo Ind Pvt Ltd, Wyzmindz Solutions pvt Ltd India |
1.7 Access Required
- DATAMART
- Visual Studio Code
1.8 Overview of Tools
| Level | Tool Name | URL | Description |
|---|---|---|---|
| 1 | VS Code | Application | It’s a App used to code and extract data for our usage. |
1.9 Legends
- MTM: Machine Type Model (Product Number)
- NA: Not Available
1.10 Dependencies
- VS Code
- DATAMART
1.11 Schedule of Reporting
The SI Update to DATAMART is structured for Quarterly flow to ensure timely data validation: - Frequency: Quarterly
1.12 Process Flow Chart
1.13 Steps of Procedure
- We need two files for this process
- Last quarter’s uploaded file and this quarter’s final coverage file
- Take the final coverage file of the quarter
- Paste it in the given path
- Now run the python code
- After the code has completed running data will be saved in downloads.
- Delete al contents from PCA($) column
- Save the file as Upload Q4(present Quarter)
- Upload the data to data mart.
1.14 Output Overview
- Cleaned quarterly coverage file
- File ready and successfully uploaded to Data Mart
1.15 Validation checklist
- Correct input files used
- Script executed without errors
- Output file generated
- PCA($) column cleared
- File naming convention followed
- Data successfully uploaded
1.16 Communication
- Data will be given to Internal Team
1.17 Repository Details
