Alberto Castro Jiménez
I help small businesses turn messy data into clear reports
New to Contra
Alberto is ready for their next project!
Automated Synthetic Dataset Generator — Python & Pandas
Developed a Python tool that generates realistic synthetic datasets in CSV and JSON format using Pandas and NumPy. Built for analytics teams and developers who need reproducible test data without exposing sensitive production records. Supports SQL analysis, EDA workflows, and dashboard prototyping out of the box.
See more details (https://ajcj97.github.io/acanalytics/projects/database-generator/)
0
43
Power BI Revenue Dashboard — Gym Business Analytics
Built a 3-page Power BI dashboard analyzing product sales and service revenue for a gym business. Combined Power Query data transformation with DAX measures to surface key business insights: revenue concentration by service type, top-performing offerings, and income distribution across payment methods. Designed for non-technical decision makers.
See more details (https://ajcj97.github.io/acanalytics/projects/gym-admin-report/)
1
78
SQL Data Pipeline — From Raw Transactions to Analysis-Ready Dataset
Transformed raw transactional tables into a clean, structured dataset using SQL JOINs across 5 related tables and a layered CTE approach. The output fed directly into a Power BI dashboard, eliminating manual data prep and ensuring consistent, reliable reporting. Reduced analysis preparation time significantly.
See more details (https://ajcj97.github.io/acanalytics/projects/gym-admin/)
0
27
Relational Database Design for Gym Management System
Designed a fully normalized relational database for a multi-location gym management system. Defined entities for clients, services, payments, and staff — including primary/foreign keys and referential integrity constraints. Built as a scalable foundation for operational reporting and future analytics.
See more details (https://ajcj97.github.io/acanalytics/projects/gym-admin/)
0
36