Portfolio
Pareto Analysis Chart
This visualization highlights the most significant contributors to total revenue using the Pareto principle. By combining a sorted bar chart with a cumulative line, it reveals which customers drive the majority of revenue — helping prioritize focus and decision-making.
Other Common Use Cases:
-
Customer profitability analysis
-
Defect or complaint root causes
-
Inventory management (which items drive most value)
-
Sales performance by product or region
Workout Wednesday Challenges 2025
Workout Wednesday is a weekly challenge where participants re-create a data-driven visualization. The challenges are designed to help with personal development in Tableau and Power BI.
Every Wednesday, a new challenge is released, and participants are tasked with replicating the posed visualization as closely as possible.
This dashboard showcases my subscriptions for the year 2025.
The Impact of the Third Industrial Revolution on Global Warming
This project, created as part of Week 4 of the Power BI DataViz World Championship 2025, focused on analyzing monthly average global surface temperature data alongside CO2 emissions from various countries and industries over time.
The primary goal was to examine the correlation between these variables, with the aim of understanding how the 3rd Industrial Revolution has contributed to the rise in global warming.
10 Different Ways to Analyze
Time Series Data
This project presents 10 metrics using time series data, showcasing various approaches with just 2 columns in our dataset.
Choosing the right metrics is crucial, depending on the business case and decision maker.
Too many metrics can be overwhelming, so identifying the most important ones is key for data analysis and management.
Which one is your favorite?
Apple's Restaurant - Monthly Report
This project uses fictional restaurant data to represent sales performance in December 2024.
The goal was to create a simple, concise monthly report for managers.
The data storytelling approach makes it easier for managers to read, understand, and make quicker decisions.
The report can be automatically generated and sent via email each month.
Monitoring E-Commerce Performance
This project involved creating an interactive dashboard for e-commerce managers to monitor sales performance.
Using data extracted from the Shopify API via Coupler.io, this dashboard offers two key pages:
-
The first page provides a sales overview, featuring Pareto analysis to highlight the most impactful products, customers, discount coupons, and weeks.
-
The second page focuses on product analysis, displaying additional metrics such as sales by product category and vendor, profitability, return rates, and regional sales performance.
The dashboard also highlights product performance correlations, identifies underperforming products, and helps managers make data-driven decisions to optimize product offerings and focus on high-growth areas.
Workout Wednesday Challenges 2024
Workout Wednesday is a weekly challenge where participants re-create a data-driven visualization. The challenges are designed to help with personal development in Tableau and Power BI.
Every Wednesday, a new challenge is released, and participants are tasked with replicating the posed visualization as closely as possible.
This dashboard showcases my subscriptions for the year 2024.
Operations Management: Monitoring Teams' Performance
This interactive dashboard analyzes 100 construction interventions across Gabon, focusing on metrics like intervention type, cost, revenue impact, and resource usage.
Operations managers can filter data by period, visualize performance trends, and adjust targets to optimize operations.
By visualizing key metrics and trends, the dashboard enables informed decision-making, efficient resource allocation, and optimized operations.
Ideia de
lanche
Incident Analysis:
A Case Study of an Australian Electricity Distributor
This project was part of Industry Inner Join v9 - The Dashboard Off by DR Analytics Recruitment, a data challenge where professionals showcase their best data visualization work.
It features an interactive dashboard built to analyze Ausgrid’s Past Outage Data for an Australian electricity distributor. The dataset tracks power interruptions affecting 50+ customers, lasting over five minutes, with details like outage duration and potential causes by Local Government Area (LGA).
The dashboard helps operations managers proactively prepare for future incidents by providing insights into incident trends, regional performance, and peak outage periods.
Key features include month-over-month trend analysis, quarter-over-quarter comparisons by LGA, and geospatial visualizations—all designed to optimize resource allocation and response times.
This project aims to empower teams to make data-driven decisions that enhance operational efficiency and improve incident management.
Segmentation Study of Airbnb Customers Visiting Lisbon During Holidays
This project focused on understanding different groups of Airbnb customers who visit Lisbon during holiday times. The main tool used for this research was R Studio.
A key part of this study is the use of cluster analysis, which is a method for grouping similar customers together. By applying different clustering techniques, the research was able to identify various segments of Airbnb listings based on customer preferences.
Understanding these customer segments is important for companies because it allows them to create targeted marketing strategies. By knowing what different groups of customers want, businesses can improve their services and attract more visitors, making them more competitive in the tourism market.
CRM Data Analysis
The FP20 Challenge 17, organized by Zoom Charts and FP20 Analytics, focused on analyzing CRM data from a fictional IT company.
To achieve simplicity and sophistication, I used storytelling principles from Cole Nussbaumer Knaflic to design intuitive dashboards for sales managers. By employing clear graphs, a minimal color scheme, and concise summaries, the dashboards are user-friendly, even for those not well-versed in tools like Power BI or statistical analysis.
Following Don Norman's Z-pattern layout, each page guides users through critical information, with key insights placed prominently for easy access. The "Overview" section highlights sales trends, pipeline health, and regional performance, ensuring that every element, from heatmaps to ribbon graphs, is clear and engaging.
Project Pricing Model
This project aims to demonstrate the Jira Power BI Connector through the Elite IT podcast.
The dashboard enables users to determine project costs based on client requirements, select an appropriate profit margin, and confirm employee availability for each specific project.
Inventory Management with Chat GPT
This project highlights the importance of AI in supporting business decisions today. Through this interactive dashboard, the inventory manager can quickly adjust parameters and see AI-driven recommendations alongside key historical metrics.
Chat GPT can be used not only to support decisions in inventory management but also in many other areas of the business, such as customer service, marketing, and financial analysis.
A variety of prompts and ideas can be implemented to enhance efficiency and innovation across the organization.
Maven Sales Challenge
This project aimed to create an interactive dashboard for sales managers to track team performance using a dataset from a fictional computer hardware company's CRM database. Key insights reveal the crucial role of lead generation in driving sales, the impact of sector allocation, particularly in technology and finance, and the need to diversify sales contributions among team members for sustained success.
Overall, the project highlights the importance of strategic sector allocation, lead generation, and team diversification in optimizing sales performance and competitiveness.
Quiz Takers Analysis
In this project, I gathered quiz data from the Private Gym webpage, which offers products for male sexual health.
The resulting dashboard was crafted to empower the CEO with insights into customer demographics and preferences, enabling informed decisions on product development and tailored marketing strategies.
Maven Coffee Challenge
The Maven Coffee Challenge tasked participants with serving as Analytics Consultants for investors aiming to enter the US coffee market. Leveraging insights from "The Great American Coffee Taste Test," participants were required to craft a data-driven strategy for launching the investors' inaugural coffee shop. This involved addressing key areas of interest while also providing additional insights and recommendations to meet the investors' objectives.
In this project, I utilized the K-Means clustering algorithm to analyze taste preferences of respondents and identify distinct customer segments. This powerful algorithm provided actionable insights for product offerings and pricing strategies, paving the way for market success.
Real Estate Insights: Streamlining Reporting with Power BI in Southern Brazil
In this project, I assisted a consultancy company in delivering monthly reports to investors and contractors in southern Brazilian cities. The reports, created in Power BI, were designed to streamline presentations and enhance audience comprehension. They include key metrics, maps, and time series analyses.
Livestock - Rio Grande Do Sul, Brazil
This dashboard was created to help students from one of the Faculties of Agronomy in Rio Grande do Sul, Brazil.
You can have information about the livestock by selecting a city and comparing it to the total stock of the region and state, as well as, you can see the percentage of total by animal category and the growth of the stock over the years.
