Scripts for automating data extraction, transformation, and loading (ETL) tasks in Microsoft Excel and Power BI. These scripts simplify data manipulation and enhance productivity and collaboration.

Informe de denuncias ante Defensa y Protección del Consumidor en la ciudad de Buenos Aires en el periodo de 2019 a 2020

Data Analytics Capstone Projects

PowerBI learnings include all cases of modules I have practiced in terms of PowerBI

Automates the building of Windows Print Queues which conform to a standard by obtaining input from CLI

Análisis de utilidad y márgenes de la empresa Appol en el periodo de 2019 a 2021

convert PowerSHell Get-ChildItem (dir) output to table with m-code

Replace data of main table from another table (exclude null cells) in Power Query

Histórico de Ticket de la empresa Tractchun y Ranking con el desempeño de sus agentes

The region-based sales comparison analyzes sales performance across different regions. It identifies trends, top-performing regions, and areas needing improvement by comparing metrics like revenue, growth rate, and product demand. This analysis helps optimize sales strategies and resource allocation for better performance.

Desarrollo de un sistema de análisis y optimización de rutas de transporte intercampus utilizando Power BI y Python, con el fin de mejorar la eficiencia y la satisfacción del usuario en el servicio de transporte entre campus de la universidad ITM

This project will be analysing historical data accquired from FBREF it will be accquire sports historical data on my favorite football team ARSENAL FC

The aim of this project was to built an interactive dashboard in Power BI with a store's sales dataset. The dashboard is accessible through the link provided in Readme file.

Analyzed Superstore Sales Data to uncover trends, optimize sales, and improve profitability. Explored customer segments, regional performance, and product categories using Python and Power BI. Delivered actionable insights to enhance revenue, streamline inventory, and refine marketing strategies, driving data-informed decision-making.

All Excel and other files for practice

Using yfinance, we grab minute-by-minute BTC-USD data, dump it into PostgreSQL, and link Excel via ODBC for quick analysis!

Convert quantitative data into single unit of measure in Power Query

Herramientas para el manejo de datos

Finds and replaces values ​​in one table based on values ​​in another table.

The insights derived from this project provide valuable input for HR departments and company executives to foster an inclusive workplace, improve talent management strategies, and ensure equitable opportunities for all employees.