Matias Rossi | Data Analyst
Professional Projects
💼 Welcome to My Professional Portfolio!
This folder highlights my expertise in data analysis through projects that showcase my ability to work with diverse tools and techniques. From building insightful SQL queries to crafting dynamic dashboards in Power BI and Tableau, and creating detailed Excel reports, these works reflect my ability to transform data into meaningful insights for decision-making.
01
Optimizing MCO’s Holiday Operations: A Data-Driven Analysis of December 2024 Flight Traffic 📊✈️🎉
Dive into my exciting journey analyzing domestic flight arrivals at Orlando International Airport (MCO) during the 2024 holiday rush, fueled by Disney World and Universal Resorts magic! 🎢🌴 I transformed raw data from the Bureau of Transportation Statistics into actionable insights using SQL queries in SSMS, interactive Tableau visualizations, and a vibrant Canva report. Discover how I filtered flights, designed a relational database, and uncovered trends like peak travel days and airline performance to optimize MCO’s operations. 📈🎉
02
📊 Payment & Client Behavior Dashboard for Force S&C Fitness Center
This cloud-based analytics project was built to optimize payment tracking and client behavior analysis for my own fitness business, combining Google Sheets, Looker Studio, and key concepts from the Google Cloud Data Analytics certification. By turning raw payment data into actionable insights, I was able to monitor monthly revenue, gender-based attendance patterns, seasonal payment trends, and customer engagement. This real-world project reflects my ability to apply Business Intelligence and cloud tools to drive operational decisions and improve business performance.
03
Bike Retail Company | SQL Analysis & Data Exploration
This project uses SQL and Looker Studio to analyze three years of sales data (2016-2018) from a U.S. bike retailer. In Part 1, I focused on data exploration, cleaning, and business intelligence analysis, uncovering trends in revenue, customer behavior, store performance, and product sales. In Part 2, I translated these insights into data-driven business recommendations, identifying key areas for improvement in customer retention, inventory management, and overall profitability.
04
Electronic Retailer - Sales Analysis
This Power BI dashboard provides a comprehensive view of business performance, tailored for CEOs and high-level managers. It is organized into four key sections: Global Sales, Products, Stores, and Customers.
With its interactive features and dynamic filtering capabilities, it supports efficient decision-making and strategic planning by delivering clear, actionable insights.
05
Sales Analysis Dashboard for NYC Coffee Shop
This project marks my first step into data analytics, transforming raw sales data from three New York City coffee shop branches into an interactive Excel dashboard. It highlights key insights on branch performance, product sales, and daily trends, showcasing my ability to clean data, apply advanced Excel functions, and deliver actionable, business-ready insights.