Looker - CRM Dashboard for Internal Agent

I developed a customized dashboard for internal agents to manage and track attendance data effectively. This project aimed to streamline the process of collecting, cleaning, and reporting attendance details for follow-up actions.

What I Did:

Collected and consolidated attendance data from multiple sources.

Cleaned and organized the data for accuracy and consistency.

Repopulated attendance details into a structured format for easy reference.

Customized individual reports for each referrer, containing their specific data.

Created the dashboard using Google Data Studio to visualize and manage data.

Utilized Python for data processing.

Integrated Google Sheets for data storage and real-time updates.

Ensured the dashboard provided actionable insights for efficient follow-up.