Skip to content

Evaluate Magist as a strategic partner for Eniac's Brazilian expansion. Use SQL to analyze growth, tech accessory sales potential, delivery times, and customer satisfaction in Magist's database.

Notifications You must be signed in to change notification settings

Cintia0528/Data_Analytics_and_Visualization-SQL_Tableau

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 

Repository files navigation

Data-Analysis-with-SQL

Task

To evaluate Magist as a partner for strategic expansion to Brazil based on their database with the help of SQL.

Overview

Eniac is exploring an expansion to the Brazilian market with the help of a local third-party company, called Magist. We get a limited glimpse of Magist's database.

Context

Eniac is an online marketplace specializing in Apple-compatible accessories. It was founded ten years ago in Spain and has since grown and expanded to other neighboring countries.

In addition to offering a wide catalog of products at competitive prices, Eniac provides friendly and professional tech support and consultation to its customers.

Challenge:

How to scale up to a major business player without losing the human side of the business, which is Eniac's emblem?

Approach

Evaluate Magist on the following criteria:

  1. As a standalone company - is the company growing?
  2. As a partner for selling high-quality tech accessories
  3. Delivery times
  4. Customer satisfaction

Deliverables

5 minute PowerPoint presentation found here to the Board of Directors, that summarizes the findings and suggests a course of action. SQL code is found here.

SQL Files

  1. Exploration of the database
  2. Business Questions
  3. Further exploration of the database (ex.: irregularities)

Skills & Tools

  1. SQL Proficiency
  2. Data Extraction and Data Analysis
  3. Data Visualization
  4. Market Research

About

Evaluate Magist as a strategic partner for Eniac's Brazilian expansion. Use SQL to analyze growth, tech accessory sales potential, delivery times, and customer satisfaction in Magist's database.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published