Skip to content
View shantanurathore's full-sized avatar
🌎
🌎
8 followers · 13 following

Block or report shantanurathore

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Please don't include any personal information such as legal names or email addresses. Maximum 100 characters, markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
shantanurathore/README.md

Hi 👋

My name is Shantanu Rathore. I also go by Shan. Welcome to my GitHub profile page. I share my learnings here. I am a Senior Data Analyst by profession. My last role was with Ideo as their Business Intelligence Lead. I started my journey in Software Engineering. While pursuing an MBA I discovered the field of Data Analytics/Business Intelligence and how impactful it is. My roles in different companies have been at the intersection of Data Engineering, Data Analytics and Data Science. In today's fast changing world of data analytics, it is important to have a significant knowledge base in all these areas no matter what our roles or titles say.

Currently working on

🔭 Bulding end-to-end ETL flow with a focus on Data Quality
🔭 Bulding end-to-end Data Apps to solve core Data Science or Analytics problems
🔭 Exploring HuggingFace and building simple applications to solve complex problems
🔭 Implementing DBT on my local machine for some data transformation automations
🔭 Deepdiving into Machine Learning concepts
🔭 The occasional Data Visualization project

Tools💻: Tableau, Looker Studio, Power BI, MySQL, PostGRES Server, SQL Server, AWS (RDS), AWS S3, AWS Lambda, AWS Redshift

Languages⚡: SQL, Python

Skill Set🦾: Data Analysis, Dashboards, Data Wrangling, Data Cleaning, Data Modelling, ETL, ELT, Building Data Pipelines, Data Vizualization, Forecasting, A/B testing, Linear Regression (simple, logistic), Logistic Regression, Classification

Certifications
🎓 Google Certified Advanced Data Analyst(ongoing)
🎓 Tableau Desktop Specialist
🎓 Azure Fundamentals AZ-900
🎓 Springboard Certified Data Scientist



List of Projects List of Blogs
A web application which analyses A/B testing dataset

Predictive Analytics for Customer Behavior
- Tableau: Practical implementation of filter actions and dynamic parameters
Data Analyst's Toolbox
- Tableau: Practical implementation of Visualization in tooltips

- EDA Case Study: Missing data can also tell a story: A Case Study
- Visual Analysis of Waze user data
  • Presentation: Visual Analysis

- ECommerce Sales Data: Predicting total spend (Multiple Parts)
  • [Part 1: Exploratory Data Analysis and Data Cleaning]
- Predicting House Prices using Boston Housing Data
  • Predicting house prices (Jupyter Notebook)

- A/B Testing guide: Running an A/B test on an Ad Dataset

- Payment Default prediction on a bank accounts dataset

⏱️ Time Series Analysis
- Bike Sharing Dataset
  • Jupyter Notebook
  • Presentation

Blog: When will a Cycle Station run out of bikes?
🛠️ Data Transformation projects
- Local implementation of dbt: Data Transformations on an eCommerce Dataset

Coming Soon!

Pinned Loading

  1. AB_Testing_guide AB_Testing_guide Public

    This is a self made guide for basic AB testing

  2. dbt_ecommerce_project dbt_ecommerce_project Public

    This repository has been created to understand, learn and implement dbt.

    Python

  3. Data_Cleaning_Case_Study Data_Cleaning_Case_Study Public

    This repository contains the markdown of a Jupyter notebook which explores an interesting data cleaning case study

  4. TimeSeries-Analysis-on-bike-sharing-data TimeSeries-Analysis-on-bike-sharing-data Public

    Capstone 2: Time Series Analysis using PySpark

    Jupyter Notebook 1

  5. Payment-Default-Prediction Payment-Default-Prediction Public

    Files for SpringBoard Capstone 1 project

    Jupyter Notebook

  6. ad-testing-dashboard ad-testing-dashboard Public

    This is the code for a webapp I developed to conduct A/B testing on a simple datasets. The user of the dashboard can upload a file with A/B testing data and the wwebapp will do basic data validatio…

    Python