PD

Hi, I'm Purav Dhanki

Aspiring Data Analyst | Business Analyst | B.Sc. IT Graduate | Tech Enthusiast

A detail-oriented and proactive B.Sc. IT graduate, passionate about leveraging data science and analytics to drive meaningful insights and solutions.

About Me

Detail-oriented Information Technology graduate with a strong foundation in data analysis, SQL, Python, Power BI, and Excel. Experienced in academic and real-world projects involving data visualization, interactive dashboards, and database management. Passionate about transforming data into actionable business insights and continuously upskilling in analytics, MIS reporting, and emerging technologies.

Education

2025

Bachelor of Science in Information Technology

University of Mumbai

B.Sc. IT with focus on programming, web development, and database management

2022

Higher Secondary Education

Maharashtra State Board

Completed HSC with a strong foundation in Commerce, Mathematics, and Information Technology.

2020

Secondary School Education

Maharashtra State Board

Completed SSC with excellent academic performance

Skills & Expertise

Programming Languages

HTML CSS JavaScript Python MySQL C C++

Tools & Frameworks

Firebase Anaconda Power BI Jupyter Notebook Visual Studio MS Office Canva

Data Science & Analytics

Data Visualization Data Cleaning EDA Power Query DAX

AI & Machine Learning

Supervised Learning Unsupervised Learning Regression Classification Clustering Neural Networks

Soft Skills

Communication Leadership Problem Solving Team Collaboration Adaptability Attention to Detail Continuous Learner

Areas of Interest

Photography UI/UX Designing Learning New Skills Gaming Movies / Series PC Upgradation / Customization

Featured Projects

OLA Ride Booking – Power BI Business Analysis

Built an interactive Power BI dashboard analyzing 100,000+ ride records to track revenue, booking success rate (62%), cancellations, and customer behavior trends. Created KPIs and DAX measures to evaluate operational performance, performed demand and cancellation analysis (Customer vs Driver, weekends/match days), and transformed raw data using Power Query to deliver accurate, insight-driven reporting.

Microsoft Power BI Microsoft Excel DAX Power Query Data Modelling KPI Analysis

Mobile Sales Dashboard – Power BI Sales Analysis

Built an interactive Power BI dashboard to analyze mobile sales by brand, city, and payment method, created key KPI metrics including Total Sales, Transactions, and Quantity for performance tracking, developed daily and weekly sales trend visualizations to support business insights, and applied data cleaning with basic DAX to ensure accurate and reliable reporting.

Microsoft Power BI Microsoft Excel DAX Power Query Data Modelling

Maven Fuzzy Factory - Digital Marketing Analysis

Performed SQL-based analysis of user behavior, marketing performance, and website conversions. Built conversion funnels to identify user drop-offs and revenue impact, and delivered data-driven insights to support marketing optimization, budget allocation, and channel performance improvement.

MySQL Data Modelling Funnel Analysis

EduMosaic - Web Application

A dynamic web-based student management system that streamlines announcements, attendance, and user communication. Built using Firebase Firestore for real-time data handling and a smooth user experience.

HTML CSS JavaScript Firebase Visual Studio

Certifications

SQL (Basic)

HackerRank

Feb 2026

Demonstrated proficiency in basic SQL queries including SELECT, JOIN, GROUP BY, and data filtering techniques.

Prompt Engineering with GitHub Copilot

Simplilearn

Feb 2026

Learned effective prompt design for AI-assisted coding, automation, and productivity enhancement.

Power BI Workshop

Office Master & Be10x

Jan 2026

Certified in Power BI Workshop — Created AI-powered interactive dashboards and learned end-to-end visualization workflows to deliver actionable insights.

Power BI Micro Course

Skill Course (ISO 9001:2015 Certified)

Jan 2026

Gained practical exposure to Power BI, including data transformation, visualization techniques, basic DAX functions, and building interactive dashboards to support data-driven decision-making.

Ai Tools Workshop

Office Master & Be10x

Jan 2026

Gained foundational knowledge of AI concepts including machine learning, neural networks, and real-world applications.

Data Visualization: Empowering Business with Effective Insights

Tata Group – Data Visualization (Forage)

Jan 2026

Completed practical tasks focused on framing business problems, selecting the right visualizations, creating impactful dashboards, and communicating data-driven insights clearly to support strategic decision-making.

Data Analytics Job Simulation

Deloitte (Forage)

Jan 2026

Gained hands-on experience in data analysis and forensic technology through real-world business simulations, applying analytical thinking to interpret data, identify patterns, and support evidence-based business decisions.

ChatGPT for Beginners

Great Learning Institute

Dec 2025

Learned the basics of prompt engineering, chatbot capabilities, and practical use cases of generative AI with ChatGPT.

SQL Tutorial

Great Learning Institute

Nov 2022

Gained hands-on experience in building structured and responsive web pages using HTML, with a focus on clean layout and best practices.

UI/ UX

Great Learning Institute

Oct 2022

Acquired basic understanding of user interface and user experience principles, focusing on usability, layout design, and user-centered design.

Experience

Jan 2025 - Present

Root Multitude (OPC) Pvt Ltd.

Data Analyst Trainee

• Built 5+ interactive Power BI dashboards for KPI tracking and performance reporting.
• Analyzed 1,000+ records using Excel to identify trends and support business decisions.
• Improved data accuracy by 20% through structured record validation.
• Reduced report preparation time by 15% using AI tools.

Apr 2025 – Sep 2025

Root Multitude (OPC) Pvt Ltd.

Data Management Intern

• Managed 100+ daily records and maintained structured documentation.
• Prepared weekly reports using Excel (sorting, filtering, formulas).
• Supported backend data tracking and workflow monitoring.

Jan 2025 – Apr 2025

Root Multitude (OPC) Pvt Ltd.

Data Management Freelancer

• Managed structured Excel datasets and delivered accurate client reports.

Jul 2024 – Jan 2025

MVLUBOT Internship

UI/UX Intern

• Designed simple and user-friendly UI concepts for a chatbot interface.
• Improved selected UI designs based on feedback to enhance usability and appearance.
• Worked with frontend and backend teams to ensure designs matched technical requirements.
• Helped in building a basic chatbot website for smooth user interaction.

Get In Touch

Contact Information

Phone

+91 81089 91069

Email

puravdhanki@hotmail.com

Address

Umiya Oasis, Gaurav Valley Road,
Near G.C.C. Club, Opp. First Step Global School,
Mira Road, Mumbai, 401107

Send a Message