👋 I'm
Drew Koontz
I love all things Business Intelligence. Whether it's designing a new dashboard, automating messy workflows, or just solving fun problems with Excel.
This portfolio highlights some of the tools and projects I've enjoyed building, and how I use them to turn complexity into clarity.
Areas of Interest
Take a look at some of the things I love working on.
Data Analysis
Uncovering trends and insights to support smart decisions.
Data Modeling
Building structured, scalable models to support accurate reporting and planning.
Data Visualization
Turning data into clear, compelling visuals that drive understanding.
Dashboard Design
Creating clean, interactive dashboards that simplify decision making.
Automation
Eliminating repetitive tasks with streamlined, efficient workflows.
Custom Solutions
Designing tailored tools that solve unique business problems. No templates here.
BI & Automation Specialist
These are the tools I use most often
Business Intelligence
Power BI
DAX
SQL
Data modeling, insights, and reporting
Process Automation
UiPath
VBA
Eliminating manual work with logic-based flows
ETL & Data Prep
Power Query
Alteryx
SQL
Automating and transforming raw data
Enterprise Tools
Microsoft 365
SAP
Operating within the corporate ecosystem
Dashboards
Adaptable
Built to evolve with user needs, whether it's changing metrics, new data, or shifting priorities.
Trusted
Relied on by hundreds of users everyday, from frontline sales to executive leadership
Operational
Embedded into daily decision-making, not just for show
Excel Based Projects
Projects created entirely within Excel, pushing the program to its limits
Fractal Generator
Built a formula-driven Mandelbrot set visualizer entirely in Excel, using custom logic and conditional formatting to generate fractals with dynamic zoom and color mapping.
Custom Functions
Used Excel Labs to develop bespoke LAMBDA-powered functions, streamlining complex tasks and empowering users with reusable, intuitive custom logic directly in their spreadsheets.
Warehouse Inventory Tracker
Designed a live-updating inventory heatmap to display warehouse utilization by zone, enabling real-time decision-making around space planning and stock movement.
Monte Carlo Simulations
Integrated Python within Excel to simulate thousands of potential stock price outcomes using Monte Carlo logic, helping visualize volatility and forecast risk over time.
3D Projections
Rendered and animated a rotating 3D cube in Excel by plotting eight points, applying rotational matrices, and using VBA to bring interactivity and motion to the charted points.
Calendar Win/Loss Heatmap
Created a GitHub-style calendar heat map in Excel to track daily progress across months, blending conditional formatting with date logic for an intuitive visual tracker.
Credentials
Corporate Finance Institute
Microsoft
Business Intelligence & Data Analyst (BIDA)
PL-300 Power BI Data Analyst
Work Experience
6+ years of experience in corporate finance, analytics, and data transformation
Encyclopedia-Excel
Created over 150 tutorials covering all levels of Excel, VBA, Power Query, Power BI
Creating short-form content for nearly 200k followers and 12 million combined views
Alteryx
Designer Core Certified
