DARTS : Athena & DARTS Communication

Shared Documents:

• Project Plan (Googlesheet)
• Data Architecture
• Datamart Pilot Folder

Finance:

• Staging database specification
  
  
• Tables and views:
  • Source tables profile 4-5-19
  • Discoverer Tables and Views Profile 3-29-19

  • SQR for PS_UM_GLQ_REPORTING table - Confluence page for UM_GLQ_REPRTING

  • SQR for PS_UM_GLQ_ACCTA table  - Confluence page for UM_GLQ_ACCTA
    
    
• Discoverer Reports: 

1. • Tables used in Discoverer Finance
   • ITS Dept Summary FY2019 February.xlsx
   • ITS Dept Summary FY2019 February.sql
   • Revenue and Expense Report from Discoverer 3-25-19.xls
   • Revenue and Expense Report from Discoverer 3-25-19.sql
     
     

• Power BI Test Reports:
  • Power BI file.pbix
  • SQL used for Revenue and Expense Report in PBI.txt

Meeting agendas:

(Datamart Pilot Athena Project Planning Folder)

• Bi-weekly session 04/16/2020

• Bi-weekly session 1/9/20

• Bi-weekly session 12/12/19

• Weekly session 11/14/19

• Weekly session 10/31/19

• Weekly session 10/17/19

• Weekly session 10/3/19

• Weekly session 9/26/19

• Weekly session 9/12/19

• Talend FN integration: September 2019

• Source to Target: September 2019

• Weekly session 9/5/19

• Alternate keys 9/4/19

• Talend Tips & Tricks 9/3/19

• Weekly session 8/29/19

• Exploring data in PBI 8/28/19

• DM documentation 8/27/19

• Weekly session 8/21/19

• Staging Orientation Walk-Through (link to video) 8/20/19

• Weekly session 8/14/19

• Weekly session 8/8/19

• Load dimension tables: August 2019

• Tracking Status in PBI

• Weekly session 7/26/19

• Weekly session 7/19/19

• Weekly session 7/12/19

• Talend FN Staging: July 2019

• Weekly session 6/28/19

• Weekly session 6/21/19

• Talend FN Staging: June 2019

• Weekly session 6/13/19

• Weekly session 6/7/19

• Talend Stats June 2019

• Weekly session 5/31/19

• Weekly session 5/24/19

• Talend Stats Overview May 2019

• Weekly session 5/17/19

• Data marts check-in 5/14/19

• Weekly session 5/10/19

• Weekly session 5/3/19

• Context variables 5/1/19

• Weekly session 4/26/19
  

• Power BI | DM Project Planning 4/24/19
  
• PS_UM_GLQ_REPRT_VW 4/23/19
  
• ER Studio Model 4/22/19

• Weekly session 4/19/19

• Weekly session 4/12/19
  
• DM Technical Team Meeting 4/10/19
• Weekly session 4/5/19
• Check-in 4/3/19
• Discoverer & Finance 3/29/19
• First Meeting 3/25/19