Aspring
Data & Business Analyst

Hello, I'm Mayank Rana

I'm a
Data & Business Analyst

Transforming complex data into actionable insights and strategic business solutions.

View My Work Contact Me
John Doe Portrait
John Doe professional shot

About Me

Bridging Data and Decisions

Data Analyst with a strong foundation in AI prompting and UI/UX design, driven by a passion for transforming complex data into clear, insightful, and engaging digital experiences. With a focus on clean logic, user-centric design, and intelligent automation, I specialize in crafting solutions that not only look great but also deliver meaningful impact. I thrive at the intersection of data, design, and AI—where innovation meets usability.

My goal is to leverage my analytical skills to help organizations optimize processes, identify growth opportunities, and make smarter decisions. I'm always eager to learn new technologies and methodologies in the ever-evolving world of data.

My Technical Skills

Data Analysis & Visualization

SQL80%

Tableau / Power BI85%

Excel75%

Python (Pandas, NumPy)70%

Tools & Technologies

Git & GitHub80%

JIRA / Confluence70%

Cloud (AWS/Azure Basics)70%

My Projects

Project 1

IPL ANALYSIS DASHBOARD

Developed a comprehensive IPL dashboard analyzing 17 seasons (2008–2025) of the Indian Premier League. Cleaned and structured raw match, player, and team datasets using Power Query.

Power BIDAXModelling
Project 2

Car Price Prediction - Data Preprocessing & Exploration

This project is focused on data preprocessing and exploratory analysis for a car price prediction dataset. It includes techniques to handle missing values, perform encoding, and prepare the data for machine learning tasks.

PythonScikit-learnML
Project 3

SuperStore-Sales-Dashboard

About Built an interactive Power BI dashboard to analyze SuperStore sales across regions and categories. Used data modeling, DAX, and mapping to visualize key metrics like revenue, profit, and product performance.

Power BIMappingDAX
Project 4

Mind Quiz Web Application

Mind Quiz is a feature-rich quiz platform that provides an interactive and fun way for users to test their general knowledge. The project was built to demonstrate a classic web application stack with user authentication, dynamic content rendering from a database, and a clean, responsive user interface.

PHPCSSJSphpMyAdmin
Project 5

HR ANALYTICS DASHBOARD

An interactive dashboard built using Power BI to analyze and visualize employee attrition trends, helping HR teams make data-driven decisions.

Power BIDAXData ManipulationData Visualization

My Journey

Master of Computer Applications

D.I.M.S., Meerut

2025 - 2027

Pursuing an MCA with a strong emphasis on data analytics, AI prompting, and user experience design. Developing skills in data visualization, predictive analysis, and intelligent system design through hands-on projects and practical applications in real-world scenarios.

Bachelor of Computer Applications

D.I.M.S., Meerut

2022 - 2025

Focused on data analysis, AI prompting, and user experience design. Gained hands-on experience with tools like SQL, Python, Power BI, and Excel to extract insights, build dashboards, and support data-driven decision-making. Explored AI prompting to automate analysis workflows and enhance interaction with intelligent systems. Also built a custom portfolio to showcase data projects and UI/UX skills.

Pyhton Data Science Certification

EICTA & IIT Kanpur

Feb 2025 - April 2025

Completed a certified Student Development Program in Data Science conducted by E&ICT Academy, IIT Kanpur. Gained practical exposure to data analysis, machine learning concepts, and Python-based tools used in real-world analytics.

Diploma in Computer Application

AICPE

April 2022 - Oct 2022

Earned certification demonstrating proficiency in Tableau for data visualization and dashboard creation.

Intermediate (12th)

K.S. Inter College | Kuralsi, Muzaffarnagar

2021 - 2022

Stream :- Physics, Chemistry, Math. (PCM)

High School (10th)

K.S. Inter College | Kuralsi, Muzaffarnagar

2019 - 2020

My Resume

Explore my experience in detail or download a PDF copy.


Download Resume (PDF)

Live Resume Dashboard

Live Resume

Education

Master of Computer Applications | D.I.M.S., Meerut

2025 - 2027

Get In Touch

🎉 Thank you! Your message has been sent. I'll get back to you soon.

What People Say

"Mayank has a remarkable ability to distill complex data into clear, concise insights. His dashboards were a game-changer for our team."

Author 1

Sarah Miller

Senior Marketing Manager, ABC Corp

"His analytical skills and business acumen are top-notch. Mayank is not just a data person; he's a problem solver who understands business context."

Author 2

David Khan

Product Lead, DEF Solutions