EDMA Data Operations and Engineering - Data Layer Support Matrix

Management Insights

	Ashwini	Jyoti	Arpana	DE - Primary	DE - Backup
Market Review Metrics		Data Layer		Lavanya	Ganesh
Customer and Revenue Dashboard			Dashboard dev	Ganesh	Kavitha
ELT Dashboard			Dashboard dev	Ganesh	Jeff, Lavanya and Kavitha
Revenue Detailed Analysis Dashboard			Dashboard dev	Ganesh	Kavitha
LHB		Data Layer Dashboard Dev		Jeff	Kavitha
Rep Performance Dashboard		Data Layer	Dashboard dev	Ganesh	Lavanya
Customer and Revenue Retention Dashboard	Product Scorecard & Product View Dashboard Dev	Data Layer	Dashboard Dev	Ganesh	Kavitha
Returning Customer		Data Layer Dashboard Dev		Ganesh	Kavitha
Lever Dashboard		Data Layer Dashboard Dev		Jeff	Kavitha
Sales Lever Dashboard		Dashboard Dev		Jeff	Kavitha
Cross Sell Lead dashboard		Dashboard Dev Data Layer - Originally built by Nijam, Taken over since then for enhancements		Lavanya	Ganesh
Customer Support Dashboard -Enhancements		Enhancements since take over from App Insights Data layer Dashboard Dev		Ganesh	Lavanya
Transaction Attachment	Data layer Dashboard Dev			Lavanya	Ganesh
Demand Plus Dashboard	DASHBOARD DEV			Lavanya	Kavitha
Sales Productivity		Dashboard Dev		Lavanya	Jeff and Kavitha
Sales Full Funnel		Dashboard Dev		Lavanya	Jeff and Kavitha

App Insights

	Anwesa	Tonnie	Aksha	DE - Primary	DE - Backup
SMPay	DATA LAYER (Exclude SMPay Usage, Include SMPay Attachment) DASHBOARD DEV	DASHBOARD DEV	DATA LAYER	Jeff SMPay - Enhancement SMPay Usage - Development	Kavitha
GDS	DATA LAYER DASHBOARD DEV		DATA LAYER	Jeff - Development	Kavitha
CM	DASHBOARD DEV	DASHBOARD DEV	DASHBOARD DEV Some DATA LAYER	Jeff and Kavitha	Lavanya, Ganesh
TBB	DASHBOARD DEV	DASHBOARD DEV	DASHBOARD DEV Some DATA LAYER	Jeff	Kavitha
LH	DASHBOARD DEV	DASHBOARD DEV	DASHBOARD DEV Some DATA LAYER	Jeff	Kavitha
Product Health Tracker	Enhancements since take over from Management InsightsDASHBOARD DEVData layer	DASHBOARD DEV Data layer	DASHBOARD DEVData layer	Lavanya	Ganesh
Critical Incident	DASHBOARD DEV		DATA LAYER DASHBOARD DEV	Lavanya	Ganesh
Enterprise	DATA LAYER DASHBOARD DEV		DATA LAYER DASHBOARD DEV	Ganesh	Kavitha
RDX	DATA LAYER DASHBOARD DEV		DATA LAYER DASHBOARD DEV	Ganesh	Kavitha
Connectivity( PMS, Channel)	DASHBOARD DEV	DASHBOARD DEV	DASHBOARD DEV	Jeff - Development	Kavitha
Partner Connection	DATA LAYER DASHBOARD DEV	DATA LAYER DASHBOARD DEV		Lavanya	Ganesh
SMX Dashboard	DATA LAYER DASHBOARD DEV	DATA LAYER DASHBOARD DEV		Lavanya	Ganesh
Channel Reporting ( Will phase out after connectivity is approved)	DASHBOARD DEV	DASHBOARD DEV		Jeff - Development	Kavitha
Total Reservation		DATA LAYER DASHBOARD DEV	DATA LAYER DASHBOARD DEV	Ganesh	Jeff
Revenue Assurance		DATA LAYER DASHBOARD DEV	DATA LAYER DASHBOARD DEV	Lavanya	Ganesh
Channel Productivity ( Aka Channel Recommendation)		DASHBOARD DEV	DATA LAYER DASHBOARD DEV	DATA LAYER Jeff	Kavitha
Platform Migration		DASHBOARD DEV		DATA LAYER Jeff	Kavitha

App Insights Dashboard - Additional Details

Dashboard	Product	Dashboard Owner	Summary Layer	Summary Layer Owner	Last 2 months changes	Backup	Expecting Change
SMPay	SMPay	Tonnie Ya-on, Anwesa	`dbi_bi_prd_src_tabs.sm_pay_summary_layer`	Jeff		Kavitha
Pay Usage	SMPay	Tonnie Ya-on, Anwesa	`dbi_bi_prd_src_tabs.pay_usage_summary`	Jeff	SMPay Usage denominator variance check against CM, TBB, LH	Kavitha	Expecting Change
PAY Attach Report	SMPay	Anwesa Choudhury	`EDMA_PROD.DBI_BI_PRD_SRC_TABS.pay_attach_ref`	Jeff	Creating the Pay Attach Layer Bringing in the LHB Opportunities	Kavitha
GDS Scorecard	GDS	Anwesa	`DBI_BI_PRD_SRC_TABS.GDS_Scorecard_Summary_Layer`	Anwesa, Jeff, Aksha	Investigation of Duplicates which affects the trans rev. Booking Date Metrics	Kavitha	Expecting Change
Billed Group Dashboard - Detailed	Enterprise	Anwesa Choudhury	`dbi_bi_prd_src_tabs.group_billed_res_ref`	Anwesa, Aksha	Adding Avg Connected Channels & PMS Including Support SLA	Ganesh and Kavitha
Billed Group Dashboard - Lite	Enterprise	Anwesa Choudhury	`dbi_bi_prd_src_tabs.group_billed_res_ref`	Anwesa, Aksha	Adding Avg Connected Channels & PMS Including Support SLA	Ganesh and Kavitha
Billed Group Dashboard - Quarterly View	Enterprise	Anwesa Choudhury	`dbi_bi_prd_src_tabs.group_billed_res_ref`	Anwesa, Aksha	Adding Avg Connected Channels & PMS Including Support SLA	Ganesh and Kavitha
Billed Group Trended Dashboard	Enterprise	Anwesa Choudhury	`dbi_bi_prd_src_tabs.group_billed_res_ref`	Anwesa, Aksha	Adding Avg Connected Channels & PMS Including Support SLA	Ganesh and Kavitha
Enterprise Account Details	Enterprise	Aksha Kurtarkar	`dbi_bi_prd_src_tabs.group_billed_res_ref`	Anwesa, Aksha		Ganesh and Kavitha
RDX Partner Billed Group Dashboard	Reseller	Anwesa Choudhury	`dbi_bi_prd_src_tabs.group_rdx_partners_billed_res_ref`	Anwesa, Aksha	Adding Avg Connected Channels & PMS Updating PMS Visibility with Connectivity Layer Inclusion of local currency and Opp Type Filter	Ganesh and Kavitha	Suspect Change
Account Summary Dashboard	Enterprise	Anwesa	`DBI_BI_SRC_TABS.PROJ_LIFT_ACCT_CONNCTD_CHANNELS`	Jeff		Ganesh and Kavitha
CM Reservation	CM	Aksha	`dbi_bi_prd_src_tabs.cm_reservation_hist`	Jeff		Lavanya , Ganesh and Kavitha
Platform Migration	All Products	Aksha	`EDMA_PRODANALYST.NXS_USERS_PRODANALYSIS` `DBI_BI_PRD_SRC_TABS.PLATFORM_MIGRATION_SUMMARY` `EDMA_PRODANALYST.PLATFORM_MIGRATOR_TOOL`	Jeff	Released On May 23	Kavitha	Expecting Change
Platform Migration - For Report Extract	All Products	Aksha	`DBI_BI_PRD_SRC_TABS.PLATFORM_MIGRATION_SUMMARY` `EDMA_PRODANALYST.PLATFORM_MIGRATOR_TOOL`	Jeff	Released On May 23	Kavitha	Expecting Change
TBB - Monthly Scorecard	TBB	Aksha	`dbi_bi_prd_src_tabs.tbb_product_summary bu_growth_core.dim_date`	Aksha		Jeff and Kavitha
TBB Reservation Trending	TBB	Aksha	`dbi_bi_prd_src_tabs.tbb_reservation_hist`	Jeff, Aksha ( understands the logic)		Kavitha
Total Reservations via SiteMinder	CM,TBB,LH	Tonnie, Aksha	`dbi_bi_prd_src_tabs.tbb_reservation_hist`	Tonnie Ya-on Aksha	Aligning outlier filters to our existing product layers Dynamic inclusion of the year current year details Exclusion of LH from CM Reservation	Jeff and Kavitha
Canvas	Canvas	Aksha	`dbi_bi_prd_src_tabs.canvas_middle_layer`	Aksha		Ganesh and Kavitha
CM Reservation - Detail View	CM	Aksha	`dbi_bi_prd_src_tabs.cm_reservation_hist`	Jeff, Aksha ( understands the logic)		Lavanya , Ganesh and Kavitha
CM Reservation - Last 3 Months Res and Login Details	CM	Aksha	`dbi_bi_prd_src_tabs.cm_hotelier_connection dbi_sf_x_01.sf_nsx_property dbi_sf_x_01.sf_account`	Jeff, Aksha ( understands the logic)		Lavanya , Ganesh and Kavitha
CM Reservation Cohort Analysis	CM	Aksha	`dbi_bi_prd_src_tabs.cm_reservation_hist_all dbi_bi_stg_src_tabs.cu_cm_data`	Jeff, Aksha ( understands the logic). Aksha owner of cu_cm_data		Lavanya , Ganesh and Kavitha
CM Reservation Trending	CM	Aksha	`dbi_bi_prd_src_tabs.cm_reservation_hist`	Jeff, Aksha ( understands the logic)		Lavanya , Ganesh and Kavitha
Critical Incidents Tracking	CI	Aksha	`dbi_bi_prd_src_tabs.product_critical_incidents_ref`	Aksha		Lavanya
Guest Data Analysis	CM	Aksha	`dbi_bi_stg_src_tabs.cu_cm_data dbi_bi_prd_src_tabs.cm_reservation_hist`	Jeff, Aksha ( understands the logic)		Lavanya , Ganesh and Kavitha
LH - Monthly Scorecard	LH	Aksha	`dbi_bi_prd_src_tabs.lh_product_summary bu_growth_core.dim_date`	Aksha		Jeff and Kavitha
LH Reservation	LH	Aksha	`dbi_bi_prd_src_tabs.lh_reservation_hist`	Jeff, Aksha ( understands the logic)		Jeff and Kavitha
LH Reservation Trending	LH	Aksha	`dbi_bi_prd_src_tabs.lh_reservation_hist`	Jeff, Aksha ( understands the logic)		Jeff and Kavitha
Partner Connection	CM	Anwesa Choudhury	`dbi_bi_prd_src_tabs.sm_partner_connections` `dbi_bi_prd_src_tabs.sm_partner_connections_active` `dbi_bi_prd_src_tabs.SMX_SF_SWF` `dbi_bi_prd_src_tabs.partner_sf` `dbi_bi_prd_src_tabs.smx_connection_swf`	Anwesa	Source of channel activation was derived from Connectivity Layer	Lavanya , Ganesh and Kavitha
Revenue Assurance	All Products	Aksha	`dbi_bi_prd_src_tabs.all_products_revenue_assurance_ref`	Aksha	Investigation of returning customers	Lavanya and Ganesh
SiteMinder Hotel List	CM	Aksha	`dbi_bi_prd_src_tabs.cm_hotelier_connection`	Jeff		Lavanya , Ganesh and Kavitha
SMX Connections	SMX	Anwesa	`dbi_bi_prd_src_tabs.SMX_ActRQ` `dbi_bi_prd_src_tabs.SMX_SFOpp_SWF`	Anwesa		Ganesh and Lavanya
TBB Reservation	TBB	Aksha	`dbi_bi_prd_src_tabs.canvas_middle_layer` `dbi_bi_prd_src_tabs.tbb_reservation_hist`	Aksha,Jeff		Kavitha
TBB Reservations - detail view	TBB	Aksha	`dbi_bi_prd_src_tabs.tbb_reservation_hist` `dbi_bi_prd_src_tabs.canvas_middle_layer`	Aksha,Jeff		kavitha
TCM - Monthly Scorecard	CM	Aksha	`dbi_bi_prd_src_tabs.cm_reservation_hist`	Aksha		Lavanya , Ganesh and Kavitha
Top Booking Channels By Country	CM	Aksha	`dbi_bi_prd_src_tabs.cm_reservation_hist`	Jeff, Aksha ( understands the logic)	LOS was corrected	Lavanya , Ganesh and Kavitha
Channel Recommendation Engine	CM	Aksha, Tonnie	`dbi_prod_viz_summary_vws.cm_hotelier_int_plat_ml`	Jeff, Aksha ( understands the logic)	Ranking of Metrics and including market stats ( In progress)	Lavanya , Ganesh and Kavitha
Connectivity Dashboard - Channels	CM	Aksha, Anwesa	`DBI_BI_PRD_SRC_TABS.CM_INTEGRATION_PLATFORM_HISTORICAL`	Jeff		Lavanya , Ganesh and Kavitha	Expecting Change ( Dashboard) SCD for archival
Connectivity Dashboard - PMS	CM	Aksha	`DBI_BI_PRD_SRC_TABS.CM_INTEGRATION_PLATFORM_HISTORICAL`	Jeff		Lavanya , Ganesh and Kavitha	Expecting Change ( Dashboard) SCD for archival
Market Future Trends	CM	Aksha	`dbi_bi_stg_src_tabs.cu_cm_data dbi_bi_prd_src_tabs.cm_reservation_hist`	Aksha, Jeff		Lavanya , Ganesh and Kavitha

Sales Operation Support

	Shai	Camille	Soumi	DAG	DE - Primary	DE - Backup
Sales Master Dashboard	DATA LAYER DASHBOARD DEV		DATA LAYER DASHBOARD DEV	Link
Sales Forecast Origin 1			DATA LAYER DASHBOARD DEV	Link
Sales Forecast Origin 2			DATA LAYER DASHBOARD DEV	Link
TQL Monitor		DATA LAYER DASHBOARD DEV	DATA LAYER DASHBOARD DEV	Link (TQL_FC.sql, TQL_AUDIT.sql, TQL_ALLOCATION.sql)
Global TAM Planner			DATA LAYER DASHBOARD DEV	Link (TERRITORY_PLANNER.sql)
New Hire/Leaver Data Download Page		DATA LAYER DASHBOARD DEV	DATA LAYER DASHBOARD DEV	Workflow that refreshes dbi_sf_x_01.sf_account table
Ideal Customer Profile	DATA LAYER DASHBOARD DEV		DATA LAYER DASHBOARD DEV	Link (TITLES_JOB_ROLES.sql, ICP_CUSTOMERS.sql)