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

• SQL Exercises
• SQL Quiz

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