π Buenos Aires, Argentina
π‘ Turning raw data into decisions that actually matter
I'm a Data Analyst with a background in Business Administration and over 3 years of hands-on experience at Brandteam Group, where I work at the intersection of finance, operations, and technology.
I'm passionate about the full data journey β optimizing processes to cut reporting time, automating repetitive tasks so teams can focus on what matters, and finding the patterns hidden in the noise that lead to better decisions.
I've designed and implemented 15+ Power BI dashboards that reduced reporting time by 60% (from 8 hours to 3 hours per week), built SQL-based data pipelines for transactional systems, and developed Python automation scripts for report generation and file processing.
My approach is simple: understand the business problem first, then build the most elegant analytical solution to solve it.
"Without data, you're just another person with an opinion." β W. Edwards Deming
Data & Analytics
Automation & DevOps
Libraries
Data Analyst & IT Analyst β Brandteam Group Β· Buenos Aires Β· June 2023 β Present
As part of the internal IT team, I bridge the gap between business needs and data analytics, delivering solutions that optimize processes and improve decision-making across multiple business units within the group.
Key contributions:
- Implementation and support of ERP and CRM systems, ensuring operational continuity and improvements in administrative and commercial processes
- Development of Power BI dashboards and automated reports using SQL and Excel, enabling real-time visualization of financial, sales, and operational KPIs
- Design of ETL processes and data modeling in a data warehouse, facilitating historical and predictive analysis
- Coordination and training of end users on management tools, driving digital adoption across different areas
- Leadership of the support ticket team using FreshDesk, improving incident resolution efficiency
Impact: Reduced report generation times, improved visibility of commercial and operational results, and supported strategic decision-making across multiple business units.
Bachelor's Degree in Business Administration
Universidad de Ciencias Empresariales y Sociales (UCES) Β· Buenos Aires
Diploma in Agile Methodologies and Frameworks
Universidad TecnolΓ³gica Nacional (UTN) Β· Buenos Aires
Python Pandas NumPy Plotly Streamlit Jupyter
End-to-end EDA and interactive dashboard for the Brazilian Olist marketplace (~100K orders, 2016β2018). Six business insights on growth, customer retention (1.03 orders per customer), geographic concentration (62% from top 3 states), delivery impact on CSAT (2.1Γ rating gap), and seller Pareto (544 of 3,095 sellers generate 80% of GMV).
π Live Dashboard Β· π» Repository Β· π Notebook
SQL Server Power Query DAX Power BI
Financial and inventory KPIs in a single analytical model: billing, collections, customer debt aging, stock control and inventory valuation. Built on a star schema with 8 fact tables.
π» Repository
SQL Server DAX Power BI
Power BI dashboard for commercial performance analysis (2021β2025). Interactive analysis of sales by client, salesperson, brand and region, built on real anonymized sales data spanning 5 years.
π» Repository
T-SQL SQL Server ETL Batch Processing
Transaction-safe SQL pipeline for ERP price synchronization. Automated stored procedure that recalculates pricing, taxes and discounts for pending sales orders, preventing billing errors and ensuring financial consistency.
π» Repository
Books that have shaped the way I think about data and analytics:
Data & Analytics
- π Data Science from Scratch β Joel Grus β A great hands-on introduction to data science fundamentals using Python. Perfect for understanding what's really happening under the hood.
- π Learning Microsoft Power BI β A practical guide that takes you from basics to building real-world dashboards. Highly recommended for anyone getting into BI.
On my radar
- π Designing Data-Intensive Applications β Martin Kleppmann β The bible for understanding how data systems work at scale.
- π The Alignment Problem β Brian Christian β A fascinating and accessible look at the challenges of building AI systems that do what we actually want.
Email: lannoowa@gmail.com
LinkedIn: linkedin.com/in/agustin-lannoo
Open to collaboration and opportunities in data analytics, business intelligence and data engineering.