Shaikh Mohd Israhil
Final-year Engineering Student | Driving innovation through data analytics projects.
GitHub
About Me
I am a final-year Information Technology student specializing in Data Science at Mumbai University's Theem College of Engineering, set to graduate in 2026. I am passionate about transforming raw data into actionable insights that drive strategic business decisions.
My portfolio showcases real-world projects in financial analytics, sales analysis, and business intelligence, built on practical application. I combine technical proficiency with business acumen, focusing on data cleaning, exploratory analysis, and creating compelling visualizations. I excel at identifying key performance indicators and developing interactive dashboards to empower data-driven decisions.
Education
Bachelor of Engineering (B.E.)
Information Technology with Honours in Data Science
Theem College of Engineering, Mumbai University
CGPA: 7.23 | Expected Graduation: 2026
Technical Expertise
SQL
Extracting and analyzing data for critical business insights.
Microsoft Excel
Modeling and visualizing data to support strategic decisions.
Power BI
Developing interactive dashboards and BI solutions for informed decisions.
Tableau
Creating compelling data visualizations and insightful narratives.
Python
Automating data manipulation and analysis for efficient reporting.
Core Analytics Capabilities
Data Cleaning
Transforming raw data into reliable, analysis-ready datasets for accurate insights.
Exploratory Data Analysis
Uncovering trends and anomalies using statistical techniques to inform strategy.
KPI Analysis
Identifying and tracking critical business metrics to drive strategic decision-making.
Dashboard Development
Building interactive dashboards that provide real-time, actionable insights.
Business Reporting
Creating comprehensive reports that translate data into clear, actionable recommendations.
Data Visualisation
Designing compelling visual stories to make data accessible and impactful for all stakeholders.
Professional Experience
Business Analytics Intern
InternsElite | September 2025 – November 2025
Gained hands-on experience in business data analysis, leveraging Excel, Power BI, and Tableau to create insightful dashboards and reports. Conducted SQL-based data analysis to extract meaningful patterns and trends, and utilized Python for data handling and generating actionable insights that supported strategic business decisions.
  • Developed comprehensive reports for stakeholders.
  • Designed interactive dashboards tracking KPIs.
  • Executed advanced SQL queries for data analysis.
  • Automated data processing and insights using Python.
  • Collaborated with cross-functional teams on data-driven recommendations.
Featured Projects
This portfolio showcases real-world data analytics projects, demonstrating my ability to transform raw data into meaningful insights that drive strategic decision-making.

Project Overview

This comprehensive Excel-based analytics solution transforms raw coffee shop transaction data into actionable business intelligence. The interactive dashboard provides real-time visibility into sales performance, customer behavior, and operational efficiency. Key Insights & Outcomes Identified top 10 products driving 65% of revenue Discovered peak sales hours enabling optimal staffing Revealed seasonal trends for inventory planning Analyzed customer preferences by location Generated recommendations increasing projected revenue by 18% Explore Project

Project Overview

This enterprise-level Excel analytics solution provides comprehensive visibility into Adventure Works' global sales operations. The interactive dashboard integrates multi-dimensional data analysis, enabling strategic decision-making across regions, product lines, and customer segments. Key Insights & Outcomes Identified top 5 products generating 58% of total revenue Analyzed country-wise performance across 5 major markets Discovered seasonal patterns optimizing inventory allocation Segmented customers by profitability and purchase behavior Provided strategic recommendations for market expansion increasing projected revenue by 22% Explore Project

Financial Analytics & Banking BI Dashboard
SQL | Power BI | Excel
Developed a financial analytics solution for loan portfolio analysis and good vs. bad loan classification. Created an interactive, multi-page Power BI dashboard delivering real-time insights into banking operations and risk assessment.
This project showcases advanced data modeling, complex DAX calculations, and the presentation of financial metrics in a decision-ready format for banking professionals.
  • Loan portfolio performance & risk tracking
  • Good vs. bad loan classification
  • Interactive multi-page Power BI dashboard
  • Real-time KPI monitoring & trend analysis
Smoking Health Risk Analysis Dashboard
SQL | Power BI | Excel
Developed a health risk analysis solution correlating smoking behavior with health outcomes and demographic factors (age, gender), providing actionable public health insights.
Implemented an interactive Power BI dashboard, enabling healthcare professionals and researchers to dynamically explore smoking-related health risks across diverse population segments.
Project Impact & Outcomes
My portfolio projects showcase tangible results and practical applications of data analytics in real-world scenarios, highlighting the value delivered through these solutions.
4
Complete Projects
End-to-end analytics solutions from data collection to actionable insights
5
Tools Mastered
Proficient across SQL, Excel, Power BI, Tableau, and Python
3
Dashboard Types
Sales, financial, and health analytics dashboards created
100%
Real Data
All projects built using authentic business datasets and scenarios

Key Takeaway: Each project highlights hands-on expertise with industry-standard tools and methodologies, underscoring my immediate capacity to deliver significant value as a data analyst.
Certifications & Professional Credentials
Excel Skills Job Simulation
Organization: Forage
Year: 2024
Skills: Advanced Excel, Data Analysis, Business Insights
Generative AI Mastermind
Organization: Outskill
Year: 2025
Skills: Generative AI, Prompt Engineering, AI Tools
SQL and Relational Databases 101
Organization: IBM (Cognitive Class)
Year: 2025
Skills: SQL, Relational Databases, Queries
Business Analytics Training Certificate
Organization: InternsElite
Type: Industrial Training
Skills: Excel, Power BI, SQL, Business Analytics
Business Analytics Internship Certificate
Organization: InternsElite
Duration: Sept 2025 – Nov 2025
Role: Business Analytics Intern
Skills: Excel, Power BI, Tableau, SQL, Python
Let's Connect
Ready to Drive Data-Driven Decisions
I am actively seeking opportunities to leverage my data analytical skills and business intelligence expertise to transform complex datasets into actionable strategic insights. My portfolio demonstrates a strong blend of technical proficiency and business acumen, and I am eager to contribute immediate value to a dynamic organization. Let's connect to discuss how my hands-on experience can drive your team's success.
Shaikh Mohd Israhil | Data Analyst | Mumbai, India | Expected Graduation: 2026
Made with