PostNet International Franchise Corporation provides a wide range of convenient and high-quality design, printing and shipping solutions for businesses and consumers. Since PostNet began franchising in 1993, the brand has grown to 660 locations in 9 countries
I was asked to create a custom Zoho Analytics dashboard for Executive Level users to view sales data for over 200 international locations.
The dashboards optimized cross-departmental reporting by integrating 5+ disparate data sources into Zoho Analytics, reducing manual reporting time and increasing data accuracy across the organization.
Tasks included:
- End-to-End Data Integration: Architected and maintained complex data pipelines connecting Zoho CRM, Books, Projects, and external SQL databases via Zoho Databridge and API integrations.
- Advanced Data Modeling: Utilized SQL (Zoho CloudSQL) to perform complex data JOINs, lookups, and query tables, transforming raw datasets into structured, report-ready formats.
- Custom Visualization: Designed interactive, C-suite level dashboards featuring KPI widgets, pivot tables, and trendlines to track real-time metrics such as Sales by Category and Monthly Recurring Revenue (MRR).
- Stakeholder Enablement: Managed user permissions and organized workspace hierarchies to ensure secure, role-based access to sensitive financial and operational data.