Hello, I'm

Rakesh Kumar Mistri

Turning raw data into actionable insights using SQL, Python, Power BI & Tableau.

Rakesh Kumar Mistri

About Me

I'm a Data Analyst with 1+ year of experience in data analysis, MIS reporting, dashboard development, and reporting automation. I specialize in transforming business data into actionable insights using SQL, Python, Power BI, Tableau, Advanced Excel, and Power Query.

Currently working at Khan Global Studies Pvt Ltd, I build automated MIS reports, monitor KPIs, and design interactive dashboards that support business decision-making. I'm pursuing B.Sc. Data Science from IIT Madras (Online).

1+

Years Experience

10+

Certifications

6+

Projects

My Skills

📊 Data Analysis

SQL, Python, Pandas, NumPy, Advanced Excel, Data Cleaning, Data Validation

📈 Business Intelligence

Power BI, Tableau, Looker Studio, Dashboard Development, KPI Reporting

⚙️ Reporting & Automation

MIS Reporting, Power Query, Google Apps Script, Excel VBA (Basic)

🗄️ Databases

MySQL, PostgreSQL, SQL Server, Oracle, SQLite

🐍 Python Libraries

Matplotlib, Seaborn, Scikit-learn, OpenPyXL, SciPy, Scrapy

☁️ Cloud & Platforms

Google BigQuery, Snowflake, AWS (Basics), Databricks

🛠 CRM & Tools

Salesforce, Zoho CRM, Zoho Analytics, Git, GitHub, Jupyter

🤖 AI Tools

ChatGPT, Claude, Gemini, DeepSeek, Grok, Meta AI

Experience & Education

Associate - Data Analyst

Khan Global Studies Pvt Ltd | Apr 2025 - Mar 2026; May 2026 - Present
  • Analyze business datasets using SQL, Python, and Advanced Excel to identify trends and monitor KPIs.
  • Develop automated MIS reports and interactive dashboards for recurring business reporting.
  • Perform data cleaning, validation, and KPI monitoring to improve data accuracy.
  • Automate reporting workflows using Power Query and advanced Excel formulas.

B.A. Political Science

IGNOU, New Delhi (Distance Learning) | Expected 2027

Class 12 (Senior Secondary) – Science (PCM)

Jharkhand Academic Council, Ranchi | 2024

My Projects

Flipkart Sales Analytics

SQL

Analyzed sales and revenue data to identify trends, product performance, and key business metrics.

View on GitHub →

Rapido Ride Booking Dashboard

Power BI

Built a KPI and booking analytics dashboard to monitor ride performance and business trends.

View on GitHub →

Customer Churn Analysis

Python

Data cleaning, EDA, visualization, and churn insight analysis on customer behavior.

View on GitHub →

HSBC Banking Risk Analytics

SQL

Analyzed banking risk and customer data to support risk reporting.

View on GitHub →

British Airways Dashboard

Tableau

Passenger satisfaction dashboard analyzing customer experience trends.

View on GitHub →

Diwali Sales Analysis

Python

Analyzed product and customer performance to identify sales patterns.

View on GitHub →

Get In Touch

📧 Email 📱 +91 93410 42627 💼 LinkedIn 💻 GitHub

Send Me a Message

📍 Noida, Uttar Pradesh, India