Lyle Miller

Turning data into business strategy across Data Analytics, CRM, BI, and operational systems

Business, Data & CRM Analyst
with a B.B.A. in Information Systems from Florida International University (FIU)Experienced in building BI dashboards, CRM workflows, and operational insights using
SQL, Power BI, Tableau, and Excel.

📁 Featured Projects – Business Analysis, Dashboards & Decision Support

These dashboards were developed as part of self-directed freelance and portfolio work, modeled after real-world business scenarios.

Explore analytics projects built from real datasets using SQL, Power BI, and Tableau, each simulating workflows in data analytics, CRM, logistics, credit risk, and IT operations.

Built using SQL and Power BI to simulate Capital One’s credit risk segmentation using the UCI default dataset.

Credit risk analysis dashboard showing SQL and Power BI visuals for default trends by age, education, and payment history.

● Analyzed 30,000+ credit records to
surface default risk trends.● Delivered interactive dashboards highlighting payment history, education level, and credit behavior.📄 View Full Report (PDF)
💻 View SQL + Dashboard Files (GitHub)

Created with SQL and Power BI to analyze international vendor delays using the World Bank’s LPI dataset.

Global logistics performance dashboard showing vendor lead time delays and LPI scores across 100+ countries using SQL and Power BI.

● Tracked shipping KPIs across 100+ countries.● Identified customs and vendor-related inefficiencies to support operational planning.📄 View Full Report (PDF)
💻 View SQL + Dashboard Files (GitHub)

Built in Excel and Tableau to audit IT ticket resolution trends and improve internal response time.

IT support ticket dashboard using Excel and Tableau showing ticket volume by priority and resolution rate.

● Cleaned and analyzed 6 months of ticket data.● Highlighted top support categories and reduced resolution delays through KPI tracking.📄 View Full Report (PDF)
💻 View Dashboard Files (GitHub)

Developed using Excel and Tableau to analyze return loss trends and forecast product refund risk in a retail simulation.

E-commerce sales and return analysis dashboard built with Excel and Tableau, highlighting product refund losses by subcategory.

● Visualized subcategory return patterns and refund inefficiencies.● Supported policy adjustments and improved logistics cost allocation.📄 View Full Report (PDF)
💻 View Dashboard Files (GitHub)

Endorsements from Capstone Collaborators

"Lyle has a strong ability to translate complex data into actionable business insights. He always brought a structured, results-focused approach to our teamwork."
— Collaborator, Information Systems Course Project

“Lyle’s dashboards were always clear, actionable, and aligned with our project’s business goals. His ability to simplify complexity really stood out.”
— Classmate, FIU Business Systems Capstone

Get in Touch

This site highlights select projects from my portfolio.
For full details, visit my GitHub repository.I’m open to roles in Data Analytics, Business Analysis, CRM Strategy, Systems Analysis, and BI Reporting.Looking for a business-savvy analyst with strong hands-on analytics experience? Let’s connect.