Skip to content

IT analytics platform · Management and governance

Vortex.

Vortex brings security, infrastructure, budget, licence and IT operations indicators together in an internal platform. Its dashboards let people follow results and explore the data; behind the scenes, collection and data-processing routines keep those views up to date.

Type
Internal platform
Areas
Security · Infrastructure · IT management
On this page
Platform description and a synthetic-data demo
Circular chrome sculpture on a black and red background.

ConfidentialityInternal corporate platform with implemented features. This page shows no source code, real data or infrastructure details. The screens and the interactive demo are independent recreations, with names, numbers and charts that are entirely synthetic; they are not captures of the original system.

Ler em português

01 /

Context

IT information was spread across separate tools and controls. Vortex organises those sources into an analytical base and presents dashboards to follow security, infrastructure, licences and spending.

The data layer relies on extraction, transformation and storage; the interface brings together filters, indicators and visualisations for operational and executive analysis.

02 /

Challenge

The challenge was to bring together data with different formats and refresh cycles while keeping consistency, traceability and access control. The platform also had to offer dashboards that let people investigate variations and follow indicators without relying on spreadsheets or manual queries for every analysis.

03 /

Pillars and capabilities

The capabilities that make up the platform, grouped by role. They are described without real data or infrastructure details.

P1

Data and processing

The technical foundation of the platform. It is not a screen module: it brings data from distinct sources into a common analytical model that underpins the indicators.

  • Extraction and transformation pipelines
  • Integrations across different sources
  • PostgreSQL and analytical modelling
  • Indicator refresh and processing

P2

Security and indicators

Brings together information security views and the platform’s own authentication, permission and auditing mechanisms.

  • WAF and security event analysis
  • Threat intelligence
  • Vulnerability management
  • LDAP / Active Directory authentication
  • Multi-factor authentication (MFA) support
  • Access profiles and permissions
  • Auditing and traceability

P3

Platform and interactivity

Backend, APIs and interface that deliver indicators to decision makers.

  • Python backend and APIs
  • Modular architecture
  • Interactive dashboards
  • Cross-filtering across charts, indicators and tables
  • Scheduling and automation

P4

IT management and operations

Operational, managerial and executive views of infrastructure, licences and budget.

  • Executive views
  • Operational indicators
  • License management
  • Financial and budget tracking
04 /

Architecture

  1. Sources

    Security tools, IT operations systems and management records.

  2. Ingestion and transformation

    Python extraction and transformation pipelines, run on schedules.

  3. Analytical layer

    PostgreSQL with indicator-oriented modelling.

  4. Services

    Modular Python backend exposing APIs to the interface.

  5. Experience

    Interactive dashboards with cross-filtering and executive views.

Cross-cutting

Identity and access

Authentication with LDAP / Active Directory and MFA support, plus access profiles.

Auditing

Logging and traceability of actions on the platform.

Simplified, sanitised diagram of the platform layers. It does not show real topology, hosts, networks, vendors or flows.

05 /

Platform screens

Five areas recreated for this page, following the product’s reading logic: filters on top, indicators, charts and detail.

Demo with fictitious data

Budget screen with period filters, four KPIs, a monthly planned versus actual chart, a supplier ranking, variance by account and a recurring-cost matrix.
Planned against actual, suppliers and recurring costs that stopped posting. Filters and values are fictitious.

On a phone, swipe the screen sideways to see everything.

06 /

Cross-filtering in practice

Cross-filtering is one of Vortex’s features: selecting an element in one chart slices the other charts, the indicators and the tables. The demo below recreates that behaviour independently, with synthetic data and a generic security events scenario; it reproduces no screens or data from the original platform.

Synthetic data · Demo

Security events demo dashboard

Click a bar, column or table row to filter. Every chart, indicator and the table recalculate together. Click again to remove the filter.

Active filtersNo active filters.

Showing 640 of 640 synthetic events.

Events
640
Block rate
52.5%
Critical
49
Targets hit
5

Events by category

Events by severity

Events per day (simulated 14-day window)

Summary by target

TargetEventsCriticalBlocked
1811351.9%
159753.5%
1381549.3%
941158.5%
68350%

Light grey bars: unfiltered total.

Standalone demo built for this portfolio. Data is generated artificially in the browser, there is no connection to any system, and the dashboard does not reproduce the Vortex corporate environment.

07 /

Technologies

Backend and APIs
  • Python
Data and processing
  • PostgreSQL
  • SQL / PL/pgSQL
Frontend and visualisation
  • JavaScript
  • HTML
  • CSS
Infrastructure and authentication
  • Linux
  • LDAP / Active Directory

Back to projects