k
keaton_rowley

Keaton R

@keaton_rowley

Data Analyst

United States
English
About me
I am a Data Analyst specializing in Power BI dashboards, SQL reporting, and Python-based reporting automation. I build analytics solutions that transform raw operational and transactional data into clear, actionable insights to help teams monitor trends and improve decision-making. My expertise includes developing Python tools for data processing, document parsing, and workflow automation to increase operational visibility.... Read more

Skills

k
keaton_rowley
Keaton R
Offline • 
Average response time: 5 hours

See my services

BI Analytics
I will automate excel and CSV reporting workflows
From$150 / projectMore details

Portfolio

Work experience

Company

Full-time • 3 yrs 1 mo

Data Analyst (Boise Cascade)

Oct 2025 - Present • 7 mos

• Designed and delivered Power BI reporting and audit solutions that replaced an existing third-party environmental reporting platform, improving reporting workflows and contributing to substantial operational cost savings. • Built a centralized semantic model integrating 25+ operational and commodity data tables using Power Query transformations and star schema modeling to support KPI reporting, operational reporting, audit workflows, and environmental performance analysis. • Developed an interactive Power BI audit tool with advanced filtering, drilldowns, contextual report page tooltips, and location-level reporting workflows to streamline data validation, improve audit visibility, and support stakeholder analysis of missing or inconsistent billing data. • Collaborated with stakeholders to improve KPI visibility, automate recurring reporting processes, and streamline access to operational and environmental performance data through Power BI and SQL-based reporting solutions. • Maintained and enhanced an Azure-hosted Python data transformation application using Pandas and NumPy to automate spreadsheet standardization, improve data consistency, and streamline operational reporting workflows.

Data Analyst (Intern, Boise Cascade)

May 2025 - Sep 2025 • 4 mos

• Developed an internal Power BI model exploration tool that generated interactive hierarchical visualizations of DAX measure relationships to improve reporting analysis, measure tracing, and model navigation workflows. • Built a SQL-based schema exploration utility that analyzed database metadata, table structures, and relationship mappings to identify likely table matches and support data discovery and reporting development processes. • Designed and implemented a SharePoint, Power Automate, and Microsoft Forms workflow to greatly simplify external audit submission processes through branching logic, automated data collection, and integrated list-based workflows.

Technical Support (Idaho Transportation Department)

Mar 2023 - May 2025 • 2 yrs 2 mos

• Developed an Excel/VBA onboarding automation system that streamlined account setup workflows through automated field population, standardized data formatting, password generation, workflow utilities, and preformatted Outlook email automation. • Designed and built a PowerShell-based remote support utility that centralized system administration commands, remote management workflows, and troubleshooting capabilities to improve operational support efficiency and supplement declining enterprise management tooling. • Supported and troubleshooted 300+ enterprise applications while managing Active Directory account administration, permission updates, and user access workflows for county and headquarters users. • Created and maintained extensive SharePoint and OneNote knowledge base documentation to improve troubleshooting consistency, operational support workflows, and internal knowledge sharing processes.