Unicorn_Maven

MySQL Operations on Unicorn Startups/Companies dataset sourced from Maven Analytics.
Dataset: https://mavenanalytics.io/data-playground?page=2&pageSize=5

Objectives

Every analytics project involves 3 primitive steps - Data Cleaning, Data Preparation and Data Processing. Detailed below are the phases with what they entail.

Data Cleaning

• Handling NULLs.
• Handling duplicates.
• Handling typos and trivial mistakes.

Data Preparation

• Adding new columns.
• Inserting new and corrected values.
• Handling produced abnormalities.

Data Analysis

• Database exploration.
• Understanding distribution of values (Univariate Analysis).
• Comparing multiple variables (Multivariate Analysis).

Key-insights to be derived were as follows

• Which unicorn companies have had the biggest return on investment?
• How long does it usually take for a company to become a unicorn? Has it always been this way?
• Which countries have the most unicorns? Are there any cities that appear to be industry hubs?
• Which investors have funded the most unicorns?