Data Analyst | BI Developer | Power BI | SQL
7.325
XP
0
Desafios
A financial budget dashboard developed to centralize control of the group’s companies, featuring detailed analyses of revenues, expenses, net income, and EBITDA. It includes comparisons between budgeted and actual values, financial projections, annual indicator trends, and key KPI performance visualizations. A strategic tool for efficient financial management and data-driven decision-making.
The dashboard was developed to monitor and optimize the operations of a freight vehicle yard, covering analyses of movements, average ticket, payment types, operations, carriers, and terminals. The goal was to improve the management of vehicle flow, optimize space and resources, and adjust operations based on movement patterns, especially during high-demand periods.
The project involves the creation of a Commercial Dashboard in Power BI to provide a strategic and operational view of the sales team's performance. The dashboard includes analyses such as revenue, average ticket size, customer retention, monthly sales evolution by product group, salesperson rankings, goal achievement, future scenario simulations, and cross-selling opportunities. The goal is to facilitate data-driven decision-making, optimize sales strategies, and drive results, increasing the team's efficiency and competitiveness.
This financial dashboard project was created to centralize key information such as accounts payable and receivable, net revenue, EBITIDA, net profit, and costs by nature and state (UF). The goal was to improve financial control, optimize cash flow, and support strategic decisions with clear, periodically updated data.
This logistics dashboard project was developed to optimize cost management and operational efficiency. It integrates analyses of gross revenue, costs, operating margin, and performance by branch and vehicle type. The dashboard also tracks delivery metrics such as OTIF, On Time, and In Full, as well as analyzes undelivered orders and their causes. The goal was to improve profitability, reduce operational costs, optimize delivery flow, and increase customer satisfaction, providing strategic data for more accurate and effective decision-making.
This BI project, developed in Power BI, was designed for a distributor of radiological equipment with the goal of consolidating strategic data and facilitating decision-making. The dashboard integrates key indicators such as sales by customer, salesperson, and supplier, target vs. actual performance analysis, ABC curve, customer delinquency, and product batch expiration tracking. Additionally, regional and product analyses were included to identify growth opportunities, reduce losses, and optimize operational efficiency. The project provided greater visibility and agility to management, strengthening the organization’s results.
This supermarket dashboard project was developed to provide a comprehensive and detailed view of sales, inventory, losses, and branch performance. It includes analyses of revenue, sales by product group, comparison of results between periods, stock control and stockouts, loss analysis and its impact on revenue, as well as comparing prices between suppliers to optimize purchases. The main objective was to improve strategic decision-making, optimize resource management, and maximize store profitability.
This dashboard project was developed to provide a comprehensive and detailed view of project performance. It includes analyses of actual versus budgeted costs, worked hours compared to estimates, the number of projects by management and area, and deadline tracking through Gantt charts. The main goal was to improve cost control, optimize resource utilization, and enable more efficient project management, focusing on delivering projects on time and within the established budget.