A case study done using Advanced Excel to perform Exploratory Data Analysis on the given dataset.
Exploratory Data Analysis done on a Supply Chain dataset of a company using Advanced SQL queries.
The data has been thoroughly analysed using various Advanced SQL functions and Queries such as CTEs(Common Table Expressions) , Subqueries,Stored Procedures etc.
The use of Lead,Lag Window Functions have been demonstrated through this case study.
The concepts of Moving Averages and Running Total have been used to get everyday's Shipping summaries.
Schema Creation Done. Performed the basic CRUD operations of an RDBMS. Used the various tables in the Company Dataset to perform the Analytics. Used Joins to compare and analyse the data across various tables.
A simple case study done on the Commodity Dataset of an E-Commerce company
The main purpose of performing this analysis was to understand the usage of table connections (JOINs), primary keys and foreign keys, working with multiple tables at the same time. To better understand concepts of Advanced SQL , window functions like row_number(),over() etc. Understand the working of rolling averages and the association of Window Functions with them.
A case study done using Python libraries for Data Science(seaborn, matplotlib,pandas,numpy) to perform Exploratory Data Analysis on the given dataset