Jacob Perovich
Sale Section Analysis
This self-led analysis identified a decline in sale hat revenue and uncovered the root cause. I presented these findings to management, which led to a company-wide pricing strategy revision and a 25% increase in the segments monthly revenue.
Retail Chain Dashboard
This interactive dashboard was created to provide management and executives with a comprehensive view of company and store-level trends across KPIs to evaluate performance and identify opportunities for improvement.
SQL Sales Goals Report
The Sales Goals report compares each store's month-to-date sales performance against it's goals. Data in BigQuery was connected to Google Sheets for easy access.
Projects
(253) 254-3887
Proactive Data Analyst who turns complex findings into deployable insights that help shape business strategy.
Jacob Perovich
This is an anonymized version of a real report that I presented to management which led to 20 stores changing their sale section pricing, and resulted in the segments monthly revenue increasing by 25%.
Hi, I'm Jacob. Welcome to my portfolio. Here, you'll find three completed projects from my current role in a 20+ location retail chain, where I've used data to influence decisions that have grown revenue and improved operational performance. The information in these projects has been anonymized to preserve the confidentiality of real company data.
Jacob Perovich
Data Analyst
This self-led analysis identified a decline in sale hat revenue and uncovered the root cause. I presented these findings to management, which led to a company-wide pricing strategy revision and a 39% increase in the segments monthly revenue.
Sale Section Analysis
This interactive dashboard was created to provide management and executives with a comprehensive view of company and store-level trends across KPIs to evaluate performance and identify opportunities for improvement.
Retail Chain Dashboard
The Sales Goals report compares each store's month-to-date sales performance against it's goals. Data in BigQuery was connected to Google Sheets for easy access.
SQL Sales Goals Report
(253) 254-3887
About Me
Turning Data Into Impact:
When communicating my findings with non-technical teams or executives, I highly prioritize translating the data into the big picture business impact and the “so what” the audience cares about. This approach allows stakeholders involved to understand what’s happening, why it’s happening, and equips them with the intel they need to make confident, data-driven decisions to drive toward goal attainment.
📊
💻
Ensuring Data Accuracy & Integrity:
I take numerous measures to ensure the data I’m working with is clean and usable before conducting analysis to prevent wrong conclusions being drawn. Whether in SQL or Excel, I ensure field names accurately represent the data within them, find missing records, and standardize text data to consistent formats that enable accurate filtering and sorting.
🎯
My Goals:
Although I’m currently located south of Seattle, Washington, I’m targeting roles in or near Phoenix, Arizona, and am happy to relocate. I’m eager to join an organization with a collaborative, growth-focused environment where I can positively contribute to a team that’s dedicated to achieving its financial and operational objectives.
If my background aligns with what you're seeking, I'd welcome the opportunity to connect. Feel free to reach out using the contact information below.