Tarik Zoubir
Data Analyst & Dashboard Specialist
New to Contra
Tarik is ready for their next project!
Automated Business Overview Dashboard (Google Sheets)
Project Description:
I developed a fully automated and interactive executive dashboard using Google Sheets. This tool is designed to provide business leaders with a real-time, comprehensive overview of their critical performance metrics (KPIs) in a single, visually appealing interface.
Key Features:
Custom KPI Tracking: Real-time monitoring of essential metrics such as Total Revenue, Total Orders, Average Order Value (AOV), and Conversion Rates, complete with period-over-period growth indicators.
Dynamic Data Visualization: Integration of clean, easy-to-read charts, including monthly sales revenue bar graphs and product category revenue pie charts.
Automated Data Sync: Built to seamlessly pull and process live data, eliminating the need for manual updates and ensuring 100% accuracy.
Impact: This dashboard empowers decision-makers to quickly analyze business health, identify sales trends, and make data-driven decisions without getting lost in raw spreadsheet data.
0
14
PDF to Excel/Google Sheets Conversion & Data Entry Services
Project Description:
I offer professional and accurate document conversion services, specializing in transforming PDFs, scanned files, and images into structured Excel spreadsheets or Google Sheets. Whether it's complex bank statements, invoices, or manual data entry tasks, I ensure high-quality results.
Key Services:
PDF to Excel/Google Sheets: Converting various document formats with precision.
Bank Statement Specialization: Accurately extracting data from financial documents into organized spreadsheets.
Data Cleaning & Formatting: Ensuring the extracted data is clean, well-organized, and ready for analysis.
Manual Data Entry: Handling complex documents that require human verification for 100% accuracy.
My Guarantee:
I am committed to providing 100% accuracy and guaranteed client satisfaction. My meticulous manual review process minimizes errors and ensures data integrity.
0
28
Project Title: Production Monitoring & KPI Tracking Dashboard
Project Description:
I designed and developed a custom analytical dashboard dedicated to production monitoring and performance tracking for a customer contact center. This interactive tool centralizes operational data and allows managers to track activity in real-time through a clear, dynamic interface.
Key Features:
Real-Time KPI Monitoring: Instant calculation and display of critical metrics (injected tickets, processed tickets, reachability rate, and customer satisfaction rate).
Advanced Data Visualization: Integration of dynamic charts (pie charts and bar graphs) to analyze processing status distribution and evaluate individual agent performance.
Custom Filtering & Reporting: Advanced sorting system by time period (dynamic calendar) and by agent, featuring dedicated tabs for detailed reports (e.g., Unfounded Tickets, VAS Reporting).
Impact:
This dashboard transformed data analysis for the management team. By replacing manual reporting with this automated tool, supervisors can now identify bottlenecks at a glance, provide targeted coaching to agents, and significantly optimize the overall quality of customer service.
0
28
Base2Co: Telecom Knowledge Management Web App
I developed Base2Co, a custom, real-time knowledge management platform tailored for telecom and ISP call center agents. Built using Google Apps Script, HTML/CSS, and JavaScript with a Google Sheets dynamic backend, this mobile-responsive tool bridges the gap between complex documentation and fast-paced customer support.
Key Features:
Smart Search & Scenario Engine: Instant filtering of procedures and an integrated simulation engine for agent scripts.
Intuitive UI: Fast navigation categorized by business universes (Prepaid, Postpaid, Internet, Roaming, VAS).
Operational Efficiency: 1-click CRM template copying to eliminate manual typing errors.
Impact: Centralizing scattered operational guides into this lightning-fast interface significantly reduced Average Handling Time (AHT) and improved First Contact Resolution (FCR) for the support teams.
1
57