A highly collaborative data analyst with strong background in Excel, SQL, Tableau, and Power Bi @Gokoyer
An in-depth Human Resources Data Analysis (HR Analytics) and Data Visualization Project. The interactive Dashboard visualizes some of the important KPIs and other metrics. The HR Analytics is carried out in SQL Server and Tableau to improve the company's workforce performance.
During the MeriSKILL Internship, large sales dataset was provided. Sales trends over time, best-selling products and other revenue metrics such as total sales are analyzed. Exclusively, SQL Server was used to query the dataset for general cleaning, formatting, wrangling, and analysis prior to data visualizing in Power Bi for effective findings presentation. This project showcases how data can be manipulated and derive insights from large datasets to make data-driven recommendations for optimizing sales strategies.
This project aims to collect and analyses Human Resources (HR) data in order to boost an organization’s workforce performance. In this data analytical tasks, data is routinely collected by HR Department and correlates to the overall organization goals and objectives. I worked as a Data Analyst Intern with MERISKILL by analyzing data gathered by HR department in order to generate data-backed insights into company's turnover. It is noteworthy to mention that it takes enormous resources such as money, time and other investments to bring employees up to a fully productive and rewarding speed. Consequently, this project will help the company to plan adequately for the future, reduce the turnover and ultimately, increase the productivity and revenue.
This project analysed and visualized the trends, market and gain insights into the motorcycle industry in USA between 1960 - 2023. Seven major motorcycles brands that were studied include Suzuki, BMW, Royal Enfield, Yamaha. Taleau is used for data visualization
In this Maven Analytics Challenge, I acted as an Analytics Consultant where imaginary group of investors are looking for opportunity to enter into US coffe market. The potential investors needed explanatory reports that will provide a data-driven strategy for opening their first coffee shop in USA. The raw data was cleaned, wrangled and analysed before being visualised using Power Bi
An overview of intuitive and interactive tableau dashboards. Here is the collection of Data Analytics works that can be visualize in various dashboard. You can employ filters or consult the graphs individually. Right insights will be easily achieved by using dashboards.
Performed the task of analysing and visualizing carbon emission by Country from 18th century to 21st century(till 2014). The raw data was previously cleaned, formatted and standardized in excel before being analysed in SQL Server. Dashboards and stories were made in Tableau. You can navigate through the tableau story for sequence of visualizations that convey information
TATA Virtual Internship Experience Program to empower businesses with effective Insights. This Virtual internship was powered by Forage, and my role was to act as a Virtual Data Visualization Specialist where Tableau was majorly utilized to manipulate and visualized TATA Global Retail Stores Dataset. The target audience are The Chief Executive Officer (CEO) and Chief Marketing Officer (CMO) needed answers to 4 questions through Data Visualization in order to gain impactful and actionable insights that will lead to data-driven decision making to empower a chain of business in TATA.
This project is a Maven’s Healthcare Challenge. Datasets were provided by American Hospital Association (AHA) which is a national organization that represents hospitals and their patients. In the challenge, Hospital Consumer Assessment of Healthcare Providers and Systems (HCAHPS) survey results for the last 9 years (2015-2023) were analyzed. The purpose of this project is to provide a standardized survey instrument for measuring patients’ perspectives on hospital care, and one of its three main goals is to establish incentives for hospitals across the country to improve the quality of care being rendered.
Utilized Excel exclusively to analyze life Expectancies of 177 countries between 2000 and 2015. The top 25 countries with highest life expectancy were thoroughly analysed in excel. The interactive dashboard is named "Dashboard.xlxs" in GitHub repository. You can apply filter (country) yourself by pressing and hold ctrl and then select countries of choice to gain insights.
In this project, I cleaned, formatted, standardized and analysed Bike Riders' Profiles in Excel. In this project, Bike riders' profiles such as their marital status, gender, cars owned, income, education, age, bike purchase and etc are analysed in excel. Slicers, pivot table and dashboard were created for the project.
This is a final project in the Google Data Analytics Professional Certificate Project. Real-world tasks of a data analyst was performed. All the steps in data analytics that were taught during the course were executed. I acted the role of a Junior Data Analyst in the marketing department at Cyclistic Bike Share Company base in Chicago.
Helsinki, Finland