● Created Tables: Successfully created tables by importing .csv data files into a database named Superstores using MySQL Workbench.
● Understanding the Data: Provided a clear description of the dataset and identified all Primary Keys and Foreign Keys for the dataset, noting any missing keys.
● Basic Querying: Wrote and executed queries to extract basic information from the database, such as customer names and segments, order IDs and dates, and total/average sales etc.
● Advanced Querying: Demonstrated proficiency in more complex SQL queries, such as finding maximum and minimum sales, grouping customers by region and product category, and identifying specific customers and their purchasing behaviors.
● Sales Analysis: Conducted a detailed analysis of the sales data in the database, including identifying the least profitable product subcategory and analyzing its shipment patterns across different regions.
PrabhanshuBA
commented
1 year ago
● Created Tables: Successfully created tables by importing .csv data files into a database named Superstores using MySQL Workbench. ● Understanding the Data: Provided a clear description of the dataset and identified all Primary Keys and Foreign Keys for the dataset, noting any missing keys. ● Basic Querying: Wrote and executed queries to extract basic information from the database, such as customer names and segments, order IDs and dates, and total/average sales etc. ● Advanced Querying: Demonstrated proficiency in more complex SQL queries, such as finding maximum and minimum sales, grouping customers by region and product category, and identifying specific customers and their purchasing behaviors. ● Sales Analysis: Conducted a detailed analysis of the sales data in the database, including identifying the least profitable product subcategory and analyzing its shipment patterns across different regions.