PORTFOLIO

Dashboard developed to monitor B2B and B2C sales for a company in the food industry. Available analyses include Revenue, Margin, and the number of Invoices issued, broken down by product line, sales channel, and product group, along with a ranking of sales representatives.

The report also provides an in-depth cash flow analysis, as well as a powerful scenario simulator that shows in real-time the impact that each hypothesis may have on the company's bottom line.

Development Notes:

• Database in Excel;

• Data processing in Power Query;

• Background design in Figma;

• Model: 2 Fact tables and 4 Dimensions;

This application was developed using Microsoft Power Apps to streamline the internal purchase request process within the organization. 

It enables employees from various business units to easily submit purchase requests, ensuring seamless communication and full traceability with the procurement department.

With a user-friendly interface, the app standardizes request submissions, automates status tracking, and improves visibility across departments. It helps reduce manual errors, accelerates approval workflows, and guarantees that all requests are properly documented and auditable—enhancing transparency, efficiency, and collaboration between business units and the purchasing team.

Dashboard developed for Project Portfolio monitoring, enabling easy tracking of the main KPIs in the area: Work, Costs, and Duration.

The report also includes analyses with a Gantt chart, S-curve, and individual project details using drill-through functionality.

Development Notes:

• Database extracted directly from Project and connected via Access;

• Data processing in Power Query;

• Background design in Figma;

• Star Schema Model: 1 Fact table and 2 Dimensions;

Dashboard developed for analysis of the 2019 ENEM (Brazilian National High School Exam) scores.

Available analyses include the average scores of students by subject and type of school, the Top 100 students and their respective states, the Top 3 states by essay and overall average scores, as well as a complete analysis of absent candidates.

The report also includes a final score simulator, allowing users to input their scores and weighting for each subject to calculate a final score.

Development Notes:

• A massive CSV database was used. After data processing in Power Query, tables were obtained with over 25 million rows and 77 columns.

• Data processing conducted in Power Query.

• Backgrounds created in PowerPoint.

• Model structure: 2 Fact tables and 11 Dimension tables.

Context

In an logistics operation environment, a analyst must simulate freight quotations based on historical data to make quick and informed decisions. After identifying the best transportation option (route, mode, seasonality), they send a real quotation request to suppliers and collect responses automatically. The process ends with internal validation and approval by stakeholders — all integrated through the Power Platform. 

Project Objectives

• Manage the day-to-day pricing & quotation requirements

• Develop & maintain carrier and service-partner relationships

• Develop proactive solutions to optimize supply chain and achieve cost-savings for customers

• Negotiate rates with carriers for road & rail transportation

• Anticipate business and industry trends to find ways for potential gain

• Develop pricing analysis for RFP’s

• Work closely with the customers, carriers, and logistics team to ensure efficient operations and to meet required deadlines

Project Stages

🔍 Power BI – Freight Quotation Simulator

• Historical freight data by origin/destination, mode of transport, cargo type, seasonality, and suppliers.

• Interactive slicers (e.g., “I want to simulate a freight from Saint John/NB to Maine/USA, dry cargo, by sea, in March.”).

• DAX measures for estimated cost, including variations (fuel, inflation, lead time).

• Comparative visuals: ideal quote vs. market average vs. lowest recorded cost.
  
  

📝 Power Apps / Forms – Quotation Request

• Form for users to submit real freight quotation requests.

• Fields such as: origin, destination, weight/volume, transportation mode, deadline, special instructions.
  
  

📧 Power Automate – Request Trigger

• Triggers upon form submission.

• Sends email with quotation request template to freight suppliers (shipping lines).

• Stores each supplier response in a repository (e.g., SharePoint or Excel).

📊 Power BI – Supplier Responses Dashboard

• Live dashboard displaying quotations received from each supplier.

• Visual indicators for cost, lead time, special conditions.

• Highlight and visual button to select the best option.
  
  

✅ Power Automate – Approval Workflow

• When an option is selected, triggers an approval flow:

• Teams notification + email to manager/logistics/sales.

• Automatic decision logging + optional comments.

• PDF generation with all quotation and approval details.