04 / Business Analysis & Decision Support
Turning business problems into practical solutions.
A selection of projects focused on process improvement, pricing tools, sales analysis, customer research and collaboration between business teams and IT.
Selected case studies
Business needs. Practical solutions.
Each case study describes the business challenge, my individual contribution, the approach taken and the value of the solution.
Excel / Pricing / Customer Experience
Customer Self-Service Freight Pricing Calculator
Independently designed and built an Excel calculator that helped Local Sales customers check applicable quoted freight rates without repeatedly contacting their sales representative.
Local Sales / Data Analysis / Pricing
Shipment Flow Analysis
Analysing prospective customers' shipment flows using Excel formulas and pivot tables to compare proposed rates, identify competitive transport lanes and support Local Sales decisions.
Sales Performance / KPI Reporting / Excel
Sales Performance & PTA Reporting
Monthly analysis of sales targets versus actual customer turnover, using CRM exports and Excel reporting across sales representatives, branches, regions and Poland.
Customer Research / NPS / Process Improvement
Customer Research & NPS Analysis
Coordinating quarterly customer research, from external provider selection and survey design to reporting findings and highlighting service issues for business teams.
Business Analysis / IT Collaboration / UAT
Business–IT Collaboration
Representing Sales in product launches and e-booking projects, participating in UAT, aligning solutions with customer needs and organising training for sales representatives.
Sales Enablement / Lead Generation / Reporting
Accelerating Sales with Lead Generation
Turned external company data into a structured prospecting process, qualifying and distributing leads to Sales Support and building dashboards to track lead outcomes and pipeline development.