Internal Audit & Analytics Portfolio

Colby Kellersberger, CIA, CFE, CICA

SQL & Data Projects

End-to-end data projects demonstrating SQL querying, transformation, and analytical storytelling through dashboards.

SQL ETL Data Modeling Power BI Data Visualization

Data Job Market Analysis

Data Job Market Analysis

SQL • Exploratory analysis

Problem
Understanding which data skills are in highest demand and command higher compensation requires analyzing large, unstructured job posting data.

Approach
Collected and queried job posting data using SQL to identify trends in required skills, job titles, and compensation ranges.

Analytical value
Highlights skill gaps and market demand trends for data professionals.

View GitHub repository

Top paying data roles analysis

Sales ETL & Dashboard

Sales ETL & Performance Dashboard

SQL • ETL • Power BI

Problem
Raw sales data often requires significant transformation before it can support meaningful performance analysis.

Approach
Designed an end-to-end pipeline using SQL to clean, transform, and model sales data, followed by a Power BI dashboard for reporting.

Analytical value
Demonstrates data engineering fundamentals and business-focused reporting.

View GitHub repository

Sales performance dashboard