Hi there 
, I'm Douglas Boateng
Data Analyst skilled in Excel, Google Sheets, Power BI, Figma, PowerPoint, SQL, and Python, with a focus on turning messy data into clear, decision-ready insights through strong data cleaning, modeling, analysis, and storytelling.
Core strengths include:
- Collecting, merging, and reconciling data from multiple sources (databases, web connections, flat files)
- Cleaning, validating, and transforming datasets (Power Query, spreadsheets, SQL, Python)
- Designing and managing data models (star schemas, relationships, fact/dimension tables)
- Building interactive dashboards and reports (Power BI/Tableau) with thoughtful UI/UX wireframing (Figma/PowerPoint)
- Writing strong SQL for querying, joins, aggregations, and performance-friendly reporting datasets
- Creating analysis workflows in Python for EDA, visualization, and predictive modeling
- Communicating insights clearly through reports, presentations, and stakeholder-ready recommendations
- Versioning and sharing analytics work via GitHub for collaboration and reproducibility
- SQL (PostgreSQL, MySQL)
- Microsoft Excel
- Google Sheets
- Power BI
- Python (Numpy, Pandas, Matplotlib, Seaborn, Scikit-learn)
- Figma
- Microsoft PowerPoint
- GitHub
| Project | Tools | Description |
|---|---|---|
| Product Performance Analysis (MVP) - Campaigns |
|
An MVP Power BI report evaluating how the Campaigns product is performing across revenue, entries, clients, and campaigns. Includes participation funnel metrics (valid vs invalid entries, wins/win rate), reward operations (disbursed vs pending), and demographics coverage (regional distribution + gender where collected). Built using confidential internal company data (no dataset link). |
| Auto Insurance Claim Prediction |
|
This project focused on developing predictive analytics to identify customers likely to submit a claim within the first three months, uncover customer insights, and propose strategies to boost profitability and efficiency. |
| South American Celebrities |
|
An in-depth analytical report on South American celebrities, focusing on singers and actors. Developed using a custom SQL database and visualized in Power BI to uncover insights on net worth, demographics, career success, and social impact. Activities include:
|
|
|
|