Welcome! I'm Jaymeson Metz, a data and business intelligence analyst with a passion for transforming messy datasets into clean insights and visual storytelling. This portfolio contains all 7 projects completed during my Business Intelligence Analytics program at TripleTen, where I built real-world dashboards, wrote SQL queries, modeled customer cohorts, and designed end-to-end BI workflows.
Each sprint focused on a different skillset—from spreadsheets to SQL, Tableau, and Power BI—culminating in a capstone analysis for Zomato’s customer data.
| Sprint | Project Title | Tool(s) Used | Focus | Link |
|---|---|---|---|---|
| 0 | Fresh Beats Business Report | Google Sheets | Stakeholder Reporting | View README |
| 1 | Manhattan Airbnb Analysis | Excel | Pivot Tables & Revenue Modeling | View README |
| 2 | Zuber Taxi Ride SQL Analysis | SQL | Exploratory Querying & Joins | View README |
| 3 | Ecommerce Funnel & Cohort Analysis | Google Sheets | Conversion & Retention Tracking | View README |
| 4 | Tableau Dashboard: Saving Superstore | Tableau | Profit, Return, and Ad Strategy | View README |
| 5 | Tableau Story: Return Root Cause Analysis | Tableau + Screencast | Interactive Storytelling | View README |
| 6 | Power BI: Shopify App Review Analysis | Power BI + DAX | KPI, Developer Behavior, Reviews | View README |
| 7 | Zomato Final Project: Customer Segmentation | Power BI | Capstone Research & Dashboard Mockup | View README |
- 📊 Dashboard Design: Tableau, Power BI, Google Sheets
- 📎 Data Cleaning & Joins: SQL (multi-table joins, aggregation, filtering)
- 📈 Storytelling: Funnel analysis, cohort analysis, stakeholder reporting
- 🔢 DAX & Calculated Columns: Custom metrics for weighted KPIs and engagement
- 📐 Mockups & UX Planning: Built intuitive, business-friendly dashboards
- 🗂️ Documentation: Clean project structure, research planning, and executive summaries
To join a mission-driven company where I can contribute insights through data storytelling, support product or marketing teams with dashboards, and grow as a full-stack BI or data analyst.
- 📧 Email: ijaymeson@icloud.com
- 🔗 LinkedIn: LinkedIn Profile
- 🌐 Portfolio Repo: github.com/yourusername/Data_Projects_TripleTen
“Data is the raw material, but story is the vehicle that moves people to action.”
— Nancy Duarte, DataStory