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.
Interactive dashboards: https://public.tableau.com/app/profile/billy.conard/vizzes
- SQL querying and database design
- Advanced SQL (CTEs, window functions, subqueries)
- PL/SQL and T-SQL programming (stored procedures, functions, triggers, exception handling, transaction management)
- Data cleaning and transformation
- Data validation and quality assurance (uniqueness checks, missing/invalid value detection)
- Exploratory Data Analysis (EDA)
- 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 and standardization
- Type conversion
- Uniqueness validation
- Missing/invalid value management
- Conditional updates
- A worked example: cleaning, analyzing, and visualizing a cafe sales dataset end-to-end (see folder README for the full writeup and dashboard link)
- 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. (Workbook files are not stored directly in this repo — GitHub can't render .twbx files; each project's README links out to its live Tableau Public dashboard instead.)
- SQL, SQLite Online, SQL Server, Oracle Database, PL/SQL, T-SQL
- Python, Pandas, NumPy, Matplotlib, Seaborn, Jupyter Notebook, Anaconda
- Tableau
This repository is actively maintained as I continue expanding my analytics portfolio with new SQL, Python, Tableau, and business analysis projects.