Services

Foto on desk

Automated data reporting & workflow

I design automated solutions that eliminate repetitive tasks and accelerate reporting processes.

Interactive Dashboards & Data Visualization

I build dynamic, interactive dashboards that simplify complex data for business users.

Data Extraction, Transformation & Analysis (ETL)

I streamline data workflows to deliver reliable, ready-to-use datasets.

Business Intelligence & Data Storytelling

I turn raw data into powerful stories that drive smarter business strategies, using SQL, Power BI, Excel, Python, and more.

Projects

LifeMe Subscriber Dashboard

LifeMe Subscriber Dashboard

Power BI | Excel | DAX

Analyzed revenue and demographics using Power BI, Excel Power Query, and DAX. Targeted insights for product strategy and high-risk segmentation.

View Dashboard
Medicare Part D Enrollment Forecast

Medicare Part D Enrollment Forecast

Excel | Power Query | Forecasting

Built an Excel-based forecasting dashboard to analyze and predict Medicare Part D enrollment trends (2016–2022). Utilized Power Query for data cleaning and applied advanced Excel formulas to calculate year-over-year metrics and forecast future enrollment based on historical patterns.

View Dashboard
Short Pay Root Cause Analysis

Short Pay Root Cause Analysis

Excel | Power Query

This dashboard tracks short pay discrepancies for KeHE, identifying root causes and high-risk retailers and suppliers. It highlights that 81% of orders had short pays, with King Kullen Grocery Co. driving most of the exposure (~$42K). The main issue was damaged goods, especially from Nestlé and Coca-Cola. Recommendations focus on improving packaging and labeling to reduce future short pays.

View Dashboard

About me

Foto on desk
Bryant Ackerman

Data Analyst

I'm a data analyst who builds dynamic dashboards, streamlines reporting workflows with Power Query and Excel VBA, and transforms messy data into clear, actionable insights. I specialize in leveraging tools like Power BI, SQL, Excel, and Python to help teams and clients make smarter, faster business decisions.

Contact Info

Location

Winter Haven, FL 33881

Social Networks

linkedin
linkedin

Get in Touch