Pinned Repositories
AdvancedSQLPuzzles
Welcome to my GitHub repository. I hope you enjoy solving these puzzles as much as I have enjoyed creating them.
air-quality-index-tableau-project
airflow
Apache Airflow - A platform to programmatically author, schedule, and monitor workflows
Classification-Analysis-on-NYPD-Crime-Arrest-Data
This is a breakdown of every arrest made by the NYPD in New York City this year. The Office of Management Analysis and Planning manually extracts and reviews this data every quarter. Each record represents an arrest made by the NYPD in NYC and contains information about the type of crime, the location, and the time of enforcement.
Data-Analysis-Vizualizations
Big Data Hadoop Project using Hive, HBase, HDFS, MapReduce & Tableau on Elections Dataset
Database-Management-Employee-Rating-Application
Developed and maintained a Relational Database of a hypothethical company and incorporated all Database Management Processes and Practices. (Python, SQL, MongoDB)
Keyword-Network-Analysis-Word-Frequency-Analysis
Keyword network analysis and word frequency analysis of Twitter data of Elon Musk for 2010-2021. Also used Zipf’s Law to draw log-log plots for checking word frequency and rank and plotted the bigram network for each year.
SARS-CoV-2-AWS-Data-Mining-and-Insights
This project focuses on analyzing COVID-19 data trends and risk factors using AWS and Python. Workflow: Data Collection -> S3 Storage -> ETL with Glue for preprocessing -> Data querying with Athena -> Redshift for warehousing -> Insightful patterns and trends analysis.
system-design-primer
Learn how to design large-scale systems. Prep for the system design interview. Includes Anki flashcards.
Youtube-Analysis-AWS
This project aims to securely manage, streamline, and perform analysis on the structured and semi-structured YouTube videos data based on the video categories and the trending metrics. Brief : Data -> Multiple buckets s3 Aws -> Data Preprocessing ETL (Lambda Function with s3 trigger) -> ETL to join -> Analysis Bucket -> QuickSight Data Analysis AWS
mahanta-mayur's Repositories
mahanta-mayur/Youtube-Analysis-AWS
This project aims to securely manage, streamline, and perform analysis on the structured and semi-structured YouTube videos data based on the video categories and the trending metrics. Brief : Data -> Multiple buckets s3 Aws -> Data Preprocessing ETL (Lambda Function with s3 trigger) -> ETL to join -> Analysis Bucket -> QuickSight Data Analysis AWS
mahanta-mayur/Database-Management-Employee-Rating-Application
Developed and maintained a Relational Database of a hypothethical company and incorporated all Database Management Processes and Practices. (Python, SQL, MongoDB)
mahanta-mayur/airflow
Apache Airflow - A platform to programmatically author, schedule, and monitor workflows
mahanta-mayur/Classification-Analysis-on-NYPD-Crime-Arrest-Data
This is a breakdown of every arrest made by the NYPD in New York City this year. The Office of Management Analysis and Planning manually extracts and reviews this data every quarter. Each record represents an arrest made by the NYPD in NYC and contains information about the type of crime, the location, and the time of enforcement.
mahanta-mayur/Data-Analysis-Vizualizations
Big Data Hadoop Project using Hive, HBase, HDFS, MapReduce & Tableau on Elections Dataset
mahanta-mayur/system-design-primer
Learn how to design large-scale systems. Prep for the system design interview. Includes Anki flashcards.
mahanta-mayur/AdvancedSQLPuzzles
Welcome to my GitHub repository. I hope you enjoy solving these puzzles as much as I have enjoyed creating them.
mahanta-mayur/air-quality-index-tableau-project
mahanta-mayur/Keyword-Network-Analysis-Word-Frequency-Analysis
Keyword network analysis and word frequency analysis of Twitter data of Elon Musk for 2010-2021. Also used Zipf’s Law to draw log-log plots for checking word frequency and rank and plotted the bigram network for each year.
mahanta-mayur/SARS-CoV-2-AWS-Data-Mining-and-Insights
This project focuses on analyzing COVID-19 data trends and risk factors using AWS and Python. Workflow: Data Collection -> S3 Storage -> ETL with Glue for preprocessing -> Data querying with Athena -> Redshift for warehousing -> Insightful patterns and trends analysis.
mahanta-mayur/azure-olympic-data-engineering-project
mahanta-mayur/azure-quickstart-templates
Azure Quickstart Templates
mahanta-mayur/bike-sharing-analysis-tableau-project
mahanta-mayur/Clustering-Method-Implementation
Applied different clustering methods to synthetic and real-world data and validated using external and internal validation techniques.
mahanta-mayur/CompViz
Computer Visualization Coursework
mahanta-mayur/mahanta-mayur
Introduction of myself for my GitHub Profile
mahanta-mayur/Online-Merchandise-Exchange
A Web-based application for an Online Auction System to faciliate the bidding and auctioning process developed using JavaScript, JSP, HTML3 and CSS5
mahanta-mayur/Portfolio-Mayur
My personal portfolio
mahanta-mayur/predictivemaintenance
Utilized ML to predict maintenance using a UCI synthetic dataset with 10K records, 14 features (e.g., Air Temp, Torque). Preprocessed data for nulls, outliers, and feature selection.
mahanta-mayur/professional-programming
A collection of learning resources for curious software engineers
mahanta-mayur/react-weather-app
A simple Weather app in React JS, using the Open Weather Map API to make calls to a restful api to return the current weather data. This also uses the Modern Javascript Fetch AP along with React hooks and conditonals.
mahanta-mayur/Resource-Management-System
Resource Management System which acted as a platform where all important personal details of an employee is stored and managed in a secure way. Technologies used - Java, MySQL, Spring-boot, JPA, CSS3 and HTML5
mahanta-mayur/spark
Apache Spark - A unified analytics engine for large-scale data processing
mahanta-mayur/Spotify-Data-Engineering-and-analysis-using-AWS
This project delves into the rich dataset of Spotify 2023, utilizing AWS and Python for data engineering. Workflow: Data Cleaning -> S3 Staging -> ETL with Glue for Transformation -> Data Analysis with Athena -> Visualization with QuickSight -> Uncovering Music Streaming Insights.
mahanta-mayur/system-design-101
Explain complex systems using visuals and simple terms. Help you prepare for system design interviews.
mahanta-mayur/three.js
An amazing JavaScript 3D Library for 3D Models, VR, AR Applications. Gonna be working on this a lot! It's super fun!
mahanta-mayur/threejsmayurportfolio
Personal portfolio showcasing my work and projects using Three.js, Tailwind CSS, React, HTML, and CSS. Explore my interactive portfolio, powered by modern web technologies.
mahanta-mayur/Time-Series-Feature-Extraction-for-Human-Body-Monitoring
Visibility Graph Network Computations (Applied HVG and NVG on Human Body Part Movement data and generated Scatter Plots for those computed factors)
mahanta-mayur/Trend-Analysis-Web-Traffic-on-Fashion-Lifestyle-E-Commerce-Platform
mahanta-mayur/VRGunShootingGame_MetaQuest2
Loved this repository! Hoping to collaborate and add more features