👨💻 Data Analyst | SQL | Python | Power BI | BigQuery | AI-Driven Insights
| 📧 Email: pradipias2023@gmail.com | 🏆 GitHub | linkdin | Medium
I am a Mangroliya Pradip data analyst with expertise in data visualization, SQL, Python, and AI-powered analytics. I specialize in interactive dashboards, business intelligence, and advanced data insights to support data-driven decision-making.
💡 Passionate about transforming raw data into actionable insights using Power BI, SQL, Python, and AI.
✅ Business Intelligence & Visualization:
- Power BI, Power Query, Power Pivot
- Microsoft Excel, Advanced Excel
- Looker Studio (Basic Knowledge)
✅ Programming & Data Processing:
- Python (Numpy, Pandas, Matplotlib, Seaborn)
- SQL (MySQL, PostgreSQL, Google BigQuery)
- Web Scraping (Python, ChatGPT AI)
- ChatGPT Prompt Writing
✅ Databases & Cloud:
- Google BigQuery
- Basic Knowledge of Cloud Data Warehousing
✅ Web Technologies (Basic Knowledge):
- HTML5, CSS3, Bootstrap
✅ AI & Automation:
- AI-Driven Data Analysis
- ChatGPT AI Insights & Report Generation
🚀 GitHub Repository: Power-BI-Cyber-Crime-Dashboard
📌 Project Overview
This project provides an in-depth analysis of cyber crime trends in India using Power BI. It highlights crime patterns, affected demographics, and key insights based on official reports from NCRB, PIB, and RBI. The dashboard enables interactive exploration of state-wise crime trends, yearly data variations, and cyber fraud categories.
🛠️ Skills & Technologies
🔹 Skills: Data Visualization 📊 | ETL with Power Query ⚡ | Report Automation 📝 | Trend Analysis 📈 | Statistical Insights 📉 | Interactive Dashboard Creation 📟 | Data Storytelling 🗣️
🔹 Technology: Power BI 🔵 | Power Query ⚙️ | ChatGPT AI 🤖 | CSV/PDF Data Extraction 📁 | Web Scraping 🌐
📂 Data Sources
📜 NCRB Report 2022 (National Crime Records Bureau)
📰 PIB (Press Information Bureau)
🏛️ Rajya Sabha & Lok Sabha Question-Answer Data
🏦 RBI Reports (Reserve Bank of India)
📁 **Data Formats Used: ** CSV, PDF, Web Scraping
🚀 GitHub Repository: World-Merchandise-Trade
📌 Project Overview
This project provides a comprehensive analysis of Global Merchandise Trade from 1947 to 2023 using Google BigQuery and Python. It explores trade trends, country-wise performance, and economic impacts based on official WTO trade statistics.
🛠️ Skills & Technologies
🔹 Skills: Data Analysis 📊 | SQL Queries ⚡ | Data Cleaning 🧹 | Trend Analysis 📈 | Statistical Insights 📉 | AI-Generated Reports 🤖
🔹 Technology: Google BigQuery 🔵 | Python 🐍 | Pandas 📊 | Numpy 🔢 | Matplotlib 📉 | Seaborn 📈 | ChatGPT AI 🤖 | AI Report Generator 📑
📂 Data Sources
📜 Official WTO Merchandise Trade Statistics
📁 **Data Formats Used: ** CSV, PDF, Web Scraping
🚀 GitHub Repository: Brand-Reputation-Social-Media-Monitoring
📌 Project Overview
AfriTech Electronics Ltd. is facing critical challenges impacting its brand reputation, directly affecting customer trust, sales performance, and market competitiveness. The following key issues have been identified:
This project analyzes social media trends and customer feedback to identify reputation risks and improve brand perception using SQL and AI-driven analysis.
🛠️ Skills & Technologies
🔹 Skills: Brand Sentiment Analysis 📊 | Social Media Monitoring 🌍 | SQL Query Optimization ⚡ | AI-Based Insights 🤖 | Data Cleaning & Processing 🧹
🔹 Technology: MySQL 🛢️ | SQL 📜 | ChatGPT AI 🤖
📂 Data Sources
📜 Amdari (Social Media & Customer Feedback Data)
📁 **Data Formats Used: ** CSV
🚀 GitHub Repository: Ecommerce-Sales-Optimization
📌 Project Overview
Shopping cart abandonment is a significant challenge for e-commerce businesses, including MagicMade. Customers often add items to their carts but leave without completing the purchase, leading to revenue loss and reduced customer retention. This project leverages Python, Power BI, and SQL to analyze cart abandonment trends, identify key reasons, and suggest actionable strategies to improve conversions.
🛠️ Skills & Technologies
🔹 Skills: Data Analysis 📊 | SQL Queries ⚡ | Python Visualization 📈 | AI-Generated Reports 🤖 | Business Intelligence 📊
🔹 Technology: Python 🐍 | SQL 📜 | MySQL 🛢️ | Power BI 🔵 | Power Query ⚙️ | ChatGPT AI 🤖 | Numpy 🔢 | Pandas 📊 | Matplotlib 📉 | Seaborn 📈
📂 Data Sources
📜 Amdari (E-commerce Customer Behavior Data)
📁 **Data Formats Used: ** CSV
🚀 GitHub Repository: India-MSME-Dynamics
📌 Project Overview
This Power BI and Power Query project provides an in-depth analysis of MSME (Micro, Small, and Medium Enterprises) Growth, Contribution, and Financial Challenges in India. The study explores MSME formalization, female entrepreneurship, manufacturing sector insights, employment trends, GDP contribution, and financial gaps.
🛠️ Skills & Technologies
🔹 Skills: Business Intelligence 📊 | Data Cleaning 🧹 | Trend Analysis 📈 | Statistical Insights 📉 | AI-Generated Reports 🤖
🔹 Technology: Power BI 🔵 | Power Query ⚙️ | AI-Based Insights 🤖 | ChatGPT AI 🤖 | Web Scraping 🌐
📂 Data Sources
📜 Udyam Registration Portal
📜 MSME Dashboard (Ministry of MSME)
📜 MSME Finance Gap
📜 Government Reports & Economic Surveys
📜 World Bank & Industry Research on MSME Financial Gaps
📁 **Data Formats Used: ** CSV, PDF, Web Scraping
📜 Project-Based Certifications:
- Product Campaign Metrics - Comparing Marketing Campaigns
- Route Optimization for Food Delivery
- Comprehensive Cybersecurity Risk Analysis
- Product Quality vs. Return Rate Analysis
📜 Technical Certifications:
- Advanced Excel
- AI ChatGPT
- SQL Certification
- Data Analysis using Microsoft Excel (Coursera)
- Dashboard Mastery
- Power BI Certification
- Power Query Certification
- Python Developer Certification
📧 Email: pradipias2023@gmail.com