I build business-focused analytics and machine learning projects using SQL, Power BI, Python, and data visualization to solve real-world business problems.
CSV Dataset
→ SQL Server
→ Data Cleaning & Transformation
→ Business Analysis
→ Power BI Dashboard
End-to-end retail analytics platform using SQL Server and Power BI for KPI analysis and business intelligence reporting.
Key Features
- SQL data ingestion and cleaning
- Business KPI analysis
- Interactive Power BI dashboard
- Sales, profit, and regional analytics
Tech: SQL Server, Power BI, Git, SSMS Repo: https://github.com/StojkoskiT/retail-business-performance-analytics
Interactive HR analytics dashboard focused on employee attrition and workforce insights.
Key Features
- Employee attrition analysis
- Workforce KPI reporting
- HR analytics dashboard with DAX measures
- Department, overtime, and salary analysis
Tech: SQL Server, Power BI, DAX, Git, GitHub Repo: https://github.com/StojkoskiT/hr-workforce-analytics-dashboard
Machine learning project for predicting loan default risk using real-world financial data.
- Processed large dataset with 300k+ rows and 200+ features
- Handled class imbalance for default prediction
- Built Balanced Random Forest model
- Achieved recall of ~0.62 for default class and ROC-AUC of ~0.73
- Built Streamlit app for real-time loan default prediction
Tech: Python, Pandas, Scikit-learn, Streamlit, Machine Learning
Repo: https://github.com/StojkoskiT/credit-risk-loan-default-platform
Machine learning project for identifying customers at risk of churn.
- Built churn prediction workflow
- Performed exploratory data analysis
- Created business insights for customer retention
- Applied feature engineering and model evaluation
Tech: Python, Pandas, Scikit-learn, Data Analysis
Repo: https://github.com/StojkoskiT/customer-churn-intelligence-platform
Data analysis project focused on job market trends and salary insights.
- Analyzed job market and salary data
- Identified demand patterns across roles and skills
- Created visualizations to communicate salary and market trends
Tech: Python, SQL, Data Visualization
Repo: https://github.com/StojkoskiT/job-market-salary-intelligence-platform
Analytics & BI: SQL, Power BI, DAX, KPI Reporting, Business Intelligence
Programming: Python, Pandas, NumPy
Machine Learning: Scikit-learn, Classification, Model Evaluation, Imbalanced Data
Visualization: Power BI, Matplotlib, Seaborn
Tools: Git, GitHub, SourceTree, VS Code, SSMS, Streamlit, Jupyter Notebook
I am currently focused on strengthening my portfolio for Data Analyst, BI Analyst, Reporting Analyst, and Junior Data Scientist roles by building practical business analytics and machine learning projects.
LinkedIn: https://www.linkedin.com/in/trpo-stojkoski/
Email: stojkoski.trpo@gmail.com