This repository serves as my data analytics portfolio, showcasing projects that demonstrate practical skills in SQL, Python, data cleaning, data transformation, exploratory data analysis (EDA), and data visualization.
The collection includes projects ranging from database design and advanced SQL programming to Python-based data analysis and interactive Tableau dashboards. While many of these projects originated through formal coursework, each has been refined and organized to highlight the technical and analytical skills used in real-world business and data analysis.
As I continue developing my skills and completing new projects, this repository is regularly updated with additional analyses, dashboards, and SQL solutions.
- SQL querying and database design
- Advanced SQL (CTEs, window functions, subqueries)
- PL/SQL and T-SQL programming
- Stored procedures, triggers, and transaction processing
- Data cleaning and transformation
- Exploratory Data Analysis (EDA)
- Data validation and quality assurance
- Data visualization and dashboard design
- Business reporting and analytical problem solving
- PLSQL_Advanced_SQL - Advanced SQL programming projects demonstrating procedural database development using Oracle PL/SQL and SQL Server T-SQL, including: - Stored procedures - Functions - Triggers - Exception handling - Transaction management - Input validation - Commit/Rollback processing
- DataCleaning - SQL scripts focused on preparing raw datasets for analysis through: - Data cleansing - Standardization - Type conversion - Duplicate handling - Missing value management - Conditional updates
- Healthcare Dataset - A multi-table analytical case study exploring healthcare data through joins, aggregations, filtering, and reporting to answer realistic business questions.
- Python Projects - Data analysis projects built with Python and Jupyter Notebook covering: - Data import and preprocessing - Exploratory data analysis - Statistical summaries - Data visualization - NumPy - Pandas - Matplotlib - Seaborn
- SQL Projects - A collection of SQL exercises and analytical projects demonstrating: - Complex joins - Aggregate functions - Window functions - Common Table Expressions (CTEs) - Subqueries - Database creation - Query optimization techniques
- Tableau Projects - Interactive dashboards designed to communicate business insights through effective visualization, storytelling, and dashboard design.
- SQL
- SQLite Online
- SQL Server
- Oracle Database
- PL/SQL
- T-SQL
- Python
- Pandas
- NumPy
- Matplotlib
- Seaborn
- Tableau
- Jupyter Notebook
- Anaconda
This repository is actively maintained as I continue expanding my analytics portfolio with new SQL, Python, Tableau, and business analysis projects.