Home / Services / Data analytics and Power BI
Data analytics and Power BI

Turn administrative, financial, and operational information into reliable indicators.

I organize, model, and visualize information to reduce manual report rebuilding and make it easier to monitor payments, budgets, balances, operations, and other relevant indicators.

Services for companies in Medellín and Colombia. I support remote projects and, depending on scope, needs that require on-site support.

When analytics creates value

  • Each closing cycle or meeting requires consolidating multiple Excel files and exports again.
  • Financial or operational indicators depend on rules that are not documented or automated.
  • Data exists in ERP systems, files, and applications, but there is no consistent view for monitoring and decisions.

How I approach it

  • Define business questions, rules, and relevant indicators.
  • Clean, integrate, and model administrative, financial, or operational sources.
  • Build measures, dashboards, and data-quality controls.
  • Automate refresh and document the model when appropriate.
Technology according to the process

The dashboard is the final layer: sources, rules, and controls are connected first so each indicator is reproducible and reliable.

Power BI · Power Query · SQL · Excel · Python · KPIs

The next step is to understand the current process.

This capability can be combined with integration, automation and data analysis within the same project. I review your process first; then we agree on the components it needs and the scope of the solution.