top of page

Monitoring E-Commerce Performance

Description

This project involved creating an interactive dashboard for e-commerce managers to monitor sales performance.

 

Using data extracted from the Shopify API via Coupler.io, this dashboard offers two key pages:

  • The first page provides a sales overview, featuring Pareto analysis to highlight the most impactful products, customers, discount coupons, and weeks.

  • The second page focuses on product analysis, displaying additional metrics such as sales by product category and vendor, profitability, return rates, and regional sales performance.

​

The dashboard also highlights product performance correlations, identifies underperforming products, and helps managers make data-driven decisions to optimize product offerings and focus on high-growth areas.

Tools Used

  • Power BI

  • Power Query

  • DAX

Machine Learning Algorithms

None

File Formats

  • API

Data Sources

Industry

E-Commerce

Key Business Questions Addressed

  • Which product categories and vendors are driving the most sales?

  • What is the overall profitability and return rate for different product groups?

  • Which states are generating the highest sales?

  • How do sales and profit performance correlate across different product groups?

  • Which products are performing poorly, and may require attention or discontinuation?

Author: Lucas Pereira Szupszynski (September/2024) 

bottom of page