Hi, I am Nazareno Cufre.
A Data Analyst.
Here you will find my resume, projects and contact information.
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
- Profitability varies more by region than by total sales volume.
- Store-level margin performance drives overall chain profitability.
- Consistent basket size growth correlates with higher long-term margins.
- Power Query
- Data Modeling
- Profit & Loss
- DAX
- Power BI
#2 - Northwind Sales (Supermarket)
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
- Profitability varies more by region than by total sales volume.
- Store-level margin performance drives overall chain profitability.
- Consistent basket size growth correlates with higher long-term margins.
- 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
- Profitability varies more by region than by total sales volume.
- Store-level margin performance drives overall chain profitability.
- Consistent basket size growth correlates with higher long-term margins.
- 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 WorkbookExcel-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
- Profitability varies more by region than by total sales volume.
- Store-level margin performance drives overall chain profitability.
- Consistent basket size growth correlates with higher long-term margins.
- Power Pivot
- Excel
- Pivot Tables
- DAX
Skills
- Advanced SQL
- Advanced Excel
- Power Query
- Power Pivot - DAX
- Power BI
- Learning Python
- Critical Analysis
- Visualizations
- HTML - CSS
Contact
Email menazareno_cufre@hotmail.com (click to copy)