Projects using Microsoft Excel in Greater Accra Region

Projects using Microsoft Excel in Greater Accra RegionProjects using Microsoft Excel in Greater Accra Region

Cover image for Captured bills, invoices, and expense

Captured bills, invoices, and expense transactions into QuickBooks for an SME client, ensuring all records were accurately categorized and saved with zero errors.

0

36

Cover image for E-Commerce Churn Analysis Project

E-Commerce Churn Analysis Project

0

1

Cover image for Ghana Financial Inclusion Analysis (2017–2024)

Ghana Financial Inclusion Analysis (2017–2024)

0

1

Cover image for GitHub - Tonyflam/Data_Analysis_and-visualization

GitHub - Tonyflam/Data_Analysis_and-visualization

0

11

Cover image for Management Report

Management Report

0

1

Cover image for Took a messy, inconsistent dataset

Took a messy, inconsistent dataset with missing values, mixed formats, and duplicate entries and cleaned it into a structured, analysis-ready Excel spreadsheet.

0

26

Cover image for Global Healthy Diet Cost Analysis (2017–2024)

Global Healthy Diet Cost Analysis (2017–2024)

0

0

Cover image for Revenue Performance Analysis Project

Revenue Performance Analysis Project

0

2

Cover image for Monthly bookkeeping summary for a

Monthly bookkeeping summary for a small business client covering revenue, expenses, accounts receivable, and payable etc. Clean report and reconciled transactions for the month

0

23

Cover image for Power BI Dashboard on Girl Child Education in Africa

Power BI Dashboard on Girl Child Education in Africa

1

0

Cover image for Full bank reconciliation statement and

Full bank reconciliation statement and management accounts for a small business client, identifying and resolving discrepancies between the cashbook balance and bank statement.

0

23

Cover image for Excel Data Analytics Project |

Excel Data Analytics Project | Revenue Performance Dashboard I built an interactive Revenue Performance Dashboard in Excel to analyze revenue, profit, and product performance across multiple years (2011–2014). 🔍 Key Insights from the Analysis: 1.North Cascade consistently led revenue generation, making it the primary growth driver across all years. 2.Coffee (http://2.Coffee) and Fresh Salads emerged as the top performing product groups, contributing the highest share of total revenue. 3. Convenience Stores generated the highest total revenue , indicating strong market reach. 4.Supermarkets recorded the strongest profit margins ,reflecting higher efficiency in cost and pricing structures. 5.Despite revenue growth over time, profit margins remained relatively stable (~26–28%), suggesting controlled cost structures rather than aggressive price increases. 6.A small number of products recorded negative margins, signaling pricing or cost inefficiencies that require attention. 📌 Strategic Recommendations 1.Increase investment in high-performing categories (e.g., Coffee). 2.Strengthen distribution through Convenience Stores to maximize revenue reach. 3.Reassess low-margin product pricing strategies. 4.Implement customer feedback systems to improve product positioning. 🛠 Tools & Skills Demonstrated: Microsoft Excel (Pivot Tables, Pivot Charts, Slicers) Data cleaning and transformation KPI design and dashboard storytelling Business performance and trend analysis This project reflects my approach to analytics: turning raw data into clear, actionable insights for decision-making.

0

27