Nikhil Rawat Profile Picture

Hi, I'm Nikhil Rawat

Data Analyst | Transforming Data into Insights with Python, SQL, Power BI, Tableau & Excel

Get in Touch

About Me

I'm a certified Data Analyst with comprehensive training from 4Achievers in data analytics, visualization, and programming. Proficient in Python, SQL, Power BI, Tableau, and Excel, I specialize in cleaning, analyzing, and visualizing data to uncover actionable insights. Through hands-on projects, I’ve built dashboards, predictive models, and reports that drive business decisions. Passionate about data-driven innovation and eager to contribute to impactful solutions.

Education

  • B.Tech CSE, Graphic Era Hill University (2021–2025, Graduated)
  • Class 12th, CBSE, SBPS Dehradun (2021)
  • Class 10th, CBSE, SBPS Dehradun (2019)

Skills

Technical

  • Data Analytics Process
  • Exploratory Data Analysis
  • Data Cleaning
  • Data Collection Methods
  • SQL Querying
  • SQL Joins/Subqueries
  • SQL Optimization
  • Data Modeling (Power BI)
  • DAX (Power BI)
  • Tableau Data Connection
  • Excel Pivot Tables
  • Power Query/Power Pivot

Programming

  • Python Programming
  • NumPy/Pandas
  • Scikit-learn (Basic ML)
  • Python File Handling
  • Python OOP
  • Python Exception Handling
  • Python Advanced Concepts
  • Python Testing/Debugging

Design

  • Data Visualization (Matplotlib/Seaborn)
  • Power BI Visualizations
  • Tableau Visualizations
  • Excel Visualizations
  • Dashboard Design

Languages

  • Python
  • SQL
  • HTML
  • CSS
  • JavaScript

Soft Skills

  • Problem-Solving
  • Communication
  • Teamwork
  • Adaptability

Tools

  • Excel
  • Power BI Desktop/Service
  • Tableau Desktop
  • Jupyter Notebook
  • VS Code
  • MySQL/PostgreSQL
  • Photoshop

Projects

Sales Data Analysis Dashboard

Developed an interactive Power BI dashboard to analyze sales trends, using Power Query for data cleaning, DAX for measures, and visualizations for insights.

View Project

Customer Churn Prediction

Built a machine learning model using Python, Pandas, and Scikit-learn for data preparation, EDA, and churn prediction with regression/classification.

View Project

Financial Data Reporting

Created Excel-based reports with Pivot Tables, advanced formulas, charts, and What-If analysis for financial datasets.

View Project

Time Series Analysis

Queried time series data with SQL and visualized trends using Tableau dashboards with filters and calculated fields.

View Project

Certifications

Data Analytics Training - 4Achievers (Completed 2025)

Comprehensive course covering:

Resume

View or download my full resume here:

View Resume

Contact Me

Let's discuss data-driven opportunities!

📞 Call ✉️ Email 💬 WhatsApp 🔗 LinkedIn