Projects in Power BI
Global Sales
Problem
With the expansion of digital markets, the company lacked a unified view to understand sales behavior in different regions. The fragmentation of data prevented a clear analysis of geographic profitability, hindering strategic decisions on where to allocate resources and how to manage international operational efficiency sustainably.
Solution
Development of a robust BI ecosystem geared towards the multinational market, focusing on:
-
Advanced Geographic Analysis: Use of ArcGIS maps and bar charts to identify revenue leaders by continent and country;
-
Trend Monitoring: Line charts for monthly sales and profit tracking, facilitating the detection of seasonality;
-
Internationalization: Dashboard fully configured in English, simulating a real reporting environment for global headquarters;
-
Institutional UI/UX: Design focused on core KPIs (Sales, Profit, Margin) with a Dark/Purple color palette to facilitate executive readability.
Result
The solution provided an unprecedented strategic view of the operation:
-
Market Dominance: Clear identification of revenue concentration in the North American market;
-
Profit Optimization: Realization that, although sales are global, profitability varies drastically by region, requiring localized marketing strategies;
-
Financial Health: Complete visibility into demand peaks, allowing for more assertive inventory and logistics planning.
Tool used
Power BI: Main platform for visualization and publishing;
Power Query: Used for processing geographic data and technical translation of fields;
Data Modeling: Structuring relationships to ensure the integrity of margin and profit calculations;
Visualization: ArcGIS Maps and dynamic Trend Charts.
Data source
-
Global Sales Enterprise Dataset: A database specifically structured for analyzing the performance of international e-commerce.
HR Analytics
Problem
In the Human Resources sector, the lack of structured data analysis hindered strategic people management. The organization lacked clear visibility into hiring patterns, salary disparities between departments, and the operational health of its human capital, which made decision-making regarding promotions and new hires reactive and poorly informed.
Solution
Development of an HR dashboard to transform raw data into business intelligence, focusing on:
-
Workforce Evolution: Monitoring peaks and trends in hiring over the years to understand company growth;
-
Salary Efficiency: Comparison of annual averages by sector to ensure budget balance;
-
Talent Distribution: Productivity and performance analysis segmented by department;
-
Demographic Composition: Visualization of gender diversity and employee profiles through donut charts and icons.
Key Analytics
To present, in a clear and visual way:
• Annual and monthly sales volume, allowing the identification of growth trends;
• Geographic profitability, highlighting the most profitable markets. Supporting expansion decisions and resource allocation in global markets.
Tool used
-
Power BI: Platform used for creating and publishing visuals;
-
Power Query: Performing HR data processing and cleaning duplicates;
-
Data Modeling: Structuring for performance integration with departments;
-
Data Visualization: Implementation of trend charts, stacked columns, and key performance indicators (KPIs).
Data source
-
Public Dataset (Kaggle): Using the HRDataset_v14 dataset to simulate a real-world corporate scenario.
UrbanPark BI Dashboard
Problem
Managing large-scale parking networks requires rigorous control over revenue fluctuations and operational efficiency across different regions. The central challenge was consolidating scattered data on billing, vehicle flow (tickets), and human capital management into a single strategic command center. The lack of an integrated view made it difficult to identify productivity bottlenecks, salary disparities, and the correlation between the volume of claims and staff turnover by position.
Solution
I developed an integrated Business Intelligence solution for 360° operational monitoring, structured as follows:
-
Data Engineering (Excel): Processing and cleaning (ETL) of financial, operational, and human resources databases, ensuring the consistency of key performance indicators (KPIs).
-
Analytical Modeling (Power BI): Implementation of DAX calculations for analysis of Average Ticket Value, historical revenue evolution (2023-2025), and payroll metrics.
-
Strategic Design (Figma): Designed with a focus on UX/UI, using a clean aesthetic and cards with soft shadows to allow managers to identify trends and alerts in seconds.
Key Analytics
Data analysis revealed critical areas and opportunities for optimization for the UrbanPark network:
-
Financial Performance: Identification of robust 200% growth in annual revenue, jumping from R$ 270,000 (2023) to R$ 810,000 (2025). Accumulated revenue reached R$ 1.6 million, with an average ticket of R$ 60.00 per vehicle.
-
Operational Efficiency: Mapping the distribution of 6,850 total vacancies by state, with SP leading (2,700 vacancies), followed by RJ (2,550) and MG (1,600). The system processed a total volume of 27,000 tickets.
-
Risk and Talent Management: The dashboard correlated the peak of 198 claims in 2024 with a critical turnover rate for the Operator position (9,180 terminations). This data points to the urgent need to review training and retention policies to reduce operational costs.
-
Gender Balance and Salary Structure: Visualization of parity in team composition (approx. 50% male / 50% female) and analysis of the cost structure, where the salary of Managers (R$ 9,080) and Supervisors (R$ 5,080) contrasts with the base salary of Operators (R$ 1,994).
Tool used
-
Power BI: Data modeling, DAX calculations, and interactive visualization;
-
Excel: Data processing and database cleansing (ETL);
-
Figma: Interface design (UX/UI) and Visual Storytelling.
Data source
Simulated data based on real parking management metrics and HR indicators for logistics operations.