Data by Toufik

Data Analytics Engineering • Workflow Automation

Invest your time and attention where it matters. Together, we'll make your data useful and your processes effortless.

© Data by Toufik. All rights reserved.

portfolio

Most of my work lives inside client systems, not on display. But here are a few examples that show how I approach problems and what the results look like.

Revenue & Membership Dashboard

A subscription business needed visibility into revenue trends, member lifecycle, and conversion metrics. Data lived in spreadsheets and required manual cleanup before any reporting could happen.I wrote a Google Apps Script to automate the data transformation, then built a Looker Studio dashboard with real-time refresh. The dashboard includes MRR tracking, revenue breakdowns by source, member acquisition trends, and a visitor-to-customer funnel.

Result: Live metrics. No manual prep. One place to see what's working.

Tools: Looker Studio · Google Apps Script · Google Sheets

E-commerce P&L & Ad Analytics

An e-commerce business needed to see profitability across multiple ad channels (Google, Bing, Meta, Criteo) alongside Shopify sales, COGS, and logistics. Data lived in different systems. Reporting was slow and fragmented.I built an end-to-end analytics platform. Fivetran pulls data into BigQuery. Python pipelines handle FX rates and P&L calculations on a schedule. Tableau dashboards deliver the final view with row-level security and currency/timezone toggles.

Result: One source of truth. Real-time visibility into what's profitable and what's not.

Tools: BigQuery · Fivetran · Python · Tableau

Commercial Bid Calculator

A landscaping and snow removal company managed properties across multiple US states. Pricing varied by location, property type, crew size, and service model. Calculating bids was slow and error-prone.I built an Excel VBA tool with one-click automation. Dynamic pricing by state and city, multiple snow pricing models (Per Service, Per Event, Seasonal), crew multipliers, and production profiles. All pricing, profit margins, and settings are configurable through dedicated sheets, so the client can adjust without touching code. Built with a modular architecture that scales as the business grows.

Result: Fast, accurate bids. No manual calculations. Easy to update as the business grows.

Tools: Excel VBA · Excel Formulas

GTM Audit Tool & Lead Automation

A marketing consultant needed a system to capture leads, deliver personalized audit templates, and track engagement. Everything was manual: form responses, file sharing, follow-up emails, and status tracking.I built a 3-part automation system: Google Form captures leads, Apps Script creates personalized audit copies, shares them with respondents, sends emails, and updates a lead registry. The Lead Management sheet includes an interactive dashboard with KPI cards, status charts, 7-day trends, and clickable audit links. Each audit template features RAG scoring (Red/Amber/Green) and a dynamic Action Plan with auto-prioritization.

Result: Leads captured, audits delivered, progress tracked. All automated.

Tools: Google Apps Script · Google Sheets · Google Forms

Multi-Stage Requests Approval Automation

A robotics team needed a system to handle purchase requests and reimbursements. Requests came through Google Forms, then required approval from different teams depending on the type and amount. Approvers needed to respond via Slack or email. Tracking was manual, and there was no visibility into budgets or bottlenecks.I built a Google Apps Script system that routes each request to the right approval chain, sends notifications via Slack and email, captures approver feedback, and triggers the next step automatically. The system tracks workflow stages, monitors department budgets, and flags overdue requests. A 4-page Looker Studio dashboard provides near real-time visibility into active requests, approval times, spending by department, and budget utilization.

Result: Requests routed, approvals collected, budgets monitored. All automated.

Tools: Google Apps Script · Google Sheets · Looker Studio · Slack API

Have a Different Challenge?

Every project is different. If you don't see something similar to what you need, reach out. I'll share relevant examples.

services

I offer three core services to help businesses gain clarity from their data and efficiency from their workflows.

Data Visualization

It starts with your questions. What do you need to track? What decisions are you trying to make? Once we're aligned, we build dashboards that surface the answers — revenue, marketing, finance, operations — with clear visuals and real-time data.Need role-based access so each team only sees their data? Automated alerts when KPIs hit a threshold? Interactive filters or currency and timezone toggles for international teams? We'll build it in.Every project includes thorough documentation. A reference guide covering all metrics, formulas, and data sources — your single source of truth. And a one-pager that explains what the dashboard contains and how to use it, so your team is self-sufficient from day one.

  • Looker Studio

  • Tableau

  • Power BI

  • Excel

  • Google Sheets

Data Analytics & Pipelines

Good dashboards need good data behind them. We work together to consolidate your data from multiple sources — ads platforms, e-commerce, CRM, payments — into a single, reliable pipeline. Clean data, consistent formatting, scheduled refreshes.Need to pull from Google Ads, Meta, Shopify, Stripe, or other platforms? We'll build ETL pipelines that extract, transform, and load your data into a warehouse like BigQuery — ready for analysis or visualization. Every pipeline includes error handling, monitoring, and documentation so you know exactly how your data flows.

  • SQL

  • Python

  • BigQuery

  • Fivetran

  • Google Sheets

Workflow Automation

If you're doing the same task repeatedly, it can probably be automated. We'll identify the manual work that's eating up your time — data entry, report generation, file processing, notifications — and build systems that handle it for you.Whether it's a one-click Excel tool that generates client reports, an automated workflow that syncs data between platforms, or a custom Apps Script that triggers on form submissions — we'll design it to fit how your team actually works. Every automation includes documentation and is built for non-technical users to operate day-to-day.

  • Google Apps Script

  • Excel VBA

  • n8n

  • Make

  • Airtable

  • Zapier

Something Else in Mind?

If your needs fall outside the services above — or you're looking for a custom solution built from scratch — I'm open to it. Let's talk about what you're trying to achieve and figure out if we're a good fit.

Contact

Have a project in mind? Let's talk about how we can work together.

Thank you

Your message has been sent. I'll review it and get back to you within 1-2 business days.

About

I started in telecommunications. Four years as a radio engineer at Bouygues Telecom France, working through Accenture. I learned how large systems work, how to coordinate across teams, and how to find problems before they become crises.Then I made a deliberate shift. I joined two early-stage blockchain projects (Mysten Labs and Rug Radio), working remotely with international teams across time zones. That's where I discovered what I actually wanted to do: turn messy data into clear answers, and manual processes into automated workflows.Today, I build dashboards that teams actually use, pipelines that run without babysitting, and automations that save hours every week. I've worked with clients in e-commerce, finance, crypto, wine investment, marketing, landscaping, and home services. Different industries, same goal: make data useful and operations effortless.I work from Morocco, but my clients are in the US, UK, and Europe. Time zones aren't a problem. Clear communication is the norm.Let's work together.