Anthony Bible | Excel/VBA · SQL · Python · Power BI · Tableau
Data analyst projects in this portfolio focus on reporting automation, BI-ready datasets, and decision-support workflows using Excel/VBA, SQL, Python, Power BI, and Tableau.
I build analytics projects that clean data, reduce manual reporting work, and turn business questions into dashboards, summaries, and insights.
Virginia Tech Business Information Technology graduate with a concentration in Decision Support Systems.
Tools: Python, Pandas, DuckDB SQL, Power BI-ready outputs
Focus: Healthcare analytics, large dataset analysis, payment trends, HCPCS service analysis
Outcome: Analyzed 9.6M+ CMS Medicare provider-service records across 1.17M+ providers to identify Medicare payment drivers, HCPCS service trends, and Connecticut vs. national benchmarks.
Tools: Excel, VBA, Solver, forecasting
Focus: Decision support, logistics optimization, profit optimization, dashboard-style reporting
Outcome: Built a decision support system with manager/employee views, Solver-based logistics and profit optimization, and automated scenario analysis; reduced report generation from hours to under 10 minutes.
Tools: Python, Pandas, Matplotlib
Focus: Public data analysis, GDP comparison, per-capita metrics, executive-style visuals
Outcome: Compared health, education, and military spending across countries using GDP and per-capita metrics; created visual summaries to highlight spending patterns across categories.
Excel/VBA: PivotTables, Power Query, lookup functions, charts, dashboards, forecasting, Solver, optimization, macros, workbook automation, navigation buttons, user interface development
SQL: DuckDB SQL, MySQL, joins, filtering, aggregations, CRUD operations, database-backed applications
Python: Pandas, DuckDB, Matplotlib, NumPy, Jupyter, data cleaning, large dataset analysis, data visualization
BI tools: Power BI, Tableau, Power BI-ready CSV outputs, dashboard reporting
Business analysis: Reporting automation, KPI tracking, operations analysis, process improvement, requirements gathering, decision support
Business systems project with Agile planning, DFDs, CRUD mapping, requirements documentation, sprint planning, and Zapier workflow automation.
Flask and MySQL web app with product pages, database connection, inventory analytics, and HTML templates.
Entry-level Data Analyst, Reporting Analyst, Business Intelligence Analyst, Business Analyst, and Operations Analyst roles focused on Excel/VBA, SQL, Python, dashboards, reporting automation, and business insights.