Understanding Data Modeling: A Healthcare-Focused Guide to Efficient Database DesignIn the digital age, data is the new oil. But raw data is often messy, disorganized, and hard to interpret. This is where data modeling…May 27May 27
Building a REST API with Ruby on Rails and PostgreSQL: A Marketplace ExampleCreating a REST API using Ruby on Rails is a powerful way to build robust backend services. In this guide, we’ll walk through the process…May 262May 262
Understanding Clinical Quality Language (CQL)In the ever-evolving landscape of healthcare, interoperability and data standardization are critical for enhancing patient care, improving…May 24May 24
Using Snowflake Window Functions to Identify Gaps in Prescription SuppliesManaging prescription medications is crucial for patient health, especially for those with chronic conditions. Ensuring continuous…May 23May 23
Understanding SQL Joins: A Comprehensive GuideSQL joins are fundamental operations that allow you to combine data from two or more tables based on a related column. They are essential…May 23May 23
Apache Spark on Scala basic exampleApache Spark is a unified analytics engine for large-scale data processing. Scala is a programming language that combines object-oriented…May 14May 14
SnowChatSQL — A Streamlit AI assistant for analyzing a Snowflake database.SnowChatSQL is a Streamlit app that uses OpenAI, ChromaDB and Snowflake to allow users to execute queries using natural language against a…May 2, 2023May 2, 2023
Analyze Bitcoin data with Google BigQueryGoogle BigQuery now has public Bitcoin datasets that allow users to analyze historical transaction data using standard SQL. Below are a…Nov 29, 2020Nov 29, 2020