Data Cleaning in SQL
Data cleaning in SQL involves identifying and correcting errors or inconsistencies in data to ensure its accuracy, completeness, and usability
Automated Employee Retirement System Using MySQL
Automated Employee Retirement System streamlines the retirement process by automatically identifying employees who reach the retirement age and transferring them to the retiree records. Using MySQL queries, the system: ✔ Monitors employee ages in real-time. ✔ Automatically moves retirees to a separate table. ✔ Runs scheduled updates using MySQL Event Scheduler. ✔ Ensures data integrity by keeping records accurate and up to date. This system eliminates manual work, ensures efficiency, and maintains accurate workforce data effortlessly.
Analyzing Seasonal Trends in Chicago Taxi Rides Using BigQuery
This topic highlights how SQL and BigQuery can be used for real-world data analysis
It calculates the daily number of trips and applies a moving average over a 7-day window to smooth fluctuations. The result provides insights into short-term trends in taxi demand.
Lung cancer dataset exploration
This Lung Cancer Data Exploration consists of 23 SQL queries designed to analyze various aspects of lung cancer cases, including prevalence, risk factors, survival rates, and mortality trends. The queries investigate demographics (age, gender, smoking status), environmental exposures (air pollution, occupational hazards), and country-specific statistics (developed vs. developing nations, mortality rates). They also categorize patients into age groups, assess cancer stage distribution, and evaluate the impact of family history on diagnosis. Additionally, smoking habits, pollution exposure, and early detection rates are examined to uncover patterns in lung cancer cases. These insights can aid health policy-making, resource allocation, and public awareness initiatives
Employee Management & Payroll Analytics System
This SQL-based Employee Management System automates HR processes, including salary management, promotions, attendance tracking, and retiree transitions. It features stored procedures for employee promotions and bonus calculations, triggers to enforce salary constraints, and scheduled events for retiree management. Advanced reports provide insights into salary expenses, employee distribution, and attendance trends. This system enhances efficiency, ensuring smooth workforce operations and data-driven decision-making.
Customer (Behavior) Analytics & Retention Insights
This SQL-based Customer Analytics system provides deep insights into customer registration trends, conversion rates, and retention behavior. It includes cohort analysis for registration channels, churn rate tracking, and customer lifetime value assessments. Advanced queries analyze the time-to-first-order, average order values by country, and the percentage of active customers over different time periods. These data-driven insights help businesses optimize marketing strategies, improve retention, and maximize revenue.