Projects
Projects
In the COVID-19 Testing Data Analysis project, proficiency in data analytics using Excel was demonstrated. Meticulous data cleaning identified and addressed missing values, ensuring dataset integrity. Data preprocessing techniques handled outliers in the temperature column, enhancing analysis accuracy. Transforming numerical values into categorical data facilitated a more insightful exploration of symptoms and demographics. Leveraging Excel's visualization tools, various charts, including stacked column charts, line graphs, bar charts, and scatterplots, were created, offering a comprehensive view of the data. The culmination of this work resulted in an interactive dashboard featuring a timeline and slicers for dynamic exploration.
Through a comprehensive exploration of the healthcare dataset using R, a rich landscape devoid of missing values was discovered. Focusing on patient demographics and test results revealed predictive insights. Descriptive statistics and histograms highlighted age distribution and test result correlations. A heatmap visualized key health metric relationships, offering nuanced insights. Engaging pie charts provided a digestible overview of medical condition distribution. This thorough analysis lays the foundation for deeper insights and predictive modeling in healthcare data science.
Optimizing the performance and efficiency of a 'Healthcare Dataset' using PostgreSQL, this project demonstrates comprehensive database management and analytics skills. Leveraging PostgreSQL's versatile features involves importing the dataset, creating tables, and executing insightful queries. Proficiency in SQL operations, covering aggregation, filtering, sorting, and joins, is pivotal in distilling meaningful insights from complex data. The narrative unfolds through statistical analysis, insurance provider assessment, patient outcome evaluation, and room utilization scrutiny. Diving deep into doctor performance analysis, advanced techniques like CTE (Common Table Expressions) and creating views are employed.
Data Visualization
Tableau Dashboard
Excel Dashboard
RStudio
RStudio