These are the data skills I’m consistently developing through hands-on practice, real-world projects, and continuous learning—while documenting and sharing my journey through Rajeev Dataverse.
Name : Rajeev Tiwari
Learning Phase : Actively Building Skills in Pythn
Location : Prayagraj, India
Email : rajeevtiwari8055@gmail.com
I'm a passionate data enthusiast, currently an expert in Microsoft 365 & SQL, Advanced Excel, including Excel MIS, Power Query, Power Pivot, Power BI, Tableau & Microsoft Access.
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 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!
These are some of the skills I've been learning & gradually improving through practice and real-world applications.
My resume showcases my skills, projects and learning journey in Data Analysis and Computer Science, supported by hands-on practice and real-world datasets.
Hands-on experience in Data Analytics gained through personal projects, Click on Personal Projects & Rajeev Dataverse to explore my work and practical experience.
Executed data analytics projects with cleaning, visualization, dashboards & reporting using Excel, Power Query, SQL, Power BI & Tableau, while creating web projects.
Responsibilities / Work Highlights:Actively engaged in multiple virtual job simulations through Forage, working on hands-on, role-based tasks designed in collaboration with leading global companies.
Responsibilities / Work Highlights:
I have completed my school education followed by undergraduate studies, & I'm continuously enhancing my skills & technical knowledge.
Grade: First class distinction.
Grade: First class distinction.
Grade: First class distinction.
Grade: First class distinction.
Below are the sample Data Analytics projects on Artificial intelligence (AI), Excel, Power Query, MIS, Access, VBA, SQL, Power BI, Tableau, Python & Web Development.
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. It covers advanced SQL techniques like joins, subqueries, window functions, and aggregations.
This Power Query project focused on cleaning and transforming messy, unstructured business data efficiently and effectively. It involved fixing duplicate columns, merged fields, and null values. Techniques like column splitting and unpivoting were used. This automated process handled repetitive tasks and saved significant time. The final output was a clean, structured dataset ready for accurate business analysis and reporting.
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. It also helps identify trends and areas for improvement in emergency care. The dashboard provides clear visuals for faster decision-making. A hands-on project during my data analytics journey.
A complete company-level online food delivery database system fully built in Microsoft Access. It manages real restaurant orders, customers, payments, cancellations, and revenue analytics. Automated queries, forms, reports, macros, and validation rules keep operations smooth and error-free. An all-in-one solution for clean data handling, customer insights, and smart business reporting.
This repository is a curated collection of Executive Business Presentation Vault built from real analytics projects. Each deck represents a complete story — transforming raw data and dashboards into executive-level narratives. These presentations focus not just on analysis, but on why it matters. They highlight trends, risks, growth opportunities across Sales, Operations, HR, Finance & Digital Products.
Retail Sales Dashboard built in Excel using Power Query, Pivot Tables, and Map Charts. This project analyzes a 5000-row retail dataset to solve real-world business problems through dynamic, slicer-controlled visual insights. It simulates a real business scenario where data-driven decisions matter—delivering answers across categories, timeframes, customer segments, and locations.
Analyzed 118.94K Nescafe sales (April 2023) using Power BI to uncover trends in product performance, store contributions, and customer behavior. Identified peak sales hours, weekday vs weekend patterns, and top-performing categories. Provided actionable insights for marketing, staffing, and inventory planning. Demonstrated how data-driven BI can optimize retail operations and support strategic decisions.
This interactive Power BI dashboard is specifically built for Motorola to monitor and analyze sales performance across multiple dimensions including city-wise trends, mobile model sales, payment methods, and customer satisfaction. It showcases essential KPIs such as total sales, quantity sold, and average ratings. The dashboard features dynamic filters like date, region, and model to allow deeper actionable insights.
Analyzed a fictional NETFLIX dataset using PostgreSQL to uncover insights on movies, TV shows, genres, ratings, and countries. Using 15+ SQL queries, the project explored distribution, release trends, and diversity. It identified patterns in ratings, actors, and categories. The work demonstrates SQL skills in aggregation, filtering, and text search. Ultimately, it shows how SQL transforms data into actionable insights.
This project analyzes Blinkit’s grocery sales, customer satisfaction, and inventory trends using Power BI. With advanced DAX calculations, interactive slicers, and KPI visuals, it highlights top-performing products, outlet type trends, and growth opportunities. The dashboard uncovers key insights such as Tier 2 city dominance, strong post-2017 outlet performance, and the impact of fat content on sales.
The Food Delivery Performance Analytics Dashboard is a comprehensive Power BI solution designed to analyze end-to-end food delivery operations. It provides insights into customer behavior, order trends, revenue performance, delivery efficiency, meal periods & partner contributions. The dashboard enables businesses to track KPIs such as total customers, orders, revenue.
This Tableau-based business intelligence solution provides a strategic, real-time view of stakeholder and insurer performance by integrating KPI monitoring, visual analytics, and behavior tracking into one unified dashboard. It empowers business leaders and analysts with centralized, interactive insights into premiums, assets, and key financial metrics—enhancing clarity, accelerating decisions.
Here are some of my professional Certification showcasing my skills and expertise. Education is the most powerful weapon in the world.
This animated snake contribution graph showcases my GitHub contributions, commits, repositories and ongoing project activity.
