April 3, 2025 1 min to read

(ENG) Corporate Analysis, DATA Analysis.

Written by CA-DATA Team

🌱 CA Data Team - ESG Project Progress Report (Environmental Focus)

🧭 Topic Selection and Data Collection Planning

• The CA Data Team has chosen to focus on the Environmental aspect of ESG (Environmental, Social, Governance).
• The core topic selected is carbon emission data.
• Each team member individually contacted 10 companies via email to request relevant carbon emission data.

🔍 Data Exploration and Initial Challenges

• The team conducted extensive searches on Kaggle to leverage existing datasets.
• Encountered challenges in securing ESG-specific carbon emission data with the desired level of granularity and reliability.

💡 Skill Development Activities

• During the data acquisition phase, team members focused on improving skills in:
  • Excel Functions
  • Power Query

📊 Kaggle Data Analysis Practice

• As a practical exercise, the team is working on the guided project:
  “Excel Data Analysis: Netflix and K-Content”

• Reference Article: 브런치 포스트 by Eunmee

• Dataset Used: Netflix Shows Dataset on Kaggle

• This hands-on project aims to:
  • Strengthen analytical skills
  • Help shape future directions for data analysis and visualization tasks

🔜 Next Steps

1. Continue data collection efforts – reach out to more companies and public institutions for carbon emission data.
2. Enhance analytical capabilities through practice and team sharing.
3. Begin full-scale analysis and visualization upon successful data acquisition.
4. Backup Plan: If ESG-related data remains unavailable, pivot the project to a general data analysis theme unrelated to ESG.