Benjamin Lusic | Data Analyst Portfolio

I'm Benjamin Lusic, a Data Analyst who bridges business context with technical data analysis. With a background grounded in the insurance industry, I bring strong domain knowledge in risk evaluation, client retention, and portfolio performance to my work. I specialize in using SQL (MySQL, MS SQL Server), Tableau, and Power BI to clean messy datasets, build clear data models, and create visual reports that help teams make informed decisions.

Get to Know Benjamin Lusic

Featured Projects

Insurance Underwriting & Risk Performance Dashboard- Power BI

📂 GitHub Repository: View Full SQL Script & Reproducible Files on GitHub Building a P&C Insurance Underwriting Intelligence Dashboard: A Journey in Iterative Design When building data analytics tools, it is easy to assume the hardest part is writing the initial data model or SQL scripts. But as any analyst will tell you, the real battle is won in user experience (UX) and visual hierarchy. Recently, I built a Property & Casualty (P&C) Insurance Underwriting Intelligence Dashb

benlusic

Jun 18

Global Retail Sales & Budget Intelligence Dashboard- Power BI

📂 GitHub Repository: View Full SQL Script & Reproducible Files on GitHub Project Overview: Executive Sales & Budget Analytics This project is a practical exercise in sales performance analysis and variance reporting using Power BI. Using a cleaned version of the public AdventureWorks retail dataset alongside created budget targets, I modeled the data to analyze sales performance against mock business goals. 1. Mismatched Timeframes & Granularity The AdventureWorks sales data

benlusic

Jun 10

Data Professionals Survey- PowerBI

Project Overview What does the global landscape look like for modern data professionals? This interactive Power BI dashboard visualizes data from a comprehensive industry survey to explore demographic trends, salary benchmarks, workplace sentiment, and the tools driving the field forward. By transforming raw survey responses into an intuitive, single-page executive summary, this project highlights key trends in how data professionals work, live, and progress in their careers.

benlusic

Jun 4

Nashville Housing Data Cleaning Project- SQL Server Studio

📂 GitHub Repository: View Full SQL Script & Reproducible Files on GitHub Executive Summary & Business Impact Raw real estate transaction records frequently suffer from missing values, unformatted date strings, embedded delimited addresses, and duplicate rows that invalidate downstream market reporting. This project implements an end-to-end data cleaning pipeline in Microsoft SQL Server (T-SQL) to transform over 56,000 raw housing records into a standardized, production-ready

benlusic

Jun 2

2 3