Skip to content
View Rohitkr2002's full-sized avatar
๐ŸŽฏ
Focusing
๐ŸŽฏ
Focusing

Block or report Rohitkr2002

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.

Maximum 250 characters. Please donโ€™t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this userโ€™s behavior. Learn more about reporting abuse.

Report abuse
Rohitkr2002/README.md

ย  ย  ย 

๐Ÿง  About Me

โ•”โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•—
โ•‘  ๐Ÿ‘ค  Rohit Kumar Singh                                                   โ•‘
โ•‘  ๐ŸŽฏ  Data Analyst ยท Data Educator ยท Newsletter Creator                     โ•‘
โ•‘  ๐Ÿ“  Bengaluru, India ๐Ÿ‡ฎ๐Ÿ‡ณ                                                โ•‘
โ•‘  ๐Ÿข  Data Analyst Intern @ ElevanceSkills  |  Ex-Intern @ Bluestock     โ•‘
โ•‘  ๐Ÿ“ฐ  Founder โ€” DATA DECODED Newsletter (LinkedIn)                       โ•‘
โ•‘  ๐Ÿ“Š  2,000,000+ Impressions  ยท  1,000,000+ Records Analysed             โ•‘
โ•‘  ๐ŸŸข  Actively Seeking Full-Time Data Analyst Roles                      โ•‘
โ•šโ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•

I'm a Data Analyst and Educator based in Bengaluru, building at the intersection of data skills and data education.

With real internship experience at ElevanceSkills and Bluestock, I've analysed over a million records, built dashboards, and solved business problems with SQL, Python, and Excel. Outside of work, I run DATA DECODED โ€” a LinkedIn newsletter teaching the exact skills that get you hired as a data analyst.

My content has crossed 2 million impressions because I don't just explain concepts โ€” I make them impossible to forget.

๐Ÿ’œ "Data is everywhere. Clarity is rare. I build the bridge."


๐Ÿ“Š Real Impact โ€” Numbers That Matter

๐Ÿ† What ๐Ÿ“ˆ How Much
๐Ÿง  LinkedIn Impressions 2,000,000+
๐Ÿ“‰ Records Analysed (Real Projects) 1,000,000+
๐Ÿข Professional Experience ElevanceSkills + Bluestock
๐Ÿ“ฐ Newsletter Issues Published DATA DECODED โ€” Live & Growing
๐Ÿ’ป GitHub Projects Built 6+ End-to-End Projects
๐Ÿ“š Content Series Running SQL ยท Excel ยท Python (Ongoing)
๐ŸŽฏ Interview Topics Covered Window Functions, CTEs, JOINs, XLOOKUP & more

๐Ÿ’ผ Work Experience

๐Ÿข ElevanceSkills โ€” Data Analyst Intern (Current)

  • Performing data cleaning, transformation, and exploratory data analysis
  • Building SQL queries for business reporting and data extraction
  • Supporting analytics workflows with Python (Pandas) and Excel

๐Ÿข Bluestock โ€” Intern (Previous)

  • Worked on real business datasets and reporting tasks
  • Gained hands-on experience with data pipelines and dashboards
  • Contributed to team projects involving data visualization

๐Ÿ› ๏ธ Technical Arsenal

๐Ÿ“Š Data & Analytics

Python SQL Excel Pandas NumPy

๐Ÿ“‰ Visualization & BI

Power BI Matplotlib Seaborn

๐Ÿ—„๏ธ Databases

MySQL PostgreSQL SQLite

๐ŸŒ Web & Dev

Next.js TypeScript Tailwind CSS JavaScript

โš™๏ธ Tools & Workflow

Git GitHub VS Code Jupyter


๐Ÿ“ฐ DATA DECODED โ€” My Newsletter

โ•”โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•—
โ•‘      ๐Ÿ“ฐ   D A T A   D E C O D E D   โ€”   by Rohit Kumar Singh        โ•‘
โ•‘   " One concept. One tool. One step closer to data mastery. "        โ•‘
โ•šโ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•โ•

Subscribe on LinkedIn

DATA DECODED is my weekly LinkedIn newsletter for aspiring data analysts, working professionals, and students โ€” covering the exact tools and concepts that get you hired and keep you sharp on the job.

๐Ÿ“Œ Series ๐Ÿ” What's Inside
๐Ÿ—„๏ธ SQL Series Subqueries, Window Functions, CTEs, JOINs, Optimization
๐Ÿ“Š Excel Series VLOOKUP vs XLOOKUP, Pivot Tables, Power Query, Dashboards
๐Ÿ Python Series Pandas, Data Cleaning, EDA, Automation Scripts
๐ŸŽฏ Interview Prep Real DA interview questions, broken down simply
๐Ÿš€ Career Tips How to break into Data Analytics from scratch

๐ŸŸฃ Issue #01 Live: Excel Series โ€” VLOOKUP vs XLOOKUP: The Complete Comparison


๐Ÿ’ป Who I Am โ€” In Code

class RohitKumarSingh:

    def __init__(self):
        self.name        = "Rohit Kumar Singh"
        self.role        = "Data Analyst | Data Educator | Newsletter Creator"
        self.location    = "Bengaluru, India ๐Ÿ‡ฎ๐Ÿ‡ณ"
        self.newsletter  = "DATA DECODED"
        self.tagline     = "One concept. One tool. One step closer to data mastery."

        self.experience = {
            "current"  : "Data Analyst Intern @ ElevanceSkills",
            "previous" : "Intern @ Bluestock",
        }

        self.impact = {
            "linkedin_impressions" : "2,000,000+",
            "records_analysed"     : "1,000,000+",
            "newsletter"           : "DATA DECODED โ€” weekly issues on LinkedIn",
            "github_projects"      : "6+ end-to-end projects",
        }

        self.what_i_teach = [
            "SQL โ€” Subqueries, Window Functions, CTEs, JOINs",
            "Excel โ€” XLOOKUP, Pivot Tables, Power Query",
            "Python โ€” Pandas, EDA, Automation",
            "Data Storytelling & Dashboard Design",
            "How to break into Data Analytics",
        ]

        self.currently_building = {
            "website"    : "Personal brand site โ€” Next.js + TypeScript + Tailwind CSS",
            "cms"        : "Sanity CMS + Stripe/Razorpay for future courses",
            "content"    : "21-day LinkedIn content strategy rollout",
            "newsletter" : "DATA DECODED weekly issues โ€” SQL, Excel, Python",
        }

        self.open_to = [
            "Full-Time Data Analyst Roles ๐Ÿ“Š",
            "Newsletter & Education Collaborations โœ๏ธ",
            "Freelance Analytics Projects ๐Ÿ’ผ",
        ]

    def philosophy(self):
        return "Simplify the complex. Teach what you learn. Build in public."

    def fun_fact(self):
        return "I turned confusing data concepts into content seen by 2M+ people. ๐Ÿš€"

    def current_mission(self):
        return "Turning data skills into a career AND a brand โ€” simultaneously."

๐Ÿš€ Featured Projects

๐Ÿท๏ธ Project ๐Ÿ“ What It Does โš™๏ธ Stack
๐Ÿค– Naukri AI Agent Automates job search & application workflows on Naukri.com JavaScript, AI Automation
๐Ÿฉธ Blood Bank System Full healthcare DB management โ€” records, donors, blood stock Python, SQL, Tkinter
๐Ÿ“— Contact Book App Feature-rich contact manager with search & DB integration Python, Tkinter, SQLite
๐Ÿด Restaurant Ordering Complete menu, cart & order management GUI Python, GUI, Database
๐ŸŽ“ Grade Management Student performance tracker with analytics Python, Analytics
๐ŸŒ Portfolio Website Personal portfolio โ€” projects, skills, career goals HTML, CSS, JS

๐Ÿ“ˆ GitHub Stats

ย 


๐Ÿ† Achievements & Milestones

2M Impressions 1M Records

ElevanceSkills Bluestock Newsletter

SQL Python Power BI Excel

Projects Open to Work


๐ŸŒฑ Currently Learning

๐Ÿ“Š Data Skills:
  - Advanced SQL: Window Functions, CTEs, Query Optimization
  - Python: Pandas pipelines, EDA workflows, automation
  - Excel: Power Query, dynamic dashboards, advanced formulas
  - Power BI: DAX, data modelling, storytelling with visuals

๐ŸŒ Building:
  - Personal brand website: Next.js + TypeScript + Tailwind CSS
  - Sanity CMS backend for newsletter + course infrastructure
  - Stripe / Razorpay integration for future course monetization

โœ๏ธ Content & Teaching:
  - DATA DECODED newsletter โ€” weekly deep-dives
  - LinkedIn 21-day content strategy rollout
  - SQL & Excel series โ€” structured guides for beginners

๐ŸŽฏ Goals for 2026

๐Ÿ† Career:
  - Land a Full-Time Data Analyst role at a product or analytics company
  - Transition from intern โ†’ full-time professional

๐Ÿ“ฐ Newsletter & Content:
  - Grow DATA DECODED to 10,000+ subscribers
  - Publish 50+ structured data education pieces
  - Build a reputation as a go-to data educator on LinkedIn

๐ŸŒ Personal Brand:
  - Launch personal brand website with blog + newsletter + courses
  - Build and sell first structured Data Analytics course
  - Reach 5,000+ LinkedIn connections

๐Ÿค Let's Connect

Open to conversations about data, content, careers, and building in public.


ย  ย  ย 

๐Ÿ”– Keywords

data-analyst sql python power-bi excel pandas data-analysis data-visualization hr-dashboard business-intelligence dax power-query data-educator rohit-kumar-singh bengaluru data-decoded portfolio numpy matplotlib mysql postgresql data-analyst-india



๐Ÿ’ฌ "The best analysts don't just answer questions โ€” they ask better ones."

โ€” Rohit Kumar Singh


Pinned Loading

  1. Contact-Book-App-in-Python Contact-Book-App-in-Python Public

    Python

  2. Restaurant-Menu-Ordering-System-in-Python Restaurant-Menu-Ordering-System-in-Python Public

    Python

  3. Student-Grade-Management-using-Python Student-Grade-Management-using-Python Public

    Python

  4. TO-DO-Application-Using-Python TO-DO-Application-Using-Python Public

    Python

  5. Naukri.com-AI-Agent- Naukri.com-AI-Agent- Public

    JavaScript 1

  6. Blood-Bank-Management-System Blood-Bank-Management-System Public

    Python