Konstantinos Besios | Portfolio: Executive Assistant to the ELT​
​
​The following section demonstrates my comprehensive approach to Executive Support.
My methodology combines meeting facilitation and formal documentation, daily operational coordination (travel, scheduling, logistics), and advanced data reporting. I ensure that every executive discussion is captured, formalized, and translated into clear action items, while simultaneously delivering the interactive dashboards and analytics that support strategic decision-making.
​
Originally from Larissa and currently based in Thessaloniki, I also maintain a permanent family residence in my hometown. This dual-city presence enables me to work flexibly and efficiently across both locations, while seamlessly supporting operations in either hub.
* Please read the Data Privacy & Compliance Disclaimer at the end of the page
Executive Travel & Logistics Management
The Approach: Managing high-stakes travel for the ELT requires more than just booking tickets; it requires anticipatory planning and 24/7 contingency readiness. This example includes a demonstration of the main page and Day 1 schedule."
Key Features of my Itineraries:
-
Time Optimization: Synchronizing flight schedules with local traffic patterns and meeting locations.
-
Digital Integration: All itineraries are hyperlinked to Google Maps and synchronized with Google Calendar for real-time mobile updates.
-
Information Layers: Inclusion of bios of meeting participants and pre-departure briefings.
Strategic Project Planning & Operations (Monday.com)
A structured overview of daily operations, ensuring clear ownership (Accountability) and real-time status tracking for high-priority executive requests.
Strategic Timeline & Project Lifecycle (Monday.com)
Visualizing the project roadmap to monitor dependencies and ensure all critical milestones are met within the established timeframes.
Title: Technical Architecture & Workflow Mapping
Custom Data Synchronization between Monday.com and Google Workspace
Visualizing the project roadmap to monitor dependencies and ensure all critical milestones are met within the established timeframes.
Power BI dashboards
Power BI dashboards transform complex data into high-level business intelligence for the Executive Leadership Team (ELT).
Executive Sales & Operations Dashboard
Real-time Data Integration & Advanced Querying
Overview: Developed a high-level monitoring tool that bridges raw corporate data with executive decision-making.
​
By connecting an external SQL-based database (Northwind) directly to Google Sheets, I eliminated manual data entry and ensured 100% data integrity.
Technical Implementation: * Data Pipeline: Established a secure live connection using IMPORTRANGE and OAuth protocols to fetch large datasets from remote sources.
-
Dynamic Querying: Applied SQL logic (QUERY function) to filter and isolate specific business criteria, such as "Top 20 High-Value Orders" and "2025 Fiscal Year Performance."
-
Data Visualization: Integrated Conditional Formatting (Color Scales) to provide instant visual hierarchy, allowing leadership to identify key revenue drivers at a glance.
Key Achievements: * Efficiency: Reduced report generation time by automating the data ingestion process.
-
Decision Support: Created a "Single Source of Truth" for the Executive Leadership Team (ELT) to monitor KPIs in real-time.
• Security: Implemented granular access controls to protect sensitive financial information.
SQL Analysis & Business Intelligence
Data Infrastructure Fluency
My proficiency in SQL allows me to understand the underlying relational logic of any ERP system (such as Pylon, SAP, or Microsoft Dynamics). By understanding how data is structured, I can rapidly adapt to new software interfaces and extract high-level insights for executive decision-making, far beyond the capabilities of a standard user
Revenue Distribution Analysis
/* Goal: Calculate total revenue per category
Logic: Join Categories, Products, OrderDetails and Orders
*/
SELECT
c.CategoryName AS [Category],
COUNT(DISTINCT o.OrderID) AS [Total Orders],
ROUND(SUM(od.UnitPrice * od.Quantity * (1 - od.Discount)), 2) AS [Net Revenue]
FROM Categories c
INNER JOIN Products p ON c.CategoryID = p.CategoryID
INNER JOIN [Order Details] od ON p.ProductID = od.ProductID
INNER JOIN Orders o ON od.OrderID = o.OrderID
WHERE o.OrderDate >= '1997-01-01' -- Analyzing a specific fiscal period
GROUP BY c.CategoryName
ORDER BY [Net Revenue] DESC;
Operational Efficiency & Performance Metrics
/* Goal: Identify top performing employees based on order volume
Logic: Join Employees and Orders to count distinct transactions
*/
SELECT
e.FirstName || ' ' || e.LastName AS [Full Name],
e.Title AS [Position],
COUNT(o.OrderID) AS [Orders Handled],
COUNT(DISTINCT o.CustomerID) AS [Unique Clients Served]
FROM Employees e
LEFT JOIN Orders o ON e.EmployeeID = o.EmployeeID
GROUP BY [Full Name]
ORDER BY [Orders Handled] DESC;
Inventory Continuity & Reorder Analysis
/* Goal: Identify products that need reordering from specific suppliers
Logic: Filter products where stock level + units on order is below reorder point
*/
SELECT
p.ProductName AS [Product],
s.CompanyName AS [Supplier],
p.UnitsInStock AS [In Stock],
p.UnitsOnOrder AS [Incoming],
p.ReorderLevel AS [Threshold]
FROM Products p
JOIN Suppliers s ON p.SupplierID = s.SupplierID
WHERE (p.UnitsInStock + p.UnitsOnOrder) <= p.ReorderLevel
AND p.Discontinued = 0 -- Exclude products no longer in production
ORDER BY p.UnitsInStock ASC;
Strategic Project Planning & Operations (excel)
Executive-level roadmap for operational data integration. This visualization tracks milestones, resource allocation, and project health to ensure seamless corporate execution.
Data Privacy & Compliance Disclaimer
"The datasets presented in this section are based on the Northwind sample database, a public-domain dataset used exclusively for demonstrating SQL and Data Visualization proficiency. In a professional environment, all corporate data is treated with the highest level of confidentiality and would not be disclosed or published in any public portfolio, in strict adherence to GDPR and company non-disclosure agreements (NDAs)."