SQL Data Analysis & Data Visualization Projects with Lean Six Sigma Implementation

Compilation of my SQL, Tableau and Microsoft PowerBI data analysis related projects where I practice and hone those skills. In addition, I will be incorporating Lean Six Sigma methodologies in some projects where applicable as I am a certified Green Belt.

Built with

SQL Languages
- SQL
- MySQL
Query Platforms
- BigQuery @ Google Cloud
Database Sources
- Kaggle
- BigQuery @ Google Cloud
Lean Six Sigma
- DMAIC Methodology

Projects and Challenges

Flow Disruption Analysis

Lean six sigma data analysis project for an Aerospace MRO

Database creation
Number of Issues by issue type
Total hours wasted by issue type
Total cost accrued due to waste by issue type
Application of value stream mapping to identify and eliminate/reduce waste in a process

Learning Journey

Data Analyst

Google Data Analytics Professional Certification (In-Progress)

Foundations Data, Data, Everywhere
Ask Questions to Make Data-Driven Decisions
Prepare Data for Exploration
Process Data from Dirty to Clean
Analyze Data to Answer Questions
Share Data Through the Art of Visualization
Data Analysis with R Programming
Google Data Analytics Capstone Complete a Case Study

SQL

W3schools SQL Tutorials

LinkedIn Learning (Level up SQL): SQL Code Challenges

Tableau

My Tableau Public Profile

My Professional Tableau Projects

Microsoft PowerBI

PowerBI Essential Training

Lean Six Sigma

Lean Six Sigma Training