Aspiring Data Analyst

LinkedIn GitHub




About me

About me 👤

These are the data skills I’m consistently developing through hands-on practice, real-world projects, and continuous learning.




Name : Rajeev Tiwari

Current Status : Aspiring Data Analyst

Learning Phase : Actively Building Skills in Power BI, VBA & Python

Address : Prayagraj, [UP] India

I'm a passionate data enthusiast, currently an expert in Microsoft 365 & SQL, Advanced Excel, including Excel MIS, Power Query, Power Pivot, Google Sheets, & Access Database.

I love transforming raw data into meaningful insights that solve real-world problems. To further enhance my skills in Data Analysis,

I’m currently learning Power BI, VBA, Python, & Database Technology through online courses. With a strong interest in data and analytics, I constantly seek new ways to grow, improve, and contribute to impactful projects.

🌱 Always learning, always exploring!

  • Profile : Learning to Transform Data into Actionable Stories
  • Domain : Business Intelligence, Data Analytics, MIS Reporting
  • Education : Master of Arts - MA, University of Allahabad
  • Language : English, Hindi
  • Data Tools : SQL, Advanced Excel (MIS, Power Query, Power Pivot), Access Database
  • Skills : Microsoft 365, Google Sheets, Data Visualization & Business Insights
  • Learning : Power BI, VBA & Python

Skills

Skills💻

These are some of the skills I've been learning & gradually improving through practice and real-world applications.

Office 365
Office 365
Word
Word
Excel
Excel
Power Query
Power Query
Power Pivot
Power Pivot
MIS Reporting
MIS Reporting
Power Point
Power Point
Access
Access
Outlook
Outlook
Publisher
Publisher
OneNote
OneNote
Power BI
Power BI
Currently learning
HTML5
HTML5
CSS
CSS
Tally Prime
Tally Prime
Google Sheets
Google Sheets
Open AI
Open AI
Canva
Canva
SQL
SQL
PostgreSQL
PostgreSQL
CHMT
CHMT
Excel VBA
Excel VBA
Pending
IoT
IoT
Pending
Python
Python
Pending

Resume

Resume📝

I'm currently learning & developing skills in Data Analysis & Computer Science. As this portfolio is still under construction, my resume hasn’t been uploaded yet. Once I finish a few professional courses & gain hands-on experience, I’ll share a professional resume here.

⚠️ Please note, this is currently a demo site & some sections are still under development.

🤝 Thank you for visiting!





Experience

Experience 🧳

I have worked in the Data Analytics domain across top companies and led impactful projects.

2021-Present

Senior Data Analyst

Demo- Google

**************************************************

  • **************************************************
  • **************************************************
  • **************************************************

2018-2021

Senior Data Analyst

Demo- Amazon

**************************************************

  • **************************************************
  • **************************************************
  • **************************************************

Education

Education 🏫

I have completed my school education followed by undergraduate studies, & I'm continuously enhancing my skills & technical knowledge.


2020 - 2022

Master of Arts - M.A. 🎓

University of Allahabad

Grade: First class distinction.

2014 - 2016

Higher Secondary School 📚

Ganga Bal Vidya Mandir Inter College

Grade: First class distinction.

Projects

Projects🚀

Below are the sample Data Analytics projects on Excel, Power Query, MIS, Access, VBA, SQL, Power BI & Python.

Online Bookstore – SQL Data Analysis

A complete SQL-based data analysis project on a fictional online bookstore using PostgreSQL. This project demonstrates how to clean, query, and analyze real-world datasets to extract business insights such as sales trends, revenue, inventory, and customer behavior using 20+ well-structured SQL queries.

Cleaned & Refined Messy Rows Dataset

This Power Query project focused on cleaning and transforming messy, unstructured data. It involved fixing duplicate columns, merged fields, and null values. Techniques like column splitting, unpivoting. The final output was a clean, structured dataset ready for accurate analysis.

Hospital Emergency Room Dashboard

My first Excel MIS Dashboard project analyzing Hospital ER performance. Built using Excel tools like Pivot Tables, Sparklines, Conditional Formatting, and Charts to track patient count, wait times, referrals, etc. A hands-on project during my data analytics journey.

Advanced Excel Projects

Projects featuring advanced formulas, dynamic dashboards, pivot tables, and Excel automation with professional reporting formats.

Power BI Projects

Interactive dashboards, KPI visualizations, and DAX-based data analysis projects focused on business insights and reporting.

Access Database Projects

Database creation, form design, report generation, and VBA scripting projects using Microsoft Access with relational structure.

Python Projects

Beginner to intermediate Python scripts covering automation, data analysis using pandas, NumPy and web scraping with BeautifulSoup.

Web Design Projects

Frontend web development projects using HTML, CSS, and basic JavaScript, including responsive layouts and animated UI sections.

VBA Projects

Excel VBA automation projects for form control, user-defined functions, data validation, and task automation in real-world use cases.

3D Solar System Animation

This is a fully animated 3D space-themed project built using only HTML and CSS, without any JavaScript. It features orbiting planets, a nested Earth–Moon system, falling stars, and rotating galaxies. The entire layout is responsive and brought to life through pure CSS animations and visual styling, showcasing how HTML and CSS alone can create dynamic and visually engaging experiences.

More projects on GitHub

I love to solve business problems & uncover hidden data stories


GitHub

0 +  Projects Completed on LinkedIn

LinkedIn

Programming Apocalypse

Programming Apocalypse 👾

🌀 From Code Carnage to Programming Apocalypse — a digital titan tale begins.
Meet Script Samurais, Syntax Warriors & Runtime Titans on LinkedIn.

Certificates

Certificates 🎓

Here are some of my professional certificates showcasing my skills and expertise.

Course on Computer Concepts

The CCC certificate from NIELIT was the spark that ignited my passion for Data Analytics and Computer Science. It laid the foundation for everything I’m building today and marked the true beginning of my journey into the world of technology.

Tally Prime with GST

I successfully completed a certified Tally Prime with GST course via the Skill Course platform. It covered voucher entry, payroll, stock, profit & loss reporting, and taxation modules like GST, TDS, and TCS—equipping me with practical digital accounting skills.

Advanced Diploma in Computer Application

I completed the 2-year diploma course 'ADCA' from Skill Course. It covered MS Office, VBA, Tally with GST, HTML/CSS, CHMT, and essential digital tools—equipping me to thrive in today’s tech-driven world.

ChatGPT in Excel

I am currently learning how to integrate ChatGPT with Excel for smarter data analysis and automation. This course is in progress and will soon add powerful AI capabilities to my Excel skills.

SQL Micro Course

I’m undergoing a project-based SQL course focused on database creation, querying, and reporting. This hands-on training is nearing completion and will solidify my backend data management expertise.

Power BI Micro Course

I am currently learning Power BI to build dynamic dashboards and gain actionable business insights. This in-progress course will soon empower me to tell compelling data stories through visualization.

Contact Me

Contact Me 🤝

Below are the details to reach out to me!

Address

Prayagraj, India

Contact Number

+91 8896250283

Download Resume

resume link

Find Me On

Find Me On 🌐

Connect with me on social media platforms below!