Alfred
Shingai

Data Analyst ·

I’m a data analyst with a strong foundation in Python, Power BI, and Excel, focused on turning raw data into actionable insights that support better decision-making. I enjoy working with data to uncover patterns, solve problems, and present findings in a clear and meaningful way.

I work across the analytics process—cleaning and transforming data using Python (Pandas, NumPy), and building interactive dashboards in Power BI using DAX, Power Query, and data modeling techniques. In Excel, I create structured reports and dashboards using Pivot Tables, XLOOKUP, and advanced formulas to communicate insights effectively.

I focus on asking the right questions, simplifying complex data, and delivering insights that are practical and easy to understand. My goal is to produce work that is not only accurate, but genuinely useful in real-world decision-making.

Download CV View GitHub Contact Me

Projects

Internships

BSc

Final Year Applied Statistics, University of Zimbabwe

Featured Projects

Excel . Python . Power BI

Bike Sales Analysis

Analyzed 1,000 customer records using Excel and Power BI (data cleaning, pivot tables, and KPI design) to uncover key business insights. Identified high-income, middle-aged professionals as the highest-value customer segment. Found the Pacific region leads with a ~59% conversion rate, highlighting a strong market opportunity. Developed an interactive dashboard to track customer segments and regional performance. Insights support targeted marketing strategies to improve conversion rates and overall revenue efficiency.

PythonPandasExcelPower BIDAX

View on GitHub →

Python · Pandas · EDA · Excel ·

Bank Customer Churn Prediction

End-to-end ML pipeline predicting bank customer churn | EDA · Feature Engineering · Gradient Boosting · AUC 0.868

PythonData CleaningEDAPandas

View on GitHub →

Power BI

Flight Status Dashboard

An interactive Power BI dashboard analysing flight performance across U.S. airlines — covering delays, cancellations, on-time rates, and airline/airport comparisons.

Power BIDAXPower QuerryData Cleaning

View on GitHub →

Excel

CocaCola USA Retailer Analysis

This project analyses 9,648 retailer invoice records from 2022–2023 to uncover what drives Coca-Cola's US retail performance. The analysis covers revenue trends, brand profitability, regional distribution, retailer efficiency, and strategic growth opportunities.

ExcelData CleaningPower Query

View on GitHub →

Power BI · Python · Excel

Kevin Cookie Company Sales Analysis 2020

A full-stack data analysis project exploring the 2020 sales performance of the Kevin Cookie Company across international markets. KPIs and aggregations were first prototyped in Python (pandas), then implemented as live formulas in Microsoft Excel, and finally visualized in an interactive Power BI dashboard.

Power BIDAXSUMIFsPandas

View on GitHub →

Alfred
Shingai

What I Work With