A Power BI and PostgreSQL dashboard analyzing 15+ years of rental property operations. Tracks end-to-end performance metrics including income, expenses, NOI, cash flow, late payments, and tenant behavior. Provides actionable insights for operational decisions, budgeting, forecasting, and portfolio optimization.

📊 A comprehensive showcase of projects and skills from the IBM Business Intelligence Analyst Professional Certificate! 📈 Features include: 📉 Tableau dashboards, 📊 Excel analytics, 🗄️ SQL database querying, 📐 statistical analysis, 🤖 AI-enhanced BI workflows, and 📋 interactive data visualizations.

📚 An End-to-End Advanced SQL Project covering Data Warehousing, ETL Pipeline (Bronze → Silver → Gold), Star Schema Modeling, EDA, and Advanced SQL Analytics. Built using PostgreSQL, this project simulates a real-world Data Engineering + Data Analytics workflow using raw ERP & CRM data to generate production-ready customer and product insights.

2nd project on Data engineering containing End to end data pipeline.

This project delivers a modern data warehouse which focuses on building clean, organized data pipeline which covers important aspects such as ETL Pipeline Development, Data Cleaning, Data Modelling and Data Analytics

Clean and analyze data using PostgreSQL then visualize using Tableau

A collection of beginner-to-intermediate SQL projects using PostgreSQL for data analysis and database management.

Building a Data Warehouse with PostgreSQL, including ETL processes, Data Modeling, and Analytics.

This an analysis of online retail (E commerce) company that wants to know the customers who are going to churn, so accordingly they can approach customer to offer some promos.

Cleaning the Nashville Housing Data dataset.

A modern data warehouse with PostgreSQL including ETL processes, data modeling, and analytics.

Designing and building a modern data warehouse using PostgreSQL, including ETL pipelines, data modeling, and analytics.

This module covers techniques to optimize query execution, such as creating indexes, and query planning, that improve performance. It will also introduce tools and techniques for terminating inefficient queries that are consuming our database resources.

Postgres plpgsql function to clean mixed-character strings of non-UTF8 characters

Construcción de un Data Warehouse completo en PostgreSQL

Repo for sharing Snowflake best practice, hints and tips and overall documentation for analysts and other end users

Building a modern data warehouse with PostgreSQL, including ETL processes, data modeling and analytics. This repository also contains a collection of SQL scripts demonstrating various analytical techniques, such as changes over time, cumulative, performance, data segmentation, part-to-whole analysis.

ETL and analytics on e-commerce data using Snowflake SQL for business insights.