This repository contains my submissions for the Data Analytics Super League (DASL) competition. I am proud to share that I secured the 3rd position in the overall standings. Throughout the competition, I tackled a series of data analytics challenges, demonstrating my skills in data manipulation, SQL querying, and data cleaning with Python.
Challenge 1: Cell Referencing Description: In this challenge, I worked on data referencing and manipulation, gaining insights from a dataset by performing calculations and analysis using various cell referencing techniques. Link: Question
Challenge 2: Detective SQL Description: In Challenge 2, I honed my SQL querying skills by solving complex data puzzles. The task involved writing SQL queries to extract valuable information from large datasets efficiently. Link: Question
Challenge 3: Food hub Orders Description: Challenge 3 required analyzing a dataset containing Foodhub orders. I processed the data, performed the statistical analysis, and derived meaningful patterns and trends related to the food delivery service. Link: Question
Challenge 4: Movie Time - Data Cleaning with Python Description: For this challenge, I was provided with the 'movies.csv' dataset and asked to clean it using Python. The cleaning process involved the following steps: Removed duplicate values from the 'movies' column. Cleaned the 'year' column to obtain the appropriate release year of the movies. Extracted the first genre from the 'genre' column. Cleaned the 'rating' column. Extracted the director's name and separated it into a different column. Separated the names of stars into individual columns. Cleaned the 'votes,' 'runtime,' and 'gross' columns. The final result was a cleaned version of the 'movies.csv' dataset, which is available as a cleaned CSV file in this repository. Link: Question
Challenge 5: Welcome to the Real World Description: Challenge 5 was designed to prepare participants for real-world data analysis scenarios. It involved reviewing and analyzing a variety of emails and data files. Link: Question
Participating in the DASL competition was an enriching experience that allowed me to showcase my data analytics skills and problem-solving abilities. I am grateful for the opportunity to learn from challenging projects and compete with talented data analysts from around the world.
Feel free to explore the respective project directories in this repository for more details on each challenge. If you have any questions or feedback, please don't hesitate to contact me.
Thank you for visiting my GitHub repository!