Step 3: SQL Data Analysis

Goal

Use SQL queries to extract insights from a dataset. The project 3 is about Creating insights using SQL Queries (Clauses like: Select, From, Where, Group by and Order By) ( Formulas like: Sum, Count and Avg) to extract Insights

Key Requirements

• Write SELECT queries

• Use WHERE, ORDER BY, GROUP BY

• Perform aggregations (COUNT, SUM, AVG)

  Step by Step Procedures

  • I Created the Database and i named it Decodelabs_Internship.
  • I changed the Excel Xlxs to CSV (Comma Delimited).
  • I imported my flat file to the database I created.
  • Columns: 14
  • Rows: 1200

Key Insights

• Total revenue is $1.26M across 1,200 orders Chair and Printer are the top revenue-generating products
• Neary half of orders are Cancelled or Returned(Out of 1,200 orders, 497 (41.4%) were either Cancelled or Returned, which is significantly high and indicates potential issues in the business) VInsight:The Business owner should Investigate which products have the highest cancellation and return rates, and review the customer feedback for those orders to identify root causes of the Cancellation and Returned Products.
• Instagram drives the most revenue of all referral sources
• Online is the most popular payment method.

Experience

I encountered a lot of bugs while coding but was determined to handle it and boom! I did it after several trials. A Special thanks to Decodelabs for providing and giving me such privilege to hands-on practice. I'm ever willing to handle a real dataset and create actionable insights from them. I'm learning and growing by the day.

Eager for the project 4......

Files in this Repo

• select_queries.sql – Basic SELECT queries
• group_by_queries.sql – Grouping queries
• aggregations.sql – COUNT, SUM, AVG queries
• dataset.csv – Dataset used
• query_outputs.csv – Results

Tools Used

• SQL, MySQL.