How rodrigosilva1936/healthcare-performance-analytics works
This is a healthcare analytics project, not an application service: its main workflow prepares the raw dataset with Python, analyzes the cleaned data in SQL Server, and presents results in Power BI. The graph preserves the documented cleaning, query-analysis, and dashboard stages, including the dashboard’s overview, regional, and trend capabilities. The README documents these workflow relationships; source excerpts were limited to the dependency list, so implementation-level calls are not established.
Main entry points: healthcare-cleaned.csv Cleaned dataset · healthcare-data.csv Raw healthcare data · data_cleaning.ipynb Data cleaning · healthcare-performance-dashboard.pbix Performance dashboard
Components 12
Data preparation
- Raw healthcare data
data/raw/healthcare-data.csv - Data understanding
notebooks/understanding_data.ipynb - Data cleaning
notebooks/data_cleaning.ipynb - Cleaned dataset
data/processed/healthcare-cleaned.csv - Exploratory analysis
notebooks/exploratory_analysis.ipynb
SQL analysis
- Data overview queries
sql/data_overview.sql - Emergency episodes
sql/Emergency_Episodes_Analysis.sql - Regional analysis
sql/regional_analysis.sql - Waiting time analysis
sql/waiting_time_analysis.sql
Power BI reporting
- Performance dashboard
powerbi/healthcare-performance-dashboard.pbix
Other components
- Analyst
- SQL Server
Connections 11
- Raw healthcare data → Data understanding: examines
README.md - Raw healthcare data → Data cleaning: prepares
README.md - Data cleaning → Cleaned dataset: exports
README.md - Cleaned dataset → Exploratory analysis: explores
README.md - Cleaned dataset → SQL Server: imports into
README.md - Data overview queries → SQL Server: queries
README.md - Emergency episodes → SQL Server: queries
README.md - Regional analysis → SQL Server: queries
README.md - Waiting time analysis → SQL Server: queries
README.md - Performance dashboard → SQL Server: connects to
README.md - Analyst → Performance dashboard: explores
README.md