Further exploration
Python · SQL · Dashboard storytelling
I use Python and SQL to explore records, validate totals, and communicate business findings. My portfolio includes a public data explorer with a downloadable source and verification script.
Specific contributions and the methods behind them.
Customer Segmentation & BI
Sep 2026
My contribution
Analyzed 440 records with Python, pandas, and scikit learn, reconciled totals in SQLite, and built a Plotly dashboard.
Read the case studyPractical lesson
Validate totals at each stage from raw records to the dashboard.
Breaking Games
Jul 2026 to Aug 2026
My contribution
Validated SQL joins for 99 products and developed a five KPI HTML/Chart.js dashboard.
Read the case studyPractical lesson
A useful dashboard connects a metric to the decision it informs.
Illustrative brief · Proposed approach
Two dashboards disagree on revenue. How would I investigate?
Start withMetric definitions, SQL queries, reporting dates, joins, and source totals.
Data Analyst Intern · Data Analytics Intern · Business Intelligence Intern · BI Analyst Intern
The published dashboards use Plotly and HTML/Chart.js. Tableau and Power BI are additional tools. Native workbooks are not included here.
The example brief above describes a proposed approach. Case studies distinguish completed work, reported results, and recommendations.
Each exercise includes a question, its assumptions, and working files.
Illustrative sample · Synthetic data
A database exercise explains why sales can be counted twice and how to check the correct total.
Public data analysis · Portfolio companion
Compare what retail customers bought with purchases by hotels, restaurants, and cafés using historical public records.