Business Data Analyst
Turning messy data into clear decisions with SQL, Python (pandas), and BI (Power BI / Tableau).
Welcome to my website! I’m Thang Tran, a UMass Lowell graduate with a degree in management information system. I am a data driven problem solver and my work turns complex data into clear, actionable insights and story-driven dashboards. Through my co-op at Lightforce Orthodontics and multiple analytics projects, I’ve gained hands-on experience with SQL, Python, Power BI and Tableau. I love learning! If you have any suggestions for my site please let me know! I hope we can meet soon!
Get in TouchSelected work with outcomes. Ask for code samples or deep-dive writeups.
Built an interactive Power BI dashboard using AWS Athena census data (2015–2020) to examine how education levels affect income and poverty across the U.S., revealing that regions with more college graduates have higher incomes and lower poverty rates, while many Southern and rural areas still lag behind.
Enabled managers to monitor $21.7B sales as data across 45 stores, improving visibility into profitiability trends for holiday season. Authored an end to end retail analytics pipeline with SQL Server, Processed and transformed 6,000+ rows with SQL bulk inserts and star schema modeling, type safe SQL in order to designed and deliver a clean interactive Power BI model with multiple pages showing analytics on real world data such as growth rate, total sales over time.
Built a interactive data dashboard to explore how traits influence healthcare insurance charges. Performed data cleaning and exploratory data analysis on real world insurance data using Pandas and Seaborn/Plotly. Implemented multiple filters for users to inreactively explore the data with a streamlit sidebar. Deployed using Streamlit cloud and github for public access.
Developed to explore sales, costs and profits across cities, products, managers and purchase types.Includes dynamic filters, map visuals, KPI cards and interactable elements so that stake holders can understand the data, uncover trends and quickly identify profit drivers. Cleaned and prepared raw excel data and used DAX measures to calculate interactive KPIs. This dashboard would essentially allow restaurant managers to monitor real-time performance across different locations, track profitability trends and identify which products were high performing
Created two connected dashboards that allow users to track fuel efficiency, horsepower, and brand popularity over time. Drill-down options include origin, cylinders, and model year, as well as dynamic filters, scatterplots, and bar charts. Provides a comprehensive image of how different regions and brands compared in terms of MPG, horsepower, and number of models between the 1970s and 1980s. Shows sale trends, brand breakdowns and model pricing insights alongside using filters to get the cleanest data. (click me!)
Designed and documented a Slack-integrated Employee Recognition & Rewards System (ERRS) to improve morale, engagement and retention. Prepared a full report documentation that includes Gantt and PERT analysis and a break even analysis. Includes user requirements, project scope, communication plans, and project feasibility. Developed data flow diagrams that ex plores all processess to the system. (click me!)
Analyzed and cleaned nearly 9000 Netflix shows and movives using the Naives Bayes model to uncover patterns in genre, country of origin and ratings with a accuracy of 99.97%. Tested decision tree, logistic regression models as well, but they did worse than Naive Bayes.Found movies dominate over TV shows; dramas, comedies and documentaries are most common; US, India and UK lead in production.
Roles where I delivered measurable impact.
Want to talk about an opportunity or a project? Reach out! I’m based in the Greater Boston area and open to roles.
