MOHAMMED SAIHAN
Data Analyst | SQL • Excel • Power BI • Python
📧 developer@mohammedsaihan.com
🌐 github.com/MohammedSaihan
📍 Saudi Arabia (Open to Jeddah & Riyadh)
Professional Summary
Results-driven Data Analyst with hands-on experience in data cleaning, transformation, and interactive dashboard development. Skilled in SQL, Excel, Power BI, and Python to convert raw data into actionable business insights. Experienced in building KPI dashboards, analyzing revenue and customer behavior trends, and supporting data-driven decision-making across retail and hospitality domains.
Core Skills
Analytics & Reporting
- Data Cleaning & Transformation
- KPI Development & Performance Tracking
- Business Reporting & MIS Dashboards
- Trend & Revenue Analysis
- Customer & Behavioral Analytics
- Forecasting & Performance Monitoring
Technical Stack
- SQL (Joins, Aggregations, Subqueries)
- Excel (Pivot Tables, Power Query, Advanced Formulas)
- Power BI (Data Modeling, DAX, Dashboards)
- Python (Pandas, NumPy, Preprocessing)
- Data Visualization & Dashboard Design
Tools & Platforms
Power BI Service • Git & GitHub • Google Colab • Jupyter Notebook
Project Experience
Retail Sales & Customer Analytics Dashboard
SQL • Power BI • Excel
- Built SQL queries to calculate KPIs including revenue, AOV, and growth metrics
- Designed interactive Power BI dashboards with drill-down capabilities
- Analyzed product category contribution and customer segmentation
- Identified monthly revenue trends and high-performing customer segments
Impact: Enabled structured KPI monitoring and identified revenue growth opportunities.
Hospitality Analytics – Hotel Occupancy & Revenue (Jeddah)
SQL • Power BI • Excel
- Calculated ADR, RevPAR, cancellation rate, and average length of stay
- Performed monthly booking and revenue trend analysis
- Built executive-level dashboard for occupancy and pricing monitoring
- Analyzed weekend vs weekday demand patterns
Impact: Identified peak demand periods and pricing optimization opportunities.
People Analytics Dashboard — Workforce Intelligence (HR Analytics)
SQL • Power BI DAX • Excel
- Designed an end-to-end People Analytics solution to analyze workforce trends, attrition drivers, and compensation insights.
- Built HR KPI dashboards tracking headcount, attrition rate, salary trends, performance, and workforce planning metrics.
- Performed attrition analysis across departments, salary bands, overtime, job satisfaction, and work-life balance.
- Developed Power BI data model with DAX measures for executive reporting and automated HR insights.
- Delivered leadership-ready dashboards enabling data-driven HR decision-making.
Impact: Provided actionable insights into workforce dynamics, enabling proactive talent management and retention strategies.
Professional Training
- Data Analytics & Data Science – Professional Online Programs
- SQL for Data Analysis
- Advanced Excel & Business Reporting
- Power BI Dashboard Development
- Python for Data Analytics
- Business Analytics & KPI Strategy
Certifications
- Power BI for Beginners — Simplilearn (Microsoft Partner)
- Data Analytics Training — CodeWithHarry
- Strong analytical mindset with business-oriented thinking
- Project-first approach with real dashboard deployment experience
- Ability to translate business problems into measurable KPIs
- Structured problem-solving and clear communication
- Fast learner with adaptability to new tools and technologies