Basic SQL Examples for Healthcare Analytics
Study Notes – SELECT, WHERE, ORDER BY, GROUP BY, HAVING & JOINs Core SQL skills that are used every day […]
1. Healthcare Knowledge Base, 3. SQL for Healthcare Analytics
1. Healthcare Knowledge Base
1. Healthcare Knowledge Base, 3. SQL for Healthcare Analytics
SQL Practice: GROUP BY & HAVING Examples
Date: June 17, 2026 Today I focused on GROUP BY and HAVING clauses. Below are clear examples using both AdventureWorksDW2017
1. Healthcare Knowledge Base, 3. SQL for Healthcare Analytics
ProductKey vs ProductAlternateKey – Why Both Exist
One of the most confusing concepts in data modeling is understanding the difference between ProductKey and ProductAlternateKey. Simple Explanation: ProductKey
1. Healthcare Knowledge Base, 3. SQL for Healthcare Analytics
SQL Final Review #1: Patient and Diagnosis Tables
This SQL practice note uses a simple healthcare example with two tables: Patients and Diagnoses. The goal is to review
1. Healthcare Knowledge Base, 2. 📊 Power BI for Healthcare Analytics
My Machine Learning Study Notes: Understanding the Ideas Instead of Memorizing Formulas
Today I spent time reviewing introductory machine learning concepts, working through practice questions, and trying to understand the reasoning behind
1. Healthcare Knowledge Base, 2. 📊 Power BI for Healthcare Analytics
KNIME Decision Tree Workflow: Step by Step
Why Learn This? After learning the basics of decision trees, I wanted to understand how a machine learning workflow is
1. Healthcare Knowledge Base, 2. 📊 Power BI for Healthcare Analytics
KNIME Workflow Steps and What Each Node Does
Why I Am Learning KNIME In this workflow, I learned that each KNIME node performs one specific step in the
1. Healthcare Knowledge Base, 2. 📊 Power BI for Healthcare Analytics
Understanding Decision Trees
As I continue learning Power BI and healthcare analytics, I have been exploring different machine learning models. One concept that
1. Healthcare Knowledge Base, 2. 📊 Power BI for Healthcare Analytics, Uncategorized
Understanding Linear Regression Calculations (Study Notes)
As I continue learning Power BI and healthcare analytics, I wanted to better understand the mathematics behind linear regression. Rather
1. Healthcare Knowledge Base, 2. 📊 Power BI for Healthcare Analytics
Understanding Linear Regression with Python (Study Notes)
As I continue learning Power BI and healthcare analytics, one topic that has especially interested me is linear regression using