top of page
All Blogs
Search
Rashmi Baburao
Jan 105 min read
Padmaja Suryawanshi
Jan 103 min read
How I Solved a 1.5 million Row Healthcare Data Performance Using SQL Aggregation?
When I started data analysis journey leaning tools like Tableau and Power BI. These powerful visualization platforms promise meaningful insights through KPIs, metrics, and interactive dashboards. The dataset I encountered had 1.5 million rows with patient IDs, biomarkers, and clinical measurements. Many patient IDs were duplicated across multiple visits, tests, and treatments. When I attempted to load this massive dataset into Power BI, the performance issues were immediately
Padmaja Suryawanshi
Jan 103 min read
How I Solved a 1.5 million Row Healthcare Data Performance Using SQL Aggregation?
When I started data analysis journey leaning tools like Tableau and Power BI. These powerful visualization platforms promise meaningful insights through KPIs, metrics, and interactive dashboards. The dataset I encountered had 1.5 million rows with patient IDs, biomarkers, and clinical measurements. Many patient IDs were duplicated across multiple visits, tests, and treatments. When I attempted to load this massive dataset into Power BI, the performance issues were immediately
Padmaja Suryawanshi
Jan 103 min read
How I Solved a 1.5 million Row Healthcare Data Performance Using SQL Aggregation?
Introduction When I started data analysis journey learning tools like Tableau and Power BI. These powerful visualization platforms promise meaningful insights through KPIs, metrics, and interactive dashboards. The dataset I encountered had 1.5 million rows with patient IDs, biomarkers, and clinical measurements. Many patient IDs were duplicated across multiple visits, tests, and treatments. When I attempted to load this massive dataset into Power BI, the performance issues we
bottom of page