🤹‍♀ Animations of tidyverse verbs using R, the tidyverse, and gganimate

PLEASE READ: Kibi is now "Siren Investigate", part of the Siren Platform. This code repository is only provided to facilitate code review and integration by Siren customers and cannot be successfully compiled. The code also requires Siren Federate to be installed in Elasticsearch.

SQL JOINS visualizer

Cheatsheet for MySQL

A Quick, Interactive Approach to Learning Analytics with SQL

A simple utility for SQL-like joins with Json, GeoJson or dbf data in Node, the browser and on the command line. Also creates join reports so you can know how successful a given join was. Try it in the browser -->

Exercises to help improve SQL skills

a minimalist dataframe

All the weekly lab work of the subject 18CSC303J Data Base Management Systems.

Master SQL Server and MySQL in Just 5 Days

Oh you know, just a coupla, two, tree Kafka Streams in Scala

Flexible joining operations for tabular and non-tabular datasets with wide range of join conditions including distance, interval, and comparison predicates.

Analyze a restaurant's new menu performance using MySQL. Explore `menu_items` and `order_details` tables to identify popular items, customer preferences, and revenue insights. Includes SQL queries, database schema, and sample data.

Create optimal Mongo aggregation pipelines, with joins/lookups, for Apollo queries.

Here is the last minute revision notes of SQL

package for exact edit similarity joins

Joining Tables in SQL

General and composable utilities for manipulating tabular, quasi-tabular, and non-tabular datasets.

Longform data analysis article arguing every “dataset” is actually three: Observed (captured rows), Missing (what should exist but doesn’t), and Excluded (what filters/joins/dropna removed). Includes dataset accounting, join-loss and missingness audits, segmentation checks, and practical templates to prevent biased KPIs and wrong conclusions.

A portfolio project involving a detailed analysis of 37,997 high school/college student records to showcase key insights through the aid of effective visualizations aimed at evaluating the factors affecting student's academic performance in high school and colleges in the US..