1. Office
1.1. Tableau
1.1.1. ECO Cost Metircs
1.1.1.1. BU Updates
1.1.1.1.1. It will be completed by today EOD or tomorrow we have started this activity and loading and processing existing changes too.
1.1.1.2. Document Readness
1.1.1.2.1. Derive New Logistics cost
1.1.1.2.2. Explain the Requirment to Amar
1.1.2. Negative values
1.1.2.1. Validate Ranjith report
1.1.2.1.1. do random sample check from each qtr
1.1.2.2. Download agile documents do End to End Validation
1.1.2.3. Count check
1.1.2.4. cycle time check
1.1.2.5. negative value check
1.1.3. Where user report
1.1.3.1. i have give report to amar about Time saving
1.1.3.2. Validate current report
1.1.3.3. list of initial users for the app
1.1.4. Need to project plan for build dashboard ( One pager release this on weekly new letter )
1.1.5. Chat Bot List
1.1.5.1. Need give list to amar about Documents
1.2. SKU Report on Quarterly
1.2.1. ECO affected item Table
1.2.2. JPN Table with Part Type "Juniper Model Number"
1.3. History Tab
1.3.1. UAT to be complete before this Month
1.3.1.1. Check List
1.3.1.1.1. Vlidation Check while Moved CCB Notification add approver during CCB without comments add observer during CCB with comments add approver with comments comments add comments only reject reject with notified Change status Remove from approver list Remove from observer list add observer add approver during TAB add obaserver during TAB adding comments in TAB without notifying to anyone Removed approver during Tab
1.3.2. History information needed only Following Actions Add Approver, Add Observer Approve, Reject, Change Status & Comment from History Tab
1.3.2.1. Remove from approvers list
1.3.2.2. History information needed only Following Actions Add Approver Add Observer Approve Reject Change Status Comment Remove from approvers list
1.4. ECO Sign off Report
1.4.1. HW Design
1.4.2. ME MECH
1.4.3. PLM
1.4.3.1. AWAN
1.4.3.2. AIDE
1.4.3.3. CRDC
1.4.3.4. CORE Technologies
1.4.3.5. COO Ops
1.4.3.6. Corporate CTO
1.4.3.7. Cross BU Offerings
1.4.3.8. CSS Opex
1.4.4. ACE EMC EMC_CSS Global Repair group JTAC ME-ELECT ME-SUST ME-MECH MPM HW-DESIGN NPI_Material PE_NPI PQE PTE_NPI Safety_RoHS_CLEI TEXT-SUST SYS-TEST
1.5. Data Clean up
1.5.1. SPA
1.5.2. Product Name Clean up
1.5.3. UPA..?
1.5.4. EX-Rampur's post FRS'd action
1.6. how to check e-exepense lastpayment details..?
1.7. OKR_Q3
2. Personal
2.1. Conver PDF to Excel
2.1.1. Check with Morrthi about PDF to Excel converation
2.1.2. Create python script
2.2. Create Notion template again
2.3. Moi Tech
2.3.1. Spoke with bhai
2.4. Book reading
2.5. Collect the customer details via MS Form
3. Formatt content
3.1. Format the content
3.2. Based on the description the following fields to be looked up from the Tools files and fill
3.3. based on the input information from the email content and filter most common or matching content in column B, then
3.4. Formatting
3.4.1. Description of changes should be very well formatted
3.4.2. it should be simple language to understand
3.4.3. Do not change the content provided by email
3.4.4. Take reference formating from the historical column B
3.5. REASON_CODE CLASSIFICATION MCO_CHANGE_TYPE MCO_CHANGE_TYPE_DETAILS
3.5.1. D REASON_CODE F CLASSIFICATION G MCO_CHANGE_TYPE H MCO_CHANGE_TYPE_DETAILS
4. Fact & Dim Cross function Team Metrics
4.1. Check list of columns in workflow table
4.2. Require Output per functions
4.2.1. ECO Number, Approver CCB Date Sign off Date Pending Days by Individual user sign off Avg by Individul users overall_by function
4.3. Create report by functions
4.3.1. AVG Time by
5. My youtube learning
5.1. watch Barra
6. POWER BI Learning
6.1. PL-300
6.1.1. First do some live project for Three Months
6.1.1.1. Learn from Youtube apply the same in PDC
6.1.1.2. Record all the learning
6.1.1.3. Power Query
6.1.1.3.1. Enter Table
6.1.1.3.2. Folder selection
6.1.1.3.3. Leared Groupby
6.1.1.3.4. Merge
6.1.1.3.5. Data Quality Check when we load at first time
6.1.1.3.6. Null & blank
6.1.1.3.7. query folding
6.1.1.3.8. Column from examples
6.1.1.3.9. Reference vs Duplidate
6.1.1.3.10. Query dependency
6.1.1.4. DAX
6.1.1.4.1. Row Context & Filter Context
6.1.1.4.2. Calculated Measure
6.1.1.4.3. calculated colum
6.1.1.4.4. Calculated Table
6.1.1.4.5. MAX, MAXX,MAXA
6.1.1.4.6. UTCNOW & UTCTODAY DAX F
6.1.1.5. Use basic statistical functions in DAX
6.1.1.5.1. Total Revenue = SUMX(Sales, Sales[Quantity] * Sales[UnitPrice])
6.1.1.6. What is row context
6.1.1.6.1. Row by row computation called Row context
6.1.1.6.2. Lerned about related function
6.1.1.7. Filter Context
6.1.1.8. Calculate
6.1.1.8.1. Removing Context