Francis Partron Addo
Data Analyst | BI Analyst | Passionate about Workflow Automation & Sustainability.
Data & BI Analyst
About Me
Hi, I’m Francis🙋a Data & BI Analyst 🤖 passionate about turning data into smarter, more sustainable decisions. I analyze data, build dashboards and reports that highlights business and environmental impact, automate workflows to cut waste, and design solutions that help organizations drive both business performance and climate resilienc
⚙️Services
- Build data pipelines to Extract Transform and Load data
- Build interactive dashboards and reports to inform business decisions
- Design and automate AI workflows that scale impact
- Lead cross-functional programs aligned with climate and sustainability goals
Featured Projects
Real-Time Air Quality Monitoring Pipeline
Streaming Pipeline Using Dataflow:
Real-time data streaming pipeline for environmental monitoring that ingests IoT sensor data from multiple sources (PM2.5, PM10, CO, NO₂, O₃, temperature, humidity) to visualize and analyze city-level air quality in Accra.
Source: IoT sensors in cities stream air quality data (timestamp, location, PM2.5, PM10, CO, NO2, O3, temperature and humidity) levels every few seconds. In this project, I used Pub/sub to BigQuery. The Pub/sub template is a streaming pipeline that can read JSON-formatted messages from a Pub/Sub topic and write them to a BigQuery table
Pipeline:
- Pub/sub (Raw messages)
- Dataflow (Custom User Defined Function (UDF) stage: clean/transform/enrich)
- BigQuery (Analytics-ready table)
Dashboard: Tableau showing city-level pollution, alerts when thresholds are exceeded.
Impact: Demonstrates environmental monitoring for smart cities.
Fiber Call Center Analytics
This project analyzes Google Fiber Customer caller complains for management to make informed descisions
Tableau_Hands-on_Project
This Project features a Dashboard built with Tableau to analyse Traffic volume.
Sales Performance Overview
This Dashboard is for analysis of Vehicle sales performance. The project was built solely on Power Query and Excel
🧠Skills
- Analytics Tools: Power BI, Tableau, Excel
- Databases: MySQL, BigQuery
- Programing: Python (Pandas, Matplotlib), R, DAX
- Collaboration: GitHub, Google Workspace, Notion, Airtable, Zoom, Slack, Teams
- Concepts: ETL, Data modeling, KPI reporting, Dashboard Design, Data cleaning, AI & Workflow Automations
- Climate & Sustainability: Green digital skills & Event Management.
You can reach me at:
| Defrancees@gmail.com | |
| ⛓️ Social | LinkedIn 4ward.earth |
| 💼 My Resume | Download Resume |
Let’s connect and solve problems that matter with data, climate, purpose, and innovation.