Alberto Castro Jiménez
I help small businesses turn messy data into clear reports
New to Contra
Alberto is ready for their next project!
Developed a Python tool that generates custom synthetic datasets in CSV or JSON format, using Pandas and NumPy. Built for analytics teams that need realistic test data without accessing sensitive production records — supports SQL analysis, EDA workflows, and dashboard prototyping.
Transformed raw transactional data into a clean, analysis-ready dataset using SQL joins across 5 tables and a structured CTE layer. The output fed directly into a Power BI dashboard, reducing preparation time and ensuring consistent, trustworthy data for business reporting.
Built a Power BI dashboard analyzing product sales and service revenue for a gym business. Combined SQL data preparation with DAX measures to surface key insights: revenue concentration, top-performing services, and income distribution — designed for non-technical decision makers.
Designed a normalized relational database for a gym management system, covering members, services, and payments. Defined entities, primary/foreign keys, and referential integrity constraints to ensure clean, reliable data storage — built as a scalable foundation for future analytics and BI reporting.
