TSQL-Project about the management of a plant store

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

Used SQL queries to perform data analysis of the COVID-19 pandemic, exploring key trends, statistics, and insights sourced from Our World in Data.

my learnings and practice with SQL functions

example sql queries

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.

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.

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

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

In any company, measuring business performance is crucial for tracking, monitoring, and evaluating the success or failure of various business processes. Therefore, this project aims to analyze the business performance of an eCommerce company, considering several business metrics: customer growth, product quality, and payment types.

Wise Owl SQL Server Exercises Solutions

SQL Challenge

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

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

UI to visualize common table expressions in sql scripts

T-SQL queries for several useful SQL Server functions including alter column, rename column, cursor, paging, and hierarchy querying.

Common Table Expression builder that uses Doctrine DBAL

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.