Built with datascienceportfol.io

Erri Efraim Sebayang

Student Data Analytics For Business

Based in Medan,Indo

LinkedIn
Kaggle

About

I am a highly motivated student at Universitas Mikroskil in Medan with a strong foundation in data analysis, data science, database management, data visualization, and machine learning, and proficiency in tools such as SQL, Python, Tableau, and Excel. Recently, I completed the Data Analytics for Business program at Bitslab Academy, a 3-month intensive training that enhanced my ability to manage large datasets, including processes like data gathering, cleaning, analysis, and visualization. As part of a Project-Based Learning (PBL) initiative for Mekari, a Bitslab partner company, my team earned 1st place in the program, demonstrating strong collaboration and technical expertise. These experiences have sharpened my problem-solving skills, attention to detail, and ability to transform complex

Skills

Projects

Project photo

Payroll Cost-Effectiveness Analysis Mekari: Optimizing HR Management for Improved Efficiency

Analyzed payroll cost-effectiveness Mekari, identifying inefficiencies and areas for improvement. Categorized employees by layoff risk and assessed salary-productivity alignment. Provided recommendations to optimize payroll spending and enhance HR management for sustainable growth.

Read more
Project photo

Optimizing Hotel Reservation Processes: Insights from Data Analysis on ADR and Cancellations

Utilized Python, SQL, and BPMN to analyze hotel reservation data, uncovering inefficiencies in booking processes. Provided actionable insights to optimize pricing, reduce cancellations, and improve operational efficiency.

Read more
Project photo

Data Visualization: Insights into Netflix Movies and TV Shows

This visualization highlights Netflix's content distribution, showing movies dominate at 68.42%, steady growth over the years, and top genres like documentaries and stand-up comedy leading the way. A quick glimpse into Netflix’s global impact

Read more
Project photo

Traveler Insights and Hotel Performance Dashboard: Tripadvisor Analysis

Interactive dashboard analyzing Tripadvisor data: user demographics, traveler types, hotel reviews, ratings, and booking trends. Showcases data visualization skills and actionable insights.

Read more
Project photo

Cosmetic Sales Dashboard: Comprehensive Analysis of Skincare, Makeup, and Haircare Performance

Created an interactive dashboard analyzing cosmetic sales trends, including skincare growth, makeup sales changes, and haircare performance. Provided insights on discounts, regional performance, and seasonal behavior to optimize marketing and inventory strategies.

Read more
Project photo

Interactive Sales Analysis Dashboard for Superstore

Created a dashboard analyzing sales trends, targets, product distribution, and forecasting future performance to support strategic decisions.

Read more
Project photo

Interactive Dashboard for Amazon Prime Video Content Analysis

Created a Tableau dashboard analyzing Amazon Prime Video content trends, including top genres, ratings, global availability, and release year insights to support strategic decisions.

Read more

Experience

2024

Student Data Analytics For Business at Bitslab Academy

Studied Data Analytics for Business at Bitslab Academy, focusing on practical skills in Excel, SQL, Python, and Tableau to solve real-world business problems. The program included topics such as advanced Excel formulas, database management with SQL, data analysis using Python, and creating interactive dashboards in Tableau. Additionally, it covered business concepts like user journey mapping and BPMN. As a capstone project, I analyzed payroll cost-effectiveness for Mekari, delivering actionable insights through data visualization and analytics.

Education

2022-present

Computer Science at Universitas Mikroskil

Key Courses Data Analytics: Computer Programming, Database Modeling and Implementation, Data Engineering, Statistics for Computing, Computational Thinking, Mathematics for Computing, Digital Literacy, Object-Oriented Design and Programming, Office Automation System

2024

Data Analytics For Business at Bitslab Academy

Studied Data Analytics for Business at Bitslab Academy, focusing on practical skills in Excel, SQL, Python, and Tableau to solve real-world business problems. The program included topics such as advanced Excel formulas, database management with SQL, data analysis using Python, and creating interactive dashboards in Tableau. Additionally, it covered business concepts like user journey mapping and BPMN. As a capstone project, I analyzed payroll cost-effectiveness for Mekari, delivering actionable insights through data visualization and analytics.