Genealogy is a free and open-source family tree PHP application to record family members and their relationships, build with LARAVEL 12.

Directed Acyclic Graphs with a variety of methods for both Nodes and Edges, and multiple exports (NetworkX, Pandas, etc). This project is the foundation for a commercial product, so expect regular improvements. PR's and other contributions are welcomed.

Common Table Expression builder that uses Doctrine DBAL

Examples of SQL queries created for Customer and Sales Data Analysis study project

in.orbit-api é uma API Rest com o fim de realizar o gerenciamento de metas semanais, permitindo o cadastramento da meta, quantidade de dias que será realizada durante a semana, listagem, exibindo as metas da ultima semana baseando-se no dia atual com a contagem de dias que a meta foi realizada e permitindo a atualização de uma meta como concluída.

SQL Challenge

Wise Owl SQL Server Exercises Solutions

Analyze product data for an online sports retail company to optimize revenue.

Unlock the power of SQL’s Common Table Expressions (CTEs) to transform data analysis capabilities! In this project, I demonstrate how to leverage CTEs to answer complex business questions with clarity and efficiency. Whether you’re dealing with hierarchical data, simplifying complex queries, or improving readability, CTEs are a game-changer.

A SQL-only ETL data infrastructure

A repository of more advanced SQL Server queries, including Common Table Expressions (CTEs) and self-joins.

Development of a database, flask server, and bootstrap dashboard that will aid in monitoring student performance.

Trading information is very important in the realm of stock, finance and trading. Using a database of synthetic data, this repository aims to answer important business questions about the user we have in our limited database of financial transactions using SQL queries.

TSQL-Project about the management of a plant store

Advanced SQL, covering Oracle PL/SQL and PostgreSQL PL/pgSQL with phases on using procedures, functions, triggers, query optimizations, packages, and Docker server setup 💡

Used pandas to resolve discrepencies in real-time election poll results and moved data to postgres.

RFM Analysis for customer segemntation, to categorize the customers based on resency, frequency and monetary. by using analytical SQL functions and common table expression(CTE).

Business questions were solved for Rockbuster Stealth LLC, a fictional movie rental company, through the use of SQL in this project. This project was completed as part of the CareerFoundry's curriculum.

Engineered a BI framework to drive growth and operational efficiency. Segmented 90+ customers for churn mitigation, audited logistical ROI to optimize shipping costs, and automated margin protection for discontinued inventory. Delivered actionable KPIs for sales attribution and revenue forecasting using 830+ order records.

This repo contains a fake vehicle telemetry dataset and performs analysis using ANSI SQL.