Skip to content
View paul-shir's full-sized avatar
πŸ’­
Data Analyst | BI Developer | Python | SQL | Power BI | Excel | Machine Learning
πŸ’­
Data Analyst | BI Developer | Python | SQL | Power BI | Excel | Machine Learning

Block or report paul-shir

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
paul-shir/README.md

Hi, I'm Paul Shir πŸ‘‹

Data Analyst | Business Intelligence Developer | Data Science & Machine Learning

I am a data professional focused on transforming raw data into clear insights that support better business decisions. My work combines data analytics, business intelligence, machine learning, and data visualization to solve practical business and research problems.

I enjoy working across the complete analytics workflow β€” from data preparation and modelling to analysis, dashboard development, machine learning, and communicating findings to decision-makers.


πŸ› οΈ Technical Skills

Data Analytics & Business Intelligence

  • Power BI
  • Microsoft Excel
  • Power Query
  • DAX
  • Data Modelling
  • KPI Development
  • Dashboard Design
  • Business Intelligence

Programming & Databases

  • Python
  • SQL
  • Microsoft SQL Server

Data Science & Machine Learning

  • Pandas
  • NumPy
  • Scikit-learn
  • XGBoost
  • Machine Learning
  • Predictive Modelling
  • Time-Series Analysis
  • Model Evaluation

Analytics Areas

  • Sales Analytics
  • Customer Analytics
  • Product Performance Analysis
  • Geographic Analysis
  • Business Performance Analysis
  • Public Health Data Analytics
  • Hr Analytics
  • Health Analytics

πŸ“Š Featured Projects

Lassa Fever Machine Learning Forecasting

A leakage-aware machine learning project developed to forecast weekly Lassa fever cases using temporal surveillance data.

The project applies time-aware feature engineering and machine learning techniques to analyse disease trends while avoiding temporal data leakage.

Key areas:

  • Time-series feature engineering
  • Lag and rolling features
  • Machine learning regression
  • Temporal validation
  • Model performance evaluation
  • Public health forecasting

Technologies:

Python Pandas Scikit-learn XGBoost Machine Learning

πŸ”— View Project


πŸ“Š HR Employee Attrition Analytics – Excel

An interactive Microsoft Excel HR analytics project developed to examine employee turnover and identify workforce segments with higher attrition risk.

The project analyzes 1,470 employees across demographics, job roles, departments, age groups, business travel, job satisfaction, performance, and other workforce factors.

Key Highlights

  • 1,470 total employees
  • 237 employee attritions
  • 16% overall attrition rate
  • 1,233 active employees
  • 84% active employee rate
  • 34 years average age of employees who left
  • Analysis by gender, age group, department, job role, education field, and business travel
  • Interactive HR dashboard with slicers and KPI indicators

Tools & Skills

Microsoft Excel Power Query PivotTables PivotCharts Slicers Data Cleaning HR Analytics Dashboard Design

πŸ”— View HR Employee Attrition Analytics Project


Sales Performance Business Intelligence – Power BI

An interactive Power BI business intelligence solution developed to analyse sales performance across customers, products, sales teams, transactions, time periods, and geographic locations.

Business areas analysed:

  • Revenue and profitability
  • Customer retargeting
  • Product performance
  • Sales team performance
  • Shipping and delivery performance
  • Sales channel performance
  • Time-based sales trends
  • Regional and location analysis

Key technologies:

Power BI DAX Power Query Data Modelling Business Intelligence

πŸ”— View Project


πŸ“ˆ Quarterly Sales Time Series Forecasting – Excel

A classical time-series forecasting project developed in Microsoft Excel to analyze quarterly car sales, identify seasonal patterns, estimate the underlying sales trend, and forecast sales for Year 5.

The project applies moving averages, centered moving averages, seasonal decomposition, deseasonalization, simple linear regression, and re-seasonalized forecasting.

Key Highlights

  • 16 historical quarterly observations across four years
  • 4-quarter moving average and centered moving average
  • Quarterly seasonal index calculation
  • Deseasonalized sales analysis
  • Linear trend modelling using regression
  • RΒ² = 0.921
  • Year 5 quarterly sales forecasting
  • Total Year 5 forecast of approximately 31.40 ('000)
  • Q4 identified as the strongest seasonal quarter
  • Q2 identified as the weakest seasonal quarter

Year 5 Forecast

Quarter Forecast Sales ('000)
Q1 7.09
Q2 6.49
Q3 8.63
Q4 9.19

Tools & Skills

Microsoft Excel Time Series Analysis Moving Average Centered Moving Average Seasonal Decomposition Deseasonalization Linear Regression Forecasting Data Visualization

πŸ”— View Quarterly Sales Time Series Forecasting Project


πŸ₯ Healthcare Admissions Analytics – Excel

An interactive Microsoft Excel healthcare analytics project developed to analyze patient admissions, diagnoses, demographics, hospital activity, regional patterns, and length of stay.

The project transforms healthcare admission records into an interactive decision-support dashboard for understanding patient demand and hospital performance.

Key Highlights

  • 100 patient admissions analyzed
  • 6 hospitals
  • 6 diagnosis categories
  • 5 geographic regions
  • 51.8 years average patient age
  • 7.6 days average length of stay
  • Hospital, diagnosis, region, and gender filtering
  • Automated filter reset using VBA
  • Analysis of monthly admission trends and patient age groups

Tools & Skills

Microsoft Excel Power Query PivotTables PivotCharts VBA Slicers Healthcare Analytics Data Visualization

πŸ”— View Healthcare Admissions Analytics Project


πŸ’‘ What I Focus On

I am particularly interested in using data to answer practical questions such as:

  • What is driving business performance?
  • Which customers, products, or locations require attention?
  • How can historical data support forecasting and planning?
  • How can complex datasets be presented clearly to decision-makers?
  • How can machine learning improve prediction without compromising analytical reliability?

πŸ“ˆ Current Focus

  • Building end-to-end data analytics portfolio projects
  • Developing interactive business intelligence dashboards
  • Applying SQL and Python to real-world analytical problems
  • Building machine learning and forecasting solutions
  • Improving data storytelling and decision-support systems

πŸš€ Portfolio

This GitHub profile contains projects demonstrating practical experience in:

Power BI β€’ SQL β€’ Python β€’ Excel β€’ Machine Learning β€’ Data Visualization β€’ Business Intelligence β€’ Data Science

More projects will be added as the portfolio continues to grow.

Pinned Loading

  1. lassa-fever-machine-learning-forecasting lassa-fever-machine-learning-forecasting Public

    Leakage-aware machine learning framework for forecasting weekly Lassa fever cases and outbreak status using temporal surveillance data.

    Jupyter Notebook

  2. Sales-Performance-Business-Intelligence-PowerBI Sales-Performance-Business-Intelligence-PowerBI Public

    Power BI sales analytics project analyzing customers, transactions, products, sales teams, time trends, and regional sales performance using US regional sales data.

  3. HR-Employee-Attrition-Analytics-Excel HR-Employee-Attrition-Analytics-Excel Public

    Interactive Excel HR analytics project examining employee attrition, workforce demographics, job satisfaction, job roles, business travel, and departmental retention patterns.

  4. paul-shir paul-shir Public

  5. Healthcare-Admissions-Analytics-Excel Healthcare-Admissions-Analytics-Excel Public

    Interactive Excel healthcare analytics project analyzing patient admissions, demographics, diagnoses, length of stay, hospital performance, regions, and monthly admission trends.

  6. Quarterly-Sales-Time-Series-Forecasting-Excel Quarterly-Sales-Time-Series-Forecasting-Excel Public

    Excel time-series forecasting project analyzing quarterly car sales using moving averages, seasonal decomposition, regression trend modelling, and Year 5 forecasting.