Francisco Ferreira

Francisco Ferreira

Data Analyst - SQL · R · Power BI · Tableau

DATA

ANALYST

I'm a data analyst with a background in digital marketing, now focused on transforming data into insights that drive smart decisions.

After years managing performance campaigns across global markets, I shifted my focus fully to analytics, collecting, cleaning, and visualizing data to uncover trends and support strategy.

I work with tools like SQL, Python, Excel, and Tableau to build dashboards, automate reporting, and bring clarity to complex datasets.

I'm driven by curiosity, clear communication, and the belief that data is most powerful when it tells a story and leads to action. Because data is indeed everywhere.

PREMIUM

TOOLS

SQL
Querying, transforming, and analyzing data
R + Tidyverse
Data wrangling, visualization, and modeling
Python + Pandas
Data cleaning, analysis, and automation
Power BI
Interactive dashboards and business insights
Excel
Spreadsheets, charts, and formulas
PowerPoint
Presentation design and storytelling
Canva
Visual design for marketing & branding
Google Stack
Ads, Analytics, Tag Manager, Merchant Center
BigQuery + Looker
Cloud data and live dashboards
Tableau
Data storytelling with visual analytics
MySQL
Relational database management

RECENT

PROJECTS

Pizza Sales Performance Dashboard

A growing local pizzeria needed better visibility into their sales, product performance, and customer behavior. I designed an interactive dashboard to help them understand when and what customers order, which pizzas sell best (or worst), and how sales trend by time and category.
💡 Tools used: Excel, SQL Queries, PowerPoint.
📊 Focus: Sales analysis, product insights, dashboard design.

Pizza Sales Dashboard
View full case study on GitHub

Shopify Sales & Customer Funnel Dashboard

Built a dynamic funnel dashboard using Shopify sales data to help stakeholders monitor performance, understand customer behavior, and evaluate long-term customer value. Insights include repeat rates, order frequency, sales by location, and payment trends.
💡 Tools used: Power BI, Excel, and PowerPoint.
📊 Focus: Customer behavior, retention metrics, funnel analysis.

Shopify Sales Dashboard
View full case study on GitHub

Electric Vehicle Growth & Market Insights Dashboard

Analyzed EV registration data across the U.S. to uncover adoption trends, manufacturer market share, and battery tech progress. Visualizations include growth by model year, geographic spread, CAFV eligibility, and top-performing EV models and brands.
💡 Tools used: Tableau, Excel, PowerPoint.
📊 Focus: Market trends, geographic insights, tech evolution, consumer preference.

Weather Forecast Engine
View Dashboard View full case study on GitHub

LET’S WORK

TOGETHER

Contact me