Fernando Almeida Teles
Portfolio
About Me
Commercial Insight & Data Analytics | Power BI Developer. Turning complex data into clear insights for commercial and operational decisions.
Business and data analyst with strong experience in Power BI, SQL, and commercial reporting. Background in aviation and corporate travel, supporting revenue, cost, and performance analysis.
Based in Calgary, AB.
YYC Airport
Commercial Insights Dashboard
Airport Commercial Performance Analysis
Context
Public financial and passenger data from Canadian airports, used to simulate real-world commercial analysis.
​
What was done
Revenue and passenger trend analysis
Revenue per passenger (RPP) metrics
Airport comparison (YYC, YVR, YOW, others)
Scenario analysis for growth and recovery
​
Key Insights Delivered
-
Clear visibility into how passenger growth impacts commercial revenue
-
Identification of differences in RPP across airports
-
Trend patterns supporting data-driven commercial decision-making
​
Tools
Power BI
DAX
Excel
Public financial statements
​
Corporate Travel Management Dashboard (B2B)
Context
This dashboard was developed for a B2B corporate client of a Travel Management Company (TMC). It provides visibility into corporate travel spend, savings, and travel behavior, supporting cost control, policy compliance, and strategic decision-making.
​
What was done
Analyzed corporate travel spend across air, hotel, car rental, and other services
Monitored savings achieved through negotiated rates and preferred suppliers
Tracked ticket volume, average airfare, and spend trends over time
Segmented travel by domestic and international travel
Built executive KPIs for ongoing performance monitoring
​
Business Value
-
Enables clients to understand where and how travel budgets are being spent
-
Supports identification of cost-saving opportunities and policy gaps
-
Improves transparency between the TMC and corporate stakeholders
Tools
Power BI
DAX
SQL Server
​
Power BI Dashboard Gallery
