Skip to content

rajeevgit8055hub/rajeevtiwari.github.io

Repository files navigation

🌐 Rajeev Tiwari | Official Website

Welcome to my official website. 🌐 rajeevgit8055hub.github.io/rajeevtiwari.github.io


📑 Table of Contents


🧩 Introduction

🚀 I’m thrilled to announce the successful launch of my official website!

This platform is more than just a digital profile — it’s a meaningful reflection of my transition from a humanities background to a data-driven professional path. Through this website, I aim to present not only my technical growth but also the mindset, effort, and passion behind the journey.

Here, you’ll find a curated showcase of:

  • 🎓 My academic achievements and technical certifications
  • 💡 My evolving skills in Excel, SQL, Power BI, Power Query, Access, Python, and more
  • 🛠️ Real-world projects that demonstrate hands-on problem-solving
  • 🎨 Creative coding experiments that blend logic with design

As an enthusiastic and consistent learner, I’ve built this website as a step toward enhancing my visibility, sharing my progress, and connecting with like-minded professionals. It stands as both a resume in action and a canvas of my continuous learning.

🔍 Explore how skills, storytelling, and data come together to define my journey toward becoming an industry-ready Data Analyst.


🏠 Home Section

The homepage serves as a digital handshake — a warm welcome into my professional identity. It briefly introduces me as a data enthusiast from Prayagraj, Uttar Pradesh, India, driven by a purpose to translate raw data into meaningful actions.

Here, you'll get a glimpse of:

  • My professional focus as an aspiring Data Analyst.
  • My vision of using data to make ethically sound, smart decisions.
  • A dynamic mindset focused on discipline, curiosity, and growth.

This section sets the tone for the full portfolio experience — informative, insightful, and innovative.


👤 About Me

In this section, I open up about my academic origin and technical evolution.

I hold a Master's degree in Arts but ventured beyond my comfort zone to step into the world of Data and Analytics. What started as curiosity soon turned into a mission: to develop real-world skills and build a strong portfolio rooted in practicality and impact.

Highlights:

  • Gained expertise in tools like SQL, Power BI, Tableau, Excel, Power Query, Power Pivot, Microsoft, Access, and Tally Prime with GST.
  • Currently building on my skill set with Python.
  • I value professionalism, purpose-driven work, and helping others grow — whether through collaboration, mentoring, or shared learning.

🛠️ Skills

This section categorizes my technical and soft skills, backed by real-world application in projects.

🔧 Technical Tools & Technologies

  • Microsoft Excel: Data cleaning, MIS dashboards, advanced formulas, pivot tables.
  • Power Query & Power Pivot: ETL tasks, data transformation, multi-file cleaning.
  • SQL (PostgreSQL): Writing complex queries, joins, subqueries, data insights.
  • Access Database: Creating relational models, forms, queries, reports.
  • Power BI: Building interactive dashboards and reports (ongoing).
  • Tableau: Building interactive dashboards and reports (ongoing).
  • Python: Data manipulation with pandas, logic building, automation.
  • Excel VBA: Automating repetitive workflows and enhancing Excel functionality.
  • HTML/CSS: UI design and creative front-end effects.

🤝 Soft Skills

  • Excellent written and spoken communication in Hindi & English.
  • Self-discipline, consistency, and a focused mindset.
  • Adaptive learner with strong problem-solving intuition.
  • Mentoring and teaching capabilities, especially for non-tech learners.

📄 Resume Section

My resume is crafted to be a precise reflection of my current abilities, learning trajectory, and project experience.

What it includes:

  • My academic background and technical certifications.
  • Practical project-based exposure across multiple domains.
  • Core skill sets, both technical and analytical.
  • A career objective centered on growing as a data analyst in real-time, impactful environments.

The resume is available in downloadable format for recruiters and collaborators directly via the website.


🎓 Education

I believe education is both formal and ongoing. Here's a snapshot of my academic credentials and certifications:

  • 🎓 MA – Master of Arts from University of Allahabad (First Division).
  • 💻 ADCA – Advanced Diploma in Computer Application.
  • 📒 Tally Prime with GST – Certified for business accounting with GST compliance.
  • 🖥️ CCC (NIELIT) – Strong foundation in digital literacy and productivity tools.
  • 🗄️ SQL (PostgreSQL) – Skilled in database management, querying, and data analysis.
  • 📊 Power BI – Proficient in building interactive dashboards and data visualizations.
  • 🐍 Python – Learning for data cleaning, automation, and scripting tasks.

📊 Projects

Real learning comes from doing. My portfolio includes hands-on, practical projects in a variety of tools:

🗄️ SQL Projects

  • SQL-Project-on-Online-Book-store – SQL queries on book inventory, orders, and customers.
  • NETFLIX-Data-SQL-Analysis – Analysis of movies, users, and viewing patterns.
  • Hospital-Data-SQL-Analysis-Project – Patient records and hospital operations insights.

📈 Excel Projects

  • Hospital-Emergency-Room-Dashboard – Visualizing patient flow and emergencies.
  • E-commerce-Sales-Dashboard-Analysis – Tracking sales trends and KPIs.
  • Retail-Sales-Dashboard-Analysis – Store performance and product analysis.

⚡ Power Query Projects

  • Power_Query-Messy-Rows-Cleaning-Project – Cleaning and restructuring messy datasets.
  • Unified-Multi-Extension-Folder-Based-Data-Cleaning – Combining and cleaning multi-format files.

🛢️ Access Database Projects

  • SmartBite-Online-Food-Delivery-DBMS – Database for food orders, customers, and delivery tracking.

📊 Power BI Projects

  • Motorola-Sales-BI-Dashboard-Analysis – Mobile sales performance insights and trends.
  • Nescafe-Driving-Coffee-Sales-Excellence – Coffee sales analytics for growth strategy.
  • Amazon-Global-Business-Analytics – Global business KPIs and performance monitoring.
  • Blinkit-Grocery-Analysis – Grocery sales and demand pattern analysis.

📉 Tableau

  • HSBC-Strategic-Stakeholder-Intelligence – Insights on HSBC stakeholders and decision-making.

📝-HTML/ 🎨-CSS/ 🛠️-JavaScript Projects

  • Dynamic-Neon-Glow-Website (rajeevtiwari.github.io) – Personal portfolio website with glowing effects.
  • 3D-Solar-System-Interactive-Animation – An immersive cosmic model with rotating planets & interactive orbits.
  • LoveForever-A-Heartfelt-Digital-Promise – A heartfelt digital creation symbolizing love & togetherness.

🐍 Python

  • Data Cleaning with pandas
  • Pattern Printing & Loops
  • Mini EDA Projects

Each project is GitHub-hosted, with documentation, screenshots, and versioning.


🎯 Final Words

This website is my career in motion — a canvas where I paint with data, logic, visuals, and code.

It reflects:

  • 📘 My journey from arts to analytics
  • ⚙️ My practical understanding of data tools
  • 💡 My ability to think creatively in technical domains
  • 🌱 My commitment to growth, one project at a time

Thanks for exploring! I look forward to your feedback, support, and future collaborations. 🚀


📬 Connect with Me

If you're looking for:

  • A beginner-friendly analyst to assist with real-world projects
  • A dedicated learner for internships or mentorship programs
  • A team player who values consistency and ownership

Then let’s connect:

🤝 Thanks for visiting my profile!


🖼️ Website Preview

Website – Main Preview


About

An official platform showcasing my education, skills, projects, and certificates for professional and educational growth.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published