Data Analyst
• Collect training participant data
• Clean and backup trainee data to a central database
• Maintain central database system
• Visualize and analyze training alumni data and PPALC data throughout Indonesia using Looker Studio (Google Data Studio)
• Extracting, updating, cleaning data and also analyzing using MySQL
• Coordinate with managers regarding the required data visualization displays
• Create a central database format design
• Perform vlookup and hlookup to complete data in Google Sheet and Excel
• Create PPALC data collection forms, regional administrators, and PPALC reports
• Updating and inputting incoming data from the form to the data source
• Input and update PPALC data on the web
• Provide data needed by managers, CEO, Training Division, regional administrators, and the general public
• Coordinate and communicate with the PPALC secretary in each region regarding data collection
• Teach regional secretaries to create databases
• Entering OTS training data into the EOA Events web
• Ensure each PPALC inputs data into the EOA Events database and web
• Update class schedules from the training division every week