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.

• GitHub
• YouTube
• Gumroad
• Etsy

© 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.

Executive Program Tracker

A government program team was managing 66 deliverables across 7 workstreams using Excel spreadsheets. Leadership had no real-time view of what was on track, at risk, or falling behind. Status updates required manual compilation before every review meeting.I built a 2-page Looker Studio dashboard connected to a Google Sheets backend. The Executive Summary page shows five KPI scorecards with donut ring indicators, a workstream summary table with automated RAG color coding, and filters by workstream, owner, status, and quarter. The Action Items page automatically surfaces at-risk and blocked deliverables. RAG thresholds are configurable, so the team can adjust sensitivity without touching formulas.

Result: Real-time program visibility. No manual status compilation. Leadership reviews run off one live dashboard.

Tools: Looker Studio · Google Sheets

Healthcare Payroll Automation

A behavioral health clinic with 30+ practitioners was running payroll manually each billing cycle. Staff cross-referenced CSV exports from their practice management system, looked up rates, validated CPT codes, and categorized reimbursements by hand. The process was slow, error-prone, and repeated every cycle.I built a Google Apps Script web app that connects directly to the IntakeQ API, pulling appointment and billing data automatically. The backend handles rate lookups, CPT validation, reimbursability categorization, and generates template-based pay summaries for each practitioner. Chunk-based processing handles 100+ appointments and 300+ API calls per cycle within Apps Script's execution limits.

Result: One-click payroll processing. No more manual cross-referencing. Billing cycle prep that took hours now runs automatically.

Tools: Google Apps Script · IntakeQ API · Google Sheets

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

Shopify Order Fulfillment Automation

An art e-commerce store was managing orders across three print-on-demand suppliers manually. Order intake, production tracking, shipping updates, and customer fulfillment notifications all required human coordination between Shopify, email, and supplier portals.I built a 5-workflow n8n automation system that handles the full order lifecycle. Shopify webhooks capture new orders into Airtable, supplier email parsing extracts production status and tracking numbers, and the Fulfillment API syncs tracking to customers automatically. The system includes direct API integration with one supplier for multi-panel artwork lookups and duplicate prevention, 3-layer carrier normalization covering 37 carriers (327 test cases, 100% pass rate), and Google Chat Cards V2 notifications with interactive submit forms for the team.

Result: Orders routed, tracked, and fulfilled without manual intervention. The team manages everything from Airtable and Google Chat.

Tools: n8n · Airtable · Shopify API · Google Chat

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.

• Back
• Contact

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.

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.

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.

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.

• Back
• Contact

Store

I build tools and templates that solve specific problems. Each one comes from real project experience, includes full documentation, and is designed to work out of the box.

Dollar Cost Averaging Calculator

Planning DCA entries manually is tedious and error-prone. This Excel tool does the math for you.Enter your entry price, exit price, and stop loss. One click generates everything else: risk-to-reward ratios, weighted cost basis, and profit/loss projections.No formulas to write. No manual calculations. Track multiple entries per stock with color-coded results.Full documentation included.

• Back
• Buy on Gumroad

Key Levels & Scaling Out Calculator

See where price stands against key levels. Plan your exits before the trade.Enter your prices, see percentage change and dollar difference instantly. Three calculators in one workbook: Key Levels, VWAP Levels, and Scaling Out.Color-coded rows. Auto-updating charts. No macros needed. Fully editable template you can customize.

• Back
• Buy on Gumroad

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 believe the best tools are the ones people actually use, not the ones with the most features.I work remotely with clients in the US, UK, and Europe. Clear communication and async workflows keep projects on track, regardless of time zones.Let's work together.

• Back
• Contact