Turning data into business strategy across CRM, BI, and systems.
📌 This repository serves as a curated portfolio overview, pinned alongside 4 individual project repositories. Each project includes full documentation, dashboards, and real-world business insights. Designed for roles in Data, Business, CRM, BI, and Systems Analysis.
I’m a Business, Data & CRM Analyst with a B.B.A. in Information Systems from Florida International University (FIU). I specialize in solving business challenges through data analysis, systems thinking, and dashboard development.
This portfolio simulates real-world workflows across data analytics, BI reporting, CRM segmentation, and IT operations, aligned with the expectations of junior analyst roles.
- About Me
- Portfolio Overview
- Key Skills Demonstrated
- Focus Areas & Target Roles
- Tools & Technologies
- Featured Project – Capital One Credit Risk Analysis
- Full Project List
- Repository Structure
- Dataset Sources
- Resume & Contact
- Final Thoughts
📌 Google Data Analytics Professional Certificate – Google/Coursera
📌 Google Project Management Professional Certificate – Google/Coursera
📌 Agile Project Management – LinkedIn Learning
📌 Business Analysis – LinkedIn Learning
📌 SQL, Power BI, and Data Visualization – LinkedIn Learning
Each project uses real datasets to reflect practical business problems in credit risk, logistics, IT ticketing, and sales returns. I used SQL, Excel, Power BI, and Tableau to simulate stakeholder-ready deliverables across functional teams.
- Data Analytics & Segmentation – Practical SQL queries & customer segmentation
- KPI Reporting & Visualization – Clear, interactive dashboards for business decisions
- System & Process Optimization – Root-cause insights, efficiency improvements
- SQL Segmentation & Trend Analysis – Practical queries for insight extraction
- Process & System Optimization – Identifying inefficiencies and improvements
- Business Decision Support – Translating data into actionable strategy
- CRM Workflow Support – Retention trend analysis and behavior-based segmentation
This portfolio reflects the expectations of entry-level and junior analyst roles, with strong alignment to:
- Data Analyst – Dashboard creation, reporting, segmentation, KPI monitoring
- Business Analyst – Operational insights, stakeholder reporting, opportunity analysis
- CRM Analyst – Customer behavior trends, retention insight, segmentation dashboards
- Operations Analyst – Process optimization, service performance tracking
- BI Analyst – SQL reporting, visual analytics, decision support
- Systems Analyst – Help desk metrics, UAT support, IT workflow audits
| Tool | Use Case |
|---|---|
| SQL | Data queries, segmentation, filtering |
| Power BI | KPI dashboards, reporting, visuals |
| Tableau | Data storytelling, service insights |
| Excel | Data cleaning, transformation, metrics |
An exploration of customer default behavior based on demographics and payment patterns.
📊 Dashboard Preview:
Report Access: 📄 View Full Report (PDF)
SQL Access: 🧮 View SQL Queries
Project Folder: 🔗 View Full Project Folder
Note: Also listed as “Sales Returns Strategy & Profitability Dashboard” on my resume and LinkedIn profile.
- Objective: Assessed sales trends and return rates to reduce losses and improve profit margins.
- Key Tools: Excel, Tableau
- Key Insights: High-return products, $23K profit loss, 8% return rate
📊 View Project Dashboard → Dashboard
📄 View Project Report → Report (PDF)
📁 View Project Folder → Project Folder
Note: Also listed as “IT Workflow & KPI Optimization” on my resume and LinkedIn profile.
- Objective: Evaluated IT support performance and identified areas of delay across ticket channels.
- Key Tools: Excel, SQL, Tableau
- Key Insights: 49.6% resolution rate, delays from pending customer responses, medium/critical overload
📊 View Project Dashboard → Dashboard
📄 View Project Report → Report (PDF)
📁 View Project Folder → Project Folder
Note: Also listed as “Global Logistics Performance Dashboard” on my resume and LinkedIn profile.
- Objective: Analyzed global LPI scores from 2010–2023 to assess trade infrastructure.
- Key Tools: Excel, SQL, Power BI
- Key Insights: Top/Bottom countries, infrastructure quality gaps, global LPI improvement
📊 View Project Dashboard → Dashboard
📄 View Project Report → Report (PDF)
🧮 View Project SQL → SQL File
📁 View Project Folder → Project Folder
Note: Also listed as “Capital One Credit Risk & CRM Segmentation Dashboard” on my resume and LinkedIn profile.
- Objective: Analyzed customer default patterns using financial and demographic indicators.
- Key Tools: Excel, SQL, Power BI
- Key Insights: Default risks by education/age/payment status, credit limits vs risk
📊 View Project Dashboard → Dashboard
📄 View Project Report → Report (PDF)
🧮 View Project SQL → SQL File
📁 View Project Folder → Project Folder
Portfolio-Projects
│
├── 📁 Project-1-Sales-Performance-Analysis
├── 📁 Project-2-IT-Helpdesk-Analysis
├── 📁 Project-3-Global-Logistics-Performance
├── 📁 Project-4-Capital-One-Credit-Risk-Analysis
└── README.md (Main Portfolio Overview)
- Sample - Superstore Sales Dataset (Tableau)
- Customer Support Ticket Dataset (Kaggle)
- World Bank Logistics Performance Index (LPI)
- Default of Credit Card Clients (UCI Repository)
📄 Download My Resume (PDF)
🔗 Connect on LinkedIn
📧 lylecmiller.work@gmail.com
Thanks for visiting! Feel free to connect on LinkedIn or explore the live version of my portfolio:
⚠️ Note: This repository is pinned as a portfolio overview alongside 4 individual project repositories. For best viewing, visit the featured dashboards and full case study documentation.