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.

Wise Owl SQL Server Exercises Solutions

SQL Challenge

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

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

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

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

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

TSQL-Project about the management of a plant store

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.

my learnings and practice with SQL functions

Exploratory Data Analysis of 60K+ sales transactions using SQL (MSSQL) to uncover customer segments, product performance, and operational insights.

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).

Repositório do módulo de Databases, Tables and Views on Databricks do curso Data Analyst Learning Plan