Analytics Dashboard
Key Metrics
About Me
I'm Aadarsh Jaiswal, a results-driven Data Analyst skilled in Python, SQL, Power BI, and Excel, transforming complex data into actionable business solutions. With a background in operations and product management, I thrive on solving business challenges with data and delivering measurable impact. I'm passionate about continuous learning, hands-on problem-solving, and collaborating with diverse teams.
Skills Proficiency
Projects Overview
Skills & Tools
Soft Skill Proficiency
Professional Experience
Business Operation Manager
Ahimsa Tour & Travels Pvt Ltd, Rishikesh, Uttarakhand April 2023 – August 2024
Led a 25-member team to achieve 20% faster operations and 15% productivity gains. Managed ₹33 lakh budget, saving ₹3 lakh through cost optimizations. Built Excel dashboards to monitor KPIs and drive data-driven decisions.
Associate Product Manager Intern
LearnQoch, Remote September 2022 – March 2023
Streamlined workflows, cutting defects by 20% and boosting satisfaction by 15%. Collaborated with a 12-member team to increase productivity by 25% and reduce turnaround time.
View Certificate
Business Development Associate Intern
Apollo 24x7, Remote March 2022 – August 2022
Resolved 95% of client issues within 24 hours, improving satisfaction by 20%. Managed 15+ client relationships, enhancing retention by 10%.
View Certificate
Featured Projects
Sales Dashboard (Power BI)
Helped retailers boost profits by identifying top-performing products. Analyzed 50,000+ retail records to uncover revenue trends, product performance, and actionable insights.
Customer Churn Prediction
Improved retention by predicting churn risk. Built a logistic regression model with 82% accuracy using Python and Scikit-learn. Performed feature engineering and model evaluation.
MySQL Data Analytics
Performed SQL-based retail analytics on a multi-table orders database to drive customer segmentation, product inventory evaluation, logistics efficiency, and pricing strategies using conditional logic, joins, and subqueries.
HR Attrition Prediction
Reduced employee turnover by identifying key attrition drivers. Built a predictive model using Python and Scikit-learn, leveraging Random Forests and data visualization.
Education
MBA – Information Technology
DR. A.P.J. Abdul Kalam Technical University, Lucknow Aug 2021 – Aug 2023BCA – Computer Application
Mahatma Gandhi Kashi Vidyapith University, Varanasi Aug 2017 – Aug 2020Certifications
Data Science Certification
Meritshot In Progress, Expected August 2025Covers practical applications of Python, SQL, Power BI, Exploratory Data Analysis (EDA), and Machine Learning, enhancing skills in data-driven decision-making and predictive analytics.
Deloitte Australia Data Analytics Virtual Experience
Forage Completed June 2025Built an interactive Tableau dashboard to uncover trends and support data-driven decisions. Organized, cleaned, and analyzed financial data using Excel for investigative reporting. Gained experience with forensic technology tools to detect financial anomalies.
Data Visualisation: Empowering Business with Effective Insights
Tata Group Completed June 2025Framed business scenarios, designed effective data visuals, and communicated key insights to senior leadership through a virtual job simulation with Tata Consultancy Services, enhancing data storytelling and executive reporting skills.
GenAI-Powered Data Analytics Job Simulation
Tata Group Completed June 2025Conducted EDA to assess data quality and identify risk indicators. Proposed a no-code predictive modeling framework for customer delinquency risk using GenAI. Designed an AI-driven collections strategy integrating agentic AI, automation, and ethical AI principles.
Introduction to Technology Apprenticeship
Accenture UK Completed June 2025Analyzed legacy IT challenges in a client case study and proposed cloud computing solutions. Presented a strategic slide deck to senior stakeholders, gaining exposure to digital transformation and business analysis.
SQL and Relational Databases 101
IBM Issued May 2025Built a solid foundation in SQL and relational database concepts using DB2 on Cognitive Class. Learned to write and optimize SQL queries, use JOINs, filter and group data, and understand database design principles such as normalization, primary and foreign keys.
Data Analysis with Python
IBM Issued May 2025Gained hands-on experience with Pandas, NumPy, and Matplotlib to clean, analyze, and visualize data. Strengthened skills in statistical analysis, data wrangling, and creating insights from datasets.
Data Visualisation with Python
IBM Issued June 2025Developed skills in creating compelling visualizations using Matplotlib, Seaborn, and Plotly. Designed charts, graphs, and dashboards to communicate data insights effectively.
Advanced Data Analysis Using Excel and Power BI
LetsUpgrade Issued May 2025Learned advanced techniques in data analysis using Excel and Power BI. Built interactive dashboards, cleaned and transformed data, and derived actionable insights for decision-making.
AI Tool Workshop
Be10X Issued May 2025Gained hands-on experience using AI tools to enhance productivity, including creating presentations in under 5 minutes, analyzing data in under 30 minutes, and automating repetitive tasks.