Post 5: Advanced Excel Tips
Advanced Excel Tips for Data Analysts These are the techniques I frequently use to work more efficiently: Key Techniques: Mastering […]
1. Healthcare Knowledge Base, 4. Excel for Data Analyst
1. Healthcare Knowledge Base
1. Healthcare Knowledge Base, 4. Excel for Data Analyst
Post 4: Conditional Functions
Conditional Aggregation (SUMIFS, COUNTIFS, IFS) Conditional functions are very useful when I need to calculate numbers based on specific conditions.
1. Healthcare Knowledge Base, 4. Excel for Data Analyst
Post 2: Pivot Tables & Charts
Pivot Tables are one of the most important and powerful tools for any Data Analyst. What I use Pivot Tables
1. Healthcare Knowledge Base, 4. Excel for Data Analyst
Post 1: Advanced Lookup Functions
Advanced Lookup Functions (XLOOKUP & VLOOKUP) Lookup functions are essential for combining data from different tables. Key Functions: Key Differences:
1. Healthcare Knowledge Base, 3. SQL for Healthcare Analytics, Uncategorized
SQL Practice -HealthCare
Database: Adventureworks Pro-Tip – pay extra attention to: Click to see the correct SQL Code sql Use code with caution.
1. Healthcare Knowledge Base, 2. 📊 Power BI for Healthcare Analytics
K-Means Clustering in Healthcare: Practical Examples
Key K-Means Clustering Concepts with Healthcare Examples Healthcare Interpretation Distance:Â How similar a patient is to a patient group. Centroid:Â The average
1. Healthcare Knowledge Base, 3. SQL for Healthcare Analytics
Date Functions in SQL
SQL Study Notes – AdventureWorksDW2017 Common Date Functions 1. Get Year, Month, Day SELECT OrderDate, YEAR(OrderDate) AS OrderYear, MONTH(OrderDate) AS
1. Healthcare Knowledge Base, 3. SQL for Healthcare Analytics
Exploring Database Structure with INFORMATION_SCHEMA
SQL Study Notes 1. Finding Columns by Name SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE ‘%Business%’ ORDER BY
1. Healthcare Knowledge Base, 3. SQL for Healthcare Analytics
UNION vs JOIN vs NOT EXISTS
SQL Study Notes – AdventureWorksDW2017 1. UNION and UNION ALL UNION combines results from two or more queries and removes
1. Healthcare Knowledge Base, 3. SQL for Healthcare Analytics
GROUP BY and HAVING Practice
GROUP BY and HAVING – Understanding & Practice SQL Study Notes – AdventureWorksDW2017 This page covers GROUP BY, HAVING, LEFT