This repository contains a portfolio project showcasing SQL querying and Tableau visualization skills through the analysis of e-commerce data.
- Interactive Dashboard: here
- Screenshot:
The project evaluates whether ENIAC should partner with Magist to expand into the Brazilian market.
Key questions addressed include:
- Is Magist a suitable partner for high-end tech products?
- Are delivery times and reliability sufficient for ENIAC’s standards?
- Is Brazil a viable expansion market for ENIAC?
Main findings:
- Product fit: Magist has limited focus on tech (10% of sales), low average prices (€106 vs. ENIAC €540), and very few high-end products (<1%).
- Delivery performance: Average delivery time of 10–12.5 days (within average range for Brazil), with 24% of tech orders delayed — below ENIAC’s service standards.
- Market potential: Brazil shows strong e-commerce growth and demand for accessories, but low Apple penetration (<10%), high import taxes (~38%), and logistics risks.
Recommendation:
- Do not pursue a long-term partnership with Magist.
- If testing the Brazilian market:
- Use a short-term, limited contract focused on São Paulo region.
- Restrict to mid-priced accessories, not high-end tech.
- Explore alternative partners and markets with stronger Apple adoption and better logistics infrastructure.
- Created: September, 2025
- Duration: 5 days
- Purpose: Portfolio project inspired by real-world business cases; created to highlight data analysis, visualization, and business storytelling.
- Source: here
- Description: E-commerce sales data covering 25 months of transactions in Brazil.
- SQL environment (e.g., PostgreSQL, MySQL, or SQLite)
- Tableau Public or Tableau Desktop
- Clone the repository
git clone https://github.com/NadineJac/ecommerce-insights-sql-tableau.git cd ecommerce-insights-sql-tableau - Set up the database
- Load the provided dataset (here) into your SQL environment.
- Run the SQL script sql_ecommerce_insights.sql to create tables, clean, and query data.
- Explore the Tableau dashboard
- Open the workbook in /tableau.
- Or view the interactive version directly via the Tableau link