Page MenuHomePhabricator

KCVelaga_WMF
Analyst, GDI

Projects

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Saturday

  • Clear sailing ahead.

User Details

User Since
Sep 15 2021, 11:36 AM (64 w, 1 d)
Availability
Available
LDAP User
KCVelaga (wikimf)
MediaWiki User
KCVelaga (WMF) [ Global Accounts ]

For my volunteer profile, please visit: KCVelaga

Recent Activity

Yesterday

KCVelaga_WMF reassigned T309276: Grants input metric from KCVelaga_WMF to JAnstee_WMF.

All the numbers align now for grants now, final comparisons at https://docs.google.com/spreadsheets/d/1smlxmLZN3igND0vW1Zhsr5BRnXgWxx_zbrd5rxMhkqc/edit#gid=75628010&range=M1:T129

Wed, Dec 7, 9:16 AM · Equity-Landscape, Data-Engineering

Mon, Nov 21

KCVelaga_WMF reassigned T309276: Grants input metric from JAnstee_WMF to ntsako.

@ntsako please assign it back to me once the changes are done.

Mon, Nov 21, 2:20 PM · Equity-Landscape, Data-Engineering
KCVelaga_WMF added a comment to T309276: Grants input metric.

@ntsako the final QC, based on recalculated numbers is on this sheet.

Mon, Nov 21, 2:18 PM · Equity-Landscape, Data-Engineering

Fri, Nov 18

KCVelaga_WMF added a comment to T309275: Affiliates input metric.

Yes. AFFs by geo is a count of all affiliates operating in the country whereas Official Affiliate info is those primarily located in the country only and often excludes the many thematic international groups operating in emerging spaces.

Fri, Nov 18, 10:38 AM · Data-Engineering, Equity-Landscape

Thu, Nov 17

KCVelaga_WMF updated subscribers of T309275: Affiliates input metric.

affiliates grants QA comments

Thu, Nov 17, 12:44 PM · Data-Engineering, Equity-Landscape
KCVelaga_WMF added a comment to T309276: Grants input metric.

@ntsako ah, my had. I misread that. Thanks for clarifying.

Thu, Nov 17, 10:00 AM · Equity-Landscape, Data-Engineering

Wed, Nov 16

KCVelaga_WMF added a comment to T309275: Affiliates input metric.

I was able to QA the metrics exclusively based on affiliate_data_csv (i.e. not anything related to grants), I will review them tomorrow, as they are tied to grants table.

Wed, Nov 16, 2:53 PM · Data-Engineering, Equity-Landscape
KCVelaga_WMF added a comment to T309276: Grants input metric.

@ntsako in the final SELECT statement, I see two columns with the same label, total_historical_grants_to_date i.e.

Wed, Nov 16, 2:53 PM · Equity-Landscape, Data-Engineering
KCVelaga_WMF reassigned T309276: Grants input metric from ntsako to JAnstee_WMF.

assigning back to Jaime for now, to check for differences in the base datasets.

Wed, Nov 16, 10:58 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF added a comment to T309276: Grants input metric.

Thanks @ntsako there is mis-alignment at the historical and annual aggregation of grants, which probably rolling into the change as well. However, the issue doesn't seem to be with with the code.

Wed, Nov 16, 10:57 AM · Equity-Landscape, Data-Engineering

Mon, Nov 14

KCVelaga_WMF triaged T306622: Overall Engagement output rank metric as Medium priority.
Mon, Nov 14, 3:59 PM · Equity-Landscape, Data-Engineering
KCVelaga_WMF triaged T309275: Affiliates input metric as High priority.
Mon, Nov 14, 3:58 PM · Data-Engineering, Equity-Landscape
KCVelaga_WMF moved T306621: Programs Metrics Transform from In Code Review to In QA Review on the Equity-Landscape board.
Mon, Nov 14, 10:33 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF moved T306624: Population output rank metrics from In Code Review to In QA Review on the Equity-Landscape board.
Mon, Nov 14, 10:33 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF moved T306622: Overall Engagement output rank metric from In Code Review to In QA Review on the Equity-Landscape board.
Mon, Nov 14, 10:33 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF moved T306619: Affiliates output rank metrics from In Code Review to In QA Review on the Equity-Landscape board.
Mon, Nov 14, 10:33 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF renamed T306622: Overall Engagement output rank metric from Overall Engagement Metric (Transformation) to Overall Engagement output rank metric.
Mon, Nov 14, 10:32 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF renamed T306624: Population output rank metrics from Population Metrics Transformation to Population output rank metrics.
Mon, Nov 14, 10:32 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF renamed T306619: Affiliates output rank metrics from Affiliate Metrics Transformation to Affiliates output rank metrics.
Mon, Nov 14, 10:29 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF reopened T306622: Overall Engagement output rank metric, a subtask of T305475: Milestone: Ingest and Transform Input Data, as Open.
Mon, Nov 14, 10:29 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF reopened T306622: Overall Engagement output rank metric as "Open".
Mon, Nov 14, 10:29 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF reopened T306624: Population output rank metrics, a subtask of T305475: Milestone: Ingest and Transform Input Data, as Open.
Mon, Nov 14, 10:29 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF reopened T306624: Population output rank metrics as "Open".

re-opening for QA review

Mon, Nov 14, 10:29 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF added a comment to T306622: Overall Engagement output rank metric.

re-opening for QA review.

Mon, Nov 14, 10:28 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF reopened T306619: Affiliates output rank metrics, a subtask of T305475: Milestone: Ingest and Transform Input Data, as Open.
Mon, Nov 14, 10:28 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF reopened T306619: Affiliates output rank metrics as "Open".

re-opening for QA review.

Mon, Nov 14, 10:28 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF reopened T306621: Programs Metrics Transform, a subtask of T305475: Milestone: Ingest and Transform Input Data, as Open.
Mon, Nov 14, 10:28 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF reopened T306621: Programs Metrics Transform as "Open".
Mon, Nov 14, 10:28 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF reassigned T306621: Programs Metrics Transform from KCVelaga_WMF to JAnstee_WMF.

re-opening for QA.

Mon, Nov 14, 10:27 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF moved T323004: Add and test world map (heatmap overlay) with the EL dashboard from Backlog to Up Next on the Equity-Landscape board.
Mon, Nov 14, 10:26 AM · Equity-Landscape
KCVelaga_WMF moved T323005: Add and test treemap chart type to EL dashboard from Backlog to Up Next on the Equity-Landscape board.
Mon, Nov 14, 10:25 AM · Equity-Landscape
KCVelaga_WMF moved T323006: Add and test multi-column plot chart type to EL dashboard from Backlog to Up Next on the Equity-Landscape board.
Mon, Nov 14, 10:25 AM · Equity-Landscape
KCVelaga_WMF moved T323007: Add and test heatmap overlay to a table, for EL dashboard from Backlog to Up Next on the Equity-Landscape board.
Mon, Nov 14, 10:25 AM · Equity-Landscape
KCVelaga_WMF moved T323001: Second round of user testing with the high fidelity prototype from Up Next to In Development on the Equity-Landscape board.
Mon, Nov 14, 10:25 AM · Equity-Landscape
KCVelaga_WMF claimed T309275: Affiliates input metric.

claiming for QA review.

Mon, Nov 14, 10:25 AM · Data-Engineering, Equity-Landscape
KCVelaga_WMF reassigned T309276: Grants input metric from JAnstee_WMF to ntsako.
Mon, Nov 14, 10:24 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF moved T323000: Align EL dashbaord design with Wikimedia design and style guidelines from In QA Review to In Development on the Equity-Landscape board.
Mon, Nov 14, 10:23 AM · Equity-Landscape
KCVelaga_WMF closed T305477: Milestone: Dashboard Interaction Map Complete, a subtask of T305468: Deploy the GDI Equity Landscape Dashboard , as Resolved.
Mon, Nov 14, 10:22 AM · Epic, Equity-Landscape, Data-Engineering
KCVelaga_WMF closed T305477: Milestone: Dashboard Interaction Map Complete as Resolved.
Mon, Nov 14, 10:22 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF claimed T305477: Milestone: Dashboard Interaction Map Complete.

This is more or less done. We have all the interactions and filters listed in the visualisation mockups.

Mon, Nov 14, 10:22 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF moved T323000: Align EL dashbaord design with Wikimedia design and style guidelines from Up Next to In QA Review on the Equity-Landscape board.
Mon, Nov 14, 10:20 AM · Equity-Landscape
KCVelaga_WMF added a subtask for T323003: Add data vizualizations to the EL dashboard: T323006: Add and test multi-column plot chart type to EL dashboard.
Mon, Nov 14, 10:20 AM · Equity-Landscape
KCVelaga_WMF removed a subtask for T323005: Add and test treemap chart type to EL dashboard: T323006: Add and test multi-column plot chart type to EL dashboard.
Mon, Nov 14, 10:20 AM · Equity-Landscape
KCVelaga_WMF edited parent tasks for T323006: Add and test multi-column plot chart type to EL dashboard, added: T323003: Add data vizualizations to the EL dashboard; removed: T323005: Add and test treemap chart type to EL dashboard.
Mon, Nov 14, 10:20 AM · Equity-Landscape
KCVelaga_WMF edited parent tasks for T323005: Add and test treemap chart type to EL dashboard, added: T323003: Add data vizualizations to the EL dashboard; removed: T323004: Add and test world map (heatmap overlay) with the EL dashboard.
Mon, Nov 14, 10:20 AM · Equity-Landscape
KCVelaga_WMF added a subtask for T323003: Add data vizualizations to the EL dashboard: T323005: Add and test treemap chart type to EL dashboard.
Mon, Nov 14, 10:20 AM · Equity-Landscape
KCVelaga_WMF removed a subtask for T323004: Add and test world map (heatmap overlay) with the EL dashboard: T323005: Add and test treemap chart type to EL dashboard.
Mon, Nov 14, 10:20 AM · Equity-Landscape
KCVelaga_WMF added a subtask for T323003: Add data vizualizations to the EL dashboard: T323007: Add and test heatmap overlay to a table, for EL dashboard.
Mon, Nov 14, 10:20 AM · Equity-Landscape
KCVelaga_WMF removed a subtask for T323006: Add and test multi-column plot chart type to EL dashboard: T323007: Add and test heatmap overlay to a table, for EL dashboard.
Mon, Nov 14, 10:20 AM · Equity-Landscape
KCVelaga_WMF edited parent tasks for T323007: Add and test heatmap overlay to a table, for EL dashboard, added: T323003: Add data vizualizations to the EL dashboard; removed: T323006: Add and test multi-column plot chart type to EL dashboard.
Mon, Nov 14, 10:20 AM · Equity-Landscape
KCVelaga_WMF created T323007: Add and test heatmap overlay to a table, for EL dashboard.
Mon, Nov 14, 10:19 AM · Equity-Landscape
KCVelaga_WMF created T323006: Add and test multi-column plot chart type to EL dashboard.
Mon, Nov 14, 10:18 AM · Equity-Landscape
KCVelaga_WMF created T323005: Add and test treemap chart type to EL dashboard.
Mon, Nov 14, 10:17 AM · Equity-Landscape
KCVelaga_WMF renamed T323004: Add and test world map (heatmap overlay) with the EL dashboard from Add and test world map (heatmap overal) with the EL dashboard to Add and test world map (heatmap overlay) with the EL dashboard.
Mon, Nov 14, 10:17 AM · Equity-Landscape
KCVelaga_WMF created T323004: Add and test world map (heatmap overlay) with the EL dashboard.
Mon, Nov 14, 10:16 AM · Equity-Landscape
KCVelaga_WMF created T323003: Add data vizualizations to the EL dashboard.
Mon, Nov 14, 10:15 AM · Equity-Landscape
KCVelaga_WMF created T323002: Code development for the EL dashboard prototype.
Mon, Nov 14, 10:14 AM · Equity-Landscape
KCVelaga_WMF created T323001: Second round of user testing with the high fidelity prototype.
Mon, Nov 14, 10:14 AM · Equity-Landscape
KCVelaga_WMF created T323000: Align EL dashbaord design with Wikimedia design and style guidelines.
Mon, Nov 14, 10:13 AM · Equity-Landscape

Thu, Nov 10

KCVelaga_WMF added a comment to T309276: Grants input metric.

All the grants and weighted columns align, but there are issues with the "change" columns

Thu, Nov 10, 11:52 AM · Equity-Landscape, Data-Engineering

Nov 3 2022

KCVelaga_WMF updated subscribers of T309276: Grants input metric.
Nov 3 2022, 11:00 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF renamed T322145: Requesting access to analytics-privatedata-users & Kerberos identity for Hghani from Requesting access to analytics-privatedata-users & Kerberos identity for Hghani and kinit credentials to Requesting access to analytics-privatedata-users & Kerberos identity for Hghani.
Nov 3 2022, 9:56 AM · SRE, SRE-Access-Requests
KCVelaga_WMF placed T322146: Requesting access to analytics-privatedata-users & Kerberos identity for Hibashaath up for grabs.
Nov 3 2022, 9:55 AM · SRE, SRE-Access-Requests
KCVelaga_WMF renamed T321918: Grant Access to ldap/nda for Ilooremeta from Grant Access to Superset for Ilooremeta to Grant Access to ldap/nda for Ilooremeta.
Nov 3 2022, 9:51 AM · SRE, LDAP-Access-Requests
KCVelaga_WMF renamed T321910: Grant Access to ldap/nda for Hghani from Grant Access to Superset for Hghani to Grant Access to ldap/nda for Hghani.
Nov 3 2022, 9:51 AM · SRE, LDAP-Access-Requests
KCVelaga_WMF renamed T321902: Grant Access to ldap/nda for Hibashaath from Grant Access to Superset for Hibashaath to Grant Access to ldap/nda for Hibashaath.
Nov 3 2022, 9:51 AM · SRE, LDAP-Access-Requests

Nov 2 2022

KCVelaga_WMF updated KCVelaga_WMF.
Nov 2 2022, 2:38 PM
KCVelaga_WMF updated subscribers of T309276: Grants input metric.
Nov 2 2022, 1:38 PM · Equity-Landscape, Data-Engineering
KCVelaga_WMF added a comment to T309276: Grants input metric.

After reviewing the input metrics, the comparisons are here: https://docs.google.com/spreadsheets/d/1smlxmLZN3igND0vW1Zhsr5BRnXgWxx_zbrd5rxMhkqc/edit#gid=75628010&range=A1:AC69, where I have marked the columns with differences in red.

Nov 2 2022, 1:37 PM · Equity-Landscape, Data-Engineering

Nov 1 2022

KCVelaga_WMF updated the task description for T322147: Requesting access to analytics-privatedata-users & Kerberos identity for Ilooremeta.
Nov 1 2022, 3:35 PM · SRE, SRE-Access-Requests

Oct 28 2022

KCVelaga_WMF added a comment to T321918: Grant Access to ldap/nda for Ilooremeta.

Approved from the team's side. @CMacholan can chime in if additional approval is necessary.

Oct 28 2022, 5:50 PM · SRE, LDAP-Access-Requests
KCVelaga_WMF renamed T321902: Grant Access to ldap/nda for Hibashaath from Grant Access to Superset for <Hibashaath> to Grant Access to Superset for Hibashaath.
Oct 28 2022, 3:28 PM · SRE, LDAP-Access-Requests
KCVelaga_WMF renamed T321903: Grant Access to Superset for Hibashaath from Grant Access to Superset for <Hibashaath> to Grant Access to Superset for Hibashaath.
Oct 28 2022, 1:38 PM · SRE, LDAP-Access-Requests

Oct 18 2022

KCVelaga_WMF reassigned T306620: Grants Leadership Output Metrics transformation from KCVelaga_WMF to JAnstee_WMF.
Oct 18 2022, 10:24 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF added a comment to T306620: Grants Leadership Output Metrics transformation.

access output rank metrics at

Oct 18 2022, 10:23 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF added a comment to T306620: Grants Leadership Output Metrics transformation.

Transformation code

Oct 18 2022, 10:20 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF added a comment to T309276: Grants input metric.

regional level metrics can be accessed at

Oct 18 2022, 10:20 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF added a comment to T306618: Editorship Output Rank Metrics.

I can also make the change at output metrics level, but I think it is best if it is handled as input metrics level, as I read from it, which I assume in turn takes the labels from country meta data.

Oct 18 2022, 10:13 AM · Equity-Landscape, Data-Engineering

Oct 17 2022

KCVelaga_WMF moved T306620: Grants Leadership Output Metrics transformation from In Code Review to In QA Review on the Equity-Landscape board.
Oct 17 2022, 4:08 PM · Equity-Landscape, Data-Engineering
KCVelaga_WMF renamed T306620: Grants Leadership Output Metrics transformation from Grants Metrics Transformation to Grants Leadership Output Metrics transformation.
Oct 17 2022, 4:08 PM · Equity-Landscape, Data-Engineering
KCVelaga_WMF reopened T306620: Grants Leadership Output Metrics transformation, a subtask of T305475: Milestone: Ingest and Transform Input Data, as Open.
Oct 17 2022, 4:08 PM · Equity-Landscape, Data-Engineering
KCVelaga_WMF reopened T306620: Grants Leadership Output Metrics transformation as "Open".

reopening for data QA

Oct 17 2022, 4:08 PM · Equity-Landscape, Data-Engineering

Oct 14 2022

KCVelaga_WMF added a comment to T306618: Editorship Output Rank Metrics.

@JAnstee_WMF All regional aggregations also align well now. You can see my comparisons at: https://docs.google.com/spreadsheets/d/1LhdxdVUCMXfmvK2xubnbvB7s4mRR5xEsnb2w1QUggmU/edit#gid=539285548&range=G1:I281. Please cross-check and confirm.

Oct 14 2022, 1:46 PM · Equity-Landscape, Data-Engineering
KCVelaga_WMF added a comment to T306617: Readership Output Rank Metrics.

@JAnstee_WMF All the regional aggregations also now fully align. You can see the full comparison at https://docs.google.com/spreadsheets/d/1B9vZc8BI7zLrZhyM7XNAYQXN_XSMLyw5CJgBjxOqr20/edit#gid=1922038447&range=A1:E280. Please cross-check this.

Oct 14 2022, 1:45 PM · Equity-Landscape, Data-Engineering
KCVelaga_WMF added a comment to T306618: Editorship Output Rank Metrics.
Oct 14 2022, 1:45 PM · Equity-Landscape, Data-Engineering

Oct 10 2022

KCVelaga_WMF added a comment to T306618: Editorship Output Rank Metrics.

after fixing the code, I re-ran the outputs and calculated the interim ranks and final outputs on sheets as well.

Oct 10 2022, 11:59 AM · Equity-Landscape, Data-Engineering

Oct 7 2022

KCVelaga_WMF added a comment to T309273: Readership input metrics.

Noting that there are some large outliers in the data for yoy growth inputs

Oct 7 2022, 2:27 PM · Data-Engineering, Equity-Landscape
KCVelaga_WMF added a comment to T306617: Readership Output Rank Metrics.

@JAnstee_WMF

The list of output countries from product data is inconsistent each year depending on metric hits, emerging spaces can sometimes disappear from year to year. It will be important to ensure we are always filling the full frame of locations from our country codes and labels sheet or our comparison points are not equal and cause different rank outputs.

This done by Ntsako at the input metrics level. Although in the input metrics code this is not present, after all the transformations, the country_meta_data is taken as a reference and all metrics are LEFT joined from there on. @ntsako can confirm this.

Oct 7 2022, 2:26 PM · Equity-Landscape, Data-Engineering

Oct 6 2022

KCVelaga_WMF added a comment to T306618: Editorship Output Rank Metrics.

Editor presence and Editor growth outputs seem to be scaled 0 to 1 rather than 0 to 10

You are right, fixed this.

Oct 6 2022, 4:58 PM · Equity-Landscape, Data-Engineering
KCVelaga_WMF updated subscribers of T306618: Editorship Output Rank Metrics.
Oct 6 2022, 11:19 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF updated subscribers of T306617: Readership Output Rank Metrics.

Some countries do not appear each year which for each internal metric so we need to ensure all are being included and zeroed into the standard frame of geo locations in our country labels table.

Oct 6 2022, 11:15 AM · Equity-Landscape, Data-Engineering

Oct 5 2022

KCVelaga_WMF updated subscribers of T306617: Readership Output Rank Metrics.
Oct 5 2022, 2:12 PM · Equity-Landscape, Data-Engineering
KCVelaga_WMF added a comment to T309273: Readership input metrics.

Does the unique devices data actually come from the same wmf.pageview_hourly or is this a copy/paste error?

Oct 5 2022, 1:41 PM · Data-Engineering, Equity-Landscape
KCVelaga_WMF added a comment to T306617: Readership Output Rank Metrics.
  • Missing countries should be fixed now.
    • Northern America is present in both continent and sub-continent level aggregations.
Oct 5 2022, 1:33 PM · Equity-Landscape, Data-Engineering

Sep 20 2022

KCVelaga_WMF added a comment to T309274: Editorship Input Metrics.

@JAnstee_WMF I have fixed the permissions. Can you check if you are able to access now?

Sep 20 2022, 1:45 PM · Equity-Landscape, Data-Engineering

Sep 15 2022

KCVelaga_WMF closed T304998: Priority metric improvements: Programs metrics by geo as Resolved.

We have finalized the considerations and metrics to be developed for Build 1.

Sep 15 2022, 10:43 AM · Equity-Landscape
KCVelaga_WMF moved T306618: Editorship Output Rank Metrics from In Development to In QA Review on the Equity-Landscape board.
Sep 15 2022, 10:42 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF moved T306617: Readership Output Rank Metrics from In Development to In QA Review on the Equity-Landscape board.
Sep 15 2022, 10:42 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF renamed T306618: Editorship Output Rank Metrics from Editorship Metrics Transformation to Editorship Output Rank Metrics.
Sep 15 2022, 10:42 AM · Equity-Landscape, Data-Engineering
KCVelaga_WMF reopened T306618: Editorship Output Rank Metrics, a subtask of T305475: Milestone: Ingest and Transform Input Data, as Open.
Sep 15 2022, 10:41 AM · Equity-Landscape, Data-Engineering