Week 4

Milestones

• Adding users table to ETL
• Starting with adding endpoints for HR tab
• Preparation for mid point showcase

Screenshots / Videos

User table moved to ETL

Contributions

• https://github.com/AvinashRamachandruni/avni-etl/pull/10

Learnings

• Learning how data is fetched from avni-server for canned reports
• SQL triggers were causing some problems so got to learn how to handle those
• Link to presentation for midpoint showcase https://tinyurl.com/y6595nsc
• Feedback from midpoint showcase :-
  • Understand how the specific ETL tasks are been defined
  • Discuss if making a separate database for Analytics operation instead of a schema in the same database will be more beneficial