Data Visualization, Analytics, and Dashboard Design
Transforming raw data into clear, actionable visualizations that support decision-making.
Data Analyst · Power BI
Rafael LuzaRocco
I transform raw data into clear, strategic dashboards that support business decisions.
About me
Data with business context
I began working with data by solving everyday spreadsheet problems: manual reports, rework, and numbers no one could explain. That is when I realized how much a well-structured data foundation can change an entire team's routine.
What motivates me is the investigative side: understanding the question behind the request, modeling data correctly, writing DAX that supports business rules, and delivering a dashboard where answers appear in seconds.
Today, I continue to strengthen my data analytics expertise, combining Power BI, data modeling, and storytelling to support sales and financial decisions.
Skills
Core competencies
Data Modeling
Star schemas, clean relationships, and well-structured dimension tables.
Storytelling
Turning numbers into a focused narrative that supports business decisions.
Logistics and Supply Chain
Solid logistics experience, connecting data to operations, delivery flows, and cost reduction.
Projects
Dashboards and analytics
Finance / Controlling Dashboard
P&L Dashboard
Managerial P&L with Budget, Forecast, and Actuals in a single report, toggle between matrix and waterfall views, dynamically accumulated subtotals, and comparison across 3 branches.
- •Toggle between matrix and waterfall views on the main page
- •Dynamic titles that adapt to the selected filter
- •Budget × Forecast × Actual comparison
- •Field parameter to switch the target (Budget/Forecast)
- •Comparison across 3 branches
CALCULATE + ALL + sort index (subtotal waterfall)Field parameter (Budget × Forecast toggle)Bookmarks + button (matrix × waterfall toggle)Dynamic title measures (DAX-generated text)DATESYTD (Time Intelligence)ISINSCOPE for hierarchy level controlSWITCH + VAR for conditional logic
Open dashboard PDF*Fictional dataset · Dashboard developed: 08/2026
Sales / Commercial Dashboard
Sales Dashboard
Sales performance dashboard covering revenue, weighted forecast, average ticket, sales funnel, sales rep ranking, and loss analysis.
- •Revenue and target KPIs
- •Weighted forecast
- •Sales funnel
- •Sales rep ranking
- •Loss analysis
SUMX + FILTERCALCULATE with multiple filtersTOPN with tie-breaking criteriaRANKX + cumulative total (Pareto)Time Intelligence (DATEADD)ALL / ALLSELECTEDDynamic target by sales rep
Open dashboard PDF*Fictional dataset · Dashboard developed: 07/2026
Logistics / Operations Dashboard
Logistics Performance Dashboard
Logistics monitoring dashboard covering orders, revenue, delivery geography, fleet performance, and returns analysis.
- •Revenue and order KPIs with percentage variance
- •Orders map by state/city
- •Order status and monthly trends
- •Performance by vehicle type and license plate
- •Returns analysis by reason and truck body
Geographic map by state/citySparklines by license plateFleet hierarchy matrixYear-over-year comparisonStatus and returns donut charts
Open dashboard PDF*Fictional dataset · Dashboard developed: 06/2026
Healthcare / Service Dashboard
HealthLab Performance
Laboratory service dashboard covering targets, operational bottlenecks by time and day, and profitability by health plan and procedure.
- •Revenue and appointment KPIs with target achievement
- •Appointment heatmap by weekday and time
- •Receptionist ranking with average workload line
- •Detection of appointments without an identified receptionist
- •Profitability ranking by health plan and procedure
Heatmap by day/timeTarget and achievement measuresRanking with average lineMissing data handlingProfitability analysis
Open dashboard PDF*Fictional dataset · Dashboard developed: 05/2026
Operations / Customer Service Dashboard
Support Indicators — Distribution Centers
A 10-page Power BI dashboard tracking support service indicators across two distribution centers (DC02 and DC05): average service time, queue time, response time, NPS, and ticket volume.
- •Overview by distribution center (DC02 and DC05)
- •NPS by operator and campaign
- •Response, service, and completion time indicators
- •Support tickets panel
- •Tickets opened by hour of day
Button navigation across pagesSynchronized slicersDynamic pivot tablesLine and area chartsKPI cards
Open dashboard PDF*Fictional dataset · Dashboard developed: 03/2026