Soham Desai
Data Analyst & BI Strategist
Transforming Complex Data Into Strategic Business Intelligence
Contact Me
Hi, I'm Soham Desai
Data Analyst | Business Intelligence Enthusiast
01
I am a passionate and curious Data Analyst who enjoys exploring data to uncover patterns, insights, and stories hidden beneath the surface.
02
I work with tools like SQL, Power BI, Python, and Excel to analyze data, build dashboards, and support data-driven decision-making. Through internships and hands-on projects, I’ve gained experience working on large datasets, performing data preprocessing, exploratory analysis, and creating meaningful visualizations that translate complex data into actionable insights.
03
What draws me to data analytics is the balance between logic and creativity. I enjoy the technical side—writing queries, modeling data, and analyzing trends—but I’m equally interested in how insights are communicated. Turning numbers into a clear narrative that stakeholders can understand is what truly excites me.
04
For me, data analytics is a continuous learning journey. I enjoy experimenting with new techniques, improving my skills, and working on projects that solve real business problems. I’m currently seeking opportunities as a Data Analyst / BI Analyst / Trainee BI Developer, where I can grow professionally and contribute to impactful analytics solutions.
Featured Analytics Work
These real-world data analysis projects showcase diverse skills and tools to deliver actionable insights.
Featured Projects
Data Analysis & EDA
Amazon Sales Data Analysis
Analyzed large-scale e-commerce sales data to uncover revenue trends and customer behavior.
What I Did
  • Cleaned and processed 100,000+ sales records
  • Performed EDA to identify monthly trends and top product categories
  • Created visual reports to support sales and inventory decisions
Technologies: Python (Pandas, NumPy, Matplotlib, Seaborn)
BI Dashboard & SQL
Flipkart Business Operations & Revenue Intelligence
Built BI dashboards to monitor sales performance and operational efficiency.
What I Did
  • Wrote optimized SQL queries on 133,000+ records
  • Performed ETL using SQL and Power Query
  • Developed interactive Power BI dashboards for revenue, orders, and regions
Technologies: SQL, Power BI, Power Query
Power bi Analysis
Adventure Works BI Dashboard
Designed an executive-level BI dashboard for business decision-making.
What I Did
  • Built star schema data model using fact and dimension tables
  • Created DAX measures for Sales, Profit, MoM & YoY growth
  • Designed interactive dashboards with slicers and drill-throughs
Technologies: Power BI, SQL, DAX
Professional Experience
Data Analyst Intern (Project-Based Training)
NMD Pvt Ltd | Remote | Jul 2025 – Dec 2025
  • Worked on real-world business datasets following industry-standard analytics workflows
  • Cleaned, transformed, and analyzed 100,000+ rows of data using SQL and Excel
  • Developed KPI reports and Power BI dashboards to support decision-making
  • Applied data visualization and analytical techniques to deliver business insights
Academic Background
Bachelor of Technology (B.Tech) – Electrical Engineering
NMCOE, Peth | Dr. Babasaheb Ambedkar Technological University (DBATU) | Graduated: 2025
I completed my Bachelor’s degree in Electrical Engineering under Dr. Babasaheb Ambedkar Technological University, where I developed a strong foundation in analytical thinking, numerical analysis, and problem-solving. My academic journey involved working extensively with technical data, system performance evaluation, and logical reasoning, which naturally aligned with my growing interest in data analytics and business intelligence.
Relevant Coursework & Technical Foundation
  • Engineering Mathematics & Statistics
    Applied statistical methods, probability concepts, regression techniques, and numerical analysis to solve engineering and data-driven problems.
  • Signals & Systems
    Analyzed system behavior, patterns, and performance metrics, strengthening my ability to interpret structured data and trends.
  • Power Systems & Electrical Machines
    Worked with operational data, efficiency calculations, load analysis, and performance evaluation using data-driven approaches.
  • Control Systems & Optimization
    Studied system modeling, optimization techniques, and analytical evaluation, building a structured and logical approach to problem-solving.
  • Programming & Technical Computing
    Developed a strong foundation in programming logic and computational problem-solving, which supported my transition into Python-based data analysis.
Final Year Project (Award-Winning)
Electric Bicycle Energy Regeneration System
Final Year B.Tech Project | Project of the Year Award
Designed and developed an energy regeneration system for an electric bicycle to improve overall efficiency by recovering energy during braking and deceleration.
Project Highlights
  • Designed an electrical system to capture and store regenerative energy, improving battery utilization.
  • Analyzed system performance, energy flow, and efficiency under different operating conditions.
  • Implemented control logic to regulate charging and ensure system safety.
  • Evaluated performance improvements through testing and comparative analysis.
Outcome & Recognition
  • Demonstrated measurable improvement in energy efficiency and system sustainability.
  • Awarded “Project of the Year” for innovation, technical execution, and practical impact.
This project strengthened my ability to analyze system performance, interpret numerical data, and optimize outcomes—skills that I now apply in data analytics to solve business problems using structured datasets.
Core Competencies
Skills & Tech Stack
Business Intelligence & Databases
  • SQL, MySQL
  • Power BI (DAX, Power Query, Data Modeling)
  • Tableau (Basic)
Data Analysis & Programming
  • Python
  • Pandas, NumPy
  • Matplotlib, Seaborn
  • Exploratory Data Analysis (EDA)
  • KPI Reporting
Tools
  • Advanced Excel
  • MS Word, PowerPoint
  • GitHub
📊 Professional Data Analytics Training
Data Analytics Internship & Certification
NMD Pvt Ltd | Project-Based Training | Jul 2025 – Dec 2025
To strengthen my practical exposure, I completed a structured Data Analytics training and internship at NMD Pvt Ltd, where I worked on real-world business datasets and analytics use cases.
What I Learned & Applied
01
SQL for Data Analysis
Writing optimized queries to extract, filter, and analyze large datasets (100,000+ records).
02
Power BI & Business Intelligence
Building interactive dashboards, KPI reports, and performance analysis visuals using Power BI, DAX, and Power Query.
03
Data Cleaning & Preprocessing
Handling missing values, standardizing data, and preparing analysis-ready datasets using Excel, SQL, and Power BI.
04
End-to-End Analytics Workflow
From raw data → analysis → visualization → actionable business insights.
This experience helped me bridge the gap between academic knowledge and real-world analytics, giving me confidence to work on business-focused data problems and communicate insights effectively.
🎯 My Vision & Goals
My vision is to leverage data analytics and business intelligence to drive meaningful impact, enable better decisions, improve processes, and uncover insights that create real value for organizations.
🔍 Impactful Insights
Turning data into decisions that matter
🛠 Real-World Solutions
Solving practical problems with data
📚 Continuous Learning
Growing every day as a data professional
🌳 Core Competencies
My foundational expertise in data analytics, built on four core competencies that drive every project and analysis.
🔄 Data Import & Transformation
Skilled in collecting, cleaning, and transforming raw data using SQL, Power Query, and Excel to create accurate, analysis-ready datasets.
📐 SQL & Data Analysis
Experienced in writing optimized SQL queries (joins, subqueries, CTEs, aggregations) to extract insights from structured databases.
📊 Data Visualization & Dashboards
Proficient in building interactive Power BI dashboards that present KPIs, trends, and performance metrics in a clear, decision-friendly format.
📈 Business Insights & Reporting
Strong ability to analyze data, identify patterns, and deliver actionable insights through structured reports and effective data storytelling.
🏅 Key Certifications
I have invested in structured certifications and hands-on job simulations to build a strong foundation in data analytics, business intelligence, and real-world problem-solving, while staying aligned with current industry practices.
Core Data Analytics & Business Intelligence
  • Career Essentials in Data Analysis — Microsoft & LinkedIn
  • Microsoft Power BI Data Analyst Associate (PL-300) – Cert Prep — Microsoft Press
  • Power BI for Beginners — Simplilearn
SQL, Excel & Data Handling
  • Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps) – Cert Prep
  • SQL Essential Training — LinkedIn
  • SQL for Data Analysis — LinkedIn
Python & Analytical Computing
  • Python Data Analysis — LinkedIn
  • Python in Excel: Getting Started with Data Analysis — LinkedIn
Industry & Job Simulations (Practical Exposure)
  • Deloitte Australia – Data Analytics Job Simulation — Forage
  • Quantium – Data Analytics Job Simulation — Forage
  • Tata – GenAI Powered Data Analytics Job Simulation — Forage
Strategy, Storytelling & Insight Generation
  • Turning Data into Strategies — LinkedIn
  • Data Storytelling & Visualization Mastery
🤝 Let's Connect!
I'm always open to internships, full-time opportunities, collaborations, and meaningful conversations in the field of Data Analytics and Business Intelligence. Whether you're a recruiter, professional, or fellow data enthusiast, I'd love to connect and exchange ideas.
If you're interested in discussing data analytics, dashboards, insights, or opportunities, feel free to reach out. Let's connect and grow together through data-driven thinking.
⭐ Open to Data Analyst, BI Analyst, and Trainee BI opportunities.
🌿 Thank You for Visiting!
Thank you for taking the time to explore my work and projects.
I look forward to opportunities where I can contribute my data analytics skills, business intelligence mindset, and problem-solving approach to meaningful and impactful data projects.
Let's connect and turn data into insights that drive better decisions.
Made with