BI with Billy

Data professional skilled in all aspects of data @BIwithBilly

My Data Journey

Data & Engineering Executive
Microsoft Certified Power BI Data Analyst (PL‑300)
BI & Analytics Practitioner Bridging Strategy and Hands‑On Execution

Power BI Data Analytics Projects

Power BI Dashboard Hub

Interactive business intelligence and automated reporting solutions. Highlights include end-to-end transformation of complex datasets using DAX and Power Query. These projects demonstrate high-performance data modeling, user-centric dashboard design, and the ability to deliver both interactive insights and precision-formatted reporting for stakeholders.

Microsoft Fabric End-to-End Analytics Projects

Building a unified data ecosystem using the Medallion Architecture. Features automated multi-source ingestion from GitHub APIs and ADLS Gen2, cleansing with PySpark Notebooks, and a high-performance Star Schema Data Warehouse. Leverages Direct Lake mode for sub-second reporting performance and automated CI/CD via Deployment Pipelines.

MySQL Projects

Strategic data transformation and investigative analysis using Advanced SQL. Projects focus on converting raw, unstructured datasets into high-integrity databases through complex CTEs, window functions, and rigorous data-cleansing pipelines.

Tableau Projects

Strategic data transformation and investigative analysis using Advanced SQL. Projects focus on converting raw, unstructured datasets into high-integrity databases through complex CTEs, window functions, and rigorous data-cleansing pipelines. Detailed visualizations of this work can be found on my Public Site.

Python/Pandas Projects

Amazon Scraper Project

End-to-end data automation focusing on web scraping and automated reporting. Built robust tools using BeautifulSoup and Pandas to monitor live market data, perform real-time price tracking, and trigger automated email notifications based on custom logic.

Excel Projects

End-to-end analysis of retail trends using advanced analytical logic to transform raw sales data into interactive executive dashboards. Leveraged Pivot Tables, slicers, and complex formulas (Nested IFs, VLOOKUPs) to provide stakeholders with actionable business insights.

Strategic Solutions

Strategic frameworks and automated toolsets designed to accelerate modernization and cost optimization. This section features my Tableau to Power BI Migration Engine—a proprietary solution built to replace manual discovery with data-driven precision. By programmatically auditing legacy portfolios, the engine identifies redundant assets and automates logic translation, allowing organizations to consolidate licensing and reduce migration timelines by up to 40%.