Stefano Meloccaro

Business Intelligence Engineer | Data Analyst

About Me

Hi! I'm Stefano, and I'm a Business Intelligence Engineer 🚀I specialize in designing data-driven solutions and building powerful reports and dashboards that empower companies to make better decisions.I'm passionate about data automation and optimization, helping businesses unlock actionable insights that drive efficiency and growth.⚡ I automate reporting workflows and streamline data processes to save time and improve accuracy.With years of experience in SQL, Power BI, and Tableau, I craft scalable analytics solutions that help organizations stay ahead in a data-driven world.

Skills

Excel | Tableau | PowerBI | SQL | Python

  • SQL Server / RedShift / Teradata

  • Tableau, PowerBI, QuickSight

  • Expert Excel – DAX, Power Pivot

  • Advanced Data Visualization

  • Python - Machine Learning (Uni)

  • Advanced Data Analysis

Trusted by Leading Companies

Featured Projects

Excel | Power BI
eCommerce Sales & User Analytics Dashboard

Automated the analysis of sales, orders, and user activity by developing a Power BI dashboard powered by an Excel file.

eCommerce - Sales & User Analytics Dashboard

This dashboard was created to provide users with the most relevant high-level insights into the eCommerce business, focusing on the main business departments. At the same time, great care was taken in crafting a user-friendly experience, which—as we know—plays a crucial role in whether or not a dashboard is adopted by its audience.🔍 Key insights highlighted:
1. Sales broken down by product, country, and month-year
2. Order count segmented by payment and shipping method
3. Executive Summary KPIs including:
- Total Sales
- Total Quantity Ordered
- Active Users
- Orders Count
- Average Order Value🧠 User Experience (UX) Highlights:
To maximize usability and user engagement, the dashboard includes a variety of interactive elements:
- A collapsible panel for filters
- A clear filters button to reset all applied filters
- Buttons to switch between different visuals
- Info buttons that provide additional details on each chart
- A help button that guides new users, explaining what each button does and how to interact with the dashboard