Description: The goal was to ensure all departments had access to precise data for informed decision-making, addressing the distinct needs of marketing, sales, and customer success teams.

Defining Strategic KPIs: Collaborated with each department to define strategic and operational KPIs tailored to their specific needs, ensuring alignment with overall business goals.

Data Extraction & Structuring: Extracted data from the data warehouse (Firebase and BigQuery) using SQL queries, ensuring that datasets were clean and accurately represented the business metrics.

Dashboard Development: Built custom dashboards in Looker Studio, enabling real-time monitoring of KPIs for each team. The dashboards included interactive elements like filters and drill-downs to provide a comprehensive view of performance.

Ongoing Collaboration: Maintained close communication with department heads to refine dashboards based on evolving business needs, continuously improving the relevance and usability of the visualizations.

Strategic & Operational Insights: Delivered visualizations that empowered each team to make data-driven decisions, whether for strategic planning, sales optimization, or improving customer satisfaction.

This structured approach ensured that every team had access to actionable insights, boosting cross-functional efficiency and decision-making across the entire marketplace.