W.

Hi, I am William Cufre.

A Data Analyst.

Here you will find my resume, projects and contact information.

Resume

Projects

Each project includes a “Behind the Visual” section explaining the data preparation, modeling, and code used.

#1 - Zarrafa's Coffee Sales

Not loading? Watch on YouTube

Interactive Dashboard in your own browser!

High-level view of coffee shops performance, complemented by a regional analysis that compares stores across different States.

Insights on sales, volumes, profit, and margins over time, from chain-level performance down to individual stores.

Key insights

  • Kiosks represent the largest store count and lead on total profit. However, Franchises are 24% more profitable.
  • Prioritizing Beverages and Bakery offers the highest return on optimization efforts.
  • Further analysis on funding, capital and operating costs by store type would help with expansion strategies.
  • Power Query
  • Data Modeling
  • Profit & Loss
  • DAX
  • Power BI

#2 - Northwind (Retail)

Not loading? Watch on YouTube

Interactive Dashboard in your own browser!

Designed as a concise demonstration of my ability to work with relational SQL databases end-to-end.

Structured data through SQL Queries, including the creation of reusable views. Visualized on Power BI.

Key insights

  • Beverages and Dairy Products dominate nearly 40% of total sales, suggesting strong consumer demand.
  • Focus on high-demand periods identified in categories like Confections, Seafood, and Meat/Poultry for targeted promotions.
  • Margaret Peacock stands out as the top performer exceeding the average by 65.5%. Buchanan, at 51% below the average, indicates potential areas for improvement.
  • PostgreSQL
  • Window Functions
  • Relational Database
  • SQL Views
  • Power BI
  • End-to-End Project

#3 - Adelaide Parking Fines

Not loading? Watch on YouTube

Interactive Dashboard in your own browser!

Using data sourced from the Adelaide Council, this project examines the financial and operational impact of a penalty-based enforcement system (late fees).

The analysis is structured on system pressure, cash-flow, and settlement quality, which provides an assessment of how effectively the enforcement scales, collects revenue, and resolves cases over time.

Key insights

  • Issuance has consistently outpaced Settlement, indicating a need for stronger enforcement strategies.
  • Prioritizing early payments may yield higher returns than late stage recovery efforts.
  • A small subset of offence types drives the majority of unsettled volume and unpaid risk.
  • Power Query
  • Data Cleaning
  • DAX
  • Time-Series Analysis
  • Rolling Measures
  • Star-Schema
  • Power BI

#4 - HR Management on Excel

Not loading? Watch on YouTube

Download Excel Workbook

Excel-only dashboard created using a collection of monthly .CSV files from an HR agency.

Provides insights of workforce composition and trends like headcount, full and part-time, gender, ethnicity, pay type and termination patterns over time.

The solution was designed to be automated: adding fresh data to the data folder would update all charts and KPIs.

Key insights

  • Reliance on part-time roles in recent years appears correlated with lower tenure and increased voluntary terminations.
  • Retention strategies should be aligned with a predominantly under-30 workforce (early careers).
  • Gender and ethnic representation are balanced across the workforce.
  • Power Pivot
  • Excel
  • Pivot Tables
  • DAX

Skills

Contact

Email me