End-to-end DWH for Spanish electricity market data – CDC-based ETL, star schema, Power BI dashboards
-
Updated
May 31, 2026 - Python
End-to-end DWH for Spanish electricity market data – CDC-based ETL, star schema, Power BI dashboards
This project aims to capture, store, and visualize real-time system performance metrics through an end-to-end data pipeline. By leveraging Python, MySQL, SQL Server, and Power BI, we've created a comprehensive solution to enhance decision-making.
Simplified blueprints for building data pipelines with Microsoft SQL Server.
Create C# entity and DTO classes for a SQL Server table or view.
🤖 Chat with your SQL database. Just speak your query and let the system do the rest 🗣️📊
Tools for deploying a ANPR Microsoft SQL-Server database as a docker container on linux (Debian)
A repository of scripts to enumerate and dump all accessible data from a database server.
PhotoGallery Backend API is a Flask-based application for managing and syncing photos with geotagging, face detection, and EXIF metadata extraction. It uses SQL Server and Flask-SQLAlchemy to store and serve JSON data, enabling seamless integration with a Mobile and Windows interface.
Stock System in Python Using Flask.
Library project
Medical Appointment System
Personal Blog
Transparent Retrieval-Augmented Generation (RAG) system built with Flask, Gemini, FAISS, and SQL Server that visualizes every AI retrieval step in real time.
End-to-end Data Engineering pipeline for extracting, transforming, validating, and loading Egypt electricity demand data into SQL Server.
Machine learning application for personalized investment portfolio recommendations and investor analytics.
A modern data warehouse solution built on SQL Server to streamline data integration, power business intelligence, and scale with growing analytics demands.
BCom Marketing Management portfolio focused on data-driven SME (Small and Medium-sized Enterprises) growth. features a commercial optimization study for Coco Bliss. Using Excel, SQL Server, Python (Pandas/Seaborn), and Power BI, I audited A 15+ SKU (Stock Keeping Unit) product mix to eliminate margin leakages and maximize weekly net profitability.
To associate your repository with the sql-server-database topic, visit your repo's landing page and select "manage topics."