Artur.Marcon

Business Intelligence Analyst · Power BI · SQL · Python

Artur Marcon builds dashboards people decide with.

I turn ERP and sales data into Power BI models that answer a leadership question in one screen: who buys, who leaves, and where the revenue really comes from.

  • Open to remote roles
  • EU citizen (Italy)
  • Based in Curitiba, Brazil
  • Available now

Sales overview

Revenue YTD
R$ 0
Avg ticket
R$ 0
Active clients
0
This yearLast yearBest month

Sample data. Click a region: the measures recalculate the way a DAX filter context would.

01 / Cases

Four questions, four models

Each case below is a pattern I deliver for commercial teams. Client data stays private, so the charts use anonymized sample data built with the same structure and logic as the real reports.

Sales analytics

Sales performance and decision intelligence

Problem
Plenty of ERP sales data, no single source of truth. KPIs were undefined and leadership decided on instinct.
What I built
A star schema on top of the ERP, a measure layer in DAX for revenue, ticket and growth (month over month and year over year), and a seller ranking with drill-through to customer level.
Result
One report the sales leadership opens every week, with underperforming segments and concentration risks visible on the first page.
Star schemaERP integrationDAX time intelligenceDrill-through
Revenue by seller vs target, sampleR$ thousand
At or above targetBelow targetTarget
Customer intelligence

RFV segmentation

Problem
Every customer got the same treatment. High-value accounts and dormant ones received the same attention from the sales team.
What I built
A Recency, Frequency and Value score computed in DAX from purchase history, classifying every customer into a segment with a clear commercial action, refreshed automatically.
Result
Sales effort allocated by segment value, with at-risk customers flagged before they go quiet. The same model fed a six-month commercial program built on segment missions.
RFV scoringBehavioral segmentationDAXCustomer lifecycle
Share of customers vs share of revenue, sample%
% of customers% of revenue
Retention analytics

Cohort retention

Problem
Nobody could answer when customers stop buying, or which acquisition months produced the healthiest customers.
What I built
Cohorts anchored to each customer's first purchase and a retention matrix rendered as a heatmap, readable by non-technical stakeholders in seconds.
Result
The second and third month showed up as the main churn window, which moved retention actions to right after onboarding.
Cohort analysisRetention matrixHeatmapChurn detection
Customers still buying, by months since first purchase, sample
Revenue strategy

ABC and Pareto concentration

Problem
Revenue distribution was opaque. The business did not know how exposed it was to losing a handful of key accounts.
What I built
An ABC classification of customers and products by revenue contribution, with a cumulative Pareto curve and dynamic class thresholds.
Result
Confirmed a heavy dependency on a small Class A tier, and pointed to growth room in Class B accounts that were under-served.
ABC classificationParetoRevenue attributionRisk
Cumulative revenue by customer rank, sample%
Class AClass BClass C
02 / Method

How a report gets built

The same five steps on every project, from the first meeting to the report people keep using.

01

Understand

Business goals, stakeholder questions, and what the ERP actually records.

02

Model

Star schema, clean relationships, Power Query transformations, performance tuning.

03

Measure

KPI definitions agreed with the business, written once as DAX measures.

04

Visualize

Decision-first layout, drill-through for detail, row-level security per user profile.

05

Deliver

Walkthrough with the team, documentation, and support as questions change.

03 / Experience

Finance first, then data

Years of credit analysis at a multinational taught me what a decision-maker needs from a number. BI is where I build that for others.

2024 to now

Business Intelligence Analyst

S&V Sucesso em Vendas, Curitiba

Client Power BI dashboards for commercial teams: advanced DAX metrics, data from ERPs, Excel and APIs, sales and target tracking, predictive analysis and customer segmentation, row-level security by user profile.

2020 to 2024

Credit Analyst, previously Trainee

ExxonMobil

Credit analysis and financial data review for business customers, with recurring reporting to support credit decisions.

Ongoing

Founder and operator

Online game server company

Technical administration and business operations of a small online game business, including revenue tracking and customer support.

2018 to 2019

Seasonal staff

Vail Resorts, Colorado, USA

Customer service in an international team, working fully in English.

2016

Intern, Corporate Cards

Banco do Brasil
04 / Toolkit

Tools and terms

Stack

Power BI / DAXAdvanced
Power QueryAdvanced
ExcelAdvanced
SQLAdvanced
Python, pandasIntermediate

Education: Business Administration (FAE, 2021), Data Science specialization (Le Wagon, 2024), Systems Analysis and Development at PUC-PR (in progress, 2027).

Working terms

  • FormatRemote, full time or contract
  • Work rightsBrazilian and Italian citizen: can work in Brazil and across the EU without a visa, open to relocating
  • HoursComfortable overlapping with US and European business hours
  • LanguagesPortuguese (native), English (fluent), Spanish (intermediate)
  • StartImmediately

Have a question your data should answer?

Emailartur.marcon@gmail.com
LocationCuritiba, Brazil (UTC-3)