Professional bilingual portfolio focused on Business Intelligence, financial analytics, data transformation, reporting automation, and operational solutions.
🔗 Live portfolio: https://jgonzalez-bi.github.io/
This website presents selected projects based on practical experience with:
- Power BI and semantic modeling
- SQL and Databricks
- Power Query
- Advanced Excel
- VBA and process automation
- Financial and operational analytics
The portfolio was developed as a responsive static website using HTML, CSS, and JavaScript, without external frameworks.
Interactive financial dashboard built with synthetic data to analyze sales, margin, contribution, and performance across regions, accounts, and channels.
Tools: Power BI, DAX, SQL, and data modeling.
Migration of business rules, aggregations, and sorting hierarchies from Power Query into Databricks to support a dynamic financial reporting solution in Power BI.
The case study demonstrates:
- Layered transformations in Databricks
- Hierarchy aggregation and ranking
- Window functions
- Reusable consolidated tables
- Integration with Power BI parameters and visualizations
Internal system names, catalogs, company names, and figures were generalized or anonymized.
Excel VBA tool created to centralize caregiver records, search candidates using multiple criteria, update information, and retrieve incident history through a single interface.
The case study includes:
- VBA UserForms
- Data validation
- Daily availability management
- Filters by language, location, and case preferences
- Related incident records
- Fully fictional demonstration data
jgonzalez-bi.github.io/
├── index.html
├── README.md
├── .nojekyll
│
├── assets/
│ ├── css/
│ │ └── styles.css
│ └── js/
│ ├── main.js
│ └── dashboard.js
│
├── case-studies/
│ ├── financial-dashboard.html
│ ├── databricks-migration.html
│ └── operations-automation.html
│
└── cv/
├── Josue_Gonzalez_CV_ES.pdf
└── Josue_Gonzalez_CV_EN.pdf
- Responsive navigation
- English and Spanish content
- Independent case-study pages
- Visualizations built with HTML and CSS
- Interactive financial dashboard demo
- Downloadable CV in both languages
- Desktop and mobile optimization
HTML5
CSS3
JavaScript
Power BI
DAX
SQL
Databricks
Power Query
Excel
VBA
The website is automatically published through GitHub Pages from the main branch.
To deploy an update:
git add .
git commit -m "Update portfolio"
git push origin mainGitHub Pages will publish the changes at:
https://jgonzalez-bi.github.io/
The projects reflect real analytical and technical experience, but:
- All displayed data is synthetic or fictional.
- Internal names were generalized.
- No credentials, personal information, proprietary paths, or confidential company data are included.
- Public visualizations were recreated specifically for this portfolio.
- GitHub: https://github.com/jgonzalez-bi
- Portfolio: https://jgonzalez-bi.github.io/
Portafolio bilingüe enfocado en Business Intelligence, análisis financiero, transformación de datos y automatización de procesos.
Los proyectos demuestran experiencia práctica con Power BI, SQL, Databricks, Power Query, Excel y VBA.
- Global Financial Performance Dashboard: dashboard financiero interactivo con datos sintéticos.
- Financial Spend Analytics Transformation: migración de transformaciones y jerarquías desde Power Query hacia Databricks para consumo en Power BI.
- Caregiver Operations Management System: herramienta en Excel VBA para centralizar registros, realizar búsquedas multicriterio y consultar incidentes.
Todos los ejemplos públicos utilizan datos sintéticos, ficticios o anonimizados y no incluyen información confidencial.